Optimizing correlated XML extracts
First Claim
Patent Images
1. A method comprising performing a machine-executed operation involving instructions, wherein the machine-executed operation is at least one of:
- A) sending said instructions over transmission media;
B) receiving said instructions over transmission media;
C) storing said instructions onto a machine-readable storage medium; and
D) executing the instructions;
wherein said instructions are instructions which, when executed by one or more processors, cause the one or more processors to perform the steps of;
evaluating a first database query that requests fields from one or more XML documents stored in a database, wherein the evaluating includes;
identifying as correlated fields a first plurality of fields that have a value contained in a XML fragment;
determining whether one or more rewrite criteria are satisfied based on the correlated fields; and
if said one or more rewrite criteria are satisfied, then rewriting said first database query to generate a rewritten query that includes a new data source that contains field values from said XML fragment, including certain values for said first plurality of fields and at least one field not requested by said database query.
1 Assignment
0 Petitions
Accused Products
Abstract
Queries that request fields that are contained in the same XML fragments are written to execute them more efficiently.
-
Citations
26 Claims
-
1. A method comprising performing a machine-executed operation involving instructions, wherein the machine-executed operation is at least one of:
-
A) sending said instructions over transmission media;
B) receiving said instructions over transmission media;
C) storing said instructions onto a machine-readable storage medium; and
D) executing the instructions;
wherein said instructions are instructions which, when executed by one or more processors, cause the one or more processors to perform the steps of;
evaluating a first database query that requests fields from one or more XML documents stored in a database, wherein the evaluating includes;
identifying as correlated fields a first plurality of fields that have a value contained in a XML fragment;
determining whether one or more rewrite criteria are satisfied based on the correlated fields; and
if said one or more rewrite criteria are satisfied, then rewriting said first database query to generate a rewritten query that includes a new data source that contains field values from said XML fragment, including certain values for said first plurality of fields and at least one field not requested by said database query. - View Dependent Claims (2, 3, 4, 5, 6, 7, 8, 9)
-
-
10. A method comprising performing a machine-executed operation involving instructions, wherein the machine-executed operation is at least one of:
-
A) sending said instructions over transmission media;
B) receiving said instructions over transmission media;
C) storing said instructions onto a machine-readable storage medium; and
D) executing the instructions;
wherein said instructions are instructions which, when executed by one or more processors, cause the one or more processors to perform the steps of;
evaluating a first database query that requests fields from one or more XML documents stored in a database, wherein the evaluating includes;
identifying one or more XML fragments as a common data source for a plurality of fields requested by said first database query;
for each of the one or more XML fragments identified, establishing as a group of correlated fields the respective plurality of fields;
for each group of correlated fields established;
determining whether one or more rewrite criteria are satisfied based on the group of correlated fields; and
if said one or more rewrite criteria are satisfied, then rewriting said first database query to generate a rewritten query that specifies a new data source for said group of correlated fields, said new data source including certain values for the group'"'"'s respective XML fragment, said certain values including values for the group of correlated fields and at least one field not requested by said database query. - View Dependent Claims (11, 12, 13)
-
-
14. A machine-readable medium carrying one or more sequences of instructions which, when executed by one or more processors, causes the one or more processors to perform the following steps:
-
evaluating a first database query that requests fields from one or more XML documents stored in a database, wherein the evaluating includes;
identifying as correlated fields a first plurality of fields that have a value contained in a XML fragment;
determining whether one or more rewrite criteria are satisfied based on the correlated fields; and
if said one or more rewrite criteria are satisfied, then rewriting said first database query to generate a rewritten query that includes a new data source that contains field values from said XML fragment, including certain values for said first plurality of fields and at least one field not requested by said database query. - View Dependent Claims (15, 16, 17, 18, 19, 20, 21, 22)
-
-
23. A machine-readable medium carrying one or more sequences of instructions which, when executed by one or more processors, causes the one or more processors to perform the following steps:
-
evaluating a first database query that requests fields from one or more XML documents stored in a database, wherein the evaluating includes;
identifying one or more XML fragments as a common data source for a plurality of fields requested by said first database query;
for each of the one or more XML fragments identified, establishing as a group of correlated fields the respective plurality of fields;
for each group of correlated fields established;
determining whether one or more rewrite criteria are satisfied based on the group of correlated fields; and
if said one or more rewrite criteria are satisfied, then rewriting said first database query to generate a rewritten query that specifies a new data source for said group of correlated fields, said new data source including certain values for the group'"'"'s respective XML fragment, said certain values including values for the group of correlated fields and at least one field not requested by said database query. - View Dependent Claims (24, 25, 26)
-
Specification