Algorithms for Integrating Temporal Properties of Data in Data Warehousing

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

[1]  Barry Devlin,et al.  Data Warehouse: From Architecture to Implementation , 1996 .

[2]  A Min Tjoa,et al.  Capturing Delays and Valid Times in Data Warehouses—Towards Timely Consistent Analyses , 2002, Journal of Intelligent Information Systems.

[3]  Malú Castellanos,et al.  Semantic enrichment of interoperable databases , 1993, Proceedings RIDE-IMS `93: Third International Workshop on Research Issues in Data Engineering: Interoperability in Multidatabase Systems.

[4]  W. H. Inmon,et al.  Building the data warehouse , 1992 .

[5]  Jeffrey D. Ullman,et al.  Implementing data cubes efficiently , 1996, SIGMOD '96.

[6]  Francisco Araque.  Integrating Heterogeneous Data Sources with Temporal Constraints Using Wrappers , 2003, CAiSE Short Paper Proceedings.

[7]  María M. Abad-Grau,et al.  Application of data warehouse and Decision Support System in soaring site recommendation , 2006, ENTER.

[8]  M. Haller,et al.  Integrating Heterogeneous Tourism Information in TIScover — The MIRO-Web Approach , 2000 .

[9]  Francisco Araque,et al.  Real-time Data Warehousing with Temporal Requirements , 2003, CAiSE Workshops.

[10]  Marta Pantoquilho,et al.  Real-Time Decision Support System for Space Missions Control , 2004, IKE.

[11]  Laura M. Haas,et al.  Optimizing Queries Across Diverse Data Sources , 1997, VLDB.

[12]  Fèlix Saltor,et al.  Integrating Security Policies in Federated Database Systems , 2000, DBSec.

[13]  Francisco Araque.  Data Warehousing with Regard to Temporal Characteristics of the Data Source , 2002, ICWI.

[14]  Jennifer Widom,et al.  Maintenance of Materialized Views: Problems, Techniques, and Applications , 1999, IEEE Data Eng. Bull..