Research indexJournal article
Alternative Development for Data Migration Using Dynamic Query Generation
Romero-Ramírez, Montenegro-Marín, García‐Díaz and 1 other
Greater South Information System1 May 2016Open access
NobleIDark:/48914/w1/20260516/7480EB94DOI10.60692/7jshr-fd956
Alternative Development for Data Migration Using Dynamic Query Generation
Romero-Ramírez, Montenegro-Marín, García‐Díaz and 1 other · Greater South Information System · 2016
NobleIDark:/48914/w1/20260516/7480EB94DOI10.60692/7jshr-fd956
Free to read at the publisher
You can read the abstract here, or the full text at the publisher.
Abstract
Abstract 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.