Authors: Bruno Oliveira 1 and Orlando Belo 2

Affiliations: 1 CIICESI, School of Management and Technology and Porto Polytechnic, Portugal ; 2 ALGORITMI R&D Centre and University of Minho, Portugal

ISBN: 978-989-758-255-4

Keyword(s): Data Warehousing Systems, ETL Patterns, ETL Component-reuse, Software Engineering, Formal Specification and Validation, BPMN, Alloy.

Related Ontology Subjects/Areas/Topics: Applications ; Artificial Intelligence ; Business Analytics ; Collaboration and e-Services ; Data Engineering ; Data Integrity ; Data Management and Quality ; Data Warehouse Management ; Databases and Data Security ; e-Business ; Enterprise Information Systems ; Information and Systems Security ; Information Integration ; Information Quality ; Information Retrieval ; Integration/Interoperability ; Knowledge Engineering and Ontology Development ; Knowledge-Based Systems ; Ontologies and the Semantic Web ; Pattern Recognition ; Semi-Structured and Unstructured Data ; Software Engineering ; Symbolic Systems

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 behaviou r. (More)

PDF ImageFull Text


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

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:
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

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,},


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

Login or register to post comments.

Comments on this Paper: Be the first to review this paper.