Alternative Development for Data Migration Using Dynamic Query Generation

Applied Computer Systems 2016
Johan Alfredo Romero-Ramírez, Carlos Enrique Montenegro-Marín, Vicente García-Díaz, Juan Manuel Cueva Lovelle

This article presents an ETL (Extract, Transform, Load) prototype called Valery as alternative approach to migration process which includes a compiler for dynamic generation of SQL queries. Its main features involve: SQL dynamic generation, set of configuration commands and environment for file uploading. The tests use the Northwind academic database and an individual environment. The model implementation uses flat files and SQL as query language. Finally, there is an analysis of the results obtained.

Atslēgas vārdi
Data migration, Data transformation, ETL, schema mapping.
DOI
10.1515/acss-2016-0003

Romero-Ramírez, J., Montenegro-Marín, C., García-Díaz, V., Lovelle, J. Alternative Development for Data Migration Using Dynamic Query Generation. Applied Computer Systems, 2016, 19, 25.-29.lpp. ISSN 2255-8683. e-ISSN 2255-8691. Pieejams: doi:10.1515/acss-2016-0003

Publikācijas valoda
English (en)