SYSTEM AND METHOD FOR AUTOMATIC LOADING OF AN XML DOCUMENT DEFINED BY A DOCUMENT-TYPE DEFINITION INTO A RELATIONAL DATABASE INCLUDING THE GENERATION OF A RELATIONAL SCHEMA THEREFOR

摘要

A system and a method are provided for generating (28) a schema (22) for a relational database corresponding to a document having a document-type definition (18) and data complying with the document-type definition (18). The document-type definition (18) has content particles representative of the structure of the document data including one or more of the following content particles: elements, attributes of elements, nesting relationships between elements, grouping relationships between elements, schema (22) ordering indicators, existence indicators, occurrence indicators and element ID referencing indicators. The system and method described herein also contemplates loading the data into the relational database in a manner consistent with the relational schema (22). Metadata is extracting from the document-type definition (18) representative of the document-type definition (18). The schema (22) for the relational database is generated 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 (18) via the metadata (34). The data is then loaded into the at least one table of the relational database according to the relational schema (22) in a manner driven by the metadata (34).