New approach for implementing big datamart using NoSQL key-value stores

Nowadays, NoSQL technologies are gaining significant ground and considered as the future of data storage, especially when it comes to huge amount of data, which is the case of data warehouse solutions. NoSQL databases provide high scalability and good performance among relational ones, which are really time consuming and can’t handle large data volume. The growing popularity of the term NoSQL these days and vaguely related phrases like big data make us think about using this technology in decision support systems. The purpose of this paper is to investigate the possibility to instantiate a big data mart under one of the most popular and least complicated types of NoSQL databases; namely key-value store, the main challenge is to make a good correlation between the old-school approach of data warehousing based on traditional databases that favor data integrity, and interesting opportunities offered by new generation of database management systems. The paper describes the transformation process from multidimensional conceptual schema to the logical model following three approaches, and outlines a list of strengths and weaknesses for each one based on practical experience under Oracle NoSQL Database.