Apparatus and method for mapping relational data and metadata to XML
First Claim
Patent Images
1. A method of providing data, the method comprising the steps of:
- receiving, at a database server, a relational database query to retrieve data that resides in a relational database; and
the database server responding to the relational database query by extracting, from one or more fields within the relational database, content for one or more XML documents;
wherein the content is stored within said one or more fields in the form of one or more data types that are natively supported by the relational database;
wherein the content is not stored within said one or more fields in the form of XML documents within the relational database;
constructing, within the database server, said one or more XML documents based on the content extracted from the one or more fields; and
providing said one or more XML documents as a result of the relational database query in the form of one or more XML documents.
2 Assignments
0 Petitions
Accused Products
Abstract
Techniques are provided for mapping XML data and metadata from data in relational databases. According to certain embodiments of the invention, a mechanism is provided to allow the user to use a database query to retrieve data form a relational database in the form of XML documents by canonically mapping object relational data to XML data and canonically mapping object relational schemas to XML-Schemas. The mechanism causes the generation of XML-schema information for the XML documents.
113 Citations
30 Claims
-
1. A method of providing data, the method comprising the steps of:
-
receiving, at a database server, a relational database query to retrieve data that resides in a relational database; and
the database server responding to the relational database query by extracting, from one or more fields within the relational database, content for one or more XML documents;
wherein the content is stored within said one or more fields in the form of one or more data types that are natively supported by the relational database;
wherein the content is not stored within said one or more fields in the form of XML documents within the relational database;
constructing, within the database server, said one or more XML documents based on the content extracted from the one or more fields; and
providing said one or more XML documents as a result of the relational database query in the form of one or more XML documents. - View Dependent Claims (2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 29)
-
-
15. A computer-readable medium carrying one or more sequences of instructions of providing data, which instructions, when executed by one or more processors, cause the one or more processors to carry out the steps:
-
receiving, at a database server, a relational database query to retrieve data that resides in a relational database; and
the database server responding to the relational database query by extracting from one or more fields within the relational database content for one or more XML documents, wherein the content is not stored in the form of XML documents within the relational database;
constructing, within the database server, said one or more XML documents; and
providing said one or more XML documents as a result of the relational database query in the form of one or more XML documents. - View Dependent Claims (16, 17, 18, 19, 20, 21, 22, 23, 24, 25, 26, 27, 28, 30)
-
Specification