Abstract
Big volumes of data cannot be processed by traditional warehouses and OLAP servers which are based on RDBMS solutions. As an alternative solution, Not only SQL (NoSQL) databases are becoming increasingly popular as they have interesting strengths such as scalability and flexibility for an OLAP system. As NoSQL database offer great flexibility, they can improve the classic solution based on data warehouses (DW). In the recent years, many web applications are moving towards the use of data in the form of graphs. For example, social media and the emergence of Facebook, LinkedIn and Twitter have accelerated the emergence of the NoSQL database and in particular graph-oriented databases that represent the basic format with which data in these media is stored. Based on these findings and in addition to the absence of a clear approach which allows the implementation of data warehouse under NoSQL model, we propose, in this paper, new rules for transforming a multidimensional conceptual model into NoSQL graph-oriented model.
This is a preview of subscription content, log in via an institution.
Buying options
Tax calculation will be finalised at checkout
Purchases are for personal use only
Learn about institutional subscriptionsReferences
Abdelhedi, F., Ait Brahim, A., Atigui, F., Zurfluh, G.: Processus de transformation mda d’un schéma conceptuel de données en un schéma logique NoSQL. INFORSID (actes électroniques) (2016)
Sellami, A., Ahlem Nabli, F.G.: Entrepôt de données nosql orienté graphe:règles de modélisation. In: ASD: Big data & Applications. ASD (2018)
Bouhali, R., Laurent, A.: Exploiting RDF open data using NoSQL graph databases. In: IFIP International Conference on Artificial Intelligence Applications and Innovations, pp. 177–190. Springer (2015)
Castelltort, A., Laurent, A.: NoSQL graph-based OLAP analysis. In: KDIR (2014)
Chevalier, M., El Malki, M., Kopliku, A., Teste, O., Tournier, R.: Implementing multidimensional data warehouses into NoSQL. In: 17th International Conference on Enterprise Information Systems, vol. DISI (2015)
Chevalier, M., El Malki, M., Kopliku, A., Teste, O., Tournier, R.: Implementation of multidimensional databases in column-oriented NoSQL systems. In: East European Conference on Advances in Databases and Information Systems. Springer (2015)
Chevalier, M., El Malki, M., Kopliku, A., Teste, O., Tournier, R.: Entrepôts de données orientés documents: cuboïdes étendus. Document numérique 20(1) (2017)
Dehdouh, K., Bentayeb, F., Boussaid, O., Kabachi, N.: Using the column oriented NoSQL model for implementing big data warehouses. In: Proceedings of PDPTAs (2015)
Dehdouh, K., Boussaid, O., Bentayeb, F.: Columnar NoSQL star schema benchmark. In: International Conference on Model and Data Engineering. Springer (2014)
El Malki, M., Hamadou, H.B., Chevalier, M., Péninou, A., Teste, O.: Querying heterogeneous data in graph-oriented NoSQL systems. In: International Conference on Big Data Analytics and Knowledge Discovery, pp. 289–301. Springer (2018)
Nabli, A., Feki, J., Gargouri, F.: Automatic construction of multidimensional schema from OLAP requirements. In: AICCSA, p. 28. IEEE (2005)
Scabora, L.C., Brito, J.J., Ciferri, R.R., Ciferri, C.D.d.A., et al.: Physical data warehouse design on NoSQL databases OLAP query processing over hbase. In: International Conference on Enterprise Information Systems, vol. XVIII (2016)
Van Erven, G., Silva, W., Carvalho, R., Holanda, M.: Graphed: a graph description diagram for graph databases. In: World Conference on Information Systems and Technologies. Springer (2018)
Yangui, R., Nabli, A., Gargouri, F.: Automatic transformation of data warehouse schema to nosql data base: comparative study. Procedia 96, 255–264 (2016)
Author information
Authors and Affiliations
Corresponding author
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 2020 Springer Nature Switzerland AG
About this paper
Cite this paper
Sellami, A., Nabli, A., Gargouri, F. (2020). Transformation of Data Warehouse Schema to NoSQL Graph Data Base. In: Abraham, A., Cherukuri, A., Melin, P., Gandhi, N. (eds) Intelligent Systems Design and Applications. ISDA 2018 2018. Advances in Intelligent Systems and Computing, vol 941. Springer, Cham. https://doi.org/10.1007/978-3-030-16660-1_41
Download citation
DOI: https://doi.org/10.1007/978-3-030-16660-1_41
Published:
Publisher Name: Springer, Cham
Print ISBN: 978-3-030-16659-5
Online ISBN: 978-3-030-16660-1
eBook Packages: Intelligent Technologies and RoboticsIntelligent Technologies and Robotics (R0)