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 |
|---|---|---|---|---|
| 102 | Of Nests and Trees: A Unified Approach to Processing Queries That Contain Nested Subqueries, Aggregates, and Quantifiers | 1987 | VLDB | 0.00049592627 |
| 196 | R* Optimizer Validation and Performance Evaluation for Distributed Queries | 1986 | VLDB | 0.00035240105 |
| 220 | Grammar-like Functional Rules for Representing Query Optimization Alternatives | 1988 | SIGMOD | 0.00033312045 |
| 269 | R* Optimizer Validation and Performance Evaluation for Local Queries | 1986 | SIGMOD | 0.00029665158 |
| 309 | Extensible Query Processing in Starburst | 1989 | SIGMOD | 0.00028195213 |
| 422 | Measuring the Complexity of Join Enumeration in Query Optimization | 1990 | VLDB | 0.00023654556 |
| 1,455 | Extending the Algebraic Framework of Query Processing to Handle Outerjoins | 1984 | VLDB | 0.00011912375 |
| 4,008 | On Semantic Reefs And Efficient Processing Of Correlation Queries With Aggregates | 1985 | VLDB | 6.5357979e-05 |
| 4,902 | Online Feedback for Nested Aggregate Queries with Multi-Threading | 1999 | VLDB | 5.8415033e-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.0040465394 |
| 315 | Distributed Query Processing In A Relational Data Base System | 1978 | SIGMOD | 0.00028022592 |
| 1,308 | A Heuristic Approach to Distributed Query Processing | 1982 | VLDB | 0.00012664082 |
| 1,345 | On the Design of a Query Processing Strategy in a Distributed Database Environment | 1983 | SIGMOD | 0.0001247541 |
| 4,814 | Overview of an Ada* Compatible Distributed Database Manager | 1983 | SIGMOD | 5.8984488e-05 |
Previous
Page 1 / 1
Next
Semantically Similar Papers
| Overall Rank | Paper | Year | Venue | Pagerank |
|---|---|---|---|---|
| 4,320 | Parallel Processing of Recursive Queries in Distributed Architectures | 1989 | VLDB | 6.2822407e-05 |
| 2,249 | Rank-aware Query Optimization | 2004 | SIGMOD | 9.1956569e-05 |
| 6,661 | Scalable Querying of Nested Data | 2021 | VLDB | 4.9663934e-05 |
| 2,722 | Optimization and Dataflow Algorithms for Nested Tree Queries | 1989 | VLDB | 8.232489e-05 |
| 2,109 | A Recursive Algebra and Query Optimization for Nested Relations | 1989 | SIGMOD | 9.5283567e-05 |
| 102 | Of Nests and Trees: A Unified Approach to Processing Queries That Contain Nested Subqueries, Aggregates, and Quantifiers | 1987 | VLDB | 0.00049592627 |
| 130 | Optimization of Nested SQL Queries Revisited | 1987 | SIGMOD | 0.00044001626 |
| 12,543 | A Nested Relational Approach to Processing SQL Subqueries | 2005 | SIGMOD | 4.1905499e-05 |
| 196 | R* Optimizer Validation and Performance Evaluation for Distributed Queries | 1986 | VLDB | 0.00035240105 |
| 269 | R* Optimizer Validation and Performance Evaluation for Local Queries | 1986 | SIGMOD | 0.00029665158 |