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,659 | A Dataspace Odyssey: The iMeMex Personal Dataspace Management System | 2007 | CIDR | 5.7179562e-05 |
| 9,360 | Extending SQL to Return a Subdatabase | 2025 | SIGMOD | 5.1868213e-05 |
| 12,893 | Dwarfs in the Rearview Mirror: How Big are they Really? | 2008 | VLDB | 4.9793485e-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 |
|---|---|---|---|---|
| 611 | "One Size Fits All" Database Architectures Do Not Work For DSS | 1995 | SIGMOD | 0.00015574329 |
| 939 | Buffering Database Operations for Enhanced Instruction Cache Performance | 2004 | SIGMOD | 0.00012970078 |
| 980 | Sybase IQ Multiplex – Designed For Analytics | 2004 | VLDB | 0.00012720677 |
| 1,696 | PIVOT and UNPIVOT: Optimization and Execution Strategies in an RDBMS | 2004 | VLDB | 9.8545415e-05 |
| 1,714 | Spreadsheets in RDBMS for OLAP | 2003 | SIGMOD | 9.80996e-05 |
| 1,773 | Rank-aware Query Optimization | 2004 | SIGMOD | 9.6719067e-05 |
| 2,254 | Relational link-based ranking | 2004 | VLDB | 8.7448663e-05 |
| 3,127 | Extending XQuery for Analytics | 2005 | SIGMOD | 7.6152762e-05 |
| 6,016 | OLAP Dimension Constraints | 2002 | PODS | 5.9134174e-05 |
| 13,246 | Database Performance in the Real World — TPC-D and SAP R/3 — | 1997 | SIGMOD | 4.9793485e-05 |
Previous
Page 1 / 1
Next
Semantically Similar Papers
| # | Overall Rank | Paper | Year | Venue |
|---|---|---|---|---|
| 1 | 8,228 | Operational Analytics Data Management Systems | 2016 | VLDB |
| 2 | 8,050 | Micro-architectural Analysis of OLAP: Limitations and Opportunities | 2020 | VLDB |
| 3 | 3,841 | High-Dimensional OLAP: A Minimal Cubing Approach | 2004 | VLDB |
| 4 | 4,238 | A Foundation for Multi-Dimensional Databases | 1997 | VLDB |
| 5 | 14,356 | Collaborative Analytical Processing — Dream or Reality | 2001 | VLDB |
| 6 | 12,887 | When is it Time to Rethink the Aggregate Configuration of Your OLAP Server? | 2008 | VLDB |
| 7 | 3,137 | Data Warehousing and OLAP for Decision Support | 1997 | SIGMOD |
| 8 | 976 | A Common Database Approach for OLTP and OLAP Using an In-Memory Column Database | 2009 | SIGMOD |
| 9 | 2,932 | OLAP and Statistical Databases: Similarities and Differences | 1997 | PODS |
| 10 | 1,714 | Spreadsheets in RDBMS for OLAP | 2003 | SIGMOD |