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 (IBM)
- 2. Dean Daniels (Carnegie-Mellon University)
- 3. Laura M. Haas (IBM)
- 4. Ruth Kistler (IBM)
- 5. Patricia G. Selinger (Carnegie-Mellon University)
BibTeX Citation
@article{lohman_vldb84,
title = {{Optimization of Nested Queries in a Distributed Relational Database}},
author = {Lohman, Guy M. and Daniels, Dean and Haas, Laura M. and Kistler, Ruth and Selinger, Patricia G.},
journal = {PVLDB},
series = {{VLDB} '84},
pages = {403},
year = {1984}
}Incoming Citations (Sorted by Pagerank)
Showing 9 of 9 citing papers.
| Rank | Citing Paper | Year | Venue | Pagerank |
|---|---|---|---|---|
| 95 | Of Nests and Trees: A Unified Approach to Processing Queries That Contain Nested Subqueries, Aggregates, and Quantifiers | 1987 | VLDB | 0.00034607909 |
| 192 | Grammar-like Functional Rules for Representing Query Optimization Alternatives | 1988 | SIGMOD | 0.00026028406 |
| 268 | Extensible Query Processing in Starburst | 1989 | SIGMOD | 0.00022788687 |
| 316 | Measuring the Complexity of Join Enumeration in Query Optimization | 1990 | VLDB | 0.0002141607 |
| 342 | R* Optimizer Validation and Performance Evaluation for Distributed Queries | 1986 | VLDB | 0.00020673706 |
| 396 | R* Optimizer Validation and Performance Evaluation for Local Queries | 1986 | SIGMOD | 0.00019287574 |
| 1,887 | Extending the Algebraic Framework of Query Processing to Handle Outerjoins | 1984 | VLDB | 9.5347906e-05 |
| 4,310 | On Semantic Reefs and Efficient Processing of Correlation Queries with Aggregates | 1985 | VLDB | 6.7677766e-05 |
| 5,142 | Online Feedback for Nested Aggregate Queries with Multi-Threading | 1999 | VLDB | 6.3482762e-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.0024089429 |
| 386 | Distributed Query Processing In A Relational Data Base System | 1978 | SIGMOD | 0.00019451022 |
| 1,651 | On the Design of a Query Processing Strategy in a Distributed Database Environment | 1983 | SIGMOD | 0.00010110141 |
| 1,772 | A Heuristic Approach to Distributed Query Processing | 1982 | VLDB | 9.792162e-05 |
| 5,159 | Overview of an Ada* Compatible Distributed Database Manager | 1983 | SIGMOD | 6.3400003e-05 |
Previous
Page 1 / 1
Next
Semantically Similar Papers
| # | Overall Rank | Paper | Year | Venue |
|---|---|---|---|---|
| 1 | 4,773 | Parallel Processing of Recursive Queries in Distributed Architectures | 1989 | VLDB |
| 2 | 1,759 | Rank-aware Query Optimization | 2004 | SIGMOD |
| 3 | 6,377 | Scalable Querying of Nested Data | 2021 | VLDB |
| 4 | 2,815 | Optimization and Dataflow Algorithms for Nested Tree Queries | 1989 | VLDB |
| 5 | 2,198 | A Recursive Algebra and Query Optimization for Nested Relations | 1989 | SIGMOD |
| 6 | 95 | Of Nests and Trees: A Unified Approach to Processing Queries That Contain Nested Subqueries, Aggregates, and Quantifiers | 1987 | VLDB |
| 7 | 129 | Optimization of Nested SQL Queries Revisited | 1987 | SIGMOD |
| 8 | 12,727 | A Nested Relational Approach to Processing SQL Subqueries | 2005 | SIGMOD |
| 9 | 342 | R* Optimizer Validation and Performance Evaluation for Distributed Queries | 1986 | VLDB |
| 10 | 396 | R* Optimizer Validation and Performance Evaluation for Local Queries | 1986 | SIGMOD |