The database schema migration with use XML transporting layer

Michał Kwapisz, Tomasz Sapelniak, Adam Pelikant

Abstract


The article describes method of the automatic transfer of relational databases schemas. Files XML were applied, which permit on free formation of document structure. The aim of investigations was creation of effective algorithm for automatic data migration which would guarantee correct target data structure as well as safety during processing. Works were guided in environment Microsoft Windows 2003 with utilization the engine of database ORACLE 10g.

Keywords


database migration; data integration; XML; Oracle

Full Text:

PDF (Polski)

References


Rosa T., Jagoda Ł., Pelikant A.: Migracja danych pomiędzy XML, a relacyjnymi modelami danych. 1st Polish and International PD Forum - Conference on Computer Science 2005, Bronisławów 2005.

Bourret R., Bornhövd C, Buchmann A.: A Generic Load/Extract Utility for Data Transfer Between XML Documents and Relational Databases. 2000 IEEE.

Kotsakis E., Bohm K.: XML Schema Directory: A Data Structure for XML Data Processing. 2000 IEEE.

Fong J., Pang F., Bloor C: Converting Relational Database into XML Document. 2001 IEEE.

Bohannon P., Freire J., Roy P., Simeon J.: From XML Schema to Relations: A Cost-Based Approach to XML Storage. 2002 IEEE, 18th International Conference on Data Engineering (ICDE.02).

Afonso de Sousal A., Luis Pereira J., Alvaro Carvalho J.: Querying XML Databases. 2002 IEEE, XXII International Conference of the Chilean Computer Science Society (SCCC'02).

Ishitani Y.: Document Transformation System from Papers to XML Data Based on Pivot XML Document Method. 2003 IEEE, Seventh International Conference on Document Analysis and Recognition (ICDAR'03).

Krishnamurthy R., Chakaravarthy V., Kaushik R., Naughton J.: Recursive XML Schemas, Recursive XML Queries, and Relational Storage: XML-to-SQL Query Translation. 2004 IEEE, 20th International Conference on Data Engineering (ICDE'04)




DOI: http://dx.doi.org/10.21936/si2009_v30.n2B.469