Skip to main content
SpringerLink
Log in

Implementation of Multidimensional Databases with Document-Oriented NoSQL

  • Conference paper
  • First Online:
Big Data Analytics and Knowledge Discovery (DaWaK 2015)

Part of the book series: Lecture Notes in Computer Science ((LNISA,volume 9263))

Included in the following conference series:

Abstract

NoSQL (Not Only SQL) systems are becoming popular due to known advantages such as horizontal scalability and elasticity. In this paper, we study the implementation of data warehouses with document-oriented NoSQL systems. We propose mapping rules that transform the multidimensional data model to logical document-oriented models. We consider three different logical translations and we use them to instantiate multidimensional data warehouses. We focus on data loading, model-to-model conversion and cuboid computation.

M. El Malki—This study is supported by the ANRT funding under CIFRE-Capgemini partnership.

This is a preview of subscription content, log in via an institution to check access.

Access this chapter

Log in via an institution
Chapter
USD 29.95
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
eBook
USD 39.99
Price excludes VAT (USA)
  • Available as EPUB and PDF
  • Read on any device
  • Instant download
  • Own it forever
Softcover Book
USD 54.99
Price excludes VAT (USA)
  • Compact, lightweight edition
  • Dispatched in 3 to 5 business days
  • Free shipping worldwide - see info

Tax calculation will be finalised at checkout

Purchases are for personal use only

Institutional subscriptions

Notes

  1. 1.

    The conceptual level consists in describing the data in a generic way regardless the information technologies whereas the logical level consists in using a specific technique for implementing the conceptual level.

References

  1. Bosworth, A., Gray, J., Layman, A., Pirahesh, H.: Data cube: A relational aggregation operator generalizing group-by, cross-tab, and sub-totals. Technical report MSRTR-95-22, Microsoft Research, February 1995

    Google Scholar 

  2. Chaudhuri, S., Dayal, U.: An overview of data warehousing and OLAP technology. SIGMOD Rec. 26, 65–74 (1997)

    Article  Google Scholar 

  3. Chevalier, M., malki, M.E., Kopliku, A., Teste, O., Tournier, R.: Implementing multidimensional data warehouses into NoSQL. In: 17th International Conference on Entreprise Information Systems, April 2015

    Google Scholar 

  4. Chevalier, M., El Malki, M., Kupliku, A., Teste, O., Tournier, R.: Benchmark for OLAP on NoSQL technologies, comparing NoSQL multidimensional data warehousing solutions. In: 9th International Conference on Research Challenges in Information Science (RCIS). IEEE (2015)

    Google Scholar 

  5. Colliat, G.: Olap, relational, and multidimensional database systems. SIGMOD Rec. 25(3), 64–69 (1996)

    Article  Google Scholar 

  6. Cuzzocrea, A., Song, I.Y., Davis, K.C.: Analytics over large-scale multidimensional data: The big data revolution!. In: 14th International Workshop on Data Warehousing and OLAP DOLAP 2011, pp. 101–104. ACM (2011)

    Google Scholar 

  7. Dede, E., Govindaraju, M., Gunter, D., Canon, R.S., Ramakrishnan, L.: Performance evaluation of a MongoDB and hadoop platform for scientific data analysis. In: 4th ACM Workshop on Scientific Cloud Computing Science Cloud 2013, pp.13–20. ACM (2013)

    Google Scholar 

  8. Dehdouh, K., Boussaid, O., Bentayeb, F.: Columnar NoSQL star schema benchmark. In: Ait Ameur, Y., Bellatreche, L., Papadopoulos, G.A. (eds.) MEDI 2014. LNCS, vol. 8748, pp. 281–288. Springer, Heidelberg (2014)

    Google Scholar 

  9. Golfarelli, M., Maio, D., Rizzi, S.: The dimensional fact model: A conceptual model for data warehouses. Int. J. Coop. Inf. Syst. 7, 215–247 (1998)

    Article  Google Scholar 

  10. Kimball, R., Ross, M.: The Data Warehouse Toolkit: The Complete Guide to Dimensional Modeling, 2nd edn. Wiley, New York (2002)

    Google Scholar 

  11. Mior, M.J.: Automated schema design for NoSQL databases. In: SigMOD (2014)

    Google Scholar 

  12. O’Neil, P., O’Neil, E., Chen, X., Revilak, S.: The star schema benchmark and augmented fact table indexing. In: Nambiar, R., Poess, M. (eds.) TPCTC 2009. LNCS, vol. 5895, pp. 237–252. Springer, Heidelberg (2009)

    Google Scholar 

  13. Ravat, F., Teste, O., Tournier, R., Zuruh, G.: Algebraic and graphic languages for OLAP manipulations. IJDWM 4(1), 17–46 (2008)

    Google Scholar 

  14. Stonebraker, M.: New opportunities for new SQL. Commun. ACM 55(11), 10–11 (2012). http://doi.acm.org/10.1145/2366316.2366319

    Article  Google Scholar 

  15. Zhao, H., Ye, X.: A practice of TPC-DS multidimensional implementation on NoSQL database systems. In: Nambiar, R., Poess, M. (eds.) TPCTC 2013. LNCS, vol. 8391, pp. 93–108. Springer, Heidelberg (2014)

    Chapter  Google Scholar 

Download references

Author information

Authors and Affiliations

  1. IRIT 5505, Université de Toulouse, 118 Route de Narbonne, 31062, Toulouse, France

    M. Chevalier, M. El Malki, A. Kopliku, O. Teste & R. Tournier

Authors
  1. M. Chevalier
    View author publications

    You can also search for this author in PubMed Google Scholar

  2. M. El Malki
    View author publications

    You can also search for this author in PubMed Google Scholar

  3. A. Kopliku
    View author publications

    You can also search for this author in PubMed Google Scholar

  4. O. Teste
    View author publications

    You can also search for this author in PubMed Google Scholar

  5. R. Tournier
    View author publications

    You can also search for this author in PubMed Google Scholar

Corresponding author

Correspondence to M. El Malki .

Editor information

Editors and Affiliations

  1. University of Science and Technology, Rolla, Missouri, USA

    Sanjay Madria

  2. Osaka University, Osaka, Japan

    Takahiro Hara

Rights and permissions

Reprints and permissions

Copyright information

© 2015 Springer International Publishing Switzerland

About this paper

Cite this paper

Chevalier, M., El Malki, M., Kopliku, A., Teste, O., Tournier, R. (2015). Implementation of Multidimensional Databases with Document-Oriented NoSQL. In: Madria, S., Hara, T. (eds) Big Data Analytics and Knowledge Discovery. DaWaK 2015. Lecture Notes in Computer Science(), vol 9263. Springer, Cham. https://doi.org/10.1007/978-3-319-22729-0_29

Download citation

  • DOI: https://doi.org/10.1007/978-3-319-22729-0_29

  • Published:

  • Publisher Name: Springer, Cham

  • Print ISBN: 978-3-319-22728-3

  • Online ISBN: 978-3-319-22729-0

  • eBook Packages: Computer ScienceComputer Science (R0)

Publish with us

Policies and ethics

Search

Navigation