Conceptual database design: an Entity-relationship approach
Conceptual database design: an Entity-relationship approach
Comparative analysis of six XML schema languages
ACM SIGMOD Record
CPI: constraints-preserving inlining algorithm for mapping XML DTD to relational schema
Data & Knowledge Engineering - ER2000
Relational Databases for Querying XML Documents: Limitations and Opportunities
VLDB '99 Proceedings of the 25th International Conference on Very Large Data Bases
Querying XML Views of Relational Data
Proceedings of the 27th International Conference on Very Large Data Bases
Semantic Data Modeling Using XML Schemas
ER '01 Proceedings of the 20th International Conference on Conceptual Modeling: Conceptual Modeling
Taxonomy of XML schema languages using formal language theory
ACM Transactions on Internet Technology (TOIT)
Constraints-preserving transformation from XML document type deffinition to relational schema
ER'00 Proceedings of the 19th international conference on Conceptual modeling
Unraveling the duplicate-elimination problem in XML-to-SQL query translation
Proceedings of the 7th International Workshop on the Web and Databases: colocated with ACM SIGMOD/PODS 2004
Storing XML documents in databases using existing object-relational features
Proceedings of the Fifth Balkan Conference in Informatics
Hi-index | 0.00 |
XML is fast emerging as the dominant standard for representing data in Internet, so there are increasing needs to efficiently store it. One potential path to this goal is transforming XML data into relational database. But exiting XML-to-RDB algorithms focus only on the structure and largely ignore semantic constrains, in addition, their inputting is DTD rather than XML-Schema, which is recommended by W3C as the standard of XML Schema language. In this paper, we present an algorithm for mapping XML-Schema to relational schema. Our main ideas are as follows: 1) On the basis of regular tree grammar, propose a concise and precise formalization representing method for XML-Schema, FD-XML, which can perfectly drive and describe structure as well as semantic constraints from a given XML-Schema; 2) Extend the traditional entity relational model to EER (Extended Entity Relational model); 3) Map FD-XML to EER and then EER to relational schema. During the mapping, both data structures and semantic constrains are correctly preserved to relational schema. With the above procedures, the mapping algorithm comes into being. Based on the algorithm, XML data is stored into relational database. Experiment results are also presented.