Providing XML node identity based operations in a value based SQL system

• US 20050289175A1
• Filed: 04/05/2005
• Published: 12/29/2005
• Est. Priority Date: 06/23/2004
• Status: Abandoned Application

• Current Assignee: Oracle International Corporation (Oracle Corporation)
• Original Assignee: Oracle International Corporation (Oracle Corporation)
• Inventors: Manikutty, Anand, Arora, Vikas, Warner, James W., Krishnaprasad, Muralidhar, Liu, Zhen Hua
• Application Number:
  US11/100,083
• Publication Number:
  US 20050289175A1
• Time in Patent Office: Days
• US Class Current: 1/1
• CPC Class Codes: G06F 16/8373 Query execution
• CPC Class Codes: G06F 16/86 Mapping to a database

Abstract

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.

Claims

1. A method for generating a representation of an XML value type, comprising the steps of:

for each XML value of a plurality of XML values, generating a serialized image;

wherein each XML value includes at least one node, each node of said at least one node having a node value; and

within each serialized image generated for each XML value of said plurality of XML values, storing a node identifier that uniquely identifies said at least one node relative to any other node in the plurality of XML values.

2. The method of claim 1, wherein:

the plurality of XML values include a first XML value and a second XML value;

a first serialized image is generated for the first XML value and a second serialized image is generated for the second XML value; and

the steps further include the step of performing a node-id based operation by comparing the node identifier of the first serialized image to the node identifier of the second serialized image

3. The method of claim 2, wherein

the node identifier of the first serialized image includes first hierarchical position data;

the node identifier of the second serialized image includes second hierarchical position data; and

the step of comparing the node identifier of the first serialized image to the node identifier of the second serialized image includes comparing the first hierarchical position data to the second hierarchical position data.

4. The method of claim 3, wherein:

for each XML value of said plurality of XML values, said each XML value is an instance of an XML schema; and

the first hierarchical position data and the second hierarchical position data includes data based on said XML schema.

5. The method of claim 2, wherein

an in-memory is generated for the first serialized image;

an in-memory representation is generated for the second serialized image;

the step of performing a node-id based operation includes comparing the respective in-memory representations of the first serialized image and the second serialized image.

6. The method of claim 1, wherein the node identifier includes a pointer.

7. The method of claim 1, wherein for each XML value of said plurality of XML values, the value for the at least one node is stored in a column of a table in an object-relational database system.

8. The method of claim 7, wherein the node-identifier includes data identifying a row in said table.

9. The method of claim 8, wherein the node identifier includes data identifying said column.

10. A computer-implemented method, the method comprising the steps of:

a database system receiving a database query that includes a first expression and a second expression that returns one or more XML values;

wherein an evaluation of the second expression requires access to an in-memory structure representing an XML value;

during an evaluation of the first expression, generating the in-memory representation representing the XML value and a pointer to the in-memory representation; and

during an evaluation of the second expression, accessing the in-memory representation using the pointer.

11. The method of claim 10, the steps further including:

generating a serialized image as an XML value returned for the first expression, wherein said generating a serialized image includes storing a pointer to the in-memory representation in the serialized image; and

wherein accessing the in-memory representation includes accessing the in-memory representation using the pointer from the serialized image.

12. The method of claim 11, wherein the steps further include:

determining that the first expression and the second expression specify a common expression; and

wherein said determining causes accessing the in-memory representation using the pointer from the serialized image during the evaluation of the second expression.

13. The method of claim 12, wherein the step of determining is performed during compile-time analysis of said database query.

14. The method of claim 10, the steps further include:

determining that the second expression is a subexpression of the first expression; and

wherein said determining causes said accessing the in-memory representation using the pointer from the serialized image during the evaluation of the second expression.

15. The method of claim 14, wherein:

the first expression is a function invocation; and

determining that the second expression is a subexpression of the first expression includes determining that the second expression is an input parameter of the function invocation.

16. A computer-implemented method, the method comprising the steps of:

generating an in-memory representation of an XML value in the memory of a computer;

generating a first serialized image of the XML value that contains a first pointer to the in-memory representation; and

generating a second serialized image of the XML value that contains a second pointer to the in-memory representation of the XML value.

17. The method of claim 16, wherein the steps further include performing a node-id based operation based on the first pointer.

18. The method of claim 17, wherein performing a node-id based operation includes comparing the first pointer to the second pointer.

19. The method of claim 17, wherein performing a node-id operation includes evaluating the in-memory representation, wherein evaluating the in-memory representation includes using the first pointer in the serialized image to access the in-memory representation and evaluate the in-memory representation.