Techniques for partial rewrite of XPath queries in a relational database

• US 7,386,568 B2
• Filed: 11/08/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: Manikutty, Anand, Arora, Vikas, Angrish, Rohan, Warner, James W., Krishnaprasad, Muralidhar, Liu, Zhen Hua, Kotsovolos, Susan M.
• Primary Examiner(s): MIZRAHI, DIANE D
• Application Number:
  US10/984,471
• Publication Number:
  US 20050065949A1
• Time in Patent Office: 1,310 Days
• Field of Search: 707/102
• US Class Current: 1/1
• CPC Class Codes: G06F 16/24534 Query rewriting; Transformation
• CPC Class Codes: G06F 16/8373 Query execution
• CPC Class Codes: G06F 16/86 Mapping to a database
• CPC Class Codes: Y10S 707/99943 Generating database or data structure, e.g. via user interface

Abstract

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.

Claims

1. A computer-implemented method for processing a database command that includes section that specifies an operation to be performed on an unmappable path, which when executed by a computer causes the computer to perform the method which comprises the steps of:

splitting the unmappable path into a plurality of path fragments, wherein the plurality of path fragments includes a mappable path fragment and an unmappable path fragment; and

replacing the section with a replacement section that specifies operations involving path fragments from the plurality of path fragments, wherein the operations include;

a mappable operation whose target is defined by the mappable path fragment; and

an unmappable operation whose target is defined by the unmappable path fragment.

2. The method of claim 1 wherein:

the section is an XPath section; and

the step of replacing the section with a replacement section that specifies operations involving path fragments from the plurality of path fragments, includes replacing the XPath section with a replacement XPath section that specifies operations involving path fragments from the plurality of path fragments.

3. The method of claim 2 wherein:

the mappable operation is defined by a particular portion of the replacement XPath section; and

the method further comprises the step of rewriting the particular portion prior to executing the database command.

4. The method of claim 3 wherein the step of rewriting the particular portion includes rewriting the particular portion over structured schema-based storage.

5. A computer-readable storage medium 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.

6. The method of claim 3 wherein the step of rewriting the particular portion includes rewriting the particular portion over one or more SQL/XML views.

7. A computer-readable storage medium 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 6.

8. The method of claim 3 wherein the step of rewriting the particular portion includes rewriting the particular portion over one or more object views.

9. A computer-readable storage medium 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 8.

10. The method of claim 3 wherein the step of rewriting the particular portion includes rewriting the particular portion over a combination of two or more storage types from a set of storage types that consists of object views, SQL/XML views, and structured schema-based storage.

11. A computer-readable storage medium 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 10.

12. A computer-readable storage medium 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 3.

13. The method of claim 2 wherein the method further includes determining that the unmappable path can be split into mappable and unmappable fragments prior to splitting the unmappable path into a mappable path fragment and an unmappable path fragment.

14. The method of claim 13 wherein the step of determining that the unmappable path can be split into mappable and unmappable fragments includes determining that the unmappable path does not have an unmappable element as the first node in the unmappable path.

15. A computer-readable storage medium 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 14.

16. The method of claim 13 wherein the step of determining that the unmappable path can be split into mappable and unmappable fragments includes determining that the unmappable path does not point to a collection element.

17. A computer-readable storage medium 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 16.

18. The method of claim 13 wherein the step of determining that the unmappable path can be split into mappable and unmappable fragments includes determining that the unmappable path does not have a reference to an ancestor, ancestor-or-self, preceding, preceding-sibling, parent, following, or following-sibling axis at any level beneath an unrewritable node.

19. A computer-readable storage medium 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 18.

20. A computer-readable storage medium 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 13.

21. A computer-readable storage medium 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.