A data decomposition method for stepwise migration of complex legacy data

Abstract

Summary Sooner or later, in almost every company, the maintenance and further development of large enterprise information technology (IT) applications reaches its limit. From the point of view of cost as well as technical capability, legacy applications must eventually be replaced by new enterprise IT applications. Data migration is an inevitable part of making this switch. While different data migration strategies can be applied, incremental data migration is one of the most popular strategies, due to its low level of risk: the entire data volume is split into several data tranches, which are then migrated in individual migration steps. The key to a successful migration is the strategy for decomposing the data into suitable tranches. This paper presents a method for data decomposition where the entire data volume of a monolithic enterprise IT application is split into independent data migration tranches. Each tranche comprises the data to be migrated in one migration step, which is usually executed during the application's downtime window. Unlike other methods, which describe data migration in a highly abstract way, we propose specific heuristics for data decomposition into independent data packages (tranches). The data migration approach described here is being applied in one of the largest migration projects currently underway in the European health care sector, comprising millions of customer records.

The migration and preservation of six Norwegian municipality record‐keeping systems: Lessons learned

“…The migration project presented here is specific to a particular context, while a lot of the existing literature is more general. Maatuk et al (2008), for example, discussed the problem of mapping between database structures from a high‐level point of view, while Martens, Book, and Gruhn (2018) focused on continued access to data between system migrations, rather than extraction for preservation purposes. High‐level approaches, for example, mapping databases to XML (Rahman, David, & Ribeiro, 2012) or other database models, do not provide that much insight as the approaches are too generic to provide concrete suggestions to solve the problem at hand.…”

Software Development for Educational Information Services Using Multilayering Semantics Adaptation

“…According to Mistrik et al (2015), the scalability, flexibility, availability, modifiability, durability, and portability of customer views may incur significant implementation and maintenance costs. When a new requirement is requested to migrate from an existing application to a new launch application, software maintenance takes a long time to evolve (Martens et al, 2019). At times, software reusability is assumed to possess a range of quality attributes appropriate for specific projects (Almogahed & Omar, 2021;Guermah et al, 2021).…”