Abstract
Transforming a heterogeneous data model to another heterogeneous data model involves mapping of structural information and data layout. For performing the transformation processes this paper presents a flexible and extensible approach for heterogeneous database transformation using XML. Basics steps involved are forward transformation and reverse transformation. Between these two steps lie two XML documents; one representing the database structure; the other representing the database data. The XML documents define tags for representing an arbitrary database thus making the representation independent of the source and target database management systems. The advantage of having standard XML representations for the database model is that it can be easily extended to support new database models with a maximum of two transformers per database management system.
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.
References
Baru, C.: XViews: XML Views of Relational Schemas. Technical Report, San Diego Supercomputer Center, University of California San Diego, October 7 (1999)
Bierman, G.M.: Using XML as an Object Interchange Format. Technical Report, Department of Computer Science, University of Warwick, May 17 (2000)
Bohannon, P., Freire, J., Roy, P., Simeon, J.: From XML Schema to Relations: A Cost-Based Approach to XML Storage. Technical Report, Bell Laboratories (2001)
Fong, J., Pang, F., Bloor, C.: Converting Relational Database into XML Document. In: The 12th International Workshop on Database and Expert Systems Applications, Munich Germany, September 03 - 07 (2001)
Hohenstein, U.: Supporting Data Migration between Relational and Object-Oriented Databases Using a Federation Approach. In: 2000 International Database Engineering and Applications Symposium (IDEAS 2000), Yokohama, Japan, September 18 - 20 (2000)
Jahnke, J., Schäfer, W., Zündorf, A.: A Design Environment for Migrating Relational to Object Oriented Database Systems. In: 1996 International Conference on Software Maintenance (ICSM 1996), Monterey, CA, November 04 - 08 (1996)
JGraph open source project: JGraphpad (2001), http://jgraph.sourceforge.net/index.html
Lee, D., Mani, M., Chiu, F., Chu, W.W.: NeT & CoT: Translating Relational Schemas to XML Schemas using Semantic Constraints. In: 11th ACM Int’l. Conf. on Information and Knowledge Management (CIKM), McLean, VA, USA (November 2002)
Mani, M., Lee, D.: XML to Relational Conversion Using Theory of Regular Tree Grammars. In: VLDB Conference, 28th Proceedings (2002)
Pydipati, K.: Heterogeneous Database Transformation using XML, Thesis for the Degree Master of Computer Science, Texas State University (August 2003)
Author information
Authors and Affiliations
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 2006 Springer-Verlag Berlin Heidelberg
About this paper
Cite this paper
Haddix, F., Pydipati, K. (2006). Using Extensible Heterogeneous Database Transformers. In: Wiedermann, J., Tel, G., Pokorný, J., Bieliková, M., Štuller, J. (eds) SOFSEM 2006: Theory and Practice of Computer Science. SOFSEM 2006. Lecture Notes in Computer Science, vol 3831. Springer, Berlin, Heidelberg. https://doi.org/10.1007/11611257_29
Download citation
DOI: https://doi.org/10.1007/11611257_29
Publisher Name: Springer, Berlin, Heidelberg
Print ISBN: 978-3-540-31198-0
Online ISBN: 978-3-540-32217-7
eBook Packages: Computer ScienceComputer Science (R0)