An Ontology for Describing ETL Patterns Behavior

Bruno Oliveira, Orlando Belo

2016

Abstract

The use of software patterns is a common practice in software design, providing reusable solutions for recurring problems. Patterns represent a general skeleton used to solve common problems, providing a way to share regular practices and reduce the resources needed for implementing software systems. Data warehousing populating processes are a very particular type of software used to migrate data from one or more data sources to a specific data schema used to support decision support activities. The quality of such processes should be guarantee. Otherwise, the final system will deal with data inconsistencies and errors, compromising its suitability to support strategic business decisions. To minimize such problems, we propose a pattern-oriented approach to support ETL lifecycle, from conceptual representation to its execution primitives using a specific commercial tool. An ontology-based meta model it was designed and used for describing patterns internal specification and providing the means to support and enable its configuration and instantiation using a domain specific language.

Paper Citation

in Harvard Style

Oliveira B. and Belo O. (2016). An Ontology for Describing ETL Patterns Behavior . In Proceedings of the 5th International Conference on Data Management Technologies and Applications - Volume 1: DATA, ISBN 978-989-758-193-9, pages 102-109. DOI: 10.5220/0005974001020109

in Bibtex Style

@conference{data16,
author={Bruno Oliveira and Orlando Belo},
title={An Ontology for Describing ETL Patterns Behavior},
booktitle={Proceedings of the 5th International Conference on Data Management Technologies and Applications - Volume 1: DATA,},
year={2016},
pages={102-109},
publisher={SciTePress},
organization={INSTICC},
doi={10.5220/0005974001020109},
isbn={978-989-758-193-9},
}

in EndNote Style

TY - CONF
JO - Proceedings of the 5th International Conference on Data Management Technologies and Applications - Volume 1: DATA,
TI - An Ontology for Describing ETL Patterns Behavior
SN - 978-989-758-193-9
AU - Oliveira B.
AU - Belo O.
PY - 2016
SP - 102
EP - 109
DO - 10.5220/0005974001020109