Techniques for efficient integration of text searching with queries over XML data

• US 20060224627A1
• Filed: 04/05/2005
• Published: 10/05/2006
• Est. Priority Date: 04/05/2005
• Status: Active Grant

• Current Assignee: Oracle International Corporation (Oracle Corporation)
• Original Assignee: Oracle International Corporation (Oracle Corporation)
• Inventors: Manikutty, Anand, Arora, Vikas, Angrish, Rohan, Kotsovolos, Susan, Murthy, Ravi, Krishnaprasad, Muralidhar, Liu, Zhen Hua, Lin, Wesley, Warner, James
• Granted Patent: US 7,305,414 B2
• Time in Patent Office: Days
• US Class Current: 1/1
• CPC Class Codes: G06F 16/8373 Query execution
• CPC Class Codes: Y10S 707/99943 Generating database or data structure, e.g. via user interface

Abstract

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.

Claims

1. A machine-implemented method, comprising the steps of:

storing, within one or more structures of a database, data for an XML document;

receiving a database command with an embedded XML query expression, wherein the embedded XML query expression specifies (a) a path that identifies one or more locations within the structure of the XML document, and (b) text search criteria for filtering the one or more locations based on content contained within the one or more locations;

determining whether an index should be used as a primary filter;

upon determination that a set of conditions is satisfied, transforming, within the database command, the embedded XML query expression into a rewritten expression that includes a text function, wherein the text function specifies the path and the text search criteria, and wherein the text function includes a reference to the index if it was determined that the index should be used; and

executing the database command to retrieve data from the one or more structures based on the path and the text search criteria specified in the rewritten expression.

2. The method of claim 1, wherein the rewritten expression consists of the text function.

3. The method of claim 1, wherein the step of determining whether the index should be used as a primary filter is performed based on cost-based or rule-based analysis.

4. The method of claim 3, wherein, based on the cost-based or rule-based analysis, the index is defined on a first column, wherein a second column stores data corresponding to content contained within the one or more locations identified by the path, and wherein the first column is the nearest column to the second column in the path upon which an index is defined.

5. The method of claim 1, wherein the embedded XML query expression is specified using, at least in part, XPath or XQuery.

6. The method of claim 1, wherein determining that the set of conditions is satisfied comprises the step of:

determining whether the properties of the index conflict with the properties of the embedded XML query expression.

7. The method of claim 1, wherein determining that the set of conditions is satisfied comprises the step of:

determining, based on cost-based or rule-based analysis, that the embedded XML query expression should be transformed into the text function.

8. The method of claim 1, wherein the text function is evaluated by functional evaluation.

9. The method of claim 1, wherein the text function is evaluated using the index.

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

storing, within one or more structures of a database, data for an XML document;

receiving a database command with an embedded XML query expression, wherein the embedded XML query expression specifies (a) a path that identifies one or more locations within the structure of the XML document, and (b) search criteria for filtering the one or more locations based on content contained within the one or more locations;

upon determination that a set of conditions is satisfied, rewriting the database command to additionally recite a database function, wherein, upon executing the database command, the database function acts as a primary filter;

executing a first portion of the database command to retrieve, from the one or more structures, a first data set, wherein the first portion includes the database function; and

executing a second portion of the database command, against the first data set, to identify data within the first data set that satisfies the search criteria specified in the embedded XML query expression, wherein the second portion includes the embedded XML query expression.

11. The method of claim 10, wherein the database function references a first set of nodes, wherein the embedded XML query expression references a second set of nodes, and wherein the first set of nodes corresponds to a hierarchy level higher than the second set of nodes.

12. The method of claim 10, wherein the database function is an operator related to document sectioning.

13. The method of claim 12, wherein the operator is either the WITHIN operator or the INPATH operator.

14. The method of claim 10, wherein the text function is evaluated using a text index defined upon a column storing data identified by the embedded XML query expression.

15. A machine-readable medium carrying one or more sequences of instructions, wherein execution of the one or more sequences of instructions by one or more processors causes the one or more processors to perform the steps of:

storing, within one or more structures of a database, data for an XML document;

receiving a database command with an embedded XML query expression, wherein the embedded XML query expression specifies (a) a path that identifies one or more locations within the structure of the XML document, and (b) text search criteria for filtering the one or more locations based on content contained within the one or more locations;

determining whether an index should be used as a primary filter;

upon determination that a set of conditions is satisfied, transforming, within the database command, the embedded XML query expression into a rewritten expression that includes a text function, wherein the text function specifies the path and the text search criteria, and wherein the text function includes a reference to the index if it was determined that the index should be used; and

executing the database command to retrieve data from the one or more structures based on the path and the text search criteria specified in the rewritten expression.

16. The machine-readable medium of claim 15, wherein the rewritten expression consists of the text function.

17. The machine-readable medium of claim 15, wherein the step of determining whether the index should be used as a primary filter is performed based on cost-based or rule-based analysis.

18. The machine-readable medium of claim 17, wherein, based on the cost-based or rule-based analysis, the index is defined on a first column, wherein a second column stores data corresponding to content contained within the one or more locations identified by the path, and wherein the first column is the nearest column to the second column in the path upon which an index is defined.

19. The machine-readable medium of claim 15, wherein the embedded XML query expression is specified using, at least in part, XPath or XQuery.

20. The machine-readable medium of claim 15, wherein determining that the set of conditions is satisfied comprises the step of:

determining whether the properties of the index conflict with the properties of the embedded XML query expression.

21. The machine-readable medium of claim 15, wherein determining that the set of conditions is satisfied comprises the step of:

determining, based on cost-based or rule-based analysis, that the embedded XML query expression should be transformed into the text function.

22. The machine-readable medium of claim 15, wherein the text function is evaluated by functional evaluation.

23. The machine-readable medium of claim 15, wherein the text function is evaluated using the index.

24. A machine-readable medium carrying one or more sequences of instructions, wherein execution of the one or more sequences of instructions by one or more processors causes the one or more processors to perform the steps of:

storing, within one or more structures of a database, data for an XML document;

receiving a database command with an embedded XML query expression, wherein the embedded XML query expression specifies (a) a path that identifies one or more locations within the structure of the XML document, and (b) search criteria for filtering the one or more locations based on content contained within the one or more locations;

upon determination that a set of conditions is satisfied, rewriting the database command to additionally recite a database function, wherein, upon executing the database command, the database function acts as a primary filter;

executing a first portion of the database command to retrieve, from the one or more structures, a first data set, wherein the first portion includes the database function; and

executing a second portion of the database command, against the first data set, to identify data within the first data set that satisfies the search criteria specified in the embedded XML query expression, wherein the second portion includes the embedded XML query expression.

25. The machine-readable medium of claim 24, wherein the database function references a first set of nodes, wherein the embedded XML query expression references a second set of nodes, and wherein the first set of nodes corresponds to a hierarchy level higher than the second set of nodes.

26. The machine-readable medium of claim 24, wherein the database function is an operator related to document sectioning.

27. The machine-readable medium of claim 26, wherein the operator is either the WITHIN operator or the INPATH operator.

28. The machine-readable medium of claim 24, wherein the text function is evaluated using a text index defined upon a column storing data identified by the embedded XML query expression.