公开(公告)号：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类型值被转换成可由所有相关执行单元共享的规范形式。

公开(公告)号：US20050065949A1

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

申请号：US10984471

申请日：2004-11-08

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

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

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

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

摘要： Techniques are described for executing queries that have XPath sections that specify unmappable paths. The techniques involve splitting the unmappable paths into (1) a mappable path fragment, and (2) an unmappable path fragment. After an unmappable path has been split into a mappable path fragment and an unmappable path fragment, the XPath section is replaced with a replacement XPath section. The replacement XPath section specifies two operations: a “mappable operation” that is based on the mappable path fragment, and an “unmappable operation” that is based on the unmappable path fragment. The portion of the replacement XPath section that specifies the mappable operation is rewritten to access underlying relational structures. Consequently, when the rewritten query is executed, a smaller amount of XML data needs to be materialized to evaluate the unmappable path fragment than would otherwise have been required to evaluate the original unmappable path.

摘要翻译： 描述了执行具有指定不可映射路径的XPath节的查询的技术。 这些技术涉及将不可映射的路径分解为（1）可映射路径片段，以及（2）不可映射的路径片段。 将不可映射路径分解为可映射路径片段和不可映射路径片段后，XPath节将替换为替换的XPath节。 替换XPath部分指定两个操作：基于可映射路径片段的“可映射操作”和基于不可映射路径片段的“不可映映操作”。 替换XPath部分指定可映射操作的部分被重写为访问基础关系结构。 因此，当执行重写的查询时，需要实现较少量的XML数据来评估不可映射的路径片段，而不是否则需要评估原始的不可映射路径。

公开(公告)号：US20060031204A1

公开(公告)日：2006-02-09

申请号：US10948536

申请日：2004-09-22

申请人： Zhen Liu ,  Muralidhar Krishnaprasad ,  Anand Manikutty ,  James Warner ,  Qin Yu ,  Hui Zhang ,  Karuna Muthiah ,  Ying Lu ,  Vikas Arora ,  Susan Kotsovolos

发明人： Zhen Liu ,  Muralidhar Krishnaprasad ,  Anand Manikutty ,  James Warner ,  Qin Yu ,  Hui Zhang ,  Karuna Muthiah ,  Ying Lu ,  Vikas Arora ,  Susan Kotsovolos

IPC分类号： G06F17/30

CPC分类号： G06F17/30545 ,  G06F17/30935 ,  Y10S707/99933

摘要： Techniques are provided for processing a query, including receiving the query, where the query specifies certain operations to be performed, including (a) a first set of one or more operations that are to be performed on a markup language data source and (b) a second set of one or more operations that are to be performed on a second data source. Then it is determined that a first server that manages the markup language data source is capable of performing the first set of operations. A request is sent to the first server to perform the first set of operations. A response is received, where the response contains results of performing the first set of operations on the markup language data source. Finally, results are generated for the query based at least in part on the results of performing the first set of operations.

摘要翻译： 提供了用于处理查询的技术，包括接收查询，其中查询指定要执行的某些操作，包括（a）要在标记语言数据源上执行的一个或多个操作的第一组，以及（b） 要在第二数据源上执行的一个或多个操作的第二组。 然后，确定管理标记语言数据源的第一服务器能够执行第一组操作。 发送请求到第一台服务器执行第一组操作。 收到响应，其中响应包含对标记语言数据源执行第一组操作的结果。 最后，至少部分地基于执行第一组操作的结果为查询生成结果。

公开(公告)号：US20050289175A1

公开(公告)日：2005-12-29

申请号：US11100083

申请日：2005-04-05

申请人： Muralidhar Krishnaprasad ,  Zhen Liu ,  Vikas Arora ,  James Warner ,  Anand Manikutty

发明人： Muralidhar Krishnaprasad ,  Zhen Liu ,  Vikas Arora ,  James Warner ,  Anand Manikutty

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

CPC分类号： G06F16/86 ,  G06F16/8373

摘要： Object-relational database systems process XML values in a way that preserves node identities of nodes in the XML values and perform node-id based operations more efficiently or even in circumstances where such operations were not performed. An object-relational database system represents an XML value as a serialized stream of bytes, herein referred to as a serialized image. A serialized image may represent an XML value of the XMLType that is stored and/or generated by an object-relational database system. The serialized image contains one or more node identifiers that identify nodes within the XML value. The serialized image may also contain a pointer to an in-memory representation of the XML value, allowing the in-memory representation to be accessed via the pointer without having re-create the in-memory representation.

摘要翻译： 对象关系数据库系统以保持XML值中节点的身份标识并更有效地执行基于节点ID的操作的方式处理XML值，甚至在不执行此类操作的情况下处理XML值。 对象关系数据库系统将XML值表示为串行字节流，这里称为序列化图像。 序列化图像可以表示由对象关系数据库系统存储和/或生成的XMLType的XML值。 序列化图像包含一个或多个标识XML值中的节点的节点标识符。 序列化图像还可以包含指向XML值的内存中表示的指针，允许通过指针访问内存中的表示，而不重新创建内存中的表示。

公开(公告)号：US20050289125A1

公开(公告)日：2005-12-29

申请号：US10948523

申请日：2004-09-22

申请人： Zhen Liu ,  Muralidhar Krishnaprasad ,  Anand Manikutty ,  James Warner ,  Hui Zhang ,  Vikas Arora ,  Susan Kotsovolos

发明人： Zhen Liu ,  Muralidhar Krishnaprasad ,  Anand Manikutty ,  James Warner ,  Hui Zhang ,  Vikas Arora ,  Susan Kotsovolos

IPC分类号： G06F17/30

CPC分类号： G06F17/30421 ,  G06F17/30436 ,  G06F17/30451 ,  G06F17/30932 ,  Y10S707/99932 ,  Y10S707/99933 ,  Y10S707/99934

摘要： Techniques are provided for processing a query including receiving the query, where the query specifies certain operations; determining that the query includes a first portion in a first query language and a second portion in a second query language; generating a first in-memory representation for the first portion; generating a second in-memory representation for the second portion; generating a third in-memory representation of the query based on the first in-memory representation and the second in-memory representation; and performing the certain operations based on the third in-memory representation.

摘要翻译： 提供技术来处理查询，包括接收查询，查询指定某些操作; 确定所述查询包括第一查询语言的第一部分和第二查询语言中的第二部分; 产生第一部分的第一内存中表示; 产生第二部分的第二内存中表示; 基于所述第一内存中表示和所述第二内存中表示，生成所述查询的第三内存中表示; 以及基于第三内存中表示执行某些操作。

公开(公告)号：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类型值被转换成可由所有相关执行单元共享的规范形式。

公开(公告)号：US20060136351A1

公开(公告)日：2006-06-22

申请号：US11008425

申请日：2004-12-08

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

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

IPC分类号： G06F17/30 ,  G06F9/44

CPC分类号： G06F17/3089 ,  G06F9/547

摘要： A database server that manages a database retrieves metadata that is stored, within the database, in association with a procedure that is stored in the database. Based on the metadata, a Web service definition is automatically constructed to describe the procedure as a Web service. The WSDL definition can be referenced to construct SOAP messages with the appropriate arguments and in the appropriate format which, when received, are converted to a suitable format for invoking execution of the procedure by the database server.

摘要翻译： 管理数据库的数据库服务器检索数据库中与存储在数据库中的过程相关联的元数据。 基于元数据，自动构造Web服务定义，以将过程描述为Web服务。 可以引用WSDL定义来构造具有适当参数和适当格式的SOAP消息，当接收到该消息时，它将被转换为用于由数据库服务器调用该过程的适当格式。

公开(公告)号：US20060031233A1

公开(公告)日：2006-02-09

申请号：US11044472

申请日：2005-01-26

申请人： Zhen Liu ,  Muralidhar Krishnaprasad ,  Vikas Arora ,  James Warner ,  Anand Manikutty

发明人： Zhen Liu ,  Muralidhar Krishnaprasad ,  Vikas Arora ,  James Warner ,  Anand Manikutty

IPC分类号： G06F7/00

CPC分类号： G06F17/2247

摘要： A universal format is used to create a type representation of XMLType instances that are generated in various ways from various sources. An XMLType Type Tree is represented as a hierarchy of nodes, including leaf item node, composite item node, operator node, aggregate node, referred to herein as an XMLType Type Tree. An XMLType Type Tree serves as a digest of the type structure of XMLType, no matter the source of the XMLType instance or its manner of its generation and it creates one uniform abstraction of the type structure of XMLType for the data-typing analysis of XPath and XQuery during query compile time.

摘要翻译： 通用格式用于创建以各种方式生成的XMLType实例的类型表示形式。 XMLType类型树被表示为节点的层次结构，包括叶项目节点，复合项目节点，运营商节点，聚合节点，这里称为XMLType类型树。 XMLType类型树作为XMLType的类型结构的摘要，无论XMLType实例的来源或其生成方式如何，它都会为XPath的数据类型分析创建XMLType类型结构的一个统一抽象， 查询编译期间的XQuery。