Method and apparatus for mapping between XML and relational representations

• US 6,732,095 B1
• Filed: 04/13/2001
• Issued: 05/04/2004
• Est. Priority Date: 04/13/2001
• Status: Active Grant

• Current Assignee: Oracle America, Inc. (Oracle Corporation)
• Original Assignee: Siebel Systems Inc. (Oracle Corporation)
• Inventors: Fischer, Jeffrey M., Bhavsar, Chandrakant R., Warshavsky, Alex S.
• Primary Examiner(s): Mizrahi, Diane D.
• Assistant Examiner(s): Wu, Yicun
• Application Number:
  US09/835,162
• Time in Patent Office: 1,117 Days
• Field of Search: 707/1, 707/2, 707/3, 707/4, 707/10, 707/103, 707/202, 707/200, 707/104.1, 707/513, 707/100, 707/101, 709/203, 709/229
• US Class Current: 1/1
• 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. A method of converting data between a relational format and an XML document comprising:

creating an XML Mapping Definition from metadata including;

creating XML tags corresponding to the table names and column names,

removing any illegal characters from the XML tags to create valid XML tags, and

adding numeric suffixes to any duplicate XML tags, to create unique XML tag,

thereby ensuring that the XML Mapping Definition only includes unique and valid XML tags;

selecting relational data from a relational application database; and

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

wherein creating an XML Mapping Definition from metadata further comprises a mapping definition from the XML document to relational data conversion including;

creating a mapping for each element of the XML document is associated with a table, and

collapsing portions of the XML hierarchy to reduce a number of tables used in the relational database.

2. The method of claim 1, further comprising;

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

storing the relational data converted from the XML document.

3. The method of claim 2, wherein the XML conversion is accomplished with an adapter that maintains the relational representation by mapping from the XML Mapping Definition.

4. The method of claim 2, wherein the XML Mapping Definition is generated by a Metadata Wizard.

5. The method of claim 4, wherein the Wizard generates the XML Mapping Definition from DTD metadata.

6. The method of claim 1, wherein the XML Mapping Definition is comprised of an XML section and a relational section that stores a mapping between a set of relational tables and columns and a set of elements and attributes of the XML document.

7. The method of claim 1, further comprising:

for fields inside different components having the same data type, instead of adding the unique numeric suffix, attribute tags are made unique within a parent element.

8. The method of claim 1, further comprising:

identifying fields inside different components having a same data type and having identical XML tags, and maintaining the identical XML tags for the fields.

9. A method of converting data between a relational format and an XML document, comprising:

creating an XML Mapping Definition using default mapping between an application relational schema and an XML representation, the mapping further including creating unique valid XML tags corresponding to the relational schema, the unique valid XML tags made unique by adding suffixes to any duplicate XML tags, and made valid by removing any illegal characters;

creating a mapping definition from the XML document to relational data conversion including;

creating a mapping for each element of the XML document is associated with a table, and

collapsing portions of the XML hierarchy to reduce a number of tables used in the relational database;

selecting relational data from a database;

representing the relational data as an object instance; and

converting the object instance to the XML document using the default set of XML Mapping Definition.

10. The method of claim 9, wherein the XML conversion is accomplished with an adapter that maintains the relational representation by mapping from the XML Mapping Definition.

11. The method of claim 9, wherein the XML Mapping Definition is generated by a Metadata Wizard.

12. The method of claim 11, wherein the Wizard generates the XML Mapping Definition from DTD metadata.

13. The method of claim 9, further comprising:

identifying fields inside different components having a same data type and having identical XML tags, and maintaining the identical XML tags for the fields.

14. An apparatus, comprising;

means for creating a XML Mapping Definition;

a relational database containing relational data;

means for representing the relational data as an object instance; and

means for converting the object instance to the XML document using the XML Mapping Definition, the XML Mapping definition including unique valid XML tags corresponding to the relational schema;

means to add suffixes to any duplicate XML tags; and

means to remove any illegal characters in the XML tags, to create the unique valid XML tags;

means for a mapping for each element of the XML document to a table; and

means for collapsing portions of the XML hierarchy to reduce a number of tables used in the relational database.

15. The apparatus of claim 14, further comprising;

means for converting the XML document to the object instance.

16. The means of claim 14, wherein the XML conversion is accomplished with an adapter means that maintains the relational representation by mapping from the XML Mapping Definition.

17. The means of claim 14, further comprising a Metadata Wizard means to generate the XML Mapping Definition.

18. The means of claim 17, wherein the Wizard generates the XML Mapping Definition from DTD metadata.

19. The means of claim 14, further comprising:

a means to identify fields inside different components having a same data type and having identical XML tags, and maintaining the identical XML tags for the fields.