DBScholar

Back to papers

Spreadsheets in RDBMS for OLAP

Summary: Proposes spreadsheet-like computations in a DBMS by extending SQL to treat relations as n-D arrays with formulas over cells. Adds post-SELECT clause, densify, partitioning for parallelism, and UPSERT/UPDATE semantics with cross correlations to emulate joins. (summarized by gpt-5-nano on Feb 09 2026)

Paper ID
3482
Venue
SIGMOD
Year
2003
Pagerank
0.00010005718
Overall Rank
1,687 | 88.43%
DOI
10.1145/872757.872767

Incoming Non-self Citations Over Time

Authors

BibTeX Citation

@inproceedings{witkowski_sigmod03,
        title = {{Spreadsheets in RDBMS for OLAP}},
        author = {Witkowski, Andrew and Bellamkonda, Srikanth and Bozkaya, Tolga and Dorman, Gregory and Folkert, Nathan and Gupta, Abhinav and Shen, Lei and Subramanian, Sankar},
        series = {{SIGMOD} '03},
        booktitle = {Proceedings of the {ACM} {SIGMOD} International Conference on Management of Data},
        publisher = {Association for Computing Machinery},
        doi = {10.1145/872757.872767},
        url = {https://dl.acm.org/doi/10.1145/872757.872767},
        year = {2003}
}

Incoming Citations (Sorted by Pagerank)

Showing 14 of 14 citing papers.

Rank Citing Paper Year Venue Pagerank
1,691 PIVOT and UNPIVOT: Optimization and Execution Strategies in an RDBMS 2004 VLDB 9.9999141e-05
1,952 Caravan: Provisioning for What-If Analysis 2013 CIDR 9.4233049e-05
3,249 Spreadsheet As a Relational Database Engine 2010 SIGMOD 7.5977673e-05
4,477 Query By Excel 2005 VLDB 6.6793744e-05
6,395 DataSpread: Unifying Databases and Spreadsheets 2015 VLDB 5.8876003e-05
7,008 Business Modeling Using SQL Spreadsheets 2003 VLDB 5.7267832e-05
8,510 Sigma Workbook: A Spreadsheet for Cloud Data Warehouses 2022 VLDB 5.4119882e-05
8,678 Building Statistical Models and Scoring with UDFs 2007 SIGMOD 5.3864318e-05
11,297 Grouping, Subsumption, and Disjunctive Join Optimizations in Oracle 2024 VLDB 5.093636e-05
12,713 Composite Subset Measures 2006 VLDB 5.093636e-05
12,742 Bridging the Gap between OLAP and SQL 2005 VLDB 5.093636e-05
12,769 Data Densification in a Relational Database System 2004 SIGMOD 5.093636e-05
12,770 Vertical and Horizontal Percentage Aggregations 2004 SIGMOD 5.093636e-05
12,796 Symmetric Relations and Cardinality-Bounded Multisets in Database Systems 2004 VLDB 5.093636e-05
Previous Page 1 / 1 Next

Outgoing Citations (Sorted by Pagerank)

Showing 14 of 14 cited papers.

Citations counted here include only citations to other VLDB/SIGMOD/CIDR/PODS papers in this database.

Rank Cited Paper Year Venue Pagerank
2 R-Trees: A Dynamic Index Structure For Spatial Searching 1984 SIGMOD 0.0020210012
4 The R*-tree: An Efficient and Robust Access Method for Points and Rectangles 1990 SIGMOD 0.001157935
39 Efficiently Updating Materialized Views 1986 SIGMOD 0.00047309646
61 Maintaining Views Incrementally 1993 SIGMOD 0.00039026867
132 Predicate Migration: Optimizing Queries with Expensive Predicates 1993 SIGMOD 0.00030378624
643 Materialized Views In Oracle 1998 VLDB 0.00015372449
1,124 Query Optimization by Predicate Move-Around 1994 VLDB 0.00012087356
1,410 Magic is Relevant 1990 SIGMOD 0.00010853223
1,845 Hypothetical Queries in an OLAP Environment 2000 VLDB 9.629006e-05
1,860 Querying Multiple Features of Groups in Relational Databases 1996 VLDB 9.5965783e-05
2,005 Practical Predicate Placement 1994 SIGMOD 9.3203144e-05
2,318 Dwarf: Shrinking the PetaCube 2002 SIGMOD 8.7588859e-05
2,876 Pushing Constraint Selections 1992 PODS 8.0075966e-05
3,774 QC-Trees: An Efficient Summary Structure for Semantic OLAP 2003 SIGMOD 7.1381444e-05
Previous Page 1 / 1 Next

Semantically Similar Papers

# Overall Rank Paper Year Venue
1 12,935 nD-SQL: A Multi-dimensional Language for Interoperability and OLAP 1998 VLDB
2 5,136 Extending Practical Pre-Aggregation in On-Line Analytical Processing 1999 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 700 Explaining differences in multidimensional aggregates 1999 VLDB
6 324 An Array-Based Algorithm for Simultaneous Multidimensional Aggregates 1997 SIGMOD
7 12,742 Bridging the Gap between OLAP and SQL 2005 VLDB
8 1,107 Simultaneous Optimization and Evaluation of Multiple Dimensional Queries 1998 SIGMOD
9 3,249 Spreadsheet As a Relational Database Engine 2010 SIGMOD
10 7,008 Business Modeling Using SQL Spreadsheets 2003 VLDB