Abstract
Column-oriented database systems offer decision-makers the most appropriate model for data warehouse storage. However, in the absence of on-line analytical operators, the only, very costly, way of constructing OLAP cubes involves using the UNION operator for group by queries in order to obtain all the Group By required to compute the OLAP cube. To solve this problem, in this article we propose a new aggregation operator, called C-CUBE (Columnar-CUBE), which allows data cubes to be computed using column-oriented data warehouses. We implemented the C-CUBE operator within the column-oriented DBMS, MonetDB and conducted experiments on the benchmark SSBM (Star Schema Benchmark). Thus we have shown that C-CUBE has OLAP cubes computation times reduced by up to 60% compared with the SQL Server CUBE operator in a 1TB warehouse.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Preview
Unable to display preview. Download preview PDF.
References
Abadi, D.J., Madden, S.R., Hachem, N.: Column-stores vs. row-stores: how different are they really? In: International Conference on Management of Data, pp. 967–980 (2008)
Matei, G.: Column-Oriented Databases, an Alternative for Analytical Environment. Database Systems Journal, 3–16 (2010)
Inmon, W.H.: Building the Data Warehouse. Information Sciences, Inc., Wellesley (1992)
Stonebraker, V., Abadi, D.J., Batkin, A., Chen, X., Cherniack, M., Ferreira, M., Lau, E., Lin, V., Madden, S., O’Neil, E., O’Neil, P., Rasin, A., Tran, N., Zdonik, S.: C-store: a column-oriented DBMS. In: Proceedings of the 31st International Conference on Very Large Data Bases, pp. 553–564 (2005)
O’Neil, P., O’Neil, B., Chen, X.: The Star Schema Benchmark, SSB (2009), http://www.cs.umb.edu/~poneil/StarSchemaB.PDF
Batory, D.S.: On searching transposed files, Association for Computing Machinery, pp. 531–544 (1979)
Copeland, G.P., Khoshafian, S.N.: A decomposition storage model. Special Interest Group on Management of Data Record, 268–279 (1985)
Abadi, D.J., Myers, D.S., Dewitt, D.J., Madden, S.: Materialization strategies in a column oriented. In: International Conference on Data Engineering, pp. 466–475 (2007)
Abadi, D.J., Madden, S., Ferreira, M.: Integrating compression and execution in column-oriented database systems. In: Special Interest Group on Management of Data Conference, pp. 671–682 (2006)
Gray, J., Chaudhuri, S., Bosworth, A., Layman, A., Reichart, D., Venkatrao, M., Pellow, F., Pirahesh, H.: Data cube: A relational aggregation operator generalizing group-by, cross-tab, and sub total. Journal of Data Mining and Knowledge Discovery 29–53 (1997)
Rafanelli, M.: Operators for Multidimensional Aggregate Data, Multidimensional Databases: Problems and Solutions, pp. 116–165. IGI Publishing Group (2003)
Idreos, V., Groffen, F., Nes, V., Manegold, S., Mullender, K., Sjoerd, K., Kersten, V.: MonetDB: Two Decades of Research in Column-oriented Database Architectures. Journal IEEE Data Engineering Bull., 40–45 (2012)
Jerzy, D.: Business Intelligence and NoSQL Databases. Information Systems in Management, 25–37 (2012)
Oracle 11g, http://www.oracle.com
SQL Server 2008 R2, http://www.microsoft.com
DBGEN: Data generator, https://github.com/electrum/ssb-dbgen
Author information
Authors and Affiliations
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 2014 Springer International Publishing Switzerland
About this paper
Cite this paper
Dehdouh, K., Bentayeb, F., Boussaid, O., Kabachi, N. (2014). Towards an OLAP Environment for Column-Oriented Data Warehouses. In: Bellatreche, L., Mohania, M.K. (eds) Data Warehousing and Knowledge Discovery. DaWaK 2014. Lecture Notes in Computer Science, vol 8646. Springer, Cham. https://doi.org/10.1007/978-3-319-10160-6_20
Download citation
DOI: https://doi.org/10.1007/978-3-319-10160-6_20
Publisher Name: Springer, Cham
Print ISBN: 978-3-319-10159-0
Online ISBN: 978-3-319-10160-6
eBook Packages: Computer ScienceComputer Science (R0)