MULTIDIMENSIONAL SCHEMA EVOLUTION - Integrating New OLAP Requirements

Mohamed Neji, Ahlem Nabli, Jamel Feki, Faiez Gargouri

Abstract

Multidimensional databases are an effective support for OLAP processes. They improve the enterprise decision-making. These databases evolve with the decision maker requirements evolution and, are sensitive to data source changes. In this paper, we are interested in the evolution of the data mart schema due to the raise of new OLAP needs. Our approach determines first, what functional data marts will be able to cover a new requirement, if any, and secondly, decides on a strategy of integration. This leads either to the alteration of an existing data mart schema or, to the creation of a new schema suitable for the new requirement.

References

  1. Blaschka M., Sapia C. and Höfling G., “On Schema Evolution in Multidimensional Databases”, Proceedings of DaWak'99 Conference, Florence, Italy, 1999.
  2. Bliujute R., Saltenis S., Slivinskas G., Jensen C.S., “Systematic Change Managment in Dimensional Data Warehousing”, Proceedings of the 3rd International Baltic Workshop on DB and IS, 1998.
  3. Body M., Miquel M., Bedard Y., Tchounikine A., “Handling Evolutions in Multidimensional Structures”, 19th International Conference on Data Engineering Sponsored by the IEEE Computer Society March 5 - March 8, 2003 Bangalore, India.
  4. Chamoni P. and Stock S., “Temporal Structures in Data warehousing”, In Proceedings of the DaWaK'99 Conference, Florence, Italy, 1999.
  5. Eder J. and Koncilia C., “Evolution of Dimension Data in Temporal Data Warehouses”, Proceedings of the DaWaK'01 Conference, Munich, Germany, 2001.
  6. Feki J., “Vers une conception automatisée des entrepôts de données : Modélisation des besoins OLAP et génération de schémas multidimensionnels“, 8th MCSEAI, Tunisia, 2004.
  7. Mendelzon A.O. and Vaisman A., “Temporal Queries in OLAP” Proceedings of the 26th VLDB'00 Conference, Cairo, Egypt, 2000.
  8. Nabli A., Feki J. and Gargouri F.:" Automatic construction of multidimensional schema from OLAP requirements", AICCSA'05, 3-6 January, Cairo, Egypt.
  9. Pedersen T.B., Jensen C.S. and Dyreson C.E., “A foundation for capturing and querying complex multidimensional data”, Information Systems Special Issue: Data Warehousing, Vol 26, No 5, 2001.
  10. Soussi A., Feki J., et Gargouri F., “Approche semiautomatisée de conception de schémas multidimensionnels valides“., EDA'05, 10 juin Lyon, France, 2005.
Download


Paper Citation


in Harvard Style

Neji M., Nabli A., Feki J. and Gargouri F. (2006). MULTIDIMENSIONAL SCHEMA EVOLUTION - Integrating New OLAP Requirements . In Proceedings of the Eighth International Conference on Enterprise Information Systems - Volume 1: ICEIS, ISBN 978-972-8865-41-2, pages 331-334. DOI: 10.5220/0002461303310334


in Bibtex Style

@conference{iceis06,
author={Mohamed Neji and Ahlem Nabli and Jamel Feki and Faiez Gargouri},
title={MULTIDIMENSIONAL SCHEMA EVOLUTION - Integrating New OLAP Requirements},
booktitle={Proceedings of the Eighth International Conference on Enterprise Information Systems - Volume 1: ICEIS,},
year={2006},
pages={331-334},
publisher={SciTePress},
organization={INSTICC},
doi={10.5220/0002461303310334},
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 - MULTIDIMENSIONAL SCHEMA EVOLUTION - Integrating New OLAP Requirements
SN - 978-972-8865-41-2
AU - Neji M.
AU - Nabli A.
AU - Feki J.
AU - Gargouri F.
PY - 2006
SP - 331
EP - 334
DO - 10.5220/0002461303310334