Transformation of Data Warehouse Schema to NoSQL Graph Data Base

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.