Method and structure for storing data of an XML-document in a relational database

• US 7,844,642 B2
• Filed: 01/18/2002
• Issued: 11/30/2010
• Est. Priority Date: 01/22/2001
• Status: Active Grant

• Current Assignee: Oracle America, Inc. (Oracle Corporation)
• Original Assignee: Oracle America, Inc. (Oracle Corporation)
• Inventors: Jahnke, Joerg, Cordes, Dietmar
• Primary Examiner(s): PANNALA, SATHYANARAYA R
• Application Number:
  US10/054,544
• Publication Number:
  US 20020099715A1
• Time in Patent Office: 3,238 Days
• Field of Search: 707100-103 R, 707/10, 707/201, 705/26
• US Class Current: 707/809
• CPC Class Codes: G06F 16/284 Relational databases

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.

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 so that said relational database includes a plurality of element records, 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 so that said relational database includes a plurality of attribute records, 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 wherein said element table and said attribute table include content of said markup document and further wherein a new markup document having a same content as said markup document can be constructed by retrieving said element data set in each of said plurality of element records stored in said element table of said relational database and by retrieving said attribute data set in each of said plurality of attribute records stored in said attribute table of said relational database.

2. The method of claim 1 wherein said element data set includes character data.

3. The method of claim 1 wherein said element data set contains a parent element ID.

4. The method of claim 2 wherein said element data set contains a parent element ID.

5. The method of claims 1 wherein said element data set includes an element name.

6. The method claim 1 further comprising:

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.

7. The method of claim 1 comprising:

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.

8. The method of claim 1 wherein said attribute data set includes an attribute name.

9. The method of claim 1 wherein said attribute data set includes an attribute value.

10. The method of claim 8 wherein said attribute data set includes an attribute value.

11. The method of claim 1 wherein the markup document is an XML document.

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 so that said relational database includes a plurality of element records, 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 so that said relational database includes a plurality of attribute records, 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 wherein said element table and said attribute table include content of said markup document and further wherein a new markup document having a same content as said markup document can be constructed by retrieving said element data set in each of said plurality of element records stored in said element table of said relational database and by retrieving said attribute data set in each of said plurality of attribute records stored in said attribute table of said relational database.

13. The method of claim 12 wherein said element data set includes character data.

14. The method of claim 12 wherein said element data set contains a parent element ID.

15. The method of claim 14 wherein said element data set contains a parent element ID.

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 so that a relational database includes a plurality of element records, 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 so that said relational database includes a plurality of attribute records, and further wherein each attribute data record includes an element ID field and an attribute data set wherein said element table and said attribute table include content of said markup document and further wherein a new markup document having a same content as said markup document can be constructed by retrieving said element data set in each of said plurality of element records stored in said element table of said relational database and by retrieving said attribute data set in each of said plurality of attribute records stored in said attribute table of said relational database.

17. The data structure of claim 16 wherein the element data set includes a character data field.

18. The data structure of claim 16 wherein the element data set includes a parent element ID field.

19. The data structure of claims 16 wherein the element data set includes an element number field.

20. The data structure of claim 17 wherein said element data set includes an element name field.

21. The data structure of claims 16 wherein the element data set comprises an element name ID field.

22. The data structure of claim 21 further comprising:

an element name table wherein said element name table is configured to store a plurality of element name records, and further wherein each element name record includes an element name ID field and a corresponding element name field.

23. The data structure of claim 16 wherein said attribute data set includes an attribute name and an attribute value.

24. The data structure of claim 16 wherein said attribute data set contains an attribute name ID.

25. The data structure of claim 24 further comprising:

an attribute name table wherein said attribute name table is configured to store a plurality of attribute name records wherein each attribute name record includes an attribute name ID field and a corresponding attribute name field.

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 so that said relational database includes a plurality of element records, 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 so that said relational database includes a plurality of attribute records, 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 wherein said element table and said attribute table include content of said markup document and further wherein a new markup document having a same content as said markup document can be constructed by retrieving said element data set in each of said plurality of element records stored in said element table of said relational database and by retrieving said attribute data set in each of said plurality of attribute records stored in said attribute table of said relational database.

27. The computer program product of claim 26 wherein said method further comprises:

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.

28. The computer program product of claim 26 wherein said method further comprises:

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.

29. The computer program product of claim 27 wherein said method further comprises:

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.

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 so that said relational database includes a plurality of element records, 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 so that said relational database includes a plurality of attribute records, 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 wherein said element table and said attribute table include content of said markup document and further wherein a new markup document having a same content as said markup document can be constructed by retrieving said element data set in each of said plurality of element records stored in said element table of said relational database and by retrieving said attribute data set in each of said plurality of attribute records stored in said attribute table of said relational database.

31. The computer system of claim 30 wherein said method further comprises:

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.

32. The computer system of claim 30 wherein said method further comprises:

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.

33. The computer system of claim 31 wherein said method further comprises:

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.