Naslov
Application for data migration with complete data integrity

Autori
Blagaić, Sven ; Bagić Babac, Marina

Izvornik
International Journal of System of Systems Engineering (1748-0671) 12 (2022), 4; 405-432

Vrsta, podvrsta i kategorija rada
Radovi u časopisima, članak, znanstveni

Ključne riječi
data integrity ; database ; data migration ; SQL ; structured query language ; application.

Sažetak
The process of data migration is used to equalise database content when it starts do differ due to database use for different purposes. It is a process that often takes some time because large quantities of data are usually migrated. However, the time that it takes the user to select migration options and the way that it is done can be reduced and simplified, respectively. This paper shows that the process of selecting migration databases, their corresponding changes, and database management in general, can be user- friendly by using the MigrationTool. Through an intuitive user interface, the MigrationTool allows the user to select the source and target environments and schemas whose content will be migrated, followed by a selection of structured query language (SQL) orders which will be applied to the target database. They are presented in a way that it is easy to see which differences exist and on which tables they could potentially be applied. This application also offers a set of additional functionalities which enable a lot of database and user management to be done directly from the application itself.

Izvorni jezik
Engleski

Znanstvena područja
Računarstvo

POVEZANOST RADA