Apparatus and method for mapping relational data and metadata to XML
First Claim
Patent Images
1. A computer implemented 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 byextracting, 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;
generating one or more XML schemas that describe features of the one or more XML documents, wherein the features comprise one or more of;
types associated with elements of the one or more XML documents; and
constraints that apply to the one or more XML documents; and
providing said one or more XML documents and said one or more XML schemas as a result of the relational database query in the form of one or more XML documents.
1 Assignment
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.
-
Citations
22 Claims
-
1. A computer implemented 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; generating one or more XML schemas that describe features of the one or more XML documents, wherein the features comprise one or more of; types associated with elements of the one or more XML documents; and constraints that apply to the one or more XML documents; and providing said one or more XML documents and said one or more XML schemas as a result of the relational database query in the form of one or more XML documents. - View Dependent Claims (2, 3, 4)
-
-
5. A computer implemented 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; based on a set of rules, constructing, within the database server, said one or more XML documents using 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 (6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22)
-
Specification