DIMENSION HIERARCHIES UPDATES IN DATA WAREHOUSES - A User-driven Approach

Cécile Favre, Fadila Bentayeb, Omar Boussaid

Abstract

We designed a data warehouse for the French bank LCL meeting users' needs regarding marketing operations decision. However, the nature of the work of users implies that their requirements are often changing. In this paper, we propose an original and global approach to achieve a user-driven model evolution that provides answers to personalized analysis needs. We developed a prototype called WEDrik (data Warehouse Evolution Driven by Knowledge) within the Oracle 10g DBMS and applied our approach on banking data of LCL.

References

  1. Bébel, B., Eder, J., Koncilia, C., Morzy, T., and Wrembel, R. (2004). Creation and Management of Versions in Multiversion Data Warehouse. In XIXth ACM Symposium on Applied Computing (SAC 04), Nicosia, Cyprus, pages 717-723.
  2. Bellahsene, Z. (2002). Schema Evolution in Data Warehouses. Knowledge and Information Systems, 4(3):283-304.
  3. Bellatreche, L., Giacometti, A., Marcel, P., Mouloudi, H., and Laurent, D. (2005). A Personalization Framework for OLAP Queries. In VIIIth ACM International Workshop on Data Warehousing and OLAP (DOLAP 05), Bremen, Germany, pages 9-18.
  4. Blaschka, M., Sapia, C., and Höfling, G. (1999). On Schema Evolution in Multidimensional Databases. In Ist International Conference on Data Warehousing and Knowledge Discovery (DaWaK 99), Florence, Italy, volume 1676 of LNCS, pages 153-164.
  5. Bliujute, R., Saltenis, S., Slivinskas, G., and Jensen, C. (1998). Systematic Change Management in Dimensional Data Warehousing. In IIIrd International Baltic Workshop on Databases and Information Systems, Riga, Latvia, pages 27-41.
  6. Body, M., Miquel, M., Bédard, Y., and Tchounikine, A. (2002). A Multidimensional and Multiversion Structure for OLAP Applications. In Vth ACM International Workshop on Data Warehousing and OLAP (DOLAP 02), McLean, Virginia, USA, pages 1-6.
  7. Eder, J. and Koncilia, C. (2001). Changes of Dimension Data in Temporal Data Warehouses. In IIIrd International Conference on Data Warehousing and Knowledge Discovery (DaWaK 01), volume 2114 of LNCS, pages 284-293.
  8. Favre, C., Bentayeb, F., and Boussaid, O. (2006). A Knowledge-driven Data Warehouse Model for Analysis Evolution. In XIIIth International Conference on Concurrent Engineering: Research and Applications (CE 06), Antibes, France, volume 143 of Frontiers in Artificial Intelligence and Applications, pages 271- 278.
  9. Golfarelli, M., Lechtenborger, J., Rizzi, S., and Vossen, G. (2006). Schema Versioning in Data Warehouses: Enabling Cross-Version Querying via Schema Augmentation. Data and Knowledge Engineering, 59(2):435- 459.
  10. Hurtado, C. A., Mendelzon, A. O., and Vaisman, A. A. (1999). Maintaining Data Cubes under Dimension Updates. In XVth International Conference on Data Engineering (ICDE 99), Sydney, Australia, pages 346-355.
  11. Mazón, J.-N. and Trujillo, J. (2006). Enriching Data Warehouse Dimension Hierarchies by Using Semantic Relations. In XXIIIrd British National Conference on Databases (BNCOD 2006), Belfast, Northern Ireland, volume 4042 of LNCS, pages 278-281.
  12. Mendelzon, A. O. and Vaisman, A. A. (2000). Temporal Queries in OLAP. In XXVIth International Conference on Very Large Data Bases (VLDB 00), Cairo, Egypt, pages 242-253.
  13. Morzy, T. and Wrembel, R. (2004). On Querying Versions of Multiversion Data Warehouse. In VIIth ACM International Workshop on Data Warehousing and OLAP (DOLAP 04), Washington, Columbia, USA, pages 92- 101.
  14. Pedersen, T. B., Jensen, C. S., and Dyreson, C. E. (2001). A Foundation for Capturing and Querying Complex Multidimensional Data. Information Systems, 26(5):383-423.
Download


Paper Citation


in Harvard Style

Favre C., Bentayeb F. and Boussaid O. (2007). DIMENSION HIERARCHIES UPDATES IN DATA WAREHOUSES - A User-driven Approach . In Proceedings of the Ninth International Conference on Enterprise Information Systems - Volume 1: ICEIS, ISBN 978-972-8865-88-7, pages 206-211. DOI: 10.5220/0002390502060211


in Bibtex Style

@conference{iceis07,
author={Cécile Favre and Fadila Bentayeb and Omar Boussaid},
title={DIMENSION HIERARCHIES UPDATES IN DATA WAREHOUSES - A User-driven Approach},
booktitle={Proceedings of the Ninth International Conference on Enterprise Information Systems - Volume 1: ICEIS,},
year={2007},
pages={206-211},
publisher={SciTePress},
organization={INSTICC},
doi={10.5220/0002390502060211},
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 - DIMENSION HIERARCHIES UPDATES IN DATA WAREHOUSES - A User-driven Approach
SN - 978-972-8865-88-7
AU - Favre C.
AU - Bentayeb F.
AU - Boussaid O.
PY - 2007
SP - 206
EP - 211
DO - 10.5220/0002390502060211