Alternative Development for Data Migration Using Dynamic Query Generation

Applied Computer Systems

García-Díaz Vicente¹  Lovelle Juan Manuel Cueva¹  Montenegro-Marín Carlos Enrique²  Romero-Ramírez Johan Alfredo² 

[1] Computer Science Department, University of Oviedo, Spain;Engineering Faculty, Universidad Distrital Francisco José de Caldas, Colombia;

关键词: data migration;    data transformation;    etl;    schema mapping;   

DOI  :  10.1515/acss-2016-0003

来源: DOAJ

【 摘 要 】

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.

【 授权许可】

Unknown