NOSQL Design for Analytical Workloads: Variability Matters

Conference paper

DOI: 10.1007/978-3-319-46397-1_4

Part of the Lecture Notes in Computer Science book series (LNCS, volume 9974)
Cite this paper as:
Herrero V., Abelló A., Romero O. (2016) NOSQL Design for Analytical Workloads: Variability Matters. In: Comyn-Wattiau I., Tanaka K., Song IY., Yamamoto S., Saeki M. (eds) Conceptual Modeling. ER 2016. Lecture Notes in Computer Science, vol 9974. Springer, Cham

Abstract

Big Data has recently gained popularity and has strongly questioned relational databases as universal storage systems, especially in the presence of analytical workloads. As result, co-relational alternatives, commonly known as NOSQL (Not Only SQL) databases, are extensively used for Big Data. As the primary focus of NOSQL is on performance, NOSQL databases are directly designed at the physical level, and consequently the resulting schema is tailored to the dataset and access patterns of the problem in hand. However, we believe that NOSQL design can also benefit from traditional design approaches. In this paper we present a method to design databases for analytical workloads. Starting from the conceptual model and adopting the classical 3-phase design used for relational databases, we propose a novel design method considering the new features brought by NOSQL and encompassing relational and co-relational design altogether.

Keywords

NOSQL DW Big data Relational Co-relational Database design 

Copyright information

© Springer International Publishing AG 2016

Authors and Affiliations

  1. 1.Universitat Politècnica de Catalunya - BarcelonaTechBarcelonaSpain

Personalised recommendations