ROLAP DW transformation proposal for OLAP architecture in NoSQL database
Rodrigo Fonseca, Marcio de Carvalho Victorino, Maristela Terto de Holanda · 2020
This paper aims to present a case study related to the migration of a ROLAP architecture Data Warehouse of the University of Brasilia to an OLAP architecture in the NoSQL DB family of columns. This migration starts from the need to study new paradigms of architectures for decision support systems due to the new reality of the problems generated by the use of Big Data in the present moment at the university. We made two approaches: the first one by migrating to the Cassandra DBMS and the second one by migrating to Apache Hive. State of the art was made from Web of Science and we used the TEMAC methodology. We made a transformation of integrating all dimensions and table of facts into a single table for both Cassandra and Hive and we made a comparison by running two queries from these tables. Besides that, we also made a qualitative analysis, addressing the advantages and disadvantages of each approach. In the end, we concluded that Apache Hive should be the best choice for the University of Brasilia.