loading
Papers Papers/2022 Papers Papers/2022

Research.Publish.Connect.

Paper

Paper Unlock

Authors: Hyeonsook Kim 1 ; Samia Oussena 1 ; Ying zhang 1 and Tony Clark 2

Affiliations: 1 Thames Valley University, United Kingdom ; 2 Middlesex University, United Kingdom

Keyword(s): Data Merging Meta-model, Data Integration, Model Driven Engineering, Model Driven Data Integration, Automatic Model Transformation, Automatic Program Code Generation.

Related Ontology Subjects/Areas/Topics: Business Analytics ; Communication and Software Technologies and Architectures ; Cross-Feeding between Data and Software Engineering ; Data Engineering ; Data Exchange and Integration ; Data Warehouses and Data Mining ; e-Business ; Enterprise Information Systems ; Model-Driven Engineering ; Software Engineering ; Software Engineering Methods and Techniques

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 and 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 burden of repetitive complex script coding and pain of maintaining consistency of design and implementation.

CC BY-NC-ND 4.0

Sign In Guest: Register as new SciTePress user now for free.

Sign In SciTePress user: please login.

PDF ImageMy Papers

You are not signed in, therefore limits apply to your IP address 3.227.239.9

In the current month:
Recent papers: 100 available of 100 total
2+ years older papers: 200 available of 200 total

Paper citation in several formats:
Kim, H.; Oussena, S.; zhang, Y. and Clark, T. (2010). AUTOMATIC GENERATION OF DATA MERGING PROGRAM CODES. In Proceedings of the 5th International Conference on Software and Data Technologies - Volume 2: ICSOFT; ISBN 978-989-8425-23-2; ISSN 2184-2833, SciTePress, pages 179-186. DOI: 10.5220/0003008301790186

@conference{icsoft10,
author={Hyeonsook Kim. and Samia Oussena. and Ying zhang. and Tony Clark.},
title={AUTOMATIC GENERATION OF DATA MERGING PROGRAM CODES},
booktitle={Proceedings of the 5th International Conference on Software and Data Technologies - Volume 2: ICSOFT},
year={2010},
pages={179-186},
publisher={SciTePress},
organization={INSTICC},
doi={10.5220/0003008301790186},
isbn={978-989-8425-23-2},
issn={2184-2833},
}

TY - CONF

JO - Proceedings of the 5th International Conference on Software and Data Technologies - Volume 2: ICSOFT
TI - AUTOMATIC GENERATION OF DATA MERGING PROGRAM CODES
SN - 978-989-8425-23-2
IS - 2184-2833
AU - Kim, H.
AU - Oussena, S.
AU - zhang, Y.
AU - Clark, T.
PY - 2010
SP - 179
EP - 186
DO - 10.5220/0003008301790186
PB - SciTePress