Bridging the Gap between OLAP and SQL
Summary: Diagnoses why OLAP engines duplicate DBMS functionality despite advances in SQL, citing limitations of SQL, the relational model, and client/server architectures. Uses the BTell OLAP engine to illustrate tighter DBMS–OLAP integration and future extensions. (summarized by gpt-5.6-luna on Jul 24 2026)
Incoming Non-self Citations Over Time
No non-self incoming citations found for this paper in this database.
Authors
- 1. Jens-Peter Dittrich (ETH Zurich; SAP)
- 2. Donald Kossmann (ETH Zurich; i-TV-T AG)
- 3. Alexander Kreutz (i-TV-T AG)
BibTeX Citation
@article{dittrich_vldb05,
title = {{Bridging the Gap between OLAP and SQL}},
author = {Dittrich, Jens-Peter and Kossmann, Donald and Kreutz, Alexander},
journal = {PVLDB},
series = {{VLDB} '05},
year = {2005}
}Incoming Citations (Sorted by Pagerank)
Showing 3 of 3 citing papers.
| Rank | Citing Paper | Year | Venue | Pagerank |
|---|---|---|---|---|
| 6,541 | A Dataspace Odyssey: The iMeMex Personal Dataspace Management System | 2007 | CIDR | 5.8471331e-05 |
| 9,183 | Extending SQL to Return a Subdatabase | 2025 | SIGMOD | 5.3058708e-05 |
| 12,603 | Dwarfs in the Rearview Mirror: How Big are they Really? | 2008 | VLDB | 5.093636e-05 |
Previous
Page 1 / 1
Next
Outgoing Citations (Sorted by Pagerank)
Showing 10 of 10 cited papers.
Citations counted here include only citations to other VLDB/SIGMOD/CIDR/PODS papers in this database.
| Rank | Cited Paper | Year | Venue | Pagerank |
|---|---|---|---|---|
| 608 | "One Size Fits All" Database Architectures Do Not Work For DSS | 1995 | SIGMOD | 0.00015795625 |
| 932 | Buffering Database Operations for Enhanced Instruction Cache Performance | 2004 | SIGMOD | 0.00013119305 |
| 970 | Sybase IQ Multiplex – Designed For Analytics | 2004 | VLDB | 0.00012882125 |
| 1,687 | Spreadsheets in RDBMS for OLAP | 2003 | SIGMOD | 0.00010005718 |
| 1,691 | PIVOT and UNPIVOT: Optimization and Execution Strategies in an RDBMS | 2004 | VLDB | 9.9999141e-05 |
| 1,759 | Rank-aware Query Optimization | 2004 | SIGMOD | 9.8160244e-05 |
| 2,211 | Relational link-based ranking | 2004 | VLDB | 8.9422791e-05 |
| 3,069 | Extending XQuery for Analytics | 2005 | SIGMOD | 7.7900555e-05 |
| 5,892 | OLAP Dimension Constraints | 2002 | PODS | 6.0488431e-05 |
| 12,956 | Database Performance in the Real World — TPC-D and SAP R/3 — | 1997 | SIGMOD | 5.093636e-05 |
Previous
Page 1 / 1
Next
Semantically Similar Papers
| # | Overall Rank | Paper | Year | Venue |
|---|---|---|---|---|
| 1 | 8,072 | Operational Analytics Data Management Systems | 2016 | VLDB |
| 2 | 7,991 | Micro-architectural Analysis of OLAP: Limitations and Opportunities | 2020 | VLDB |
| 3 | 3,753 | High-Dimensional OLAP: A Minimal Cubing Approach | 2004 | VLDB |
| 4 | 4,166 | A Foundation for Multi-Dimensional Databases | 1997 | VLDB |
| 5 | 14,045 | Collaborative Analytical Processing — Dream or Reality | 2001 | VLDB |
| 6 | 12,597 | When is it Time to Rethink the Aggregate Configuration of Your OLAP Server? | 2008 | VLDB |
| 7 | 3,079 | Data Warehousing and OLAP for Decision Support | 1997 | SIGMOD |
| 8 | 966 | A Common Database Approach for OLTP and OLAP Using an In-Memory Column Database | 2009 | SIGMOD |
| 9 | 2,882 | OLAP and Statistical Databases: Similarities and Differences | 1997 | PODS |
| 10 | 1,687 | Spreadsheets in RDBMS for OLAP | 2003 | SIGMOD |