MONITORING WEB DATA SOURCES USING TEMPORAL PROPERTIES AS AN EXTERNAL RESOURCES OF A DATA WAREHOUSE

Francisco Araque, Alberto Salguero, Cecilia Delgado

2007

Abstract

Flexibility to react on rapidly changing general conditions of the environment has become a key factor for economic success of any company, and the WWW has become an important resource of information for this proposal. Nowadays most of the important enterprise has incorporated the Data Warehouse (DW) technology where the information retrieved from different sources, including the WWW, has been integrated. The quality of data provided to the decision makers depends on the capability of the DW system to convey in a reasonable time, from the sources to the data marts, the changes made at the data sources. If we use the data arrival properties of such underlying information sources, the DW Administrator can derive more appropriate rules and check the consistency of user requirements more accurately. In this paper we present an algorithm for data integration depending on the temporal characteristics of the data sources and an architecture for monitoring web sources on the WWW in order to obtain its temporal properties. In addition we show an example applied to tourism area where data integrated into DW can be used to schedule personalized travel as a value-added service for electronic commerce.

References

  1. Araque, F, Samos. J.: External Schemas in Real-Time Object-Oriented Databases. 20th IEEE Real-Time Systems Symposium, WIP Proceedings, pp. 105-109. Phoenix. (1999)
  2. Araque, F. & Samos, J.: Data warehouse refreshment maintaining temporal consistency. 5th Intern. Conference on Enterprise Information Systems, ICEIS03.Angers. France. (2003)
  3. Araque, F., Salguero, A., Abad, M.M.: Application of data warehouse and Decision Support System in Soaring site recommendation. Proc. Information and Communication Technologies in Tourism, ENTER 2006. Springer Verlag, Lausanne, Switzerland.
  4. Araque, F., Salguero, A.G., Delgado, C., Samos, J.: Algorithms for integrating temporal properties of data in DW. 8th Int. Conf. on Enterprise Information Systems (ICEIS). Paphos, Cyprus. May, (2006)
  5. Araque, F.: Integrating heterogeneous data sources with temporal constraints using wrappers. The 15th Conference On Advanced Information Systems Engineering. Caise Forum. Klagenfurt, Austria. (2003)
  6. Araque, F.: Real-time Data Warehousing with Temporal Requirements. Decision Systems Engineering, DSE'03 (CAISE'03 conference). Klagenfurt/Velden, Austria. (2003)
  7. Bruckner, R., 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. (2002)
  8. Chaudhuri, S., Dayal, U.: OLAP technology and data warehousing, ACM SIGMOD Records, HewlettPackard . (1997)
  9. Hammer, J., GarcĂ­a-Molina, H., Widom, J., Labio, W., Zhuge, Y.: The Stanford Data Warehousing Project. IEEE Data Engineering Bulletin. (1995)
  10. Inmon W.H.: Building the Data Warehouse. John Wiley. (2002)
  11. March, S.T., Hevner, A.R.: Integrated decision support systems: A data warehousing perspective. Decision Support Systems. (2005)
  12. Ramamritham, R., Sivasankaran, J. A., Stankovic, D. T., Towsley, M.: Integrating Temporal, Real-Time, and Active Databases, ACM Sigmod Record, Vol. 25. No. 1. pp. 8-12. (1996)
  13. Srinivasan, C. L., Ramamritham, R.: Maintaining Temporal Coherency of Virtual Warehouses (abstract). The 19th IEEE Real-Time Systems Symposium (RTSS98), Madrid, Spain. (1998)
  14. Watanabe, Y., Kitagawa, H., Ishikawa, Y.: Integration of Multiple Dissemination-Based Information Sources Using Source Data Arrival Properties. Proc. 2nd Int. Conf. on Web Information Systems Engineering, Kyoto, Japan (2001)
  15. Yu, L., Huang, W., Wang, S. and Lai, K. K., Web warehouse - a new web information fusion tool for web mining. Information Fusion, vol. In Press, Corrected Proof, (2006)
Download


Paper Citation


in Harvard Style

Araque F., Salguero A. and Delgado C. (2007). MONITORING WEB DATA SOURCES USING TEMPORAL PROPERTIES AS AN EXTERNAL RESOURCES OF A DATA WAREHOUSE . In Proceedings of the Ninth International Conference on Enterprise Information Systems - Volume 1: ICEIS, ISBN 978-972-8865-88-7, pages 28-35. DOI: 10.5220/0002393100280035


in Bibtex Style

@conference{iceis07,
author={Francisco Araque and Alberto Salguero and Cecilia Delgado},
title={MONITORING WEB DATA SOURCES USING TEMPORAL PROPERTIES AS AN EXTERNAL RESOURCES OF A DATA WAREHOUSE},
booktitle={Proceedings of the Ninth International Conference on Enterprise Information Systems - Volume 1: ICEIS,},
year={2007},
pages={28-35},
publisher={SciTePress},
organization={INSTICC},
doi={10.5220/0002393100280035},
isbn={978-972-8865-88-7},
}


in EndNote Style

TY - CONF
JO - Proceedings of the Ninth International Conference on Enterprise Information Systems - Volume 1: ICEIS,
TI - MONITORING WEB DATA SOURCES USING TEMPORAL PROPERTIES AS AN EXTERNAL RESOURCES OF A DATA WAREHOUSE
SN - 978-972-8865-88-7
AU - Araque F.
AU - Salguero A.
AU - Delgado C.
PY - 2007
SP - 28
EP - 35
DO - 10.5220/0002393100280035