Automatic generation of data merging program codes

Kim, Hyeonsook, Oussena, Samia, Zhang, Ying ORCID: https://orcid.org/0000-0002-6669-1671 and Clark, Tony (2010) Automatic generation of data merging program codes. In: Fifth International Conference on Software and Data Technologies, 22-24 July 2010, Athens, Greece.

[thumbnail of Hyeonsook-etal-2010-Automatic-generation-of-data-merging-program-codes.pdf]
Preview
PDF
Hyeonsook-etal-2010-Automatic-generation-of-data-merging-program-codes.pdf - Accepted Version

Download (347kB) | Preview

Abstract

Data merging is an essential part of ETL (Extract-Transform-Load) processes to build a data warehouse system. To avoid rewheeling merging techniques, we propose a Data Merging Meta-model (DMM) and its transformation into executable program codes in the manner of model driven engineering. DMM allows defining relationships of different model entities and their merging types in conceptual level. Our formalized transformation described using ATL (ATLAS Transformation Language) enables automatic generation of PL/SQL packages to execute data merging in commercial ETL tools. With this approach data warehouse engineers can be relieved from the burden of repetitive complex script coding and the pain of maintaining consistency of design and implementation.

Item Type: Conference or Workshop Item (Paper)
ISBN: 9789898425232
Page Range: pp. 179-186
Keywords: Data Merging Meta-model, Data Integration, Model Driven Engineering, Model Driven Data Integration, Automatic Model Transformation, Automatic Program Code Generation
Subjects: Computing
Depositing User: Vani Aul
Date Deposited: 21 Feb 2014 16:20
Last Modified: 28 Aug 2021 07:17
URI: https://repository.uwl.ac.uk/id/eprint/724

Downloads

Downloads per month over past year

Actions (login required)

View Item View Item

Menu