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
h0d1ab9e7830d1a47
Venue
SIGMOD
Year
2003
Pagerank
9.80996e-05
Overall Rank
1,714 | 88.48%
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,696 PIVOT and UNPIVOT: Optimization and Execution Strategies in an RDBMS 2004 VLDB 9.8545415e-05
1,944 Caravan: Provisioning for What-If Analysis 2013 CIDR 9.3281326e-05
3,303 Spreadsheet As a Relational Database Engine 2010 SIGMOD 7.4429728e-05
4,555 Query By Excel 2005 VLDB 6.5386199e-05
6,256 DataSpread: Unifying Databases and Spreadsheets 2015 VLDB 5.8335602e-05
7,144 Business Modeling Using SQL Spreadsheets 2003 VLDB 5.5995962e-05
8,271 Sigma Workbook: A Spreadsheet for Cloud Data Warehouses 2022 VLDB 5.3643259e-05
8,842 Building Statistical Models and Scoring with UDFs 2007 SIGMOD 5.2657018e-05
11,617 Grouping, Subsumption, and Disjunctive Join Optimizations in Oracle 2024 VLDB 4.9793485e-05
13,003 Composite Subset Measures 2006 VLDB 4.9793485e-05
13,032 Bridging the Gap between OLAP and SQL 2005 VLDB 4.9793485e-05
13,059 Data Densification in a Relational Database System 2004 SIGMOD 4.9793485e-05
13,060 Vertical and Horizontal Percentage Aggregations 2004 SIGMOD 4.9793485e-05
13,086 Symmetric Relations and Cardinality-Bounded Multisets in Database Systems 2004 VLDB 4.9793485e-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.001992968
4 The R*-tree: An Efficient and Robust Access Method for Points and Rectangles 1990 SIGMOD 0.0011405675
39 Efficiently Updating Materialized Views 1986 SIGMOD 0.00046602544
62 Maintaining Views Incrementally 1993 SIGMOD 0.00039045511
125 Predicate Migration: Optimizing Queries with Expensive Predicates 1993 SIGMOD 0.00030470848
648 Materialized Views In Oracle 1998 VLDB 0.00015151422
1,119 Query Optimization by Predicate Move-Around 1994 VLDB 0.00011950395
1,438 Magic is Relevant 1990 SIGMOD 0.00010648031
1,853 Hypothetical Queries in an OLAP Environment 2000 VLDB 9.5001964e-05
1,898 Querying Multiple Features of Groups in Relational Databases 1996 VLDB 9.4085557e-05
2,032 Practical Predicate Placement 1994 SIGMOD 9.1561026e-05
2,256 Dwarf: Shrinking the PetaCube 2002 SIGMOD 8.7438759e-05
2,937 Pushing Constraint Selections 1992 PODS 7.8356559e-05
3,850 QC-Trees: An Efficient Summary Structure for Semantic OLAP 2003 SIGMOD 6.9801117e-05
Previous Page 1 / 1 Next

Semantically Similar Papers

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