Open AccessDatabase Migration Strategies and Techniques to Minimize Unexpected Dysfunctionality
Author(s) -
Akhmad Fahmi,
Yeffry Handoko Putra
Publication year - 2019
Publication title -
iop conference series. materials science and engineering
Language(s) - English
Resource type - Journals
eISSN - 1757-899X
pISSN - 1757-8981
DOI - 10.1088/1757-899x/662/6/062003
Subject(s) - data migration , computer science , consistency (knowledge bases) , database , data consistency , data quality , schema (genetic algorithms) , process (computing) , data integrity , schema evolution , table (database) , legacy system , database schema , database design , engineering , information retrieval , operations management , artificial intelligence , operating system , metric (unit) , software
The purpose of this research is to develop good data migration strategies and techniques. To ensure the speed and accuracy of the process and also measure the quality of data from pre-migration and post-migration data we use the “Phased Migration Strategy” method. The results of this study are offering speed and timeliness without causing data loss or damage, maintaining consistency and integrity of the schema table structure resulting from data migration, especially in mapping data types, to match the structure in the original database, to minimize unexpected disfunctionality . From these results in a number of other cases, a new system was developed to replace the old one which became too complicated or out of date and which held back further modification and evolution. This system is known as a “legacy” system. The rate of increase or at least a change from one system to another will not slow down in the near future. In fact, the process of migrating data from the legacy system will continue to be accelerated in the coming years.