公开(公告)号：US07051042B2

公开(公告)日：2006-05-23

申请号：US10428393

申请日：2003-05-01

申请人： Muralidhar Krishnaprasad ,  Ravi Murthy ,  Anand Manikutty ,  James Warner ,  Neema Jalali ,  Sivasankaran Chandrasekar

发明人： Muralidhar Krishnaprasad ,  Ravi Murthy ,  Anand Manikutty ,  James Warner ,  Neema Jalali ,  Sivasankaran Chandrasekar

IPC分类号： G06F17/30

CPC分类号： G06F17/3092 ,  Y10S707/99943

摘要： Techniques for transferring a serialized image of data for an XML construct includes selecting a first format from multiple different XML serialization formats that represent, in a database system, data for XML constructs as a series of data units, such as a series of bytes representing characters, or a series of bits, bytes or octets representing binary values. A message is generated that includes a payload and a payload type field. The payload includes particular serialized data that represents particular data for a particular XML construct in the first format. The type field includes data that indicates the first format. The message is sent from a sending component of the database system to a different receiving component of the database system. These techniques allow the format selection to be based on characteristics of the sending or receiving components to make better use of the resources available to the two components.

摘要翻译： 用于传送用于XML构造的数据的序列化图像的技术包括从多个不同的XML序列化格式中选择第一格式，所述XML序列化格式在数据库系统中表示作为一系列数据单元的XML结构的数据，诸如表示字符 或一系列表示二进制值的位，字节或八位位组。 生成包含有效载荷和有效载荷类型字段的消息。 有效载荷包括表示第一格式的特定XML构造的特定数据的特定序列化数据。 类型字段包括指示第一格式的数据。 消息从数据库系统的发送组件发送到数据库系统的其他接收组件。 这些技术允许格式选择基于发送或接收组件的特性，以更好地利用两个组件可用的资源。

公开(公告)号：US07386567B2

公开(公告)日：2008-06-10

申请号：US10956300

申请日：2004-09-30

申请人： Anand Manikutty ,  Muralidhar Krishnaprasad ,  Ravi Murthy ,  Visar Nimani ,  James Warner ,  Eric Sedlar ,  Neema Jalali ,  Bhushan Khaladkar

发明人： Anand Manikutty ,  Muralidhar Krishnaprasad ,  Ravi Murthy ,  Visar Nimani ,  James Warner ,  Eric Sedlar ,  Neema Jalali ,  Bhushan Khaladkar

IPC分类号： G06F17/30

CPC分类号： G06F17/3061 ,  G06F17/30923 ,  Y10S707/99943

摘要： Techniques are provided for changing data for an XML construct in an SQL/XML compliant database management system (DBMS). The DBMS allows instances of XML type to represent XML constructs, such as XML documents, XML elements, XML attributes, and fragments of XML documents. An SQL statement is received that includes an XML operator that operates on a particular component in an instance of XML type. During execution of the SQL statement, the XML operator is evaluated by modifying content for the component without modifying the entire instance. For example, an XML delete operator deletes the particular component from the instance. Other XML operators include an insert operator, an insert-before operator, an append-child operator, and an update operator. During execution, these operators may be rewritten to operate on existing SQL constructs, or evaluated by updating only some of the existing SQL constructs, or both.

摘要翻译： 提供技术用于在符合SQL / XML的数据库管理系统（DBMS）中更改XML构造的数据。 DBMS允许XML类型的实例表示XML构造，例如XML文档，XML元素，XML属性和XML文档片段。 收到一条SQL语句，其中包含一个在XML类型的实例中对特定组件进行操作的XML运算符。 在执行SQL语句期间，通过修改组件的内容而不修改整个实例来评估XML运算符。 例如，XML删除运算符从实例中删除特定组件。 其他XML运算符包括一个插入运算符，一个insert-before运算符，一个append-child运算符和一个update运算符。 在执行期间，这些运算符可能被重写为对现有的SQL结构进行操作，或者只通过更新现有的SQL结构或两者来评估。

公开(公告)号：US20050044113A1

公开(公告)日：2005-02-24

申请号：US10956300

申请日：2004-09-30

申请人： Anand Manikutty ,  Muralidhar Krishnaprasad ,  Ravi Murthy ,  Visar Nimani ,  James Warner ,  Eric Sedlar ,  Neema Jalali ,  Bhushan Khaladkar

发明人： Anand Manikutty ,  Muralidhar Krishnaprasad ,  Ravi Murthy ,  Visar Nimani ,  James Warner ,  Eric Sedlar ,  Neema Jalali ,  Bhushan Khaladkar

IPC分类号： G06F17/30 ,  G06F17/00

CPC分类号： G06F17/3061 ,  G06F17/30923 ,  Y10S707/99943

摘要： Techniques are provided for changing data for an XML construct in an SQL/XML compliant database management system (DBMS). The DBMS allows instances of XML type to represent XML constructs, such as XML documents, XML elements, XML attributes, and fragments of XML documents. An SQL statement is received that includes an XML operator that operates on a particular component in an instance of XML type. During execution of the SQL statement, the XML operator is evaluated by modifying content for the component without modifying the entire instance. For example, an XML delete operator deletes the particular component from the instance. Other XML operators include an insert operator, an insert-before operator, an append-child operator, and an update operator. During execution, these operators may be rewritten to operate on existing SQL constructs, or evaluated by updating only some of the existing SQL constructs, or both.

摘要翻译： 提供技术用于在符合SQL / XML的数据库管理系统（DBMS）中更改XML构造的数据。 DBMS允许XML类型的实例表示XML构造，例如XML文档，XML元素，XML属性和XML文档片段。 收到一条SQL语句，其中包含一个在XML类型的实例中对特定组件进行操作的XML运算符。 在执行SQL语句期间，通过修改组件的内容而不修改整个实例来评估XML运算符。 例如，XML删除运算符从实例中删除特定组件。 其他XML运算符包括一个插入运算符，一个insert-before运算符，一个append-child运算符和一个update运算符。 在执行期间，这些运算符可能被重写为对现有的SQL结构进行操作，或者只通过更新现有的SQL结构或两者来评估。

公开(公告)号：US06836778B2

公开(公告)日：2004-12-28

申请号：US10428445

申请日：2003-05-01

申请人： Anand Manikutty ,  Muralidhar Krishnaprasad ,  Ravi Murthy ,  Visar Nimani ,  James Warner ,  Eric Sedlar ,  Neema Jalali ,  Bhushan Khaladkar

发明人： Anand Manikutty ,  Muralidhar Krishnaprasad ,  Ravi Murthy ,  Visar Nimani ,  James Warner ,  Eric Sedlar ,  Neema Jalali ,  Bhushan Khaladkar

IPC分类号： G06F1730

CPC分类号： G06F17/3061 ,  G06F17/30923 ,  Y10S707/99943

摘要： Techniques are provided for changing data for an XML construct in an SQL/XML compliant database management system (DBMS). The DBMS allows instances of XML type to represent XML constructs, such as XML documents, XML elements, XML attributes, and fragments of XML documents. An SQL statement is received that includes an XML operator that operates on a particular component in an instance of XML type. During execution of the SQL statement, the XML operator is evaluated by modifying content for the component without modifying the entire instance. For example, an XML delete operator deletes the particular component from the instance. Other XML operators include an insert operator, an insert-before operator, an append-child operator, and an update operator. During execution, these operators may be rewritten to operate on existing SQL constructs, or evaluated by updating only some of the existing SQL constructs, or both.

摘要翻译： 提供技术用于在符合SQL / XML的数据库管理系统（DBMS）中更改XML构造的数据。 DBMS允许XML类型的实例表示XML构造，例如XML文档，XML元素，XML属性和XML文档片段。 收到一条SQL语句，其中包含一个在XML类型的实例中对特定组件进行操作的XML运算符。 在执行SQL语句期间，通过修改组件的内容而不修改整个实例来评估XML运算符。 例如，XML删除运算符从实例中删除特定组件。 其他XML运算符包括一个插入运算符，一个insert-before运算符，一个append-child运算符和一个update运算符。 在执行期间，这些运算符可能被重写为对现有的SQL结构进行操作，或者只通过更新现有的SQL结构或两者来评估。

公开(公告)号：US07120645B2

公开(公告)日：2006-10-10

申请号：US10428878

申请日：2003-05-01

申请人： Anand Manikutty ,  Muralidhar Krishnaprasad ,  Ravi Murthy ,  Zhen Liu ,  Subramanian Muralidhar ,  James Warner ,  Sivasankaran Chandrasekar

发明人： Anand Manikutty ,  Muralidhar Krishnaprasad ,  Ravi Murthy ,  Zhen Liu ,  Subramanian Muralidhar ,  James Warner ,  Sivasankaran Chandrasekar

IPC分类号： G06F17/30

CPC分类号： G06F17/30938 ,  G06F17/30917 ,  Y10S707/99943

摘要： Techniques for executing database commands include receiving a database command that includes an XML component operation that operates on an XML construct that is based on a first set of one or more relational database constructs. It is determined whether the XML component operation can be transformed to a relational database operation on a particular set of one or more relational database constructs of the first set, which does not involve the XML component operation. If it is determined that the XML component operation can be transformed, then the XML component operation is rewritten as a particular relational database operation that operates on the particular set and that does not involve the XML component operation. The particular relational database operation is evaluated. In another aspect, techniques include determining a primitive set of XML generation operations and replacing non-primitive XML generation operations with one or more operations from the primitive set.

摘要翻译： 用于执行数据库命令的技术包括接收包括对基于第一组一个或多个关系数据库构造的XML构造进行操作的XML组件操作的数据库命令。 确定XML组件操作是否可以被转换为第一组的一个或多个关系数据库构造的特定集合上的关系数据库操作，其不涉及XML组件操作。 如果确定可以转换XML组件操作，则将XML组件操作重写为在特定集合上操作且不涉及XML组件操作的特定关系数据库操作。 评估特定的关系数据库操作。 在另一方面，技术包括确定XML生成操作的原始集合并且用来自原语集合的一个或多个操作来替换非原始XML生成操作。

公开(公告)号：US20060224627A1

公开(公告)日：2006-10-05

申请号：US11099918

申请日：2005-04-05

申请人： Anand Manikutty ,  Muralidhar Krishnaprasad ,  Zhen Liu ,  James Warner ,  Rohan Angrish ,  Vikas Arora ,  Susan Kotsovolos ,  Ravi Murthy ,  Wesley Lin

发明人： Anand Manikutty ,  Muralidhar Krishnaprasad ,  Zhen Liu ,  James Warner ,  Rohan Angrish ,  Vikas Arora ,  Susan Kotsovolos ,  Ravi Murthy ,  Wesley Lin

IPC分类号： G06F17/00

CPC分类号： G06F17/30938 ,  Y10S707/99943

摘要： A method and apparatus for rewriting a database command containing an embedded XML expression such that the rewritten database command recites a text function, in lieu of the embedded XML expression, is provided. Advantageously, a DBMS may take advantage of the efficiencies in storing XML data within the database, while avoiding the generation of unnecessary XML elements in processing the query when the XML elements contribute nothing to the outcome of the query. Cost-base or rule-based analysis may be performed to determine how to rewrite a received database command. The database server may functionally evaluate the text function or may use an index defined on a column of the database. The text function may function as a primary filter or may reference a column upon which an index is defined, wherein the index operates at the same or higher level than a column being referenced in the embedded XML expression.

摘要翻译： 提供一种用于重写包含嵌入式XML表达式的数据库命令的方法和装置，使得重写的数据库命令背景文本功能代替嵌入的XML表达。 有利地，DBMS可以利用在数据库中存储XML数据的效率，同时避免在XML元素对查询的结果没有贡献时在处理查询时生成不必要的XML元素。 可以执行基于成本或基于规则的分析来确定如何重写接收到的数据库命令。 数据库服务器可以在功能上评估文本功能，或者可以使用在数据库的列上定义的索引。 文本函数可以用作主过滤器，或者可以引用定义索引的列，其中索引在与嵌入式XML表达式中引用的列相同或更高的级别上操作。

公开(公告)号：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.

公开(公告)号：US20050138047A1

公开(公告)日：2005-06-23

申请号：US10810152

申请日：2004-03-26

申请人： Zhen Liu ,  Muralidhar Krishnaprasad ,  Anand Manikutty ,  Ravi Murthy ,  James Warner ,  Thomas Chang ,  Vikas Arora ,  Susan Kotsovolos

发明人： Zhen Liu ,  Muralidhar Krishnaprasad ,  Anand Manikutty ,  Ravi Murthy ,  James Warner ,  Thomas Chang ,  Vikas Arora ,  Susan Kotsovolos

IPC分类号： G06F7/00 ,  G06F17/30

CPC分类号： G06F17/3092

摘要： Techniques for managing XML data associated with multiple execution units ensure that execution units are able to use XML data coming from other execution units. Such techniques are applicable when, but for the technique, an XML type value is produced in a particular form by one execution unit and is supposed to be consumed by another execution unit that is unable to process data in the particular form, and involves detecting that the foregoing situation exists and annotating information sent to an XML producer execution unit to cause the XML type value to be transformed into a canonical form that can be shared by all relevant execution units.

摘要翻译： 管理与多个执行单元相关联的XML数据的技术确保执行单元能够使用来自其他执行单元的XML数据。 这种技术适用于但是对于技术而言，XML类型值由一个执行单元以特定形式产生并且被假定由不能处理特定形式的数据的另一执行单元消耗，并且涉及检测该 存在上述情况并且向XML生成器执行单元注释信息，以使XML类型值被转换成可由所有相关执行单元共享的规范形式。

公开(公告)号：US20070260650A1

公开(公告)日：2007-11-08

申请号：US11416835

申请日：2006-05-03

申请人： James Warner ,  Zhen Liu ,  Sundeep Abraham ,  Muralidhar Krishnaprasad ,  Geeta Arora ,  Ravi Murthy ,  Sivasankaran Chandrasekar ,  Lik Wong ,  Nimar Arora

发明人： James Warner ,  Zhen Liu ,  Sundeep Abraham ,  Muralidhar Krishnaprasad ,  Geeta Arora ,  Ravi Murthy ,  Sivasankaran Chandrasekar ,  Lik Wong ,  Nimar Arora

IPC分类号： G06F17/30

CPC分类号： G06F17/30908

摘要： Efficiently replicating XML data among databases includes techniques for (a) replicating XML data involved with an insert operation; (b) replicating XML data involved with an update operation; (c) leveraging existing relational replication techniques for XML data stored in shredded form using object-relational constructs; and (d) replicating XQuery Data Model sequences. Each technique reduces the amount of information that would otherwise need to be transmitted over a network for XML data replication purposes.

摘要翻译： 在数据库之间有效复制XML数据包括（a）复制与插入操作相关的XML数据的技术; （b）复制涉及更新操作的XML数据; （c）利用现有的关系复制技术，使用对象关系结构存储在切割形式的XML数据; 和（d）复制XQuery数据模型序列。 每种技术减少了为了进行XML数据复制而需要通过网络传输的信息量。

公开(公告)号：US08949220B2

公开(公告)日：2015-02-03

申请号：US10810152

申请日：2004-03-26

申请人： Zhen Liu ,  Muralidhar Krishnaprasad ,  Anand Manikutty ,  Ravi Murthy ,  James Warner ,  Thomas H. Chang ,  Vikas Arora ,  Susan Kotsovolos

发明人： Zhen Liu ,  Muralidhar Krishnaprasad ,  Anand Manikutty ,  Ravi Murthy ,  James Warner ,  Thomas H. Chang ,  Vikas Arora ,  Susan Kotsovolos

IPC分类号： G06F17/30 ,  G06F7/00

CPC分类号： G06F17/3092

摘要： Techniques for managing XML data associated with multiple execution units ensure that execution units are able to use XML data coming from other execution units. Such techniques are applicable when, but for the technique, an XML type value is produced in a particular form by one execution unit and is supposed to be consumed by another execution unit that is unable to process data in the particular form, and involves detecting that the foregoing situation exists and annotating information sent to an XML producer execution unit to cause the XML type value to be transformed into a canonical form that can be shared by all relevant execution units.

摘要翻译： 用于管理与多个执行单元相关联的XML数据的技术确保执行单元能够使用来自其他执行单元的XML数据。 这种技术适用于但是对于技术而言，XML类型值由一个执行单元以特定形式产生并且被假定由不能处理特定形式的数据的另一执行单元消耗，并且涉及检测该 存在上述情况并且向XML生成器执行单元注释信息，以使XML类型值被转换成可由所有相关执行单元共享的规范形式。