System and method for the storage, indexing and retrieval of XML documents using relation databases
First Claim
Patent Images
1. A computer system for manipulating an XML document using a relational database, comprising:
- a converter that receives an XML document and generates a pre-determined set of relational database tables based on the XML document;
a database for storing the relational database table; and
a searcher for querying the generated relational database table in the database to locate content originally in the XML document that is now stored in the relational database table wherein the located content is returned to the user as a portion of an XML document.
2 Assignments
0 Petitions
Accused Products
Abstract
A system and method for assigning attributes to XML document nodes to facilitate their storage in relational databases and the subsequent retrieval and re-construction of pertinent nodes and fragments in original document order is provided. Since these queries are performed using relational database query engines, the speed of their execution is significantly faster than that using more exotic systems such as object-oriented databases. Furthermore, this method is portable across all vendor platforms, and so can be deployed at client sites without additional investments in database software.
234 Citations
25 Claims
-
1. A computer system for manipulating an XML document using a relational database, comprising:
-
a converter that receives an XML document and generates a pre-determined set of relational database tables based on the XML document;
a database for storing the relational database table; and
a searcher for querying the generated relational database table in the database to locate content originally in the XML document that is now stored in the relational database table wherein the located content is returned to the user as a portion of an XML document. - View Dependent Claims (2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23, 25)
-
-
12. A computer system for storing an XML document using a relational database, comprising:
-
a converter that receives an XML document and generates a relational database table based on the XML document;
the converter further comprising a software module that generates a unique name attribute for each node in the XML document, a software module that generates a path attribute for a particular node of the XML document wherein the path attribute comprises a list of the name attributes for the one or more nodes from the particular node to a root node of the XML document, a software module that generates an order attribute for the particular node, the order attribute comprising an enumerated order of the particular node from the root node to the particular node, and a software module that generates a NodeValue attribute containing a value of the particular node.
-
-
13. A method for manipulating an XML document using a relational database, comprising:
-
generating a relational database table based on an XML document wherein the information about each node of the XML document is stored in a row of the table;
storing the relational database table in a database; and
querying the generated relational database table in the database to locate content originally in the XML document that is now stored in the relational database table wherein the located content is returned to the user as a portion of an XML document.
-
-
24. A data structure that stores a node of interest of an XML document in a relational database, the data structure comprising:
-
an XMLName attribute comprising a unique name for the node of interest;
a NamePath attribute comprising a list of the XMLName attributes for the one or more nodes from the node of interest to a root node of the XML document;
an OrderPath attribute comprising an enumerated order of the node of interest from the root node to the node of interest; and
a NodeValue attribute containing a value of the node of interest.
-
Specification