Generating one or more XML documents from a single SQL query
First Claim
1. A method of locating data in a data store connected to a computer, the method comprising the steps of:
- creating a main table having a column for storing a document, wherein the document has one or more elements or attributes;
creating one or more side tables, wherein each side table stores one or more elements or attributes; and
using the side tables to locate data in the main table.
3 Assignments
0 Petitions
Accused Products
Abstract
A technique is provided for creating metadata for fast search of XML documents stored as column data. Data is stored in a data store connected to a computer. A main table is created having a column for storing a document, wherein the document has one or more elements or attributes. One or more side tables are created, wherein each side table stores one or more elements or attributes. Then, the side tables are used to locate data in the main table with scalable indexing mechanisms to facilitate search.
A technique is provided for generating one or more XML documents from a single SQL query. Data stored on a data storage device that is connected to a computer is transformed. A query that selects data in the data storage device is received. The selected data is retrieved into a work space. Then, one or more XML documents are generated to consist of the selected data.
A technique is provided for generating one or more XML documents from a relational database using the XPath data model. Data stored on a data storage device that is connected to a computer is transformed. Initially, a document object model tree is generated using a document access definition, which defines the mapping between an XML tree structure and relational tables. The document object model tree is traversed to obtain information to retrieve relational data. The relational data is mapped to one or more XML documents.
A technique is provided to store fragmented XML data into a relational database by decomposing XML documents with application specific mappings. Data stored on a data store that is connected to a computer is transformed. Initially, an XML document containing XML data is received. A document access definition that identifies one or more relational tables and columns is received. The XML data is mapped from the application DTD to the relational tables and columns using the document access definition based on the XPath data model.
-
Citations
190 Claims
-
1. A method of locating data in a data store connected to a computer, the method comprising the steps of:
-
creating a main table having a column for storing a document, wherein the document has one or more elements or attributes;
creating one or more side tables, wherein each side table stores one or more elements or attributes; and
using the side tables to locate data in the main table. - View Dependent Claims (2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19)
-
-
20. The method of claim l, further comprising disabling the column.
-
21. An apparatus for locating data in a data store, comprising:
-
a computer having a data store coupled thereto, wherein the data store stores data; and
one or more computer programs, performed by the computer, for creating a main table having a column for storing a document, wherein the document has one or more elements or attributes, for creating one or more side tables, wherein each side table stores one or more elements or attributes, and for using the side tables to locate data in the main table. - View Dependent Claims (22, 23, 24, 25, 26, 27, 28, 29, 30, 31, 32, 33, 34, 35, 36, 37, 38, 39, 40)
-
-
41. An article of manufacture comprising a program storage medium readable by a computer and embodying one or more instructions executable by the computer to perform method steps for locating data in a data store connected to the computer, the method comprising the steps of:
-
creating a main table having a column for storing a document, wherein the document has one or more elements or attributes;
creating one or more side tables, wherein each side table stores one or more elements or attributes; and
using the side tables to locate data in the main table. - View Dependent Claims (42, 43, 44, 45, 46, 47, 48, 49, 50, 51, 52, 53, 54, 55, 56, 57, 58, 60, 61, 62, 63, 64, 65, 66, 67, 68, 69, 70, 71, 72, 73, 74, 75, 76, 77, 79, 80, 81, 82, 83, 84, 85, 86, 87, 88, 89, 90, 91, 92, 93, 94, 95, 96)
-
-
59. A method of transforming data stored on a data storage device that is connected to a computer, the method comprising:
-
receiving a query that selects data in the data storage device;
retrieving the selected data into a work space; and
generating one or more XML documents to consist of the selected data.
-
-
78. An apparatus for transforming data, comprising:
-
a computer having a data store coupled thereto, wherein the data store stores data; and
one or more computer programs, performed by the computer, for receiving a query that selects data in the data storage device, retrieving the selected data into a work space, and generating one or more XML documents to consist of the selected data.
-
-
97. An article of manufacture comprising a program storage medium readable by a computer and embodying one or more instructions executable by the computer to perform method steps for transforming data in a data store connected to the computer, the method comprising the steps of:
-
receiving a query that selects data in the data storage device;
retrieving the selected data into a work space; and
generating one or more XML documents to consist of the selected data. - View Dependent Claims (98, 99, 100, 101, 102, 103, 104, 105, 106, 107, 108, 109, 110, 111, 112, 113, 114, 115, 117, 118, 119, 120, 121, 122, 123, 124, 125, 126, 127, 128, 129, 130, 132, 133, 134, 135, 136, 137, 138, 139, 140, 141, 142, 143, 144, 145, 147, 148, 149, 150, 151, 152, 153, 154, 155, 156, 157, 158, 159, 160, 162, 163, 164, 165, 166, 167, 168, 169, 170, 172, 173, 174, 175, 176, 177, 178, 179, 180, 182, 183, 184, 185, 186, 187, 188, 189, 190)
-
-
116. A method of transforming data stored on a data storage device that is connected to a computer, the method comprising:
-
generating a document object model tree using a document access definition;
traversing the document object model tree to obtain information to retrieve relational data; and
mapping the relational data to one or more XML documents.
-
-
131. An apparatus for transforming data, comprising:
-
a computer having a data store coupled thereto, wherein the data store stores data; and
one or more computer programs, performed by the computer, for generating a document object model tree using a document access definition, traversing the document object model tree to obtain information to retrieve relational data, and mapping the relational data to one or more XML documents.
-
-
146. An article of manufacture comprising a program storage medium readable by a computer and embodying one or more instructions executable by the computer to perform steps for transforming data in a data store connected to the computer, comprising:
-
generating a document object model tree using a document access definition;
traversing the document object model tree to obtain information to retrieve relational data; and
mapping the relational data to one or more XML documents.
-
-
161. A method of transforming data stored on a data store that is connected to a computer, comprising:
-
receiving an XML document containing XML data;
receiving a document access definition that identifies one or more relational tables and columns; and
mapping the XML data to the relational tables and columns using the document access definition.
-
-
171. An apparatus for transforming data, comprising:
-
a computer having a data store coupled thereto, wherein the data store stores data; and
one or more computer programs, performed by the computer, for receiving an XML document containing XML data, receiving a document access definition that identifies one or more relational tables and columns, and mapping the XML data to the relational tables and columns using the document access definition.
-
-
181. An article of manufacture comprising a program storage medium readable by a computer and embodying one or more instructions executable by the computer to perform steps for transforming data in a data store connected to the computer, comprising:
-
receiving XML document containing XML data;
receiving a document access definition that identifies one or more relational tables and columns; and
mapping the XML data to the relational tables and columns using the document access definition.
-
Specification