Data Densification in a Relational Database System
Summary: Proposes PARTITIONED OUTER JOIN, an ANSI SQL extension for densifying sparse relational data along dimensions. Presents efficient evaluation strategies, compares with CROSS/DISTINCT/OUTER, and introduces LAST_VALUE(IGNORE NULLS) for dense-window analytics. (summarized by gpt-5-nano on Feb 09 2026)
Incoming Non-self Citations Over Time
No non-self incoming citations found for this paper in this database.
Authors
- 1. Abhinav Gupta
- 2. Sankar Subramanian
- 3. Srikanth Bellamkonda
- 4. Tolga Bozkaya
- 5. Nathan Folkert
- 6. Lei Sheng
- 7. Andrew Witkowski
Incoming Citations (Sorted by Pagerank)
Showing 1 of 1 citing papers.
| Rank | Citing Paper | Year | Venue | Pagerank |
|---|---|---|---|---|
| 2,597 | Continuous Queries in Oracle | 2007 | VLDB | 8.4713998e-05 |
Previous
Page 1 / 1
Next
Outgoing Citations (Sorted by Pagerank)
Showing 3 of 3 cited papers.
Citations counted here include only citations to other VLDB/SIGMOD/CIDR/PODS papers in this database.
| Rank | Cited Paper | Year | Venue | Pagerank |
|---|---|---|---|---|
| 139 | Predicate Migration: Optimizing Queries with Expensive Predicates | 1993 | SIGMOD | 0.00042299329 |
| 1,302 | Query Optimization by Predicate Move-Around | 1994 | VLDB | 0.00012705525 |
| 1,549 | Spreadsheets in RDBMS for OLAP | 2003 | SIGMOD | 0.00011428835 |
Previous
Page 1 / 1
Next
Semantically Similar Papers
| Overall Rank | Paper | Year | Venue | Pagerank |
|---|---|---|---|---|
| 996 | Approximating Multi-Dimensional Aggregate Range Queries Over Real Attributes | 2000 | SIGMOD | 0.00014741524 |
| 773 | Multi-Dimensional Database Allocation for Parallel Data Warehouses | 2000 | VLDB | 0.00016870159 |
| 13,738 | Coarse-Grained Optimization: Techniques for Rewriting SQL Statement Sequences | 2003 | VLDB | - |
| 1,549 | Spreadsheets in RDBMS for OLAP | 2003 | SIGMOD | 0.00011428835 |
| 1,191 | Fast Computation of Sparse Datacubes | 1997 | VLDB | 0.00013434201 |
| 5,670 | Joins on Encoded and Partitioned Data | 2014 | VLDB | 5.3804618e-05 |
| 550 | Hash-Partitioned Join Method Using Dynamic Destaging Strategy | 1988 | VLDB | 0.00020359891 |
| 2,969 | Estimating Join Selectivities using Bandwidth-Optimized Kernel Density Models | 2017 | VLDB | 7.7974762e-05 |
| 3,885 | Density-optimized Intersection-free Mapping and Matrix Multiplication for Join-Project Operations | 2022 | VLDB | 6.6674822e-05 |
| 4,433 | The Case for a Wide-Table Approach to Manage Sparse Relational Data Sets | 2007 | SIGMOD | 6.1935064e-05 |