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,601 | Continuous Queries in Oracle | 2007 | VLDB | 8.4646467e-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 |
|---|---|---|---|---|
| 140 | Predicate Migration: Optimizing Queries with Expensive Predicates | 1993 | SIGMOD | 0.00042289025 |
| 1,303 | Query Optimization by Predicate Move-Around | 1994 | VLDB | 0.00012692678 |
| 1,547 | Spreadsheets in RDBMS for OLAP | 2003 | SIGMOD | 0.00011417795 |
Previous
Page 1 / 1
Next
Semantically Similar Papers
| Overall Rank | Paper | Year | Venue | Pagerank |
|---|---|---|---|---|
| 995 | Approximating Multi-Dimensional Aggregate Range Queries Over Real Attributes | 2000 | SIGMOD | 0.00014745185 |
| 769 | Multi-Dimensional Database Allocation for Parallel Data Warehouses | 2000 | VLDB | 0.00016862794 |
| 13,752 | Coarse-Grained Optimization: Techniques for Rewriting SQL Statement Sequences | 2003 | VLDB | - |
| 1,547 | Spreadsheets in RDBMS for OLAP | 2003 | SIGMOD | 0.00011417795 |
| 1,193 | Fast Computation of Sparse Datacubes | 1997 | VLDB | 0.00013412915 |
| 5,677 | Joins on Encoded and Partitioned Data | 2014 | VLDB | 5.376511e-05 |
| 549 | Hash-Partitioned Join Method Using Dynamic Destaging Strategy | 1988 | VLDB | 0.00020348047 |
| 2,971 | Estimating Join Selectivities using Bandwidth-Optimized Kernel Density Models | 2017 | VLDB | 7.7935535e-05 |
| 3,886 | Density-optimized Intersection-free Mapping and Matrix Multiplication for Join-Project Operations | 2022 | VLDB | 6.6610704e-05 |
| 4,427 | The Case for a Wide-Table Approach to Manage Sparse Relational Data Sets | 2007 | SIGMOD | 6.1886396e-05 |