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.8056478e-05
Overall Rank
1,715 | 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,697 PIVOT and UNPIVOT: Optimization and Execution Strategies in an RDBMS 2004 VLDB 9.8499097e-05
1,941 Caravan: Provisioning for What-If Analysis 2013 CIDR 9.3276626e-05
3,305 Spreadsheet As a Relational Database Engine 2010 SIGMOD 7.4394494e-05
4,556 Query By Excel 2005 VLDB 6.5355246e-05
6,259 DataSpread: Unifying Databases and Spreadsheets 2015 VLDB 5.8307986e-05
7,146 Business Modeling Using SQL Spreadsheets 2003 VLDB 5.5969454e-05
8,278 Sigma Workbook: A Spreadsheet for Cloud Data Warehouses 2022 VLDB 5.3617864e-05
8,852 Building Statistical Models and Scoring with UDFs 2007 SIGMOD 5.2632106e-05
11,623 Grouping, Subsumption, and Disjunctive Join Optimizations in Oracle 2024 VLDB 4.9769913e-05
13,009 Composite Subset Measures 2006 VLDB 4.9769913e-05
13,038 Bridging the Gap between OLAP and SQL 2005 VLDB 4.9769913e-05
13,065 Data Densification in a Relational Database System 2004 SIGMOD 4.9769913e-05
13,066 Vertical and Horizontal Percentage Aggregations 2004 SIGMOD 4.9769913e-05
13,092 Symmetric Relations and Cardinality-Bounded Multisets in Database Systems 2004 VLDB 4.9769913e-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.0019923528
4 The R*-tree: An Efficient and Robust Access Method for Points and Rectangles 1990 SIGMOD 0.0011402175
39 Efficiently Updating Materialized Views 1986 SIGMOD 0.00046583225
62 Maintaining Views Incrementally 1993 SIGMOD 0.00039040346
125 Predicate Migration: Optimizing Queries with Expensive Predicates 1993 SIGMOD 0.00030462671
649 Materialized Views In Oracle 1998 VLDB 0.00015144459
1,119 Query Optimization by Predicate Move-Around 1994 VLDB 0.00011946162
1,439 Magic is Relevant 1990 SIGMOD 0.000106437
1,855 Hypothetical Queries in an OLAP Environment 2000 VLDB 9.4960532e-05
1,899 Querying Multiple Features of Groups in Relational Databases 1996 VLDB 9.4044461e-05
2,035 Practical Predicate Placement 1994 SIGMOD 9.1519324e-05
2,257 Dwarf: Shrinking the PetaCube 2002 SIGMOD 8.7397925e-05
2,938 Pushing Constraint Selections 1992 PODS 7.8320394e-05
3,851 QC-Trees: An Efficient Summary Structure for Semantic OLAP 2003 SIGMOD 6.9768367e-05
Previous Page 1 / 1 Next

Semantically Similar Papers

# Overall Rank Paper Year Venue
1 13,231 nD-SQL: A Multi-dimensional Language for Interoperability and OLAP 1998 VLDB
2 5,201 Extending Practical Pre-Aggregation in On-Line Analytical Processing 1999 VLDB
3 3,842 High-Dimensional OLAP: A Minimal Cubing Approach 2004 VLDB
4 4,238 A Foundation for Multi-Dimensional Databases 1997 VLDB
5 701 Explaining differences in multidimensional aggregates 1999 VLDB
6 323 An Array-Based Algorithm for Simultaneous Multidimensional Aggregates 1997 SIGMOD
7 13,038 Bridging the Gap between OLAP and SQL 2005 VLDB
8 1,127 Simultaneous Optimization and Evaluation of Multiple Dimensional Queries 1998 SIGMOD
9 3,305 Spreadsheet As a Relational Database Engine 2010 SIGMOD
10 7,146 Business Modeling Using SQL Spreadsheets 2003 VLDB