An algorithm for automatic inference of referential integrities during translation from relational database to XML schema

Authors:
Jinhyung Kim;Dongwon Jeong;Doo-Kwon Baik
Affiliations:
Dept. of Computer Science and Engineering, Korea University, Korea;Dept. of Informatics & Statistics, Kunsan National University, Korea;Dept. of Computer Science and Engineering, Korea University, Korea
Venue:
CIS'05 Proceedings of the 2005 international conference on Computational Intelligence and Security - Volume Part II
Year:
2005

Citing 8
Cited 0

Integrity constraints for XML

PODS '00 Proceedings of the nineteenth ACM SIGMOD-SIGACT-SIGART symposium on Principles of database systems
Beginning XML

Beginning XML
NeT & CoT: translating relational schemas to XML schemas using semantic constraints

Proceedings of the eleventh international conference on Information and knowledge management
Remarks on the algebra of non first normal form relations

PODS '82 Proceedings of the 1st ACM SIGACT-SIGMOD symposium on Principles of database systems
XML's Impact on Databases and Data Sharing

Computer
ConvRel: relationship conversion to XML nested structures

Proceedings of the 2004 ACM symposium on Applied computing
Fundamentals of Database Systems, Fourth Edition

Fundamentals of Database Systems, Fourth Edition
Advanced SQL modeling in RDBMS

ACM Transactions on Database Systems (TODS) - Special Issue: SIGMOD/PODS 2003

Quantified Score

Hi-index	0.00

Visualization

Abstract

XML is rapidly becoming one of the most widely adopted technologies for information exchange and representation on the World Wide Web. However, the large part of data is still stored in a relational database and we need to convert those relational data into an XML document. There are existing approaches such as NeT and CoT to convert relational models to XML models but those approaches only consider explicit referential integrities. In this paper, we suggest an algorithm to reflect implicit referential integrities to the conversion. The proposed algorithm provides several good points such as improving semantic information extraction and conversion, securing sufficient referential integrity of the target databases, and so on.