Back to results
US 6,732,095 B1Granted
Method and apparatus for mapping between XML and relational representations
AssigneeSiebel Systems, Inc.
InventorsAlex S. Warshavsky, Chandrakant R. Bhavsar, Jeffrey M. Fischer
Life of this patent
Estimating the term…
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.
Claims19
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.
8 more elements
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.
5 more elements
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.
8 more elements
Dependencies are inferred from the claim text.