Everything about OLAP cube

🧭 Start here: a 6-step reading path

1. Read the overview: OLAP cubeA 5-minute orientation
2. Skim a recent paper: Evolving OLAP and BI towards Complex, High-Performance Big-OLAP-Data-Cube-Processing Analytics Frameworks: How to Speed-Up Large-Scale, High-Dimensional Queries over CloudsInfluential work since 2022
3. Pick up a classic book: OlapThe most-reprinted book on the subject
4. Read the landmark paper: Enabling OLAP in mobile environments via intelligent data cube compression techniquesCited 60 times
5. Go sideways: Online analytical processingA closely related topic
6. Go sideways: Cubes (OLAP server)A closely related topic

🏆 Landmark papers (most cited)

• Enabling OLAP in mobile environments via intelligent data cube compression techniques

  Alfredo Cuzzocrea, Filippo Furfaro, Domenico Saccà · 2008 · Journal of Intelligent Information Systems · 60 citations

• Topic modeling for OLAP on multidimensional text databases: topic cube and its applications

  Duo Zhang, ChengXiang Zhai, Jiawei Han · 2009 · Statistical Analysis and Data Mining: The ASA Data Science Journal · 24 citations

• Building a novel physical design of a distributed big data warehouse over a Hadoop cluster to enhance OLAP cube query performance

  Yassine Ramdane, Omar Boussaid, Doulkifli Boukraà · 2022 · Parallel Computing · 19 citations

• A New Big Data Benchmark for OLAP Cube Design Using Data Pre-Aggregation Techniques

  Roberto Tardío, Alejandro Maté, Juan Trujillo · 2020 · Applied Sciences · 16 citations

• Compressed data cube for approximate OLAP query processing

  Yu Feng, Shan Wang · 2002 · Journal of Computer Science and Technology · 12 citations

• OLAP cube partitioning based on association rules method

  Khadija Letrache, Omar El Beggar, Mohammed Ramdani · 2018 · Applied Intelligence · 11 citations

• The hierarchical agglomerative clustering with Gower index: A methodology for automatic design of OLAP cube in ecological data processing context

  Lucile Sautot, Bruno Faivre, Ludovic Journaux · 2015 · Ecological Informatics · 11 citations

• A wavelet framework for adapting data cube views for OLAP

  J.R. Smith, Chung-Sheng Li, A. Jhingran · 2004 · IEEE Transactions on Knowledge and Data Engineering · 10 citations

🆕 Influential since 2022

• Evolving OLAP and BI towards Complex, High-Performance Big-OLAP-Data-Cube-Processing Analytics Frameworks: How to Speed-Up Large-Scale, High-Dimensional Queries over Clouds

  Alfredo Cuzzocrea · 2024 · Procedia Computer Science · 1 citations

• NoSQL-based approach in data warehousing and OLAP cube computation

  Abdelhak Khalil, Mustapha Belaissaoui · 2023 · International Journal of Information and Decision Sciences · 0 citations

• NoSQL-based approach in data warehousing and OLAP cube computation

  Mustapha Belaissaoui, Abdelhak Khalil · 2023 · International Journal of Information and Decision Sciences · 0 citations

📚 Books worth reading

• 📕OlapBooks Llc · 2010
• 📕Olap Without Cubes - Data Analysis in Non-Cube SystemsSascha Mendack · 2008
• 📕DB2 Cube ViewsIBM Redbooks · 2003
• Expert cube development with Microsoft SQL Server 2008 Analysis ServicesChris Webb · 2009
• 📕SAS business intelligence for the health care industryRenu Gehring · 2013
• Data warehousing and knowledge discoveryDaWaK 2009 (2009 Linz, Austria) · 2009
• Multidimensional databases and data warehousingChristian S. Jensen · 2010

Ranked by number of editions on Open Library, a rough measure of how lasting a book is.

🔗 Related topics

• Online analytical processing In computing, online analytical processing (OLAP) (/ˈoʊlæp/), is an approach to quickly answer multi-dimensional analytical (MDA) queries. The term OLAP…
• Cubes (OLAP server) Cubes is a light-weight open source multidimensional modelling and OLAP toolkit for development reporting applications and browsing of aggregated data…
• Functional database model The functional database model is used to support analytics applications such as financial planning and performance management. The functional database…
• Data cube In computer programming, a data cube (or datacube) is a multi-dimensional array of values. Typically, the term "data cube" is applied in contexts where…
• Aggregate function In database management, an aggregate function or aggregation function is a function where multiple values are processed together to form a single summary…
• Essbase Essbase is a multidimensional database management system (MDBMS). The platform provides tools to build data analytic applications. Arbor Software developed…
• MultiDimensional eXpressions Multidimensional Expressions (MDX) is a query language for online analytical processing (OLAP) using a database management system. Much like SQL, it is…
• Microsoft Analysis Services Microsoft SQL Server Analysis Services (SSAS) is an online analytical processing (OLAP) and data mining tool in Microsoft SQL Server. SSAS is used as a…