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.
This is a preview of subscription content, log in via an institution to check access.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Preview
Unable to display preview. Download preview PDF.
Similar content being viewed by others
References
Bray, T., Paoli, J., Sperberg-McQueen, C.M.: Extensible Markup Language (XML) 1.0, 2nd edn. W3C Recommendation (October 2000)
ISO / IEC JTC 1 SC 34, ISO / IEC 8839:1986: Information processing – Text and office systems – Standard Generalized Markup Language (SGML) (August 2001)
Elmasri, R., Navathe, S.: Fundamental of Database Systems. Addison-Wesley, Reading (2003)
Fan, W., Simeon, J.: Integrity Constraints for XML. In: ACM PODS (May 2000)
Lee, D., Mani, M., Chiu, F., Chu, W.W.: Nesting-based Relational-to-XML Schema Translation. In: Int’l Workshop on the Web and Databases (WebDB) (May 2001)
Kurt, C., David, H.: Beginning XML. John Wiley & Sons Inc., Chichester (2001)
Jaeschke, G., Schek, H.J.: Remakrs on the Algevra of Non First Normal Form Relations. In: ACM PODS, Los Angeles, CA (March 1982)
Lee, D., Mani, M., Chit, F., Chu, W.W.: Effective Schema Conversions between XML and Relational Models. In: European Converence on Artificial Intelligence (ECAI), Knowledge Transformation Workshop (ECAI-OT), Lyon, France (July 2002)
Lee, D., Mani, M., Chit, F., Chu, W.W.: NeT&CoT: Translating Relational Schemas to XML Schemas using Semantic Constraints. In: The 11th ACM Int’l Conference on Information and Knowledge Management (CIKM), McLean, VA, USA (November 2002)
Goodson, J.: Using XML with Existing Data Access Standards. Enterprise Application Integration Knowledge Base (EAI) Journal, 43–45 (March 2002)
Widom, J.: Data Management for XML: Research Directions. IEEE Data Engineering Bulletin, 44–52 (September 1999)
Seligman, L., Rosenthal, A.: XML’s Impact on Databases and Data Sharing. IEEE Computer 34(6), 59–67 (2001)
Witkowski, A., Bellamkonda, S., Bozkaya, T., Folkert, N., Gupta, A., Haydu, J., Sheng, L., Subramanian, S.: Advanced SQL Modeling in RDBMS. ACM Transactions on Database Systems 30(1), 83–121 (2005)
Duta, A.C., Barker, K., Alhajj, R.: ConvRel: Relationship Conversion to XML Nested Structures. In: SAC 2004, Nicosia, Cyprus (March 2004)
Author information
Authors and Affiliations
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 2005 Springer-Verlag Berlin Heidelberg
About this paper
Cite this paper
Kim, J., Jeong, D., Baik, DK. (2005). An Algorithm for Automatic Inference of Referential Integrities During Translation from Relational Database to XML Schema. In: Hao, Y., et al. Computational Intelligence and Security. CIS 2005. Lecture Notes in Computer Science(), vol 3802. Springer, Berlin, Heidelberg. https://doi.org/10.1007/11596981_106
Download citation
DOI: https://doi.org/10.1007/11596981_106
Publisher Name: Springer, Berlin, Heidelberg
Print ISBN: 978-3-540-30819-5
Online ISBN: 978-3-540-31598-8
eBook Packages: Computer ScienceComputer Science (R0)