ETL Transformation Function Modeling Approach Based on Model Transformation

DOI

10.2991/ncce-18.2018.23How to use a DOI?

Keywords

ETL; SHIQ; Model-Driven; schema data; accurately represented.

Abstract

ETL is Extract-Transform-Load, which cleans, transforms, and integrates data according to uniform rules. At present, most of the methods for constructing ETL transformation function adopt a graphical representation method and lack precise semantic representation, which cause the computer to not automatically generate ETL process code. This paper proposes a modeling method of ETL transformation function based on model transformation. According to the model transformation idea in Model-Driven Architecture, Combining the semantics of relational metamodel which are accurately represented by the description logic SHIQ with the relational algebra representation method, to model the ETL transformation function from the relational schema data source to the multidimensional data warehouse. This method is of great significance for automatic code generation and improvement of ETL development efficiency.

Copyright

© 2018, the Authors. Published by Atlantis Press.

Open Access

This is an open access article distributed under the CC BY-NC license (http://creativecommons.org/licenses/by-nc/4.0/).

Download article (PDF)

TY  - CONF
AU  - Yu Zhou
AU  - Yue Zhang
PY  - 2018/05
DA  - 2018/05
TI  - ETL Transformation Function Modeling Approach Based on Model Transformation
BT  - Proceedings of the 2018 International Conference on Network, Communication, Computer Engineering (NCCE 2018)
PB  - Atlantis Press
SP  - 134
EP  - 140
SN  - 1951-6851
UR  - https://doi.org/10.2991/ncce-18.2018.23
DO  - 10.2991/ncce-18.2018.23
ID  - Zhou2018/05
ER  -