Algorithmic and Software of Migration of Databases in Hypermarket Network

: pp. 77 - 84
Lviv Polytechnic National University
Lviv Polytechnic National University, Ukraine

Possible ways and options of migrating data from existing database management systems to new ones have been analyzed in the article. Also, the main advantages and disadvantages of these methods have been considered, the common problems that may arise during migration and the standard requirements for this type of system have been given. In the practical part, the Exact Transform Load (ETL) system has been developed with the implementation of all its functional and non-functional requirements, migrating data from the old system to the new one.

  1. Implementation of the ETL system (ETL (Extract, Transform, Load) Sybsystem implementation of corporate data warehouse) [Online]. Available: of_etl_process.php
  2. The main functions of ETL systems [Online]. Available:
  3. Panneerselvam R “Database Management Systems”, Prentice Hall India Learning Private Limited, 2011, 404 p.
  4. Ranking of the most popular database management systems worldwide [Online]. Available: statistics/809750/worldwide-popularity-ranking-database- management-systems/
  5. Jan L. Harrington “Relational Database Design and Implementation, 4th Edition”, Morgan Kaufmann-Elsevier, 2016, 691 p.
  6. Malcolm Hamer “Relational Database Practices: Bridging the Gap Between the Theory of Database Design and Real-World Practices”, Malcolm Hamer, 2017, 242 p.
  7. MariaDB relational database management system [Online]. Available:
  8. Детермінізм і програмне забезпечення: витяг, перетворення та завантаження (ETL) [Online]. Available:
  9. 15 Best ETL Tools In 2020 [Online]. Available:
  10. What Is Talend? — An Unified Platform For Data Integration [Online]. Available: talend-tool/