Abstract
Data Warehouse (DW) evolution is becoming a critical research topic for several organizations mainly because their analytical data change permanently and rapidly due to changes in the data source and decision-makers’ requirements. This paper presents an MDA-compliant (Model Driven Architecture) approach and a software tool for propagating automatically the evolutions of the data source model and OLAP (On-Line Analytical Processing) requirements towards the multidimensional DW model. More accurately, we propose a DWE (Data Warehouse Evolution) framework. Being MDA compliant, we perform this DW evolution through Model-To-Model transformation rules we have defined as QVT (Query/View/Transformation) along with M2T (Model-To-Text) transformations realized using Acceleo templates. Thus, the evolution operations (Create table, Add column…) are firstly modeled, secondly transformed into multidimensional evolution operations (Create dimension, hierarchy…), and then are used with Acceleo templates for generating the DW alteration code.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
References
Kimball, R., Ross, M.: The Data Warehouse Toolkit, 2nd edn. Wiley, New York (2002)
Golfarelli, M., Rizzi, S., Vrdoljak, B.: Data warehouse design from XML sources. In: Proceedings of ACM International Workshop on Data Warehousing and OLAP (DOLAP 2001), Atlanta, GA, USA, pp. 40–47 (2001)
Rusu, L.I., Rahayu, W., Taniar, D.: A methodology for building XML DW. Int. J. Data Warehous. Min. 1(2), 67–92 (2005)
Nabli, A., Soussi, A., Feki, J., Ben Abdallah, H., Gargouri, F.: Towards an automatic data warehouse and data mart design. In: 7th International Conference on Enterprise Information Systems (ICEIS 2005), Miami, USA, pp. 226–231 (2005)
Rundensteiner, E.A., Nica, A., Lee, A.J.: On preserving views in evolving environments. In: The 4th International Workshop Knowledge Representation Meets Databases, pp. 131–141 (1997)
Bellahsene, Z.: Schema evolution in data warehouses. Knowl. Inf. Syst. 4(3), 283–304 (2002)
Thakur, G., Gosain, A.: A comprehensive analysis of materialized views in a data warehouse environment. Int. J. Adv. Comput. Sci. Appl. (IJACSA) 2(5), 76–82 (2011)
Papastefanatos, G., Vassiliadis, P., Simitsis, A., Sellis, T., Vassiliou, Y.: Rule-based management of schema changes at ETL sources. In: Grundspenkis, J., Kirikova, M., Manolopoulos, Y., Novickis, L. (eds.) ADBIS 2009. LNCS, vol. 5968, pp. 55–62. Springer, Heidelberg (2010). https://doi.org/10.1007/978-3-642-12082-4_8
El Akkaoui, Z., Zimànyi, E., Mazón, J.N., Trujillo. J.: A model-driven framework for ETL process development. In: Proceedings of the ACM 14th International Workshop on Data Warehousing and OLAP (DOLAP 2011), New York, USA, pp. 45–52 (2011)
Wrembel, R., Bębel, B.: Metadata management in a multiversion data warehouse. In: Spaccapietra, S., et al. (eds.) Journal on Data Semantics VIII. LNCS, vol. 4380, pp. 118–157. Springer, Heidelberg (2007). https://doi.org/10.1007/978-3-540-70664-9_5
Favre, C., Bentayeb, F., Boussaid, O.: Dimension hierarchies updates in data warehouses: a user-driven approach. In: 9th International Conference on Enterprise Information Systems (ICEIS 2007), Madeira, Portugal, pp. 206–211 (2007)
Thakur, G., Gosain, A.: DWEVOLVE: a requirement based framework for DW evolution. SIGSOFT Softw. Eng. Notes 36(6), 1–8 (2011)
Solodovnikova, D., Niedrite, L., Kozmina, N.: Handling evolving data warehouse requirements. In: Morzy, T., Valduriez, P., Bellatreche, L. (eds.) ADBIS 2015. CCIS, vol. 539, pp. 334–345. Springer, Cham (2015). https://doi.org/10.1007/978-3-319-23201-0_35
Object Management Group (OMG): Model Driven Architecture (MDA) (2004)
Taktak, S., Feki, J., Zurfluh, G.: Toward evolution models for data warehouses. In: 2nd International Conference on Model-Driven Engineering and Software Development (MODELSWARD 2014), Lisbon, Portugal, pp. 472–479 (2014)
Bellatreche, L., Wrembel, R.: Evolution and versioning in semantic data integration systems. J. Data Semant. 2, 57–59 (2013)
Taktak S., Alshomrani S., Feki J., Zurfluh G.: 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 (MODELSWARD 2017), pp. 169–181 (2017). ISBN 978-989-758-210-3
Hachaichi, Y., Feki, J., Ben-Abdallah, H.: Designing data marts from XML and relational data sources. In: Design and Advanced Engineering Applications: Methods for Complex Construction. Advances in Data Warehousing and Mining Series, pp. 55–80. IGI Global (2009). Bellatreche Edition
Taktak, S., Alshomrani, S., Feki, J., Zurfluh, G.: An MDA approach for the evolution of data warehouses. Int. J. Decis. Support Syst. Technol. (IJDSST) 7(3), 65–89 (2015)
Golfarelli, M., Maio, D., Rizzi, S.: The dimensional fact model: a conceptual model for data warehouses. Int. J. Coop. Inf. Syst. 7(2–3), 215–247 (1998)
Hachaichi, Y., Feki, J.: An automatic method for the design of multidimensional schemas from object oriented databases. Int. J. Inf. Technol. Decis. Mak. 12(06), 1223–1259 (2013)
Object Management Group (OMG): MOF Model to Text Transformation Language, v1.0 (2008). http://www.omg.org/spec/MOFM2T/1.0/
Author information
Authors and Affiliations
Corresponding author
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 2018 Springer International Publishing AG, part of Springer Nature
About this paper
Cite this paper
Taktak, S., Feki, J., Altalhi, A., Zurfluh, G. (2018). Model-Driven Approach to Handle Evolutions of OLAP Requirements and Data Source Model. In: Pires, L., Hammoudi, S., Selic, B. (eds) Model-Driven Engineering and Software Development. MODELSWARD 2017. Communications in Computer and Information Science, vol 880. Springer, Cham. https://doi.org/10.1007/978-3-319-94764-8_17
Download citation
DOI: https://doi.org/10.1007/978-3-319-94764-8_17
Published:
Publisher Name: Springer, Cham
Print ISBN: 978-3-319-94763-1
Online ISBN: 978-3-319-94764-8
eBook Packages: Computer ScienceComputer Science (R0)