公开(公告)号：US20080065674A1

公开(公告)日：2008-03-13

申请号：US11517969

申请日：2006-09-08

申请人： Zhen Hua Liu ,  Muralidhar Krishnaprasad ,  Hui Joe Chang ,  Anand Manikutty ,  James W. Warner ,  Vikas Arora ,  Susan Kotsovolos

发明人： Zhen Hua Liu ,  Muralidhar Krishnaprasad ,  Hui Joe Chang ,  Anand Manikutty ,  James W. Warner ,  Vikas Arora ,  Susan Kotsovolos

IPC分类号： G06F17/00

CPC分类号： G06F17/30454

摘要： A method for optimizing queries is described. A query, which includes a first expression for determining whether each of a set of values evaluates to NULL or NOT NULL, is received. At compile-time, a first representation of the query is generated, where the first representation indicates that the query is to be performed based on the first expression. Based on the first expression, a second expression is determined. The second expression is such that the first expression would evaluate to any NOT NULL value if and only if the second expression would evaluate to any NOT NULL value. The second expression, when evaluated, is much more computationally efficient compared with the evaluation of the first expression. Based on the first representation, a second representation of the query is generated, where the second representation indicates that the query is to be performed based on the second expression. Thereafter, the query is executed based on the second representation.

摘要翻译： 描述用于优化查询的方法。 一个查询，其中包含一个第一表达式，用于确定一组值中的每一个是否计算为NULL或NOT NULL。 在编译时，生成查询的第一个表示，其中第一个表示指示要根据第一个表达式执行查询。 基于第一个表达式，确定第二个表达式。 第二个表达式使得当且仅当第二个表达式计算为任何NOT NULL值时，第一个表达式将求值为任何NOT NULL值。 第二个表达式与评估第一个表达式相比，计算效率要高得多。 基于第一表示，生成查询的第二表示，其中第二表示指示将基于第二表达式执行查询。 此后，基于第二表示执行查询。

公开(公告)号：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查询。

公开(公告)号：US07668806B2

公开(公告)日：2010-02-23

申请号：US10948536

申请日：2004-09-22

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

发明人： Zhen Hua Liu ,  Muralidhar Krishnaprasad ,  Anand Manikutty ,  James Warner ,  Qin Yu ,  Hui X. Zhang ,  Karuna Muthiah ,  Ying Lu ,  Vikas Arora ,  Susan M. 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） 要在第二数据源上执行的一个或多个操作的第二组。 然后，确定管理标记语言数据源的第一服务器能够执行第一组操作。 发送请求到第一台服务器执行第一组操作。 收到响应，其中响应包含对标记语言数据源执行第一组操作的结果。 最后，至少部分地基于执行第一组操作的结果为查询生成结果。

公开(公告)号：US07516121B2

公开(公告)日：2009-04-07

申请号：US10948523

申请日：2004-09-22

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

发明人： Zhen Hua Liu ,  Muralidhar Krishnaprasad ,  Anand Manikutty ,  James Warner ,  Hui X. Zhang ,  Vikas Arora ,  Susan M. 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.

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

公开(公告)号：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结构或两者来评估。

公开(公告)号：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构造的特定数据的特定序列化数据。 类型字段包括指示第一格式的数据。 消息从数据库系统的发送组件发送到数据库系统的其他接收组件。 这些技术允许格式选择基于发送或接收组件的特性，以更好地利用两个组件可用的资源。

公开(公告)号：US09760647B2

公开(公告)日：2017-09-12

申请号：US11008425

申请日：2004-12-08

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

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

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

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.

公开(公告)号：US07908286B2

公开(公告)日：2011-03-15

申请号：US11007894

申请日：2004-12-08

申请人： Muralidhar Krishnaprasad ,  Zhen Hua Liu ,  Karuna Muthiah ,  Ying Lu ,  James W. Warner ,  Rohan Angrish ,  Vikas Arora ,  Anand Manikutty

发明人： Muralidhar Krishnaprasad ,  Zhen Hua Liu ,  Karuna Muthiah ,  Ying Lu ,  James W. Warner ,  Rohan Angrish ,  Vikas Arora ,  Anand Manikutty

IPC分类号： G06F17/30

CPC分类号： G06F17/30923 ,  G06F17/30861

摘要： An XQuery access API is described, for providing access to XML data from a data source, using the XQuery language. A requestor can request, from a server, performance of an operation on XML data, wherein request messages and response messages conform to the Simple Object Access Protocol (SOAP). Request and response messages can be transmitted using Hypertext Transfer Protocol (HTTP) or Hypertext Transfer Protocol over Secure Socket Layer (HTTPS). The format of the request and response messages is specified in a definition of a Web service, where the definition conforms to the Web Service Description Language (WSDL).

摘要翻译： 描述了一个XQuery访问API，用于使用XQuery语言提供从数据源访问XML数据。 请求者可以从服务器请求执行对XML数据的操作，其中请求消息和响应消息符合简单对象访问协议（SOAP）。 请求和响应消息可以使用超文本传输​​协议（HTTP）或超文本传输​​协议通过安全套接字层（HTTPS）传输。 请求和响应消息的格式在Web服务的定义中指定，其中定义符合Web服务描述语言（WSDL）。