Effectively and efficiently supporting XML sequence type and XQuery sequence natively in a SQL system

• US 8,463,801 B2
• Filed: 04/04/2005
• Issued: 06/11/2013
• Est. Priority Date: 04/04/2005
• Status: Active Grant

• Current Assignee: Oracle International Corporation (Oracle Corporation)
• Original Assignee: Oracle International Corporation (Oracle Corporation)
• Inventors: Liu, Zhen Hua, Krishnaprasad, Muralidhar, Warner, James W.
• Primary Examiner(s): Ng, Amy
• Application Number:
  US11/098,887
• Publication Number:
  US 20060224576A1
• Time in Patent Office: 2,990 Days
• Field of Search: 707/4, 707/756
• US Class Current: 707/756
• CPC Class Codes: G06F 16/86 Mapping to a database

Abstract

Techniques for effectively and efficiently supporting XML sequence type and XQuery sequence natively in a SQL system are described. According to one aspect, SQL functions that correctly handle XML sequences are provided. Thus, XML sequences are handled effectively. According to another aspect, rules for simplifying an abstract syntax tree (AST) that represents one or more such SQL functions are provided. For each such SQL function that is represented in an AST that represents a SQL query, one or more rules that are relevant to that SQL function are determined. Relevant rules are applied to the representation of the SQL function within the AST. Through the application of the rules to the representations of the SQL functions within the AST, the AST is modified in a manner that simplifies the AST prior to the evaluation of the AST at query execution time. Thus, XML sequences are handled efficiently.

Claims

1. A method of simplifying an abstract syntax tree that represents a query, comprising:

determining whether the abstract syntax tree includes a representation of a first Structured Query Language (SQL) function that either (a) has an input parameter that is of Extensible Markup Language (XML) sequence type or (b) has an output parameter that is of XML sequence type; and

in response to a determination that the abstract syntax tree includes the representation, determining one or more rules that apply to the first SQL function; and

prior to evaluating the abstract syntax tree to execute the query, modifying the abstract syntax tree by applying the one or more rules to the first SQL function in the abstract syntax tree;

wherein determining the one or more rules that apply to the first SQL function comprises;

determining whether an input parameter of the first SQL function is a null value;

determining whether the first SQL function is a member of a specified set of SQL functions; and

in response to a determination that (a) an input parameter of the first SQL function is a null value and (b) the first SQL function is a member of the specified set of SQL functions, including, within the one or more rules, a rule which, when applied, replaces the first SQL function with a null value.

2. A method of simplifying an abstract syntax tree that represents a query, comprising:

determining whether the abstract syntax tree includes a representation of a first Structured Query Language (SQL) function that either (a) has an input parameter that is of Extensible Markup Language (XML) sequence type or (b) has an output parameter that is of XML sequence type; and

in response to a determination that the abstract syntax tree includes the representation, determining one or more rules that apply to the first SQL function; and

prior to evaluating the abstract syntax tree to execute the query, modifying the abstract syntax tree by applying the one or more rules to the first SQL function in the abstract syntax tree;

wherein determining the one or more rules that apply to the first SQL function comprises;

determining whether an input parameter of the first SQL function is a SQL CASE expression;

determining whether the first SQL function is a member of a specified set of SQL functions; and

in response to a determination that (a) an input parameter of the first SQL function is a SQL CASE expression and (b) the first SQL function is a member of the specified set of SQL functions, including, within the one or more rules, a rule which, when applied, replaces the first SQL function with a SQL CASE expression that contains the first SQL function as a return expression.

3. A method of simplifying an abstract syntax tree that represents a query, comprising:

determining whether the abstract syntax tree includes a representation of a first Structured Query Language (SQL) function that either (a) has an input parameter that is of Extensible Markup Language (XML) sequence type or (b) has an output parameter that is of XML sequence type; and

in response to a determination that the abstract syntax tree includes the representation, determining one or more rules that apply to the first SQL function; and

prior to evaluating the abstract syntax tree to execute the query, modifying the abstract syntax tree by applying the one or more rules to the first SQL function in the abstract syntax tree;

wherein determining the one or more rules that apply to the first SQL function comprises;

determining whether the first SQL function has (a) a first input parameter that is a first integer, (b) a second input parameter that is a second integer, and (c) an output parameter that is an XML sequence of atomic values that represent all integers between and including the first integer and the second integer;

determining whether the first integer is equal to the second integer; and

in response to a determination that (a) the first SQL function has (i) a first input parameter that is a first integer, (ii) a second input parameter that is a second integer, and (iii) an output parameter that is an XML sequence of atomic values that represent all integers between and including the first integer and the second integer, and (b) the first integer is equal to the second integer, including, within the one or more rules, a rule which, when applied, replaces the first SQL function with the first integer.

4. A method of processing a Structured Query Language (SQL) query, comprising:

processing a query that contains at least one SQL function that has (a) an input parameter that is of Extensible Markup Language (XML) sequence type and (b) produces output that is not of XML sequence type; and

evaluating the SQL function;

wherein an input parameter of the SQL function is a first instance that (a) is of XML sequence type and (b) is a sequence of items, wherein the output of the SQL function is a SQL collection of XMLType instances, wherein each XMLType instance in the output SQL collection of instances is of XML content type, and wherein for each particular item in the sequence of items, the output SQL collection contains a separate instance that corresponds to said each particular item.

5. A method of processing a Structured Query Language (SQL) query, comprising:

processing a query that contains at least one SQL function that (a) does not take any Extensible Markup Language (XML) type as input and (b) produces output that is of XML sequence type; and

evaluating the SQL function;

wherein an input parameter of the SQL function is a SQL scalar value, wherein the output of the SQL function is an instance that (a) is of XML sequence type and (b) is a sequence of an XQuery atomic value, and wherein the SQL scalar value is equal to the XQuery atomic value.

6. One or more non-transitory machine-readable media storing instructions for simplifying an abstract syntax tree that represents a query, wherein the instructions, when executed by one or more processors, cause:

determining whether the abstract syntax tree includes a representation of a first Structured Query Language (SQL) function that either (a) has an input parameter that is of Extensible Markup Language (XML) sequence type or (b) has an output parameter that is of XML sequence type; and

in response to a determination that the abstract syntax tree includes the representation, determining one or more rules that apply to the first SQL function; and

prior to evaluating the abstract syntax tree to execute the query, modifying the abstract syntax tree by applying the one or more rules to the first SQL function in the abstract syntax tree;

wherein determining the one or more rules that apply to the first SQL function comprises;

determining whether an input parameter of the first SQL function is a null value;

determining whether the first SQL function is a member of a specified set of SQL functions; and

in response to a determination that (a) an input parameter of the first SQL function is a null value and (b) the first SQL function is a member of the specified set of SQL functions, including, within the one or more rules, a rule which, when applied, replaces the first SQL function with a null value.

7. One or more non-transitory machine-readable media storing instructions for simplifying an abstract syntax tree that represents a query, wherein the instructions, when executed by one or more processors, cause:

determining whether the abstract syntax tree includes a representation of a first Structured Query Language (SQL) function that either (a) has an input parameter that is of Extensible Markup Language (XML) sequence type or (b) has an output parameter that is of XML sequence type; and

in response to a determination that the abstract syntax tree includes the representation, determining one or more rules that apply to the first SQL function; and

prior to evaluating the abstract syntax tree to execute the query, modifying the abstract syntax tree by applying the one or more rules to the first SQL function in the abstract syntax tree;

wherein determining the one or more rules that apply to the first SQL function comprises;

determining whether an input parameter of the first SQL function is a SQL CASE expression;

determining whether the first SQL function is a member of a specified set of SQL functions; and

in response to a determination that (a) an input parameter of the first SQL function is a SQL CASE expression and (b) the first SQL function is a member of the specified set of SQL functions, including, within the one or more rules, a rule which, when applied, replaces the first SQL function with a SQL CASE expression that contains the first SQL function as a return expression.

8. One or more non-transitory machine-readable media storing instructions for simplifying an abstract syntax tree that represents a query, wherein the instructions, when executed by one or more processors, cause:

determining whether the abstract syntax tree includes a representation of a first Structured Query Language (SQL) function that either (a) has an input parameter that is of Extensible Markup Language (XML) sequence type or (b) has an output parameter that is of XML sequence type; and

in response to a determination that the abstract syntax tree includes the representation, determining one or more rules that apply to the first SQL function; and

prior to evaluating the abstract syntax tree to execute the query, modifying the abstract syntax tree by applying the one or more rules to the first SQL function in the abstract syntax tree;

wherein determining the one or more rules that apply to the first SQL function comprises;

determining whether the first SQL function has (a) a first input parameter that is a first integer, (b) a second input parameter that is a second integer, and (c) an output parameter that is an XML sequence of atomic values that represent all integers between and including the first integer and the second integer;

determining whether the first integer is equal to the second integer; and

in response to a determination that (a) the first SQL function has (i) a first input parameter that is a first integer, (ii) a second input parameter that is a second integer, and (iii) an output parameter that is an XML sequence of atomic values that represent all integers between and including the first integer and the second integer, and (b) the first integer is equal to the second integer, including, within the one or more rules, a rule which, when applied, replaces the first SQL function with the first integer.

9. One or more non-transitory machine-readable media storing instructions for processing a Structured Query Language (SQL) query, wherein the instructions, when executed by one or more processors, cause:

processing a query that contains at least one SQL function that (a) has an input parameter that is of Extensible Markup Language (XML) sequence type and (b) produces output that is not of XML sequence type; and

evaluating the SQL function;

wherein an input parameter of the SQL function is a first instance that (a) is of XML sequence type and (b) is a sequence of items, wherein the output of the SQL function is a SQL collection of XMLType instances, wherein each XMLType instance in the output SQL collection of instances is of XML content type, and wherein for each particular item in the sequence of items, the output SQL collection contains a separate instance that corresponds to said each particular item.

10. One or more non-transitory machine-readable media storing instructions for processing a Structured Query Language (SQL) query, wherein the instructions, when executed by one or more processors, cause:

processing a query that contains at least one SQL function that (a) does not take any Extensible Markup Language (XML) type as input and (b) produces output that is of XML sequence type; and

evaluating the SQL function;

wherein an input parameter of the SQL function is a SQL scalar value, wherein the output of the SQL function is an instance that (a) is of XML sequence type and (b) is a sequence of an XQuery atomic value, and wherein the SQL scalar value is equal to the XQuery atomic value.