Method and apparatus for mapping between XML and relational representations

• US 7,805,474 B2
• Filed: 04/28/2008
• Issued: 09/28/2010
• Est. Priority Date: 04/13/2001
• Status: Active Grant

• Current Assignee: Siebel Systems Inc. (Oracle Corporation)
• Original Assignee: Siebel Systems Inc. (Oracle Corporation)
• Inventors: Fischer, Jeffrey M., Bhavsar, Chandrakant R., Warshavsky, Alex S.
• Primary Examiner(s): Wu; Yicun
• Application Number:
  US12/110,498
• Publication Number:
  US 20080201359A1
• Time in Patent Office: 883 Days
• Field of Search: 707/954, 707/956
• US Class Current: 715/239
• CPC Class Codes: G06F 16/258 Data format conversion from or to a database
• CPC Class Codes: G06F 16/86 Mapping to a database
• CPC Class Codes: Y10S 707/954 Relational
• CPC Class Codes: Y10S 707/956 Hierarchical
• CPC Class Codes: Y10S 707/99934 Query formulation, input preparation, or translation
• CPC Class Codes: Y10S 707/99935 Query augmenting and refining, e.g. inexact access

Abstract

A method to convert data between a relational format and an XML document, by creating a set of XML Mapping Definition from metadata; selecting relational data from a relational application database, and converting the relational data to the XML document using the set of XML Mapping Definition.

Claims

1. An apparatus for converting data between a relational format and an XML document, the apparatus comprising:

a relational application database containing relational data;

means for creating an XML Mapping Definition from metadata, wherein

the XML Mapping Definition comprises information relating relational data components to XML elements and relational data fields to XML elements or XML attributes, and

said means for creating the XML Mapping Definition comprises means for collapsing one or more portions of an XML hierarchy comprising the XML elements and attributes to reduce the number of tables used in the relational application database;

means for selecting relational data from the relational application database;

means for converting the relational data to XML data using the XML Mapping Definition; and

means for storing the converted relational data in the XML document.

2. The apparatus of claim 1 further comprising:

means for converting the XML document to relational data using the XML Mapping Definition; and

means for storing the relational data converted from the XML document.

3. The apparatus of claim 2 further comprising:

means for generating the XML Mapping Definition from DTD metadata.

4. A computer-readable storage medium comprising:

a first set of instructions, executable by a processor, configured to create an XML Mapping Definition from metadata, wherein

the XML Mapping Definition comprises information relating relational data components to XML elements and relational data fields to XML elements or XML attributes, and

said first set of instructions further comprises a second set of instructions, executable by the processor, configured to collapse one or more portions of an XML hierarchy comprising the XML elements and attributes to reduce the number of tables used in a relational application database;

a third set of instructions, executable by the processor, configured to select relational data from the relational application database;

a fourth set of instructions, executable by the processor, configured to convert the relational data to XML data using the XML Mapping Definition; and

a fifth set of instructions, executable by the processor, configured to store the converted relational data in the XML document.

5. The computer-readable storage medium of claim 4 further comprising:

a sixth set of instructions, executable by the processor, configured to convert the XML document to relational data using the XML Mapping Definition; and

a seventh set of instructions, executable by the processor, configured to store the relational data converted from the XML document.

6. The computer-readable storage medium of claim 5 further comprising:

an eighth set of instructions, executable by the processor, configured to generate the XML Mapping Definition from DTD metadata.

7. A system for converting data between a relational format and an XML document, the system comprising:

a processor;

a relational application database, coupled to the processor, and containing relational data;

a memory, coupled to the processor, and storing instructions for performing a method, the method comprising;

creating an XML Mapping Definition from metadata, wherein

the XML Mapping Definition comprises information relating relational data components to XML elements and relational data fields to XML elements or XML attributes, and

said creating the XML Mapping Definition comprises collapsing one or more portions of an XML hierarchy comprising the XML elements and attributes to reduce the number of tables used in a relational application database;

selecting relational data from the relational application database;

converting the relational data to XML data using the XML Mapping Definition; and

storing the converted relational data in the XML document.

8. The system of claim 7 wherein the memory stores further instructions for performing the method, the method further comprising:

converting the XML document to relational data using the XML Mapping Definition; and

storing the relational data converted from the XML document.

9. The system of claim 8 wherein the memory stores further instructions for performing the method, the method further comprising:

generating the XML Mapping Definition from DTD metadata.

10. An apparatus for converting data between a relational format and an XML document, the apparatus comprising:

a relational database containing relational data;

means for generating a XML Mapping Definition from XML or Relational metadata, wherein

the XML Mapping Definition comprises information relating relational data components to XML elements and relational data fields to XML elements or XML attributes, and

said means for generating the XML Mapping Definition comprises collapsing one or more portions of an XML hierarchy comprising the XML elements and attributes to reduce the number of tables used in the relational database;

means for selecting relational data from the relational database;

means for representing the relational data as an object instance;

means for converting the object instance to XML data using the XML Mapping Definition; and

means for storing the converted object instance in the XML document.

11. The apparatus of claim 10 further comprising:

means for obtaining the XML document;

means for converting the XML document to an object instance with the XML Mapping Definition;

means for representing the object instance as relational data; and

means for placing the relational data in the relational database.

12. The apparatus of claim 11 wherein said means for converting further comprises:

means for translating between the object instance and the XML document using the XML Mapping Definition.

13. A computer-readable storage medium comprising:

a first set of instructions, executable by a processor, configured to generate a XML Mapping Definition from XML or Relational metadata, wherein

the XML Mapping Definition comprises information relating relational data components to XML elements and relational data fields to XML elements or XML attributes, and

said first set of instructions comprises a second set of instructions, executable by the processor, configured to collapse one or more portions of an XML hierarchy comprising the XML elements and attributes to reduce the number of tables used in a relational database;

a third set of instructions, executable by the processor, configured to select relational data from the relational database;

a fourth set of instructions, executable by the processor, configured to represent the relational data as an object instance;

a fifth set of instructions, executable by the processor, configured to convert the object instance to XML data using the XML Mapping Definition; and

a sixth set of instructions, executable by the processor, configured to store the converted object instance in the XML document.

14. The computer-readable storage medium of claim 13 further comprising:

a seventh set of instructions, executable by the processor, configured to obtain the XML document;

an eighth set of instructions, executable by the processor, configured to convert the XML document to an object instance with the XML Mapping Definition;

a ninth set of instructions, executable by the processor, configured to represent the object instance as relational data; and

a tenth set of instructions, executable by the processor, configured to place the relational data in the relational database.

15. The computer-readable storage medium of claim 14 wherein said eighth set of instructions further comprises:

an eleventh set of instructions, executable by the processor, configured to translate between the object instance and the XML document using the XML Mapping Definition.

16. A system for converting data between a relational format and an XML document, the system comprising:

a processor;

a relational database, coupled to the processor, and containing relational data;

a memory, coupled to the processor, and storing instructions for performing a method, the method comprising;

generating a XML Mapping Definition from XML or Relational metadata, wherein

the XML Mapping Definition comprises information relating relational data components to XML elements and relational data fields to XML elements or XML attributes, and

said generating the XML Mapping Definition comprises collapsing one or more portions of an XML hierarchy comprising the XML elements and attributes to reduce the number of tables used in the relational database;

selecting relational data from the relational database;

representing the relational data as an object instance;

converting the object instance to XML data using the XML Mapping Definition; and

storing the converted object instance in the XML document.

17. The system of claim 16 wherein the memory stores further instructions for performing the method, the method further comprising:

obtaining the XML document;

converting the XML document to an object instance with the XML Mapping Definition;

representing the object instance as relational data; and

placing the relational data in the relational database.

18. The system of claim 17 wherein said converting further comprises:

translating between the object instance and the XML document using the XML Mapping Definition.