XML document stored as column data
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 in a relational database management system, the main table having an XML column for storing entire extensible markup language (XML) documents in a native XML format;
creating one or more side tables in the relational database management system, wherein each side table has one or more columns that store one or more attributes extracted from the XML documents for fast searching of the XML documnents; 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 in a relational database management system, wherein the main table has a column for storing an extensible markup language (XML) document in a native XML format One or more side tables are created in the relational database management system, wherein each side table has one or more columns that store one or more attributes extracted from the XML document for fast searching of the XML document. Thereafter, the side tables are used to locate data in the main table.
-
Citations
55 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 in a relational database management system, the main table having an XML column for storing entire extensible markup language (XML) documents in a native XML format;
creating one or more side tables in the relational database management system, wherein each side table has one or more columns that store one or more attributes extracted from the XML documents for fast searching of the XML documnents; 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)
searching for the data in the side tables using the indexes; and
mapping data located in the side tables to data in the main table.
-
-
12. The method of claim 1, further comprising searching from a join view.
-
13. The method of claim 1, further comprising receiving a query on one or more side rabies and using the tables to locate data in the queried side tables.
-
14. A The method of claim 1, further comprising using an extracting user-defined function to locate data.
-
15. The method of claim 1, further comprising searching on an attribute with multiple occurrences.
-
16. The method of claim 1, further comprising performing a text search on the XML document.
-
17. The method of claim 1, further comprising performing a range search.
-
18. The method of claim 1, further comprising enabling the column.
-
19. A The method of claim 1, further comprising disabling the column.
-
20. 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 in a relational database management system, the main table having an XML column for stating entire extensible markup language (XML) documents in a native XML format, for creating one or more side tables in the relational database management system, wherein each side table has age or more columns that store one or more attributes extracted from the XML documents for fast searching of the XML documents, and for using the side tables to locate data in the main table. - View Dependent Claims (21, 22, 23, 24, 25, 26, 27, 28, 29, 30, 31, 32, 33, 34, 35, 36, 37, 38)
searching for the data in the side tables using the indexes; and
mapping data located in the side tables to data in the main table.
- and
-
31. The apparatus of claim 20, further comprising searching from a join view.
-
32. The apparatus of claim 20, further comprising receiving a query on one or more side tables and using the side tables to locate data in the queried side tables.
-
33. The apparatus of claim 20, further comprising using an extracting user-defined function to locate data.
-
34. The apparatus of claim 20, further comprising searching on an attribute with multiple occurrences.
-
35. The apparatus of claim 20, further comprising performing a text search on the XML document.
-
36. The apparatus of claim 20, further comprising performing a range search.
-
37. The apparatus of claim 20, further comprising enabling the column.
-
38. The apparatus of claim 20, further comprising disabling the column.
-
39. 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 in a relational database management system, the main table having an XML column for storing entire extensible markup language (XML) document in a native XML format;
creating one or more side tables in the relational database management system, wherein each side table has one ox more columns that store one or more attributes extracted from the XML documents for fast searching of the XML documents; and
using the side tables to locate data in the main table. - View Dependent Claims (40, 41, 42, 43, 44, 45, 46, 47, 48, 49, 50, 51, 52, 53, 54, 55)
searching for the data in the side tables using the indexes; and
mapping data located in the side tables to data in the main table.
-
-
50. The article of manufacture of claim 39, further comprising searching from a join view.
-
51. The article of manufacture of claim 39, further comprising receiving a query on one or more side tables and using the side tables to locate data in the queried side tables.
-
52. The article of manufacture of claim 39, further comprising using an extracting user-defined function to locate data.
-
53. The article of manufacture of claim 39, further comprising searching on an attribute with multiple occurrences.
-
54. The article of manufacture of claim 39, further comprising performing a text search on the XML document.
-
55. The article of manufacture of claim 39, further comprising performing a range search.
Specification