A Methodology for Data Migration between Different Database Management Systems

Authors: Bogdan Walek, Cyril Klimes

Abstract:

In present days the area of data migration is very topical. Current tools for data migration in the area of relational database have several disadvantages that are presented in this paper. We propose a methodology for data migration of the database tables and their data between various types of relational database systems (RDBMS). The proposed methodology contains an expert system. The expert system contains a knowledge base that is composed of IFTHEN rules and based on the input data suggests appropriate data types of columns of database tables. The proposed tool, which contains an expert system, also includes the possibility of optimizing the data types in the target RDBMS database tables based on processed data of the source RDBMS database tables. The proposed expert system is shown on data migration of selected database of the source RDBMS to the target RDBMS.

Keywords: Expert system, fuzzy, data migration, database, relational database, data type, relational database management system.

Digital Object Identifier (DOI): doi.org/10.5281/zenodo.1330271

References:

[1] P. Atzeni, V. De Antonellis, Relational Database Theory. The Benjamin/ Cummings Publishing Company, Inc., Redwood City, 1993, ch. 1.
[2] L. Jan Harrington, Relational database design and implementation. Elsevier Inc., Burlington, 2009, ch. 4,5.
[3] ISO, ANSI: Framework (SQL/Framework). International Organization for Standartization, 2003.
[4] H. Habiballa, V. Nov├ík, A. Dvoř├ík, V. Pavliska, "Using software package LFLC 2000", 2nd International Conference Aplimat 2003, Bratislava, 2003, pp. 355-358.
[5] J. Morris, Practical data migration. The British Computer Society, Chippenham, 2009, ch.1.