文章基本信息

标题：Alternative Development for Data Migration Using Dynamic Query Generation
本地全文：下载
作者：Johan Alfredo Romero-Ramírez ; Carlos Enrique Montenegro-Marín ; Vicente García-Díaz 等
期刊名称：Applied Computer Systems
印刷版ISSN：2255-8691
出版年度：2016
卷号：19
期号：1
页码：25-29
DOI：10.1515/acss-2016-0003
语种：English
出版社：Walter de Gruyter GmbH
摘要：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.
关键词：Data migration ; Data transformation ; ETL ; schema mapping