System for querying markup language data stored in a relational database according to markup language schema
0 Assignments
0 Petitions
Accused Products
Abstract
A data processing system receives data in a first format utilizing a markup language such as extensible Markup Language (XML), and stores the data in a different, relational database format involving multiple tables and columns, etc. The system translates subsequent query input expressed in the first format to prepare representative query instructions in SQL or another query language compatible with relational data, and thereafter executes the prepared instructions upon data in the relational database. The system outputs results of the query in format dictated by the query input.
-
Citations
24 Claims
-
1-16. -16. (canceled)
-
17. A query processing method, comprising the operations of:
-
receiving input including a statement of a markup language data schema and data described by the markup language data schema;
preparing a translation of the markup language data schema into a relational database schema comprising multiple table definitions each table definition comprising multiple column definitions;
utilizing the translation to translate the received data into translated data comprising an instance of the relational database schema;
receiving query input including at least one of the following;
1) query conditions referring to data formatted according to the markup language data schema, and
2) result-assembly instructions for constructing query results according to the markup language;
wherein the received query input resides in a query language that is structured to operate upon markup language data and contemplates query actions comprising any two or more of Selection, Projection, Join, Grouping, Ordering, and Navigation with at least one of Join and Grouping at minimum;
preparing query instructions implementing at least a portion of said query input, the query instructions including structured query language (SQL) query conditions referring to said relational database schema;
issuing one or more commands to execute the query instructions upon the translated data to produce query results;
receiving the query results and providing an output of the query results according to the query input. - View Dependent Claims (18, 19, 20, 21)
-
-
22. A computer-readable storage medium tangibly embodying a program of machine-readable instructions executable by a digital processing apparatus to perform operations for processing queries, said operations comprising:
-
receiving input including a statement of a markup language data schema and data described by the markup language data schema;
preparing a translation of the markup language data schema into a relational database schema comprising multiple table definitions each table definition comprising multiple column definitions;
utilizing the translation to translate the received data into translated data comprising an instance of the relational database schema;
receiving query input including at least one of the following;
1) query conditions referring to data formatted according to the markup language data schema, and
2) result-assembly instructions for constructing query results according to the markup language;
wherein the received query input resides in a query language that is structured to operate upon markup language data and contemplates query actions comprising any two or more of Selection, Projection, Join, Grouping, Ordering, and Navigation with at least one of Join and Grouping at minimum;
preparing query instructions implementing at least a portion of said query input, the query instructions including structured query language (SQL) query conditions referring to said relational database schema;
issuing one or more commands to execute the query instructions upon the translated data to produce query results;
receiving the query results and providing an output of the query results according to the query input.
-
-
23. Logic circuitry of multiple interconnected electrically conductive elements configured to perform operations to process queries, the operations comprising:
-
receiving input including a statement of a markup language data schema and data described by the markup language data schema;
preparing a translation of the markup language data schema into a relational database schema comprising multiple table definitions each table definition comprising multiple column definitions;
utilizing the translation to translate the received data into translated data comprising an instance of the relational database schema;
receiving query input including at least one of the following;
1) query conditions referring to data formatted according to the markup language data schema, and
2) result-assembly instructions for constructing query results according to the markup language;
wherein the received query input resides in a query language that is structured to operate upon markup language data and contemplates query actions comprising any two or more of Selection, Projection, Join, Grouping, Ordering, and Navigation with at least one of Join and Grouping at minimum;
preparing query instructions implementing at least a portion of said query input, the query instructions including structured query language (SQL) query conditions referring to said relational database schema;
issuing one or more commands to execute the query instructions upon the translated data to produce query results;
receiving the query results and providing an output of the query results according to the query input.
-
-
24. A query processing method, comprising the operations of:
-
receiving multiple different schema/data inputs, each schema/data input including a statement of a markup language data schema and data described by the markup language data schema;
for each schema/data input, performing operations comprising;
preparing a translation of the markup language data schema into a corresponding relational database schema comprising multiple table definitions each table definition comprising multiple column definitions;
utilizing the translation to translate the received data into translated data comprising an instance of the relational database schema;
receiving query input including at least one of the following;
1) query conditions referring to data formatted according to the markup language data schema, and
2) result-assembly instructions for constructing query results according to the markup language;
wherein the received query input resides in a query language that is structured to operate upon markup language data and contemplates query actions comprising any two or more of Selection, Projection, Join, Grouping, Ordering, and Navigation with at least one of Join and Grouping at minimum;
preparing query instructions implementing at least a portion of said query input, the query instructions including structured query language (SQL) query conditions referring to said relational database schema;
responsive to issuance of one or more commands to execute the query instructions upon the translated data and produce query results, receiving the query results and providing an output of the query results according to the query input.
-
Specification