Please use this identifier to cite or link to this item: http://hdl.handle.net/1822/37402

TitleModelling ETL conciliation tasks using relational algebra operators
Author(s)Santos, Vasco
Belo, O.
KeywordsData Warehousing Systems
ETL Conceptual Modelling
Data Conciliation Tasks
Relational Algebra
component
Issue date21-Oct-2014
PublisherIEEE
Abstract(s)The design and development of a data warehousing system (DWS) tends to be an exceptional resource consuming project which in turn makes it a high risk/reward project. In order to minimize the risk, some design methodologies and tools are used along the several phases of the project. The Extract-Transform-Load (ETL) component is normally one of the most critical components of a DWS since it gathers, corrects and conforms data in order to be loaded into the Data Warehouse (DW). Data conciliation task tends to be a dull and manual intensive job that often deals with several heterogeneous sources which is critical to the correct representation of the enterprise’s information. The manual nature of this task makes it prone to errors and subject of intensive and successive monitoring. In this paper, we analyse some of the most common ETL tasks for data conciliation using a Relational Algebra approach, as an effort to standardize them for future use in a generic ETL environment. A slowly changed dimension scenario will be used to support the data conciliation modelling process designed for this work.
TypeConference paper
URIhttp://hdl.handle.net/1822/37402
ISBN9781479974115
DOI10.1109/EMS.2014.59
Peer-Reviewedyes
AccessRestricted access (UMinho)
Appears in Collections:CAlg - Artigos em livros de atas/Papers in proceedings

Files in This Item:
File Description SizeFormat 
2014-CI-EMS-Santos&Belo-CRP.pdf
  Restricted access
Artigo completo publicado.523,62 kBAdobe PDFView/Open

Partilhe no FacebookPartilhe no TwitterPartilhe no DeliciousPartilhe no LinkedInPartilhe no DiggAdicionar ao Google BookmarksPartilhe no MySpacePartilhe no Orkut
Exporte no formato BibTex mendeley Exporte no formato Endnote Adicione ao seu ORCID