Authors:
Francisco Araque
1
;
Alberto Salguero
2
;
Cecilia Delgado
3
;
Eladio Garví
3
and
José Samos
3
Affiliations:
1
University of Jaén, Spain
;
2
E.T.S.I.I., University of Granada, Spain
;
3
University of Granada, Spain
Keyword(s):
Data Warehouse, Temporal integration, Middleware Integration, Organisational Issues on Systems Integration.
Related
Ontology
Subjects/Areas/Topics:
Coupling and Integrating Heterogeneous Data Sources
;
Data Warehouses and OLAP
;
Databases and Information Systems Integration
;
Enterprise Information Systems
;
Organisational Issues on Systems Integration
Abstract:
One of the most complex issues of the integration and transformation interface is the case where there are multiple sources for a single data element in the enterprise data warehouse. While there are many facets to the large number of variables that are needed in the integration phase, what we are interested in is the temporal problem. It is necessary to solve problems such as what happens when data from data source A is available but data from data source B is not. This paper presents our work into data integration in the Data Warehouse on the basis of the temporal properties of the data sources. Depending on the extraction method and data source, we can determine whether it will be possible to incorporate the data into the Data Warehouse. We shall also examine the temporal features of the data extraction methods and propose algorithms for data integration depending on the temporal characteristics of the data sources and on the data extraction method.