Techniques for changing XML content in a relational database

• US 7,386,567 B2
• Filed: 09/30/2004
• Issued: 06/10/2008
• Est. Priority Date: 05/01/2003
• Status: Active Grant

• Current Assignee: Oracle International Corporation (Oracle Corporation)
• Original Assignee: Oracle International Corporation (Oracle Corporation)
• Inventors: Warner, James, Manikutty, Anand, Sedlar, Eric, Khaladkar, Bhushan, Murthy, Ravi, Krishnaprasad, Muralidhar, Jalali, Neema, Nimani, Visar
• Primary Examiner(s): MIZRAHI, DIANE D
• Application Number:
  US10/956,300
• Publication Number:
  US 20050044113A1
• Time in Patent Office: 1,349 Days
• Field of Search: 707/102
• US Class Current: 1/1
• CPC Class Codes: G06F 16/30 of unstructured textual data document management systems G06F16/93
• CPC Class Codes: G06F 16/83 Querying
• CPC Class Codes: Y10S 707/99943 Generating database or data structure, e.g. via user interface

Abstract

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.

Claims

1. A method of comprising:

receiving, at a database server, a request to change an XML document by performing an operation on a portion of the XML document, wherein the XML document is stored on durable storage;

in response to the request, accessing the portion of the XML document through relational structures managed by the database server;

creating in volatile memory an in-memory representation of the XML document;

performing the change to the in-memory representation;

tracking which portions of the in-memory representation are changed in response to the request; and

updating the durably stored XML document based on which portions of the in-memory representations were changed without updating portions of the durably stored XML document that were not changed in the in-memory representation.

2. The method of claim 1 wherein:

the in-memory representation has a structure that corresponds to the portion;

the method includes setting a dirty bit associated with the structure in response to performing the change on the in-memory representation; and

inspecting said dirty bit to determine which portions of the durably stored XML document to change to cause the durably stored XML document to reflect changes made to the in-memory representation.

3. A computer-readable storage medium carrying storing one or more sequences of instructions which, when executed by one or more processors, causes the one or more processors to perform the method recited in claim 2, wherein the computer-readable storage medium is one of a volatile memory or a non-volatile memory.

4. The method of claim 1 wherein the step of tracking includes:

allocating a plurality of flags, each of which corresponds to a different portion of the in- memory representation; and

when a change is made to the corresponding portion of the in-memory representation, changing the corresponding flag of the plurality of flags from a first state to a second state.

5. The method of claim 4 wherein the step of making the change to the XML document on durable storage includes executing update statements based on which flags of the plurality of flags are in the second state.

6. A computer-readable storage medium carrying storing one or more sequences of instructions which, when executed by one or more processors, causes the one or more processors to perform the method recited in claim 5, wherein the computer-readable storage medium is one of a volatile memory or a non-volatile memory.

7. A computer-readable storage medium carrying storing one or more sequences of instructions which, when executed by one or more processors, causes the one or more processors to perform the method recited in claim 1, wherein the computer-readable storage medium is one of a volatile memory or a non-volatile memory.

8. A computer-readable storage medium carrying storing one or more sequences of instructions which, when executed by one or more processors, causes the one or more processors to perform the method recited in claim 4, wherein the computer-readable storage medium is one of a volatile memory or a non-volatile memory.

9. A method of comprising:

receiving, at a database server, a request to change an XML document by performing an operation on a portion of the XML document, wherein the XML document is stored on durable storage and the step of receiving a request includes receiving a database command;

rewriting the database command to produce a revised database command; and

in response to the request, accessing the portion of the XML document through relational structures managed by the database server; and

making the change are the XML document on durable storage by executing the revised database command on the portion of the XML document without rewriting onto the durable storage other portions of the XML document.

10. A computer-readable storage medium carrying storing one or more sequences of instructions which, when executed by one or more processors, causes the one or more processors to perform the method recited in claim 9, wherein the computer-readable storage medium is one of a volatile memory or a non-volatile memory.