Automatic generation of data merging program codes.

HYENSOOK, Kim, OUSSENA, Samia, ZHANG, Ying and CLARK, Tony (2010). Automatic generation of data merging program codes. In: CORDEIRO, Jose, (ed.) ICSOFT 2010 - Proceedings of the Fifth International Conference on Software and Data Technologies, Athens, Greece, July 22-24, 2010. SciTePress, 179-186.

[img]
Preview
PDF
clark-automatic_generation_of_data_merging.pdf
All rights reserved.

Download (358kB) | Preview
Related URLs:

    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: Book Section
    Research Institute, Centre or Group - Does NOT include content added after October 2018: Cultural Communication and Computing Research Institute > Communication and Computing Research Centre
    Departments - Does NOT include content added after October 2018: Faculty of Science, Technology and Arts > Department of Computing
    Page Range: 179-186
    Depositing User: Tony Clark
    Date Deposited: 19 Apr 2016 08:53
    Last Modified: 27 Jan 2018 22:38
    URI: http://shura.shu.ac.uk/id/eprint/11958

    Actions (login required)

    View Item View Item

    Downloads

    Downloads per month over past year

    View more statistics