Alternative Development for Data Migration Using Dynamic Query Generation

Johan Alfredo Romero-Ramírez, Carlos Enrique Montenegro-Marín, Vicente García-Díaz, Juan Manuel Cueva Lovelle
2016 Applied Computer Systems  
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.
doi:10.1515/acss-2016-0003 fatcat:z4x3lpmmhvdj7pcy3qeta3gnwe