Skip to main content
Top

2016 | OriginalPaper | Chapter

NOSQL Design for Analytical Workloads: Variability Matters

Authors : Victor Herrero, Alberto Abelló, Oscar Romero

Published in: Conceptual Modeling

Publisher: Springer International Publishing

Activate our intelligent search to find suitable subject content or patents.

search-config
loading …

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.

Dont have a licence yet? Then find out more about our products and how to get one now:

Springer Professional "Wirtschaft+Technik"

Online-Abonnement

Mit Springer Professional "Wirtschaft+Technik" erhalten Sie Zugriff auf:

  • über 102.000 Bücher
  • über 537 Zeitschriften

aus folgenden Fachgebieten:

  • Automobil + Motoren
  • Bauwesen + Immobilien
  • Business IT + Informatik
  • Elektrotechnik + Elektronik
  • Energie + Nachhaltigkeit
  • Finance + Banking
  • Management + Führung
  • Marketing + Vertrieb
  • Maschinenbau + Werkstoffe
  • Versicherung + Risiko

Jetzt Wissensvorsprung sichern!

Springer Professional "Technik"

Online-Abonnement

Mit Springer Professional "Technik" erhalten Sie Zugriff auf:

  • über 67.000 Bücher
  • über 390 Zeitschriften

aus folgenden Fachgebieten:

  • Automobil + Motoren
  • Bauwesen + Immobilien
  • Business IT + Informatik
  • Elektrotechnik + Elektronik
  • Energie + Nachhaltigkeit
  • Maschinenbau + Werkstoffe




 

Jetzt Wissensvorsprung sichern!

Springer Professional "Wirtschaft"

Online-Abonnement

Mit Springer Professional "Wirtschaft" erhalten Sie Zugriff auf:

  • über 67.000 Bücher
  • über 340 Zeitschriften

aus folgenden Fachgebieten:

  • Bauwesen + Immobilien
  • Business IT + Informatik
  • Finance + Banking
  • Management + Führung
  • Marketing + Vertrieb
  • Versicherung + Risiko




Jetzt Wissensvorsprung sichern!

Literature
1.
go back to reference Alagiannis, I., et al.: H2O: a hands-free adaptive store. In: SIGMOD (2014) Alagiannis, I., et al.: H2O: a hands-free adaptive store. In: SIGMOD (2014)
2.
go back to reference Ambler, S.: Agile Database Techniques: Effective Strategies for the Agile Software Developer. Wiley, New York (2003) Ambler, S.: Agile Database Techniques: Effective Strategies for the Agile Software Developer. Wiley, New York (2003)
3.
go back to reference Blaha, M.: On reverse engineering of vendor databases. In: WCRE (1998) Blaha, M.: On reverse engineering of vendor databases. In: WCRE (1998)
4.
go back to reference Blaha, M.: Patterns of Data Modeling. CRC Press, Inc., Boca Raton (2010) Blaha, M.: Patterns of Data Modeling. CRC Press, Inc., Boca Raton (2010)
5.
go back to reference Bondiombouy, C., Kolev, B., Levchenko, O., Valduriez, P.: Integrating big data and relational data with a functional SQL-like query language. In: Databaseand Expert Systems Applications - 26th International Conference, DEXA 2015, Valencia, Spain, 1–4 September 2015, Proceedings, Part I, pp. 170–185 (2015). http://dx.doi.org/10.1007/978-3-319-22849-5_13 Bondiombouy, C., Kolev, B., Levchenko, O., Valduriez, P.: Integrating big data and relational data with a functional SQL-like query language. In: Databaseand Expert Systems Applications - 26th International Conference, DEXA 2015, Valencia, Spain, 1–4 September 2015, Proceedings, Part I, pp. 170–185 (2015). http://​dx.​doi.​org/​10.​1007/​978-3-319-22849-5_​13
6.
go back to reference Bugiotti, F., Cabibbo, L., Atzeni, P., Torlone, R.: Database design for NoSQL systems. In: Yu, E., Dobbie, G., Jarke, M., Purao, S. (eds.) ER 2014. LNCS, vol. 8824, pp. 223–231. Springer, Heidelberg (2014). doi:10.1007/978-3-319-12206-9_18 Bugiotti, F., Cabibbo, L., Atzeni, P., Torlone, R.: Database design for NoSQL systems. In: Yu, E., Dobbie, G., Jarke, M., Purao, S. (eds.) ER 2014. LNCS, vol. 8824, pp. 223–231. Springer, Heidelberg (2014). doi:10.​1007/​978-3-319-12206-9_​18
7.
go back to reference Garcia, S., et al.: DSS from an RE perspective: a systematic mapping. J. Syst. Softw. 117, 488–507 (2016)CrossRef Garcia, S., et al.: DSS from an RE perspective: a systematic mapping. J. Syst. Softw. 117, 488–507 (2016)CrossRef
8.
go back to reference Garcia-Molina, H., et al.: Database Systems - The Complete Book. Pearson Education, Harlow (2009) Garcia-Molina, H., et al.: Database Systems - The Complete Book. Pearson Education, Harlow (2009)
10.
go back to reference Inmon, W.H., et al.: Corporate Information Factory. Wiley, New York (2001) Inmon, W.H., et al.: Corporate Information Factory. Wiley, New York (2001)
11.
go back to reference Jagadish, H.V., et al.: Big data and its technical challenges. Commun. ACM 57(7), 86–94 (2014)CrossRef Jagadish, H.V., et al.: Big data and its technical challenges. Commun. ACM 57(7), 86–94 (2014)CrossRef
12.
go back to reference Kimball, R.: The Data Warehouse Toolkit: Practical Techniques for Building Dimensional Data Warehouses. Wiley, New York (1996) Kimball, R.: The Data Warehouse Toolkit: Practical Techniques for Building Dimensional Data Warehouses. Wiley, New York (1996)
13.
go back to reference Mazón, J.-N., Trujillo, J., Lechtenbörger, J.: A set of QVT relations to assure the correctness of data warehouses by using multidimensional normal forms. In: Embley, D.W., Olivé, A., Ram, S. (eds.) ER 2006. LNCS, vol. 4215, pp. 385–398. Springer, Heidelberg (2006). doi:10.1007/11901181_29 CrossRef Mazón, J.-N., Trujillo, J., Lechtenbörger, J.: A set of QVT relations to assure the correctness of data warehouses by using multidimensional normal forms. In: Embley, D.W., Olivé, A., Ram, S. (eds.) ER 2006. LNCS, vol. 4215, pp. 385–398. Springer, Heidelberg (2006). doi:10.​1007/​11901181_​29 CrossRef
14.
go back to reference Meijer, E., Bierman, G.M.: A co-relational model of data for large shared data banks. Commun. ACM 54(4), 49–58 (2011)CrossRef Meijer, E., Bierman, G.M.: A co-relational model of data for large shared data banks. Commun. ACM 54(4), 49–58 (2011)CrossRef
16.
go back to reference Özsu, M.T., Valduriez, P.: Principles of Distributed DB Systems. Springer, New York (2011) Özsu, M.T., Valduriez, P.: Principles of Distributed DB Systems. Springer, New York (2011)
17.
go back to reference Romero, O., et al.: Tuning small analytics on big data: data partitioning and secondary indexes in the Hadoop ecosystem. Inf. Syst. 54, 336–356 (2015)CrossRef Romero, O., et al.: Tuning small analytics on big data: data partitioning and secondary indexes in the Hadoop ecosystem. Inf. Syst. 54, 336–356 (2015)CrossRef
18.
go back to reference Sadalage, P., Fowler, M.: NoSQL Distilled: A Brief Guide to the Emerging World of Polyglot Persistence. Addison-Wesley Professional, Upper Saddle River (2012) Sadalage, P., Fowler, M.: NoSQL Distilled: A Brief Guide to the Emerging World of Polyglot Persistence. Addison-Wesley Professional, Upper Saddle River (2012)
20.
go back to reference Stonebraker, M., et al.: C-store: a column-oriented DBMS. In: VLDB (2005) Stonebraker, M., et al.: C-store: a column-oriented DBMS. In: VLDB (2005)
22.
go back to reference Wiese, L.: Advanced Data Management for SQL, NoSQL, Cloud and Distributed Databases. DeGruyter, Boston (2015) Wiese, L.: Advanced Data Management for SQL, NoSQL, Cloud and Distributed Databases. DeGruyter, Boston (2015)
Metadata
Title
NOSQL Design for Analytical Workloads: Variability Matters
Authors
Victor Herrero
Alberto Abelló
Oscar Romero
Copyright Year
2016
DOI
https://doi.org/10.1007/978-3-319-46397-1_4

Premium Partner