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

TitleModeling ETL data quality enforcement tasks using relational algebra operators
Author(s)Santos, Vasco
Belo, O.
KeywordsData Warehousing Systems
ETL modeling
Data Quality Enforcement
Relational Algebra
Issue date23-Oct-2013
PublisherElsevier
JournalProcedia Technology
Abstract(s)Usually, a data warehouse is refreshed periodically with data gathered from disparate source systems. Nevertheless this data might not be fully accurate, probably containing serious data quality problems, such as uniqueness, misrepresentations, null values, multi-purpose fields, or inconsistent values, for one or more attributes. This is a major contribution to the falling expectations users have on data analyzed from data warehouses. Data quality enforcement is a complex time consuming task that parses data from source tables and corrects it, normalizes it and integrates it into a data warehouse for a better representation of real businesses. In this paper, we analyze some of the common tasks that are associated with data quality enforcement, representing and modeling them using Relational Algebra as specification tool.
TypeConference paper
URIhttp://hdl.handle.net/1822/37418
DOI10.1016/j.protcy.2013.12.049
ISSN2212-0173
Peer-Reviewedyes
AccessRestricted access (UMinho)
Appears in Collections:CAlg - Artigos em livros de atas/Papers in proceedings

Files in This Item:
File Description SizeFormat 
2013-CI-Centeris-Santos&Belo-CRP.pdf
  Restricted access
Artigo completo publicado424,15 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