NOSOLAP: Moving from Data Warehouse Requirements to NoSQL Databases

Deepika Prakash

Abstract

Typical data warehouse systems are implemented either on a relational database or on a multi-dimensional database. While the former supports ROLAP operations the latter supports MOLAP. We explore a third alternative, that is, to implement a data warehouse on a NoSQL database. For this, we propose rules that help us move from information obtained from data warehouse requirements engineering stage to the logical model of NoSQL databases, giving rise to NOSOLAP (NOSql OLAP). We show the advantages of NOSOLAP over ROLAP and MOLAP. We illustrate our NOSOLAP approach by converting to the logical model of Cassandra and give an example.

Download


Paper Citation


in Harvard Style

Prakash D. (2019). NOSOLAP: Moving from Data Warehouse Requirements to NoSQL Databases.In Proceedings of the 14th International Conference on Evaluation of Novel Approaches to Software Engineering - Volume 1: ENASE, ISBN 978-989-758-375-9, pages 452-458. DOI: 10.5220/0007748304520458


in Bibtex Style

@conference{enase19,
author={Deepika Prakash},
title={NOSOLAP: Moving from Data Warehouse Requirements to NoSQL Databases},
booktitle={Proceedings of the 14th International Conference on Evaluation of Novel Approaches to Software Engineering - Volume 1: ENASE,},
year={2019},
pages={452-458},
publisher={SciTePress},
organization={INSTICC},
doi={10.5220/0007748304520458},
isbn={978-989-758-375-9},
}


in EndNote Style

TY - CONF

JO - Proceedings of the 14th International Conference on Evaluation of Novel Approaches to Software Engineering - Volume 1: ENASE,
TI - NOSOLAP: Moving from Data Warehouse Requirements to NoSQL Databases
SN - 978-989-758-375-9
AU - Prakash D.
PY - 2019
SP - 452
EP - 458
DO - 10.5220/0007748304520458