发明名称 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).
申请公布号 US2002169788(A1) 申请公布日期 2002.11.14
申请号 US20010783657 申请日期 2001.02.14
申请人 LEE WANG-CHIEN;MITCHELL GAIL ANNE;ZHANG XIN 发明人 LEE WANG-CHIEN;MITCHELL GAIL ANNE;ZHANG XIN
分类号 G06F17/30;(IPC1-7):G06F7/00 主分类号 G06F17/30
代理机构 代理人
主权项
地址