Validating ETL Patterns Feasability using Alloy

Bruno Oliveira, Orlando Belo

2017

Abstract

The ETL processes can be seen as typical data-oriented workflows composed of dozens of granular tasks that are responsible for the integration of data coming from different data sources. They are one of the most important components of a data warehousing system, strongly influenced by the complexity of business requirements, their changing, and evolution. To facilitate the planning and ETL implementation, a set of patterns specially designed to map standard ETL procedures is presented. They provide a simpler and conceptual perspective that can enrich to enable the generation of execution primitives. Generic models can be built, simplifying process views and providing methods for carrying out the acquired expertise to new applications using well-proven practices. This work demonstrates the fundaments of an ETL pattern-based approach for ETL development, its configuration and validation trough a set of Alloy specifications used to express its structural constraints and behaviour.

Paper Citation

in Harvard Style

Oliveira B. and Belo O. (2017). Validating ETL Patterns Feasability using Alloy . In Proceedings of the 6th International Conference on Data Science, Technology and Applications - Volume 1: DATA, ISBN 978-989-758-255-4, pages 200-207. DOI: 10.5220/0006428002000207

in Bibtex Style

@conference{data17,
author={Bruno Oliveira and Orlando Belo},
title={Validating ETL Patterns Feasability using Alloy},
booktitle={Proceedings of the 6th International Conference on Data Science, Technology and Applications - Volume 1: DATA,},
year={2017},
pages={200-207},
publisher={SciTePress},
organization={INSTICC},
doi={10.5220/0006428002000207},
isbn={978-989-758-255-4},
}

in EndNote Style

TY - CONF
JO - Proceedings of the 6th International Conference on Data Science, Technology and Applications - Volume 1: DATA,
TI - Validating ETL Patterns Feasability using Alloy
SN - 978-989-758-255-4
AU - Oliveira B.
AU - Belo O.
PY - 2017
SP - 200
EP - 207
DO - 10.5220/0006428002000207