Transformation of Data Warehouse Schema to NoSQL Graph Data Base

  • Amal SellamiEmail author
  • Ahlem Nabli
  • Faiez Gargouri
Conference paper
Part of the Advances in Intelligent Systems and Computing book series (AISC, volume 941)


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.


NoSQL Graph-oriented databases Data warehouse 


  1. 1.
    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)Google Scholar
  2. 2.
    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)Google Scholar
  3. 3.
    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)Google Scholar
  4. 4.
    Castelltort, A., Laurent, A.: NoSQL graph-based OLAP analysis. In: KDIR (2014)Google Scholar
  5. 5.
    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)Google Scholar
  6. 6.
    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)Google Scholar
  7. 7.
    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)Google Scholar
  8. 8.
    Dehdouh, K., Bentayeb, F., Boussaid, O., Kabachi, N.: Using the column oriented NoSQL model for implementing big data warehouses. In: Proceedings of PDPTAs (2015)Google Scholar
  9. 9.
    Dehdouh, K., Boussaid, O., Bentayeb, F.: Columnar NoSQL star schema benchmark. In: International Conference on Model and Data Engineering. Springer (2014)Google Scholar
  10. 10.
    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)Google Scholar
  11. 11.
    Nabli, A., Feki, J., Gargouri, F.: Automatic construction of multidimensional schema from OLAP requirements. In: AICCSA, p. 28. IEEE (2005)Google Scholar
  12. 12.
    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)Google Scholar
  13. 13.
    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)Google Scholar
  14. 14.
    Yangui, R., Nabli, A., Gargouri, F.: Automatic transformation of data warehouse schema to nosql data base: comparative study. Procedia 96, 255–264 (2016)Google Scholar

Copyright information

© Springer Nature Switzerland AG 2020

Authors and Affiliations

  1. 1.MIRACL LaboratoryUniversity of SfaxSfaxTunisia
  2. 2.Al-Baha UniversityAl BahahKingdom of Saudi Arabia

Personalised recommendations