TRANSACTION CONCEPTS FOR SUPPORTING CHANGES IN DATA WAREHOUSES

Bartosz Bębel, Zbyszko Królikowski, Tadeusz Morzy, Robert Wrembel

Abstract

A data warehouse (DW) provides information from external data sources for analytical processing, decision-making, and data mining tools. External data sources are autonomous, i.e. they change over time, independently of a DW. Therefore, the structure and content of a DW has to be periodically synchronized with its external data sources. This synchronization concerns DW data as well as schema. Concurrent work of synchronizing processes and user queries may result in various anomalies. In order to tackle this problem we propose to apply a multiversion data warehouse and an advanced transaction mechanism to a DW synchronization.

References

  1. Agrawal D., El Abbadi A., Singh A., Yurek T., Efficient View Maintenance at Data Warehouse. Proc. of the 1997 ACM SIGMOD International Conference on Management of Data, May 13-15, 1997, Tucson, Arizona, USA.
  2. Barghouti N.S., Kaiser G.E., Concurrency Control in Advanced Database Applications. Department of Computer Science, Columbia University, New York, USA, 1994.
  3. Bellahsene, Z. (1998). View Adaptation in Data Warehousing Systems. Proc. of the DEXA Conf.
  4. Blaschka, M. Sapia, C., Hofling, G. (1999). On Schema Evolution in Multidimensional Databases. Proc. of the DaWak99 Conference, Italy.
  5. Chamoni, P., Stock, S. (1999). Temporal Structures in Data Warehousing. Proc. of the Data Warehousing and Knowledge Discovery DaWaK, Italy.
  6. Chen J., Chen S., Rundensteiner E., TxnWrap: A Transactional Approach to Data Warehouse Maintenance. Worcester Polytechnic Institute Technical Report, 2000. (Revisited on February 2002).
  7. Eder, J., Koncilia, C. (2001). Changes of Dimension Data in Temporal Data Warehouses. Proc. of the DaWak 2001 Conference, Germany.
  8. Eder, J., Koncilia, C., Morzy, T. (2002). The COMET Metamodel for Temporal Data Warehouses. Proc. of the 14th Int. Conference on Advanced Information Systems Engineering (CAISE'02), Canada.
  9. Hurtado, C.A., Mendelzon, A.O.: Vaisman, A.A. (1999a). Maintaining Data Cubes under Dimension Updates. Proc. of the ICDE Conference, Australia.
  10. Hurtado, C.A., Mendelzon, A.O.: Vaisman, A.A. (1999b). Updating OLAP Dimensions. Proc. of the DOLAP Conference.
  11. Kang, H.G., Chung, C.W.: (2002). Exploiting Versions for On-line Data Warehouse Maintenance in MOLAP Servers. Proc. of the VLDB Conference, China.
  12. Kulkarni, S., Mohania, M. (1999). Concurrent Maintenance of Views Using Multiple Versions. Proc. of the Intern. Database Engineering and Application Symposium.
  13. Mendelzon, A.O., Vaisman, A.A (2000). Temporal Queries in OLAP. Proc. of the VLDB Conference, Egypt.
  14. Morzy T., Wrembel R. (2003). Modeling a Multiversion Data Warehouse: a Formal Approach. Proc. of the 5th International Conference on Enterprise Information Systems (ICEIS), Angers, France.
  15. Mostefaoui A., Raynal M., Roy M., Agrawal D., El Abbadi A., The Lord of the Rings: Efficient Maintenance of Views at Data Warehouse. Proc. of 16th International Conference Distributed Computing, DISC 2002, Toulouse, France, October 28-30, 2002.
  16. Quass, D., Widom, J. (1997). On-Line Warehouse View Maintenance. Proc. of the SIGMOD Conference.
  17. Yang, J., Widom, J. (2000). Temporal View SelfMaintenance. Proc. of the EDBT Conference, Germany.
  18. Rundensteiner E., Koeller A., and Zhang X.: Maintaining Data Warehouses over Changing Information Sources. Communications of the ACM, vol. 43, No. 6, 2000.
  19. Zhuge Y., Garcia-Molina H., Hammer J., Widom J., View Maintenance in a Warehousing Environment. Proc. of the 1995 ACM SIGMOD International Conference on Management of Data, San Jose, California, May 22-25, 1995.
  20. Zhuge Y., Garcia-Molina H., Wiener J., The Strobe Algorithms for Multi-Source Warehouse Consistency. Proc. of the 4th International Conference on Parallel and Distributed Information Systems, December 18- 20, 1996, Miami Beach, Florida, USA.
Download


Paper Citation


in Harvard Style

Bębel B., Królikowski Z., Morzy T. and Wrembel R. (2004). TRANSACTION CONCEPTS FOR SUPPORTING CHANGES IN DATA WAREHOUSES . In Proceedings of the Sixth International Conference on Enterprise Information Systems - Volume 1: ICEIS, ISBN 972-8865-00-7, pages 290-297. DOI: 10.5220/0002636702900297


in Bibtex Style

@conference{iceis04,
author={Bartosz Bębel and Zbyszko Królikowski and Tadeusz Morzy and Robert Wrembel},
title={TRANSACTION CONCEPTS FOR SUPPORTING CHANGES IN DATA WAREHOUSES},
booktitle={Proceedings of the Sixth International Conference on Enterprise Information Systems - Volume 1: ICEIS,},
year={2004},
pages={290-297},
publisher={SciTePress},
organization={INSTICC},
doi={10.5220/0002636702900297},
isbn={972-8865-00-7},
}


in EndNote Style

TY - CONF
JO - Proceedings of the Sixth International Conference on Enterprise Information Systems - Volume 1: ICEIS,
TI - TRANSACTION CONCEPTS FOR SUPPORTING CHANGES IN DATA WAREHOUSES
SN - 972-8865-00-7
AU - Bębel B.
AU - Królikowski Z.
AU - Morzy T.
AU - Wrembel R.
PY - 2004
SP - 290
EP - 297
DO - 10.5220/0002636702900297