Mapping XML-Schema to Relational Schema

Authors:
Sun Hongwei;Zhang Shusheng;Zhou Jingtao;Wang Jing
Affiliations:
-;-;-;-
Venue:
EurAsia-ICT '02 Proceedings of the First EurAsian Conference on Information and Communication Technology
Year:
2002

Citing 3
Cited 0

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

Quantified Score

Hi-index	0.00

Visualization

Abstract

XML is fast emerging as the dominant standard for representing data in Internet. One efficient path to store it is transforming XML data into relational database. Exiting XML-to-RDB algorithms focus only on the structure and ignore semantic constrains, in addition, their inputting is not XML-Schema but DTD. 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 named FD-XML for XML-Schema; 2) Extend the traditional ER model to Extended ER model (EER); 3) Map FD-XML to EER and then EER to relational schema. With the above procedures, the mapping algorithm comes into being, where both correct data structure and integrated data constrains are translated.