Optimization of Nested Queries in a Distributed Relational Database
Summary: R* extends System R to distributed settings, enabling nested SQL subqueries across sites, with subQBs as Evaluate-at-Open or Evaluate-at-Application. A bottom-up per-subQB optimizer independently selects site and protocols using subQB cost, cardinality, and result site to yield a minimal-cost plan. (summarized by gpt-5-nano on Feb 09 2026)
Incoming Non-self Citations Over Time
Authors
- 1. Guy M. Lohman
- 2. Dean Daniels
- 3. Laura M. Haas
- 4. Ruth Kistler
- 5. Patricia G. Selinger
Incoming Citations (Sorted by Pagerank)
Showing 9 of 9 citing papers.
| Rank | Citing Paper | Year | Venue | Pagerank |
|---|---|---|---|---|
| 100 | Of Nests and Trees: A Unified Approach to Processing Queries That Contain Nested Subqueries, Aggregates, and Quantifiers | 1987 | VLDB | 0.00049624696 |
| 196 | R* Optimizer Validation and Performance Evaluation for Distributed Queries | 1986 | VLDB | 0.00035261496 |
| 219 | Grammar-like Functional Rules for Representing Query Optimization Alternatives | 1988 | SIGMOD | 0.00033244259 |
| 268 | R* Optimizer Validation and Performance Evaluation for Local Queries | 1986 | SIGMOD | 0.00029662304 |
| 307 | Extensible Query Processing in Starburst | 1989 | SIGMOD | 0.00028211308 |
| 423 | Measuring the Complexity of Join Enumeration in Query Optimization | 1990 | VLDB | 0.00023669348 |
| 1,451 | Extending the Algebraic Framework of Query Processing to Handle Outerjoins | 1984 | VLDB | 0.00011922302 |
| 4,006 | On Semantic Reefs And Efficient Processing Of Correlation Queries With Aggregates | 1985 | VLDB | 6.5410994e-05 |
| 4,896 | Online Feedback for Nested Aggregate Queries with Multi-Threading | 1999 | VLDB | 5.8469503e-05 |
Previous
Page 1 / 1
Next
Outgoing Citations (Sorted by Pagerank)
Showing 5 of 5 cited papers.
Citations counted here include only citations to other VLDB/SIGMOD/CIDR/PODS papers in this database.
| Rank | Cited Paper | Year | Venue | Pagerank |
|---|---|---|---|---|
| 1 | Access Path Selection in a Relational Database Management System | 1979 | SIGMOD | 0.0040449103 |
| 317 | Distributed Query Processing In A Relational Data Base System | 1978 | SIGMOD | 0.00027980992 |
| 1,318 | A Heuristic Approach to Distributed Query Processing | 1982 | VLDB | 0.00012624059 |
| 1,342 | On the Design of a Query Processing Strategy in a Distributed Database Environment | 1983 | SIGMOD | 0.00012483694 |
| 4,814 | Overview of an Ada* Compatible Distributed Database Manager | 1983 | SIGMOD | 5.9041764e-05 |
Previous
Page 1 / 1
Next
Semantically Similar Papers
| Overall Rank | Paper | Year | Venue | Pagerank |
|---|---|---|---|---|
| 4,288 | Parallel Processing of Recursive Queries in Distributed Architectures | 1989 | VLDB | 6.2891396e-05 |
| 2,393 | Rank-aware Query Optimization | 2004 | SIGMOD | 8.9016542e-05 |
| 6,658 | Scalable Querying of Nested Data | 2021 | VLDB | 4.9711629e-05 |
| 2,719 | Optimization and Dataflow Algorithms for Nested Tree Queries | 1989 | VLDB | 8.2398923e-05 |
| 2,110 | A Recursive Algebra and Query Optimization for Nested Relations | 1989 | SIGMOD | 9.5315487e-05 |
| 100 | Of Nests and Trees: A Unified Approach to Processing Queries That Contain Nested Subqueries, Aggregates, and Quantifiers | 1987 | VLDB | 0.00049624696 |
| 130 | Optimization of Nested SQL Queries Revisited | 1987 | SIGMOD | 0.00044031247 |
| 12,534 | A Nested Relational Approach to Processing SQL Subqueries | 2005 | SIGMOD | 4.1945683e-05 |
| 196 | R* Optimizer Validation and Performance Evaluation for Distributed Queries | 1986 | VLDB | 0.00035261496 |
| 268 | R* Optimizer Validation and Performance Evaluation for Local Queries | 1986 | SIGMOD | 0.00029662304 |