Abstract: The expansion of data has prompted the creation of various NoSQL (Not only SQL) databases, including graph-oriented databases, which provide an understandable abstraction for modeling complex domains and managing highly connected data. However, to add graph data to existing decision support systems, new data warehouse systems that consider the special characteristics of graphs need to be developed. This work proposes a novel method for creating a data warehouse under a graph database and demonstrates how OLAP (Online Analytical Processing) structures created for reporting can be handled by graph databases. Additionally, the paper suggests using aggregation algorithms based association rules techniques to improve the efficiency of reporting and data analysis within a graph-based data warehouse. Finally, we provide a Cypher language implementation of the suggested approach to evaluate and validate our approach.

Redouane LABZIOUI, Khadija LETRACHE and Mohammed RAMDANI, “New Approach based on Association Rules for Building and Optimizing OLAP Cubes on Graphs” International Journal of Advanced Computer Science and Applications(IJACSA), 14(7), 2023. http://dx.doi.org/10.14569/IJACSA.2023.01407108

@article{LABZIOUI2023,
title = {New Approach based on Association Rules for Building and Optimizing OLAP Cubes on Graphs},
journal = {International Journal of Advanced Computer Science and Applications},
doi = {10.14569/IJACSA.2023.01407108},
url = {http://dx.doi.org/10.14569/IJACSA.2023.01407108},
year = {2023},
publisher = {The Science and Information Organization},
volume = {14},
number = {7},
author = {Redouane LABZIOUI and Khadija LETRACHE and Mohammed RAMDANI}
}