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.
Keywords
- Not Only SQL (NoSQL)
- NoSQL Systems
- Document-oriented Model
- Multidimensional Conceptual Model
- Data Warehouse
These keywords were added by machine and not by the authors. This process is experimental and the keywords may be updated as the learning algorithm improves.
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.
Buying options
Tax calculation will be finalised at checkout
Purchases are for personal use only
Learn about institutional subscriptionsNotes
- 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
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
Chaudhuri, S., Dayal, U.: An overview of data warehousing and OLAP technology. SIGMOD Rec. 26, 65–74 (1997)
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
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)
Colliat, G.: Olap, relational, and multidimensional database systems. SIGMOD Rec. 25(3), 64–69 (1996)
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)
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)
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)
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)
Kimball, R., Ross, M.: The Data Warehouse Toolkit: The Complete Guide to Dimensional Modeling, 2nd edn. Wiley, New York (2002)
Mior, M.J.: Automated schema design for NoSQL databases. In: SigMOD (2014)
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)
Ravat, F., Teste, O., Tournier, R., Zuruh, G.: Algebraic and graphic languages for OLAP manipulations. IJDWM 4(1), 17–46 (2008)
Stonebraker, M.: New opportunities for new SQL. Commun. ACM 55(11), 10–11 (2012). http://doi.acm.org/10.1145/2366316.2366319
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)
Author information
Authors and Affiliations
Corresponding author
Editor information
Editors and Affiliations
Rights 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)