-
公开(公告)号：US20060179068A1
公开(公告)日：2006-08-10
申请号：US11056312
申请日：2005-02-10
申请人： James Warner , Abhyudaya Agrawal , Hui Zhang , Muralidhar Krishnaprasad , Ravi Murthy , Zhen Liu , Nipun Agarwal , Vikas Arora , Susan Kotsovolos , Anand Manikutty , Rohan Angrish
发明人： James Warner , Abhyudaya Agrawal , Hui Zhang , Muralidhar Krishnaprasad , Ravi Murthy , Zhen Liu , Nipun Agarwal , Vikas Arora , Susan Kotsovolos , Anand Manikutty , Rohan Angrish
IPC分类号： G06F7/00
CPC分类号： G06F17/30917 , Y10S707/99934 , Y10S707/99943
摘要： To associate XML data objects (“child objects”), stored in rows of relational or object-relational tables, with the appropriate XML data objects (“parent objects”) from which the child objects descend, tables that contain child objects (“out-of-line” tables) are constructed with an additional column. In one embodiment, this column stores values that identify the root objects, in the appropriate table, from which the respective child objects descend. Hence, the root object from which any given object descends is traceable by following the respective value back to the corresponding root object. In one embodiment, this column stores values that identify the complete XML hierarchical path, through multiple tables, back to the root object from which the respective child objects descend. Consequently, XML query language queries against XML documents stored in such tables can be rewritten as SQL queries against the data in the tables, even in the presence of cyclic constructs.
-
2.发明授权Techniques for efficiently storing and querying in a relational database, XML documents conforming to schemas that contain cyclic constructs 有权在关系数据库中高效存储和查询的技术，符合包含循环结构的模式的XML文档公开(公告)号：US07523131B2
公开(公告)日：2009-04-21
申请号：US11056312
申请日：2005-02-10
申请人： James W. Warner , Abhyudaya Agrawal , Hui Zhang , Muralidhar Krishnaprasad , Ravi Murthy , Zhen Hua Liu , Nipun Agarwal , Vikas Arora , Susan M. Kotsovolos , Anand Manikutty , Rohan Angrish
发明人： James W. Warner , Abhyudaya Agrawal , Hui Zhang , Muralidhar Krishnaprasad , Ravi Murthy , Zhen Hua Liu , Nipun Agarwal , Vikas Arora , Susan M. Kotsovolos , Anand Manikutty , Rohan Angrish
IPC分类号： G06F17/00
CPC分类号： G06F17/30917 , Y10S707/99934 , Y10S707/99943
摘要： To associate XML data objects (“child objects”), stored in rows of relational or object-relational tables, with the appropriate XML data objects (“parent objects”) from which the child objects descend, tables that contain child objects (“out-of-line” tables) are constructed with an additional column. In one embodiment, this column stores values that identify the root objects, in the appropriate table, from which the respective child objects descend. Hence, the root object from which any given object descends is traceable by following the respective value back to the corresponding root object. In one embodiment, this column stores values that identify the complete XML hierarchical path, through multiple tables, back to the root object from which the respective child objects descend. Consequently, XML query language queries against XML documents stored in such tables can be rewritten as SQL queries against the data in the tables, even in the presence of cyclic constructs.
摘要翻译： 将存储在关系关系表或对象关系表行中的XML数据对象（“子对象”）与子对象所属的相应XML数据对象（“父对象”）相关联，包含子对象的表（“out” -line“表）用另外的列构造。 在一个实施例中，该列存储识别相应子对象下降的适当表中的根对象的值。 因此，通过将相应的值追溯到相应的根对象，可以追溯任何给定对象下降的根对象。 在一个实施例中，该列将通过多个表标识完整的XML分层路径的值存储回到相应子对象从其下降的根对象。 因此，即使在存在循环结构的情况下，存储在这些表中的XML文档的XML查询语言查询可以重写为表中数据的SQL查询。
-
3.发明授权公开(公告)号：US09367642B2
公开(公告)日：2016-06-14
申请号：US11246039
申请日：2005-10-07
CPC分类号： G06F17/30923 , G06F7/00
摘要： A database server determines, on an element-level of granularity, what form of VARRAY storage to map collections of elements defined by a XML schema. A collection element may be mapped to an in-line VARRAY or an out-of-line VARRAY. The determination may based on a variety of factors, including the database type mapped to the collection element, database limitations that limit the form storage for certain database types, and annotations (“mapping annotations”) embedded within that XML schema that specifying a database type for database representation of a collection element or a form of VARRAY storage.
摘要翻译： 数据库服务器根据粒度级别确定使用什么形式的VARRAY存储来映射由XML模式定义的元素集合。 集合元素可以被映射到串联的VARRAY或者行外的VARRAY。 确定可以基于各种因素，包括映射到集合元素的数据库类型，限制某些数据库类型的表单存储的数据库限制，以及嵌入在指定数据库类型的XML模式中的注释（“映射注释”） 用于收集元素或VARRAY存储的形式的数据库表示。
-
4.发明授权Efficient mechanism to support user defined resource metadata in a database repository 有权有效的机制来支持数据库存储库中用户定义的资源元数据公开(公告)号：US07849106B1
公开(公告)日：2010-12-07
申请号：US11003611
申请日：2004-12-03
申请人： Abhyudaya Agrawal , Ravi Murthy , Nipun Agarwal , Eric Sedlar
发明人： Abhyudaya Agrawal , Ravi Murthy , Nipun Agarwal , Eric Sedlar
CPC分类号： G06F17/30525
摘要： A method and apparatus for facilitating the management of metadata is disclosed, specifically by associating metadata with an XML schema. The database system provides a method that allows end users to maintain additional information describing resources. User-defined metadata attributes are associated as an XML schema which in turn is mapped to a table, referred to as the user metadata table. The XML schema contains user-defined information specifying the metadata that the end-user wants the system to store and maintain. Additionally, a reference is created between an entry in the user metadata table and its corresponding resource entry in the resource table. The resources are accessed directly or by issuing queries against the user metadata table. The querying of the user metadata table gains the benefit of fast and efficient query results and access time.
摘要翻译： 具体地，通过将元数据与XML模式相关联来公开用于促进元数据管理的方法和装置。 数据库系统提供了一种允许最终用户维护描述资源的附加信息的方法。 用户定义的元数据属性作为XML模式进行关联，XML模式又被映射到表，称为用户元数据表。 XML模式包含用户定义的信息，指定最终用户希望系统存储和维护的元数据。 此外，在用户元数据表中的条目和资源表中的相应资源条目之间创建引用。 可以直接访问资源，或通过对用户元数据表发出查询。 查询用户元数据表可以获得快速高效的查询结果和访问时间的优点。
-
公开(公告)号：US20070083529A1
公开(公告)日：2007-04-12
申请号：US11246001
申请日：2005-10-07
IPC分类号： G06F7/00
CPC分类号： G06F17/2247 , G06F17/30917
摘要： A database system automatically detects a cyclic construct in a XML schema, determines a database representation for the cyclic construct, and maps the XML schema and elements involved in the cyclic construct to the database representation.
摘要翻译： 数据库系统自动检测XML模式中的循环结构，确定循环结构的数据库表示，并将循环结构中涉及的XML模式和元素映射到数据库表示。
-
6.发明申请公开(公告)号：US20070038649A1
公开(公告)日：2007-02-15
申请号：US11202463
申请日：2005-08-11
IPC分类号： G06F7/00
CPC分类号： G06F17/30917 , Y10S707/99942 , Y10S707/99943
摘要： A database server registers an XML schema and determines a database representation for the XML schema and mapping information, determining what database types should be used to represent an XML schema and/or how instances of the XML schema are stored by a database system. The mapping information indicates the mapping between the constructs declared in the XML schema and the constructs included in the appropriate database representation. The XML schema may contain annotations that describe one or more properties of a database representation of an XML date-time type. Based on the annotations, the database determines an appropriate database representation and generates mapping information mapping the declaration of the XML date-time type of the XML schema to the constructs of the database representation.
摘要翻译： 数据库服务器注册XML模式并确定XML模式和映射信息的数据库表示，确定应使用什么数据库类型来表示XML模式和/或数据库系统如何存储XML模式的实例。 映射信息指示在XML模式中声明的结构与包含在适当的数据库表示中的构造之间的映射。 XML模式可能包含描述XML日期时间类型的数据库表示形式的一个或多个属性的注释。 基于注释，数据库确定适当的数据库表示，并生成映射信息，将XML模式的XML日期时间类型的声明映射到数据库表示的构造。
-
7.发明授权Implementation of backward compatible XML schema evolution in a relational database system 有权在关系数据库系统中实现向后兼容的XML模式演进公开(公告)号：US07870163B2
公开(公告)日：2011-01-11
申请号：US11540341
申请日：2006-09-28
申请人： Abhyudaya Agrawal , Thomas Baby , Nipun Agarwal , Sam Idicula , Ravi Murthy , Eric Sedlar
发明人： Abhyudaya Agrawal , Thomas Baby , Nipun Agarwal , Sam Idicula , Ravi Murthy , Eric Sedlar
IPC分类号： G06F17/30
CPC分类号： G06F17/2247
摘要： In-place XML schema evolution occurs by evaluating an existing XML schema in a database system to see if it is compatible with a new XML schema. To determine if the old schema is compatible with the new schema, a lock-step traversal is performed on the two schemas. Each instruction in the old schema is compared to instructions in the new schema. Detected differences between the two schemas are evaluated to determine if existing XML documents are still compatible with the new schema. If they are, then an in-place schema evolution operation can take place. The in-place schema operation basically, involves appending the updated object information to the underlying object type and preserving the order of elements in a document by storing element mapping information on disk.
摘要翻译： 通过评估数据库系统中的现有XML模式来查看是否与新的XML模式兼容，就会发生就地XML模式演进。 为了确定旧模式是否与新模式兼容，在两个模式上执行锁步遍历。 将旧模式中的每个指令与新模式中的指令进行比较。 对两个模式之间的检测差异进行评估，以确定现有XML文档是否仍然与新模式兼容。 如果它们是，则可以进行就地模式演进操作。 就地模式操作基本上包括将更新的对象信息附加到底层对象类型，并通过在盘上存储元素映射信息来保留文档中元素的顺序。
-
公开(公告)号：US20080082560A1
公开(公告)日：2008-04-03
申请号：US11540341
申请日：2006-09-28
申请人： Abhyudaya Agrawal , Thomas Baby , Nipun Agarwal , Sam Idicula , Ravi Murthy , Eric Sedlar
发明人： Abhyudaya Agrawal , Thomas Baby , Nipun Agarwal , Sam Idicula , Ravi Murthy , Eric Sedlar
IPC分类号： G06F7/00
CPC分类号： G06F17/2247
摘要： In-place XML schema evolution occurs by evaluating an existing XML schema in a database system to see if it is compatible with a new XML schema. To determine if the old schema is compatible with the new schema, a lock-step traversal is performed on the two schemas. Each instruction in the old schema is compared to instructions in the new schema. Detected differences between the two schemas are evaluated to determine if existing XML documents are still compatible with the new schema. If they are, then an in-place schema evolution operation can take place. The in-place schema operation basically, involves appending the updated object information to the underlying object type and preserving the order of elements in a document by storing element mapping information on disk.
摘要翻译： 通过评估数据库系统中的现有XML模式来查看是否与新的XML模式兼容，就会发生就地XML模式演进。 为了确定旧模式是否与新模式兼容，在两个模式上执行锁步遍历。 将旧模式中的每个指令与新模式中的指令进行比较。 对两个模式之间的检测差异进行评估，以确定现有XML文档是否仍然与新模式兼容。 如果它们是，则可以进行就地模式演进操作。 就地模式操作基本上包括将更新的对象信息附加到底层对象类型，并通过在盘上存储元素映射信息来保留文档中元素的顺序。
-
公开(公告)号：US07761479B2
公开(公告)日：2010-07-20
申请号：US11519720
申请日：2006-09-11
申请人： Abhyudaya Agrawal , Thomas Baby , Ravi Murthy , Nipun Agarwal
发明人： Abhyudaya Agrawal , Thomas Baby , Ravi Murthy , Nipun Agarwal
CPC分类号： G06F17/30917 , Y10S707/954
摘要： Techniques manage the presence of repeated constructs within a complex type at the time of schema registration. At registration, techniques detect repeated elements in the XML schema and analyze whether the repeated elements are from the same complex type. If so, techniques perform additional analysis to determine a minimal common ancestor. Within the context of a minimal common ancestor, techniques determine the maximum number of times an element may occur in the schema. In a choice content model, the largest maximum occurrence value is selected. In other content models, the maximum occurrence value is determined by adding together the occurrence values for the repeated elements. Then, when an object relational table is generated for the XML schema, the maximum number of times that an element appears in the schema is this value. Techniques retain the advantages of object relational storage, even after a schema evolution.
摘要翻译： 技术在模式注册时管理复杂类型中重复构造的存在。 在注册时，技术会检测XML模式中的重复元素，并分析重复的元素是否来自相同的复杂类型。 如果是这样，技术将进行额外的分析，以确定一个最小的共同祖先。 在最小共同祖先的上下文中，技术确定元素在模式中可能发生的最大次数。 在选择内容模型中，选择最大的最大出现值。 在其他内容模型中，通过将重复元素的出现值相加来确定最大出现值。 然后，当为XML模式生成对象关系表时，元素在模式中出现的最大次数是此值。 技术保留对象关系存储的优点，即使在模式演进之后。
-
10.发明申请公开(公告)号：US20070083542A1
公开(公告)日：2007-04-12
申请号：US11246039
申请日：2005-10-07
IPC分类号： G06F7/00
CPC分类号： G06F17/30923 , G06F7/00
摘要： A database server determines, on an element-level of granularity, what form of VARRAY storage to map collections of elements defined by a XML schema. A collection element may be mapped to an in-line VARRAY or an out-of-line VARRAY. The determination may based on a variety of factors, including the database type mapped to the collection element, database limitations that limit the form storage for certain database types, and annotations (“mapping annotations”) embedded within that XML schema that specifying a database type for database representation of a collection element or a form of VARRAY storage.
摘要翻译： 数据库服务器根据粒度级别确定使用什么形式的VARRAY存储来映射由XML模式定义的元素集合。 集合元素可以映射到串行VARRAY或行外VARRAY。 该确定可以基于各种因素，包括映射到集合元素的数据库类型，限制特定数据库类型的表单存储的数据库限制以及嵌入在指定数据库类型的XML模式中的注释（“映射注释”） 用于收集元素或VARRAY存储的形式的数据库表示。
-
-
-
-
-
-
-
-
-
搜索结果
256 条记录 (耗时 0.041 秒)
