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: 3421
Venue: SIGMOD
Year: 2003
Pagerank: 0.00011417795
Overall Rank: 1,547 | 89.25%
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,205	PIVOT and UNPIVOT: Optimization and Execution Strategies in an RDBMS	2004	VLDB	0.00013309393
1,646	Caravan: Provisioning for What-If Analysis	2013	CIDR	0.00011026644
2,661	Spreadsheet As a Relational Database Engine	2010	SIGMOD	8.3582084e-05
4,059	Query By Excel	2005	VLDB	6.4867352e-05
6,051	Business Modeling Using SQL Spreadsheets	2003	VLDB	5.2320276e-05
6,503	DataSpread: Unifying Databases and Spreadsheets	2015	VLDB	5.0286698e-05
8,174	Sigma Workbook: A Spreadsheet for Cloud Data Warehouses	2022	VLDB	4.5638044e-05
8,462	Building Statistical Models and Scoring with UDFs	2007	SIGMOD	4.5007504e-05
11,094	Grouping, Subsumption, and Disjunctive Join Optimizations in Oracle	2024	VLDB	4.1905499e-05
12,529	Composite Subset Measures	2006	VLDB	4.1905499e-05
12,558	Bridging the Gap between OLAP and SQL	2005	VLDB	4.1905499e-05
12,585	Data Densification in a Relational Database System	2004	SIGMOD	4.1905499e-05
12,586	Vertical and Horizontal Percentage Aggregations	2004	SIGMOD	4.1905499e-05
12,612	Symmetric Relations and Cardinality-Bounded Multisets in Database Systems	2004	VLDB	4.1905499e-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.0032118946
6	The R*-tree: An Efficient and Robust Access Method for Points and Rectangles	1990	SIGMOD	0.0016113151
55	Efficiently Updating Materialized Views	1986	SIGMOD	0.00065687017
97	Maintaining Views Incrementally	1993	SIGMOD	0.00050863077
140	Predicate Migration: Optimizing Queries with Expensive Predicates	1993	SIGMOD	0.00042289025
470	Materialized Views In Oracle	1998	VLDB	0.00022386815
1,303	Query Optimization by Predicate Move-Around	1994	VLDB	0.00012692678
1,423	Magic is Relevant	1990	SIGMOD	0.00012047765
1,460	Hypothetical Queries in an OLAP Environment	2000	VLDB	0.00011873918
1,754	Querying Multiple Features of Groups in Relational Databases	1996	VLDB	0.00010663123
2,089	Practical Predicate Placement	1994	SIGMOD	9.5689208e-05
2,665	Dwarf: Shrinking the PetaCube	2002	SIGMOD	8.3505169e-05
2,870	Pushing Constraint Selections	1992	PODS	7.9840692e-05
4,004	QC-Trees: An Efficient Summary Structure for Semantic OLAP	2003	SIGMOD	6.5401186e-05

Semantically Similar Papers

Overall Rank	Paper	Year	Venue	Pagerank
12,751	nD-SQL: A Multi-dimensional Language for Interoperability and OLAP	1998	VLDB	4.1905499e-05
4,796	Extending Practical Pre-Aggregation in On-Line Analytical Processing	1999	VLDB	5.9104535e-05
3,162	High-Dimensional OLAP: A Minimal Cubing Approach	2004	VLDB	7.4622284e-05
4,356	A Foundation for Multi-Dimensional Databases	1997	VLDB	6.2518316e-05
762	Explaining differences in multidimensional aggregates	1999	VLDB	0.00016984985
368	An Array-Based Algorithm for Simultaneous Multidimensional Aggregates	1997	SIGMOD	0.00025508459
12,558	Bridging the Gap between OLAP and SQL	2005	VLDB	4.1905499e-05
825	Simultaneous Optimization and Evaluation of Multiple Dimensional Queries	1998	SIGMOD	0.00016171735
2,661	Spreadsheet As a Relational Database Engine	2010	SIGMOD	8.3582084e-05
6,051	Business Modeling Using SQL Spreadsheets	2003	VLDB	5.2320276e-05