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.
Highlights
John Morris (2001) [1] defines the data migration as the selection, preparation, extraction, transformation and movement of the suitable data with the right quality, to the right place and with the dismantling of the legacy data sources
This paper presents the features of a solution called Valery as an alternative approach to data migration for heterogeneous data sources where the source implies flat files
This is based on the hypothesis that it is possible to create a model that exploits the advantages of standardisation and functionality existing by SQL language (Structured Query Language) [10] and the RDMB (Relational Database Management System) [11] onto a model that addresses the problem of mapping exposed and delegates the factors of performance to the infrastructure hardware and legacy data size
Summary
John Morris (2001) [1] defines the data migration as the selection, preparation, extraction, transformation and movement of the suitable data with the right quality, to the right place and with the dismantling of the legacy data sources Some of these projects may have the scenario where the information sources involve flat files [7] and the target system is a relational database and SQL-based [9]. This paper presents the features of a solution called Valery as an alternative approach to data migration for heterogeneous data sources where the source implies flat files This is based on the hypothesis that it is possible to create a model that exploits the advantages of standardisation and functionality existing by SQL language (Structured Query Language) [10] and the RDMB (Relational Database Management System) [11] onto a model that addresses the problem of mapping exposed and delegates the factors of performance to the infrastructure hardware and legacy data size
Sign-in/Register to view highlights & summary Talk to us
Join us for a 30 min session where you can share your feedback and ask us any queries you have
Schedule a callDisclaimer: All third-party content on this website/platform is and will remain the property of their respective owners and is provided on "as is" basis without any warranties, express or implied. Use of third-party content does not indicate any affiliation, sponsorship with or endorsement by them. Any references to third-party content is to identify the corresponding services and shall be considered fair use under The CopyrightLaw.
