Technique of using XMLType tree as the type infrastructure for XML

• US 7,685,137 B2
• Filed: 01/26/2005
• Issued: 03/23/2010
• Est. Priority Date: 08/06/2004
• Status: Active Grant

• 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
• Primary Examiner(s): Ly; Cheyne D
• Application Number:
  US11/044,472
• Publication Number:
  US 20060031233A1
• Time in Patent Office: 1,882 Days
• Field of Search: 707/100
• US Class Current: 1/1
• CPC Class Codes: G06F 40/143 Markup, e.g. Standard Generalized Markup Language [SGML] or Document Type Definition [DTD]

Abstract

A universal format is used to create a type representation of XMLType instances that are generated in various ways from various sources. An XMLType Type Tree is represented as a hierarchy of nodes, including leaf item node, composite item node, operator node, aggregate node, referred to herein as an XMLType Type Tree. An XMLType Type Tree serves as a digest of the type structure of XMLType, no matter the source of the XMLType instance or its manner of its generation and it creates one uniform abstraction of the type structure of XMLType for the data-typing analysis of XPath and XQuery during query compile time.

Claims

1. A machine-implemented method for generating a type representation of an XMLType instance, comprising the steps of:

generating within a volatile or a nonvolatile memory a XMLType type tree of nodes that represents a uniform abstraction of a type structure of the XMLType instance;

wherein the XMLType type tree of nodes is generated based on the XMLType instance and a source of data type information about the XMLType instance;

wherein the source of data type information is separate from the XMLType instance;

determining data type information about said XMLType instance using the XMLType type tree of nodes without using the source of data type information about the XMLType instance; and

rewriting a query using the data type information determined about the XMLType instance without using the source of data type information about the XMLType instance;

wherein the step of generating a XMLType type tree of nodes includes generating a parent node of one or more children nodes, the parent node corresponding to either,

an operator node that indicates how the one or more children nodes are grouped as a sequence, choice, or permutation, or

an aggregate node with an aggregate quantifier set to indicate a cardinality restriction on the one or more children nodes;

wherein the method is performed by one or more computing devices.

2. The machine-implemented method of claim 1, wherein the source of data type information is one of a plurality of heterogeneous sources of data type information selected from the group consisting of an XML schema, a SQL expression tree, an XQuery query result, an XPath query result, and object type metadata.

3. The machine-implemented method of claim 1, wherein the source of data type information comprises an XML schema associated with the XMLType instance, and wherein the step of generating a XMLType type tree of nodes comprises generating as the parent node,

a sequence operator node that represents a sequence content model construct of said XML schema,

a choice operator node that represents a choice content model construct of said XML schema, or

a permutation operator node that represents an all content model construct of said XML schema.

4. The machine-implemented method of claim 1, wherein the source of data type information comprises a SQL expression returning the XMLType instance.

5. The machine-implemented method of claim 4, wherein the query comprises an XPath query or an XQuery query, and wherein the step of rewriting the query comprises rewriting the query into a SQL query.

6. The machine-implemented method of claim 4, wherein the SQL expression comprises a SQL/XML function converting a SQL object type to the XMLType instance, and wherein the step of generating a XMLType type tree of nodes further comprises:

generating a sequence operator node as the parent node, wherein the one or more children of the parent node each correspond to a member attribute of the SQL object type; and

generating an element composite item node that corresponds to the SQL object type as a parent of the parent node.

7. The machine-implemented method of claim 4, wherein the SQL expression comprises a SQL/XML function converting a collection type to the XMLType instance, and wherein the step of generating a XMLType type tree of nodes comprises:

generating an aggregate node as the parent node, wherein the aggregate quantifier of the aggregate node is set to zero or more; and

generating one child of the parent node based on the collection type.

8. The machine-implemented method of claim 4, wherein the SQL expression comprises an XMLConcat( ) SQL/XML function returning sequence option, and wherein the step of generating a XMLType type tree of nodes further comprises:

generating a sequence operator node as the parent node; and

generating one or more descendant nodes as descendants of the parent node, wherein the one or more descendant nodes are generated based on input SQL expressions to the XMLConcat( ) function.

9. The machine-implemented method of claim 4, wherein the SQL expression comprises a XMLConcat( ) SQL/XML function returning content option, and wherein the step of generating a XMLType type tree of nodes further comprises:

generating a document composite item node; and

generating one or more descendant nodes as descendants of the document composite item node, wherein the one or more descendant nodes are generated based on input SQL expressions to the XMLConcat( ) function.

10. The machine-implemented method of claim 4, wherein the SQL expression comprises an XMLAgg( ) SQL/XML function returning sequence option, and wherein the step of generating a XMLType type tree of nodes further comprises:

generating an aggregate node as the parent node, wherein the aggregate quantifier of the aggregate node is set to zero or more; and

generating one or more descendant nodes as descendants of the parent node, wherein the one or more descendant nodes are generated based on input SQL expressions to the XMLAgg( ) function.

11. The machine-implemented method of claim 4, wherein the SQL expression comprises an XMLAgg( ) SQL/XML function returning content option, and wherein the step of generating a XMLType type tree of nodes further comprises:

generating a document composite item node;

generating an aggregate node as the parent node and as a child of the document composite item node, wherein the aggregate quantifier of the aggregate node is set to zero or more; and

generating one or more descendant nodes as descendants of the aggregate node, wherein the one or more descendant nodes are generated based on input SQL expressions to the XMLAgg( ) function.

12. The machine-implemented method of claim 4, wherein the SQL expression comprises a SQL CASE function, and wherein the step of generating a XMLType type tree of nodes comprises:

generating a choice operator node as the parent node, wherein each of the one or more children of the parent node correspond to a branch of the SQL CASE function.

13. The machine-implemented method of claim 4, wherein the SQL expression comprises an XMLQuery( ) function embedding an XPath expression, and wherein the source of data type information comprises information obtained from performing a data typing analysis on the XPath expression.

14. The machine-implemented method of claim 4, wherein the SQL expression comprises a SQL/XML function embedding an XQuery expression, and wherein the source of data type information comprises information obtained from performing a data typing analysis on the XQuery expression.

15. The machine-implemented method of claim 4, wherein the SQL expression comprises an SQL/XML function returning the XMLType instance whose type structure is unknown during query compile time, and wherein the step of generating a XMLType type tree of nodes further comprises:

generating an aggregate operator node as the parent node, wherein the aggregate quantifier of the aggregate node is set to zero or more; and

generating a choice operator node as a child of the aggregate node; and

generating one or more children nodes of the choice operator node.

16. The machine-implemented method of claim 1, wherein:

the XMLType type tree of nodes contains a first subset of one or more nodes; and

generating based on one or more rules that define equivalent sets of nodes, another XMLType type tree of nodes that include in lieu of the first subset of nodes, a second subset of one or more nodes that are the equivalent to the first subset of one or more nodes.

17. The machine-implemented method of claim 16, wherein the one or more rules include at least one rule from a set of algebra rules that include:

(1) empty*=empty,

(2) empty?=empty,

(3) empty+=empty, and

(4) (T1, . . . , empty, . . Tn)=(T1, . . . , Tn).

18. The machine-implemented method of claim 16, wherein the one or more rules include at least one rule from a set of algebra rules that include:

(1) (T1|T1)*=T1*|T2*,

(2) (T1|T2)?=T1?|T2?, and

(3) (T1|T2)+=T1+|T2+.

19. The machine-implemented method of claim 16, wherein the one or more rules include at least one rule from a set of algebra rules that include:

(1) (T*)*=T*,

(2) (T*)?=T*,

(3) (T*)+=T*,

(4) (T?)?=T,

(5) (T?)?=T*,

(6) (T?)+=T*,

(7) (T+)?=T*,

(8) (T+)+=T+, and

(9) (T+)*=T*.

20. The machine-implemented method of claim 16, wherein the one or more rules include at least one rule from a set of algebra rules that include:

(1) T1&

T2=(T1, T2)|(T2, T1),

(2) T|T=T, and

(3) T&

T=T, T.

21. The machine-implemented method of claim 16, wherein the one or more rules include at least one rule from a set of algebra rules that include:

(1) T?=empty|T, and

(2) T*=empty|T+.

22. A computer-readable storage medium storing instructions for generating a type representation of an XMLType instance, the instructions, when executed by one or more computing devices, cause the one or more computing devices to perform the steps of:

generating within a volatile or a nonvolatile memory a XMLType type tree of nodes that represents a uniform abstraction of a type structure of the XMLType instance;

wherein the XMLType type tree of nodes is generated based on the XMLType instance and a source of data type information about the XMLType instance;

wherein the source of data type information is separate from the XMLType instance;

determining data type information about said XMLType instance using the XMLType type tree of nodes without using the source of data type information about the XMLType instance; and

rewriting a query using the data type information determined about the XMLType instance without using the source of data type information about the XMLType instance;

wherein the step of generating a XMLType type tree of nodes includes generating a parent node of one or more children nodes, the parent node corresponding to either,

an operator node that indicates how the one or more children nodes are grouped as a sequence, choice, or permutation, or

an aggregate node with an aggregate quantifier set to indicate a cardinality restriction on the one or more children nodes.

23. The computer-readable storage medium of claim 22, wherein the source of data type information is one of a plurality of heterogeneous sources of data type information selected from the group consisting of an XML schema, a SQL expression tree, an XQuery query result, an XPath query result, and object type metadata.

24. The computer-readable storage medium of claim 22, wherein the source of data type information comprises an XML schema associated with the XMLType instance, and wherein the step of generating a XMLType type tree of nodes comprises generating as the parent node,

a sequence operator node that represents a sequence content model construct of said XML schema,

a choice operator node that represents a choice content model construct of said XML schema, or

a permutation operator node that represents an all content model construct of said XML schema.

25. The computer-readable storage medium of claim 22, wherein the source of data type information comprises a SQL expression returning the XMLType instance.

26. The computer-readable storage medium of claim 25, wherein the query comprises an XPath query or an XQuery query, and wherein the step of rewriting the query comprises rewriting the query into a SQL query.

27. The computer-readable storage medium of claim 22, wherein:

the XMLType type tree of nodes contains a first subset of one or more nodes; and

generating based on one or more rules that define equivalent sets of nodes, another XMLType type tree of nodes that include in lieu of the first subset of nodes, a second subset of one or more nodes that are the equivalent to the first subset of one or more nodes.

28. The computer-readable storage medium of claim 27, wherein the one or more rules include at least one rule from a set of algebra rules that include:

29. The computer-readable storage medium of claim 27, wherein the one or more rules include at least one rule from a set of algebra rules that include:

30. The computer-readable storage medium of claim 27, wherein the one or more rules include at least one rule from a set of algebra rules that include:

31. The computer-readable storage medium of claim 27, wherein the one or more rules include at least one rule from a set of algebra rules that include:

32. The computer-readable storage medium of claim 27, wherein the one or more rules include at least one rule from a set of algebra rules that include: