Patent ID: 7072896
Filing Date: 2006-07-04
Classification: G06F,Y10S

Abstract:
1. A method for generating a schema for a relational database corresponding to a document having a document-type definition and data complying with the document-type definition, the document-type definition having content particles representative of the structure of the document data, as well as loading the data into the relational database in a manner consistent with the relational schema, the method comprising the steps of: extracting metadata representative of the document-type definition from the document-type definition; storing the metadata in at least three tables comprising a metadata item table containing metadata representative of element types in the document-type definition, a metadata attribute table containing metadata representative of attributes in the document type definition, and a metadata nesting table containing metadata representative of nesting relationships between particles in the document type definition; automatically generating the schema for the relational database from the metadata, wherein at least one table is thereby defined in the relational database corresponding to at least one content particle of the document-type definition via the metadata; and loading the document data into the at least one table of the relational database according to the relational schema in a manner driven by the metadata.