Toward Evolution Models for Data Warehouses

Saïd Taktak, Jamel Feki, Gilles Zurfluh

Abstract

A Data warehouse (DW) is characterized by a complex architecture, designed in order to integrate data derived from operational data sources (DS), hence providing advanced analytical tools of these data. The DW is highly dependent on its DS. Hence, evolutions of the DS schema need to be propagated to the DW schema and content. This paper presents a model-driven approach for the evolution of a multidimensional DW. It is based on two evolution models: a first evolution model for the DS and another for the DW. These two models concern the data structure aspects as well as the evolution operations. The transition between these two models is performed through specific transformation rules defined in QVT (Query\View\Transformation).

References

  1. Azaiez, N., Taktak, S., Feki, J., 20113. DWEv : Un prototype pour l'évolution partielle du schéma multidimensionnel. 7éme édition de la Conférence Maghrébine sur les Avancées des Systèmes Décisionnels (ASD 2013), Marrakech, Maroc, pages 457-462.
  2. Bebel, B., Eder,J., Koncilia, C., Morzy, T., Wrembel, R., 2004. Creation and Management ofVersions in Multiversion Data Warehouse.In XIXth ACM Symposium on Applied Computing (SAC), Nicosia, Cyprus, pages 717-723.
  3. Bellahsene, Z., 2002. Schema Evolution in Data Warehouses.Knowledge and Information-Systems 4(3), pages 283-304.
  4. Benitez-Guerrero, E.I., Collet, C., Adiba, M., 2004. The Whes Approach To Data Warehouse Evolution, eGnosis (online), 2, Art. 11.
  5. Blaschka, M., Sapia, C., and Hofling, G., 1999. On Schema Evolution in Multi-dimensional Databases.In Ist International Conference on Data Ware-housing and Knowledge Discovery(DaWaK), Florence, Italy, volume1676 of LNCS, pages 153-164.
  6. Favre, C., Bentayeb, F., Boussaid, O., 2007. A Survey of Data Warehouse Model Evolution, Encyclopedia of Database Technologies and Applications, Second Edition, Idea Group Publishing.
  7. Inmon, W., 2002. Building the Data Warehouse (3rd Edition). New York. Wiley & Sons.
  8. Mazon, J.N., Trujillo, J. 2008. An MDA approach for the development of data warehouses. Decision Support Systems (DSS'08), Vol. 45 (1), pages 41-58.
  9. OMG, 2001. Object Management Group: Unified Modeling Language Specification 1.4. http://www.omg.org/cgi-bin/doc?formal/01-09-67.
  10. OMG, 2004. Object Management Group: Model Driven Architecture (MDA). http://www.omg.org/cgibin/doc?formal/03-06-01.
  11. OMG, 2009. Object Management Group: Meta Object Facility (MOF) 2.0 Query/View/Transformation, version 1.1, ttp://www.omg.org/spec/QVT/1.1/Beta2/.
  12. Papastefanatos, G., Vassiliadis, P., Simitsis, A., Sellis, T., Vassiliou, Y., 2009. Rulebased Managementof Schema Changes at ETL Sources. In The International Workshop on ManagingEvolution of Data Warehouses (MEDWa), Riga, Latvia.
  13. Prat, N., Akoka, J., Comyn-Wattiau. I., 2006. A UMLbased data warehouse design method, Decision Support Systems (DSS?06), Vol. 42(3), pages 1449- 1473.
  14. Rundensteiner, E. A., Koeller, A., Zhang, X., Lee, A.J., Nica, A., 1999. Evolvable View Environment EVE: A Data Warehouse System Handling Schema and Data Changes of Distributed Sources. The International Database Engineering and ApplicationSympo-sium (IDEAS'99), Montreal, Canada.
  15. Solodovnikova, D., 2008. The Formal Model for Multiversion Data Warehouse Evolution. Postconference proceedings of the 8th International Baltic Conference on Databases and Information Systems, Tallinn, Estonia, Frontiers in Artificial Intelligence and Applicationsby IOS Press, pages 91- 102.
  16. Taktak, S., Feki, J., 2012. Toward Propagating the Evolution of Data Warehouse on Data Marts, 2nd International Conference on Model & Data Engineering (MEDI'2012), Poitiers, France, pages 178-185.
  17. Vassiliadis, P., 2009. A survey of Extract-transform-Load technology. International Journal of Data Warehousing & Mining (IJDWM'09), Vol. 5(3), pages. 1-27.
  18. Wrembel, R., Bebel, B., 2007. Metadata management in a multiversion data warehouse.In Journal on data semantics VIII.Lecture Notes In Computer Science, Vol. 4380. Springer-Verlag, Berlin, Heidelberg pages 118-157.
Download


Paper Citation


in Harvard Style

Taktak S., Feki J. and Zurfluh G. (2014). Toward Evolution Models for Data Warehouses . In Proceedings of the 2nd International Conference on Model-Driven Engineering and Software Development - Volume 1: MODELSWARD, ISBN 978-989-758-007-9, pages 472-479. DOI: 10.5220/0004877304720479


in Bibtex Style

@conference{modelsward14,
author={Saïd Taktak and Jamel Feki and Gilles Zurfluh},
title={Toward Evolution Models for Data Warehouses},
booktitle={Proceedings of the 2nd International Conference on Model-Driven Engineering and Software Development - Volume 1: MODELSWARD,},
year={2014},
pages={472-479},
publisher={SciTePress},
organization={INSTICC},
doi={10.5220/0004877304720479},
isbn={978-989-758-007-9},
}


in EndNote Style

TY - CONF
JO - Proceedings of the 2nd International Conference on Model-Driven Engineering and Software Development - Volume 1: MODELSWARD,
TI - Toward Evolution Models for Data Warehouses
SN - 978-989-758-007-9
AU - Taktak S.
AU - Feki J.
AU - Zurfluh G.
PY - 2014
SP - 472
EP - 479
DO - 10.5220/0004877304720479