Expert system for data migration between different database management systems

摘要

This paper deals with the design of the fuzzy expert system for processing data migration between different relational database management systems (RDBMS). At the beginning we identify current state of data migration between different RDBMS. Then we propose new approach which suggests creating of expert system as a tool for migration of database tables and their data between different RDBMS. The expert system contains a knowledge base which is composed of IF-THEN 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. Paper also proposes methodological guidelines for successful migration of database tables and their data between different RDBMS and suggests the possibility of tool extension when the source or target RDMBS is changed. The proposed expert system is shown on data migration of selected database of the source RDBMS to the target RDBMS.