Method and structure for storing data of an XML-document in a relational database
First Claim
1. A method of storing data, from a markup document containing a plurality of elements and a plurality of attributes, in a relational database, said method comprising:
- storing an element record for every element of said plurality of elements in an element table of said relational database, wherein each element record includes a unique element ID, and an element data set; and
storing an attribute record for every attribute of said plurality of attributes in an attribute table of said relational database, wherein said attribute record comprises an attribute data set for one attribute and an element ID of an element to which the one attribute is assigned.
2 Assignments
0 Petitions
Accused Products
Abstract
A method for importing data from an XML document containing a plurality of elements and a plurality of attributes into a relational database includes: creating an element table for storing data of the plurality of elements and creating an attribute table for storing data of the plurality of attributes. In the element table, element records, each containing a unique element ID, are stored, one record for every one of the plurality of elements is stored. In the attribute table, an attribute record for every one of the plurality of attributes is stored. Each attribute record includes an attribute name, an attribute value and the element ID of the element to which the attribute is assigned. The method provides a fixed database model for different XML documents; allows a simple creation of a database; and allows simple data import and export into/from the database.
-
Citations
33 Claims
-
1. A method of storing data, from a markup document containing a plurality of elements and a plurality of attributes, in a relational database, said method comprising:
-
storing an element record for every element of said plurality of elements in an element table of said relational database, wherein each element record includes a unique element ID, and an element data set; and
storing an attribute record for every attribute of said plurality of attributes in an attribute table of said relational database, wherein said attribute record comprises an attribute data set for one attribute and an element ID of an element to which the one attribute is assigned. - View Dependent Claims (2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 13, 14, 15, 17, 18, 20, 23, 24)
-
-
12. A method of storing data, from a markup document containing a plurality of elements and a plurality of attributes, in a relational database, said method comprising:
-
storing an element record for every element of said plurality of elements in an element table of said relational database, wherein each element record includes a unique element ID, and an element data set;
storing an attribute record for every attribute of said plurality of attributes in an attribute table of said relational database, wherein said attribute record comprises an attribute data set for one attribute and an element ID of an element to which the one attribute is assigned;
storing, for every unique element name of the plurality of elements, an element name record including an element name and a corresponding unique element name ID in an element name table of said relational database; and
storing, for every unique attribute name of the plurality of attributes, an attribute name record including an attribute name and a corresponding unique attribute name ID in an attribute name table of said relational database.
-
-
16. A memory data structure comprising:
-
an element table wherein said element table is configured to store a plurality of element records corresponding to a plurality of elements of a markup document, and further wherein each element record includes an assigned element ID field and an element data set field; and
an attribute table wherein said attribute table is configured to store a plurality of attribute records corresponding to a plurality of attributes of said markup document, and further wherein each attribute data record includes an element ID field and an attribute data set. - View Dependent Claims (19, 21, 22, 25, 27, 28, 29)
-
-
26. A computer program product having stored thereon a module for transferring data from a markup document into a relational database wherein execution of said module generates a method comprising:
-
storing an element record for every element of a plurality of elements of said markup document in an element table of said relational database, wherein each element record includes a unique element ID, and an element data set; and
storing an attribute record for every attribute of a plurality of attributes of said markup document in an attribute table of said relational database, wherein said attribute record comprises an attribute data set for one attribute and an element ID of an element to which the one attribute is assigned.
-
-
30. A computer system comprising:
-
a memory having stored therein a module for transferring data from a markup document into a relational database;
a processor coupled to said memory wherein execution of said module by said processor generates a method comprising;
storing an element record for every element of a plurality of elements of said markup document in an element table of said relational database, wherein each element record includes a unique element ID, and an element data set; and
storing an attribute record for every attribute of a plurality of attributes of said markup document in an attribute table of said relational database, wherein said attribute record comprises an attribute data set for one attribute and an element ID of an element to which the one attribute is assigned. - View Dependent Claims (31, 32, 33)
-
Specification