Vasco Santos

Vasco Santos

Auto-generated profile, based on publicly available information

Vasco Santos

University of Minho

Research Focus & Metrics

Academic Career Length

15Years (2012-Present)

(Calculated once Scilit publication data is synced: current year − year of first publication + 1)

Representative Publications

View All Publications
1 January 2013
Verified
Book Chapter
Closed access
PDF file
Bruno OliveiraBruno Oliveira
Bruno Oliveira
VSVasco Santos
Vasco Santos
OBOrlando Belo
Orlando Belo

1 January 2013 in Procedia Technology
Verified
Journal Article
Open access
VSVasco Santos
Vasco Santos
OBOrlando Belo
Orlando Belo
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

1 January 2019
Verified
Conference Paper
Open access
Bruno OliveiraBruno Oliveira
Bruno Oliveira
Óscar OliveiraÓscar Oliveira
Óscar Oliveira
VSVasco Santos
Vasco Santos
OBOrlando Belo
Orlando Belo

1 January 2012 in Procedia Technology
Verified
Journal Article
Open access
VSVasco Santos
Vasco Santos
Bruno OliveiraBruno Oliveira
Bruno Oliveira
RSRui Silva
Rui Silva
OBOrlando Belo
Orlando Belo
Data Warehouses store integrated and consistent data in a subject-oriented data repository dedicated especially to support business intelligence processes. Nevertheless, in order to maintain a data warehouse up-to-date, data intensive tasks retrieve regularly specialized information from specific preselected information sources, transforming and conforming it accordingly to some specific business requirements provided by decision-makers. Such tasks, commonly named as Extract-Transform-Load (ETL) processes, have a limited time frame window to be executed over an ever increasing amount of data with extremely complex operations. The common approach to deal with the need of more computational power is the acquisition of new and more powerful hardware. This expensive approach disregards the unused computational resources available in desktop computers already present at most enterprises’ computational environments. This paper intends to define a different approach to deal with ETL processes, taking advantage of parallel processing over a GRID environment using XML data as an effective support to data storage and communication, demonstrating that GRID environments could be a real alternative for the implementation of low cost data warehouses

29 September 2015
Verified
Book Chapter
Closed access
PDF file
OBOrlando Belo
Orlando Belo
CGClaudia Gomes
Claudia Gomes
Bruno OliveiraBruno Oliveira
Bruno Oliveira
RMRicardo Marques
Ricardo Marques
VSVasco Santos
Vasco Santos

30 April 2014 in International Journal of Database Management Systems
Verified
Journal Article
Closed access
VSVasco Santos
Vasco Santos
RSRui Silva
Rui Silva
OBOrlando Belo
Orlando Belo