The Power of a Model-Driven Approach to Handle Evolving Data Warehouse Requirements

Said Taktak, Saleh Alshomrani, Jamel Feki, Gilles Zurfluh

Abstract

The Data Warehouse (DW) is characterized by complex architecture, specific modeling and design approaches. It integrates data issued from operational data sources in order to meet decision-makers’ needs by providing answers for OLAP queries (On-Line Analytical Processing). In practice, both data source models and decision-makers’ analytical requirements evolve over time and, therefore, lead to changes in the DW multidimensional model. In this evolving context, we have developed the DWE (Data Warehouse Evolution) framework. DWE automatically propagates the changes of the data source data-model on the DW data-model. This paper proposes a model-driven approach for extending DWE in order to consider a further related evolutionary aspect: The evolution of decision-makers’ needs. It deals with the propagation of these evolutions on the DW multidimensional model. This approach relies on a classification of evolution scenarios and a set of transformation rules for the identification of evolution operations to apply on the DW.

References

  1. Bellahsene, Z., 2002. Schema Evolution in Data Warehouses. Knowledge and Information Systems, 4(3), (pp. 283-304).
  2. Bellatreche, L., Wrembel, R. (2013). Evolution and Versioning in Semantic Data Integration Systems. Journal on Data Semantics, (2), (pp. 57-59).
  3. El Akkaoui, Z., Zimànyi, E., Mazón, J. N., Trujillo. J., 2011. A model-driven framework for ETL process development. In Proceedings of the ACM 14th international workshop on Data Warehousing and OLAP (DOLAP 7811), (pp. 45-52). New York, USA.
  4. Favre, C., Bentayeb, F., Boussaid, O., (2007). Dimension Hierarchies Updates in Data Warehouses: a Userdriven Approach. In 9th International Conference on Enterprise Information Systems (ICEIS'07), (pp. 206- 211), Madeira, Portugal.
  5. Golfarelli, M., Rizzi, S., Vrdoljak, B., 2001. Data Warehouse Design from XML Sources. In proceedings of ACM International Workshop on Data Warehousing and OLAP (DOLAP'01), (pp. 40-47), Atlanta, GA, USA.
  6. Kimball, R., Ross, M., 2002. The Data Warehouse Toolkit. Wiley & Sons. New York, 2nd edition.
  7. Nabli, A., Soussi, A., Feki, J., Ben Abdallah, H., Gargouri, F., 2005. Towards an Automatic Data Warehouse and Data Mart Design, 7th International Conference on Enterprise Information Systems (ICEIS'05), (pp. 226- 231), Miami, USA.
  8. OMG, 2004. Object Management Group: Model Driven Architecture (MDA). http://www.omg.org/cgibin/doc?formal/03-06-01.
  9. OMG, 2009. Object Management Group: Meta Object Facility (MOF) 2.0 Query/View/Transformation, version 1.1. http://www.omg.org/spec/QVT/1.1/Beta2/
  10. Papastefanatos, G., Vassiliadis, P., Simitsis, A., Sellis, T. Vassiliou, Y., 2009. Rule based Management of Schema Changes at ETL Sources. International Workshop on Managing Evolution of Data Warehouses (MEDWa'09), (pp. 55-62), Riga, Latvia.
  11. Phipps, C., Davis, K., 2002. Automating data warehouse conceptual schema design and evaluation. In the 4th Intern. workshop Design and Management of Data Warehouses. Canada, 2002, (pp. 23-32).
  12. Rundensteiner, E. A., Nica, A., Lee, A. J., 1997. On Preserving Views in Evolving Environments. In the 4th International Workshop Knowledge Representation Meets Databases (pp.131-141).
  13. Rusu, L. I., Rahayu, W., Taniar, D., 2005. A methodology for Building XML DW. In International Journal of Data warehousing & Mining, 1(2), (pp.67-92).
  14. Solodovnikova, D., Niedrite, L., Kozmina, N., 2015. Handling Evolving Data Warehouse Requirements. In the East European Conference on Advances in Databases and Information Systems (pp. 334-345). Springer International Publishing.
  15. Taktak, S., Feki, J., Zurfluh, G., 2014. Toward Evolution Models for Data Warehouses. 2nd Intern. Conference on Model-Driven Engineering and Software Development. Lisbon, Portugal, (pp. 472-479).
  16. Taktak S., Alshomrani S., Feki J., Zurfluh, G., 2015. An MDA Approach for the Evolution of Data Warehouses. Intern. Journal of Decision Support System Technology (IJDSST), 7(3) (pp. 65-89).
  17. Talwar, K., Gosain. A., 2012. Implementing schema evolution in data warehouse through complex hierarchy semantics. In the International Journal of Scientific and Engineering Research 3 (pp.917-922).
  18. Thakur, G., Gosain, A., 2011. DWEVOLVE: A Requirement Based Framework for DW Evolution. In SIGSOFT Softw. Eng. Notes 36, 6 (pp. 1-8).
  19. Wrembel, R., Bebel, B., 2007. Metadata Management in a Multiversion DW. In Journal on data semantics VIII (pp. 118-157). Springer Berlin Heidelberg.
Download


Paper Citation


in Harvard Style

Taktak S., Alshomrani S., Feki J. and Zurfluh G. (2017). The Power of a Model-Driven Approach to Handle Evolving Data Warehouse Requirements . In Proceedings of the 5th International Conference on Model-Driven Engineering and Software Development - Volume 1: MODELSWARD, ISBN 978-989-758-210-3, pages 169-181. DOI: 10.5220/0006209001690181


in Bibtex Style

@conference{modelsward17,
author={Said Taktak and Saleh Alshomrani and Jamel Feki and Gilles Zurfluh},
title={The Power of a Model-Driven Approach to Handle Evolving Data Warehouse Requirements},
booktitle={Proceedings of the 5th International Conference on Model-Driven Engineering and Software Development - Volume 1: MODELSWARD,},
year={2017},
pages={169-181},
publisher={SciTePress},
organization={INSTICC},
doi={10.5220/0006209001690181},
isbn={978-989-758-210-3},
}


in EndNote Style

TY - CONF
JO - Proceedings of the 5th International Conference on Model-Driven Engineering and Software Development - Volume 1: MODELSWARD,
TI - The Power of a Model-Driven Approach to Handle Evolving Data Warehouse Requirements
SN - 978-989-758-210-3
AU - Taktak S.
AU - Alshomrani S.
AU - Feki J.
AU - Zurfluh G.
PY - 2017
SP - 169
EP - 181
DO - 10.5220/0006209001690181