Patent ID: 6732095
Filing Date: 2004-05-04
Classification: G06F,Y10S

Abstract:
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.