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.7733128e-05
Overall Rank
1,725 | 88.44%
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,702 PIVOT and UNPIVOT: Optimization and Execution Strategies in an RDBMS 2004 VLDB 9.8175982e-05
1,953 Caravan: Provisioning for What-If Analysis 2013 CIDR 9.297314e-05
3,317 Spreadsheet As a Relational Database Engine 2010 SIGMOD 7.4148507e-05
4,574 Query By Excel 2005 VLDB 6.5139142e-05
6,270 DataSpread: Unifying Databases and Spreadsheets 2015 VLDB 5.8115184e-05
7,172 Business Modeling Using SQL Spreadsheets 2003 VLDB 5.5784385e-05
8,294 Sigma Workbook: A Spreadsheet for Cloud Data Warehouses 2022 VLDB 5.344057e-05
8,869 Building Statistical Models and Scoring with UDFs 2007 SIGMOD 5.2463747e-05
11,670 Grouping, Subsumption, and Disjunctive Join Optimizations in Oracle 2024 VLDB 4.9605343e-05
13,051 Composite Subset Measures 2006 VLDB 4.9605343e-05
13,080 Bridging the Gap between OLAP and SQL 2005 VLDB 4.9605343e-05
13,106 Data Densification in a Relational Database System 2004 SIGMOD 4.9605343e-05
13,107 Vertical and Horizontal Percentage Aggregations 2004 SIGMOD 4.9605343e-05
13,133 Symmetric Relations and Cardinality-Bounded Multisets in Database Systems 2004 VLDB 4.9605343e-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.0019892478
4 The R*-tree: An Efficient and Robust Access Method for Points and Rectangles 1990 SIGMOD 0.0011386412
39 Efficiently Updating Materialized Views 1986 SIGMOD 0.00046445099
62 Maintaining Views Incrementally 1993 SIGMOD 0.00038944207
125 Predicate Migration: Optimizing Queries with Expensive Predicates 1993 SIGMOD 0.00030398363
654 Materialized Views In Oracle 1998 VLDB 0.00015096471
1,122 Query Optimization by Predicate Move-Around 1994 VLDB 0.00011915958
1,443 Magic is Relevant 1990 SIGMOD 0.00010618161
1,864 Hypothetical Queries in an OLAP Environment 2000 VLDB 9.4653035e-05
1,909 Querying Multiple Features of Groups in Relational Databases 1996 VLDB 9.3758651e-05
2,033 Practical Predicate Placement 1994 SIGMOD 9.1389597e-05
2,270 Dwarf: Shrinking the PetaCube 2002 SIGMOD 8.7112055e-05
2,951 Pushing Constraint Selections 1992 PODS 7.8066026e-05
3,859 QC-Trees: An Efficient Summary Structure for Semantic OLAP 2003 SIGMOD 6.9540456e-05
Previous Page 1 / 1 Next

Semantically Similar Papers

# Overall Rank Paper Year Venue
1 13,272 nD-SQL: A Multi-dimensional Language for Interoperability and OLAP 1998 VLDB
2 5,198 Extending Practical Pre-Aggregation in On-Line Analytical Processing 1999 VLDB
3 3,850 High-Dimensional OLAP: A Minimal Cubing Approach 2004 VLDB
4 4,256 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 13,080 Bridging the Gap between OLAP and SQL 2005 VLDB
8 1,131 Simultaneous Optimization and Evaluation of Multiple Dimensional Queries 1998 SIGMOD
9 3,317 Spreadsheet As a Relational Database Engine 2010 SIGMOD
10 7,172 Business Modeling Using SQL Spreadsheets 2003 VLDB