Automatic generation of data merging program codes.
Hyensook, Kim and Oussena, Samia and Zhang, Ying and Clark, Tony (2010) Automatic generation of data merging program codes. In: ICSOFT 2010 - Proceedings of the Fifth International Conference on Software and Data Technologies, Athens, Greece, July 22-24, 2010. SciTePress, pp. 179-186. ISBN 9789898425232
Official URL: http://www.informatik.uni-trier.de/~ley/db/conf/ic...
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:||Book Section|
|Research Areas:||Middlesex University Schools and Centres > School of Science and Technology > Computer Science|
Middlesex University Schools and Centres > School of Science and Technology > Computer Science > SensoLab group
Middlesex University Schools and Centres > School of Science and Technology > Computer Science > Intelligent Environments group
|Deposited On:||25 May 2010 09:32|
|Last Modified:||10 Dec 2014 20:25|
Repository staff only: item control page
Full text downloads (NB count will be zero if no full text documents are attached to the record)
Downloads per month over the past year