Influencing Migration Processes by Real-Time Data
Roman Čerešňák, Karol Matiaško, Adam Dudáš · 2021
The current trend of information systems and informatization moving forward in big steps also influences database systems. This direction of a data transfer from the databases with a rigid structure to the systems with a free data structure created a vast amount of challenges, including problems with backward compatibility, the inconsistency of data types or possibly of data editing during the transformation transfer. As a solution to this problem, we created MigrationLayer which can manage the structural and data compatibility between a relational and nonrelational database which is divided into three modules: The first is module of transformation, respectively, of the data transfer from the relational database to the nonrelational database. The second module is based on the catching of the data during its' modification which could influence the data entering the system, and the third module is a module of backward compatibility, which, based on the data change, evokes a consolidation edit of the structure and of course, the data. Experiments show that MigrationLayer can catch the data incoming to the transformation module in real-time with sufficient effectiveness. This leads to reduction of the time needed for the modifications after the whole migration ends. The module of the backward compatibility effectively helps us to maintain the backward compatibility between the structures of relational and nonrelational database.