ALGORITHMS FOR INTEGRATING TEMPORAL PROPERTIES OF DATA IN DATA WAREHOUSING

Francisco Araque, Alberto Salguero, Cecilia Delgado, Eladio Garví, José Samos

2006

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.

References

  1. Araque, F. & Samos, J. (2003). Data warehouse refreshment maintaining temporal consistency. 5th Intern. Conference on Enterprise Information Systems, ICEIS03.Angers. France.
  2. Araque, F. (2002). Data Warehousing with regard to temporal characteristics of the data source. IADIS WWW/Internet Conference. Lisbon, Portugal.
  3. Araque, F. (2003a). Real-time Data Warehousing with Temporal Requirements. Decision Systems Engineering, DSE'03 (in conjunction with the CAISE'03 conference). Klagenfurt/Velden, Austria.
  4. Araque, F. (2003b). Integrating heterogeneous data sources with temporal constraints using wrappers. The 15th Conference On Advanced Information Systems Engineering. Caise Forum. Klagenfurt, Austria.
  5. Araque, F., Salguero, A., and Abad, M.M. 2006. Application of data warehouse and Decision Support System in Soaring site recommendation. Proc. Information and Communication Technologies in Tourism, ENTER 2006. Springer Verlag, 18-20 January. Lausanne, Switzerland.
  6. Bruckner, Robert M. and Tjoa, A M. Capturing Delays and Valid Times in Data Warehouses - Towards Timely Consistent Analyses. Journal of Intelligent Information Systems (JIIS), Vol. 19(2), pp. 169-190, Kluwer Academic Publishers, September 2002.
  7. Castellanos, M. Semiautomatic Semantic Enrichment for the Integrated Access in Interoperable Databases. PhD thesis, Dept. Lenguajes y Sistemas Informáticos, Universidad Politécnica de Cataluña, Barcelona (SPAIN), June 1993.
  8. Chaudhuri, S., & Dayal, U. (1997). OLAP technology and data warehousing, ACM SIGMOD Records, HewlettPackard .
  9. Devlin, Barry. (1997). Data warehouse: from architecture to implementation. Addison Wesley , c1997.
  10. Haller, M., Pröll, B. , Retschitzegger, W., Tjoa, A. M., & Wagner, R. R. (2000). Integrating Heterogeneous Tourism Information in TIScover - The MIRO-Web Approach. Proceedings Information and Communication Technologies in Tourism, Springer Verlag, ENTER 2000. Barcelona.
  11. Hammer, J., García-Molina, H., Widom, J., Labio, W., & Zhuge, Y. (1995). The Stanford Data Warehousing Project. IEEE Data Engineering Bulletin.
  12. Harinarayan, V., Rajaraman, A., & Ullman, J. (1996). Implementing Data Cubes Efficiently. Proc. of ACM SIGMOD Conference. Montreal.
  13. Haas L., Kossman D., Wimmers E., Yang J.: "Optimizing Queries across Diverse Data Sources", 23rd Very Large Data Bases, August 1998, Athens, Greece.
  14. Inmon W.H. (2002). Building the Data Warehouse. John Wiley.
  15. Oliva, M., and Saltor, F. Integrating Multilevel Security Policies in Multilevel Federated Database Systems. In B. Thuraisingham, R. van de Riet, K.R. Dittrich, and Z. Tari, editors, Data and Applications Security: Developments and Directions, pages 135-147. Kluwer Academic Publishers, Boston, 2001.
  16. Moura Pires, J., Pantoquilho, M., & Viana, N. (2004). Real-Time Decision Support System for Space Missions Control. Int. Conference on Information and Knowledge Engineering, Las Vegas, USA.
Download


Paper Citation


in Harvard Style

Araque F., Salguero A., Delgado C., Garví E. and Samos J. (2006). ALGORITHMS FOR INTEGRATING TEMPORAL PROPERTIES OF DATA IN DATA WAREHOUSING . In Proceedings of the Eighth International Conference on Enterprise Information Systems - Volume 1: ICEIS, ISBN 978-972-8865-41-2, pages 193-199. DOI: 10.5220/0002493801930199


in Bibtex Style

@conference{iceis06,
author={Francisco Araque and Alberto Salguero and Cecilia Delgado and Eladio Garví and José Samos},
title={ALGORITHMS FOR INTEGRATING TEMPORAL PROPERTIES OF DATA IN DATA WAREHOUSING},
booktitle={Proceedings of the Eighth International Conference on Enterprise Information Systems - Volume 1: ICEIS,},
year={2006},
pages={193-199},
publisher={SciTePress},
organization={INSTICC},
doi={10.5220/0002493801930199},
isbn={978-972-8865-41-2},
}


in EndNote Style

TY - CONF
JO - Proceedings of the Eighth International Conference on Enterprise Information Systems - Volume 1: ICEIS,
TI - ALGORITHMS FOR INTEGRATING TEMPORAL PROPERTIES OF DATA IN DATA WAREHOUSING
SN - 978-972-8865-41-2
AU - Araque F.
AU - Salguero A.
AU - Delgado C.
AU - Garví E.
AU - Samos J.
PY - 2006
SP - 193
EP - 199
DO - 10.5220/0002493801930199