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

作者: Gail Anne Mitchell , Wang-Chien Lee , Xin Zhang

DOI:

关键词: Database modelRelational modelRelational databaseSemi-structured modelDatabase designDocument Schema Definition LanguagesInformation retrievalDatabase schemaRelational calculusComputer science

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

参考文章(42)
David Samuel Zipkin, Lisa Conners Vogt, Sheila Caroline Rocchio, Stephen David Gantz, Eric Bruce Livingston, Matthew Todd Richards, System for presenting and managing enterprise architectures ,(1998)
Dan Suciu, Maria F. Fernandez, Wang-Chiew Tan, Atsuyuki Morishima, Method for converting relational data into XML ,(2001)
Gerti Kappel, Elisabeth Kapsammer, Stefan Rausch- Schott, Werner Retschitzegger, X-ray: towards integrating XML and relational database systems international conference on conceptual modeling. pp. 339- 353 ,(2000) , 10.1007/3-540-45393-8_25
Paul Lin, Alok Srivastava, Marco Carrer, System for collecting, transforming and managing media metadata ,(1999)
Neelakantan Sundaresan, Susan B. Lee, Facility for adding dynamism to an extensible markup language ,(1998)