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: 3420
Venue: SIGMOD
Year: 2003
Pagerank: 0.00011428835
Overall Rank: 1,549 | 89.23%
DOI: -

Incoming Non-self Citations Over Time

Authors

Incoming Citations (Sorted by Pagerank)

Showing 14 of 14 citing papers.

Rank	Citing Paper	Year	Venue	Pagerank
1,203	PIVOT and UNPIVOT: Optimization and Execution Strategies in an RDBMS	2004	VLDB	0.00013320373
1,646	Caravan: Provisioning for What-If Analysis	2013	CIDR	0.00011036992
2,652	Spreadsheet As a Relational Database Engine	2010	SIGMOD	8.3662745e-05
4,053	Query By Excel	2005	VLDB	6.4929934e-05
6,047	Business Modeling Using SQL Spreadsheets	2003	VLDB	5.2370673e-05
6,508	DataSpread: Unifying Databases and Spreadsheets	2015	VLDB	5.0335028e-05
8,173	Sigma Workbook: A Spreadsheet for Cloud Data Warehouses	2022	VLDB	4.568186e-05
8,466	Building Statistical Models and Scoring with UDFs	2007	SIGMOD	4.5050696e-05
11,091	Grouping, Subsumption, and Disjunctive Join Optimizations in Oracle	2024	VLDB	4.1945683e-05
12,520	Composite Subset Measures	2006	VLDB	4.1945683e-05
12,549	Bridging the Gap between OLAP and SQL	2005	VLDB	4.1945683e-05
12,576	Data Densification in a Relational Database System	2004	SIGMOD	4.1945683e-05
12,577	Vertical and Horizontal Percentage Aggregations	2004	SIGMOD	4.1945683e-05
12,603	Symmetric Relations and Cardinality-Bounded Multisets in Database Systems	2004	VLDB	4.1945683e-05

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.0032169493
6	The R*-tree: An Efficient and Robust Access Method for Points and Rectangles	1990	SIGMOD	0.0016162015
55	Efficiently Updating Materialized Views	1986	SIGMOD	0.00065762967
95	Maintaining Views Incrementally	1993	SIGMOD	0.00050896659
139	Predicate Migration: Optimizing Queries with Expensive Predicates	1993	SIGMOD	0.00042299329
468	Materialized Views In Oracle	1998	VLDB	0.00022411821
1,302	Query Optimization by Predicate Move-Around	1994	VLDB	0.00012705525
1,423	Magic is Relevant	1990	SIGMOD	0.00012054867
1,461	Hypothetical Queries in an OLAP Environment	2000	VLDB	0.0001188499
1,754	Querying Multiple Features of Groups in Relational Databases	1996	VLDB	0.00010670609
2,086	Practical Predicate Placement	1994	SIGMOD	9.5779956e-05
2,662	Dwarf: Shrinking the PetaCube	2002	SIGMOD	8.3532302e-05
2,861	Pushing Constraint Selections	1992	PODS	7.9919152e-05
4,005	QC-Trees: An Efficient Summary Structure for Semantic OLAP	2003	SIGMOD	6.5414308e-05

Semantically Similar Papers

Overall Rank	Paper	Year	Venue	Pagerank
12,742	nD-SQL: A Multi-dimensional Language for Interoperability and OLAP	1998	VLDB	4.1945683e-05
4,796	Extending Practical Pre-Aggregation in On-Line Analytical Processing	1999	VLDB	5.9152598e-05
3,157	High-Dimensional OLAP: A Minimal Cubing Approach	2004	VLDB	7.4656511e-05
4,356	A Foundation for Multi-Dimensional Databases	1997	VLDB	6.2578525e-05
767	Explaining differences in multidimensional aggregates	1999	VLDB	0.00016981309
366	An Array-Based Algorithm for Simultaneous Multidimensional Aggregates	1997	SIGMOD	0.0002552977
12,549	Bridging the Gap between OLAP and SQL	2005	VLDB	4.1945683e-05
829	Simultaneous Optimization and Evaluation of Multiple Dimensional Queries	1998	SIGMOD	0.0001618536
2,652	Spreadsheet As a Relational Database Engine	2010	SIGMOD	8.3662745e-05
6,047	Business Modeling Using SQL Spreadsheets	2003	VLDB	5.2370673e-05