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 |
|---|---|---|---|---|
| 97 | Of Nests and Trees: A Unified Approach to Processing Queries That Contain Nested Subqueries, Aggregates, and Quantifiers | 1987 | VLDB | 0.00034124569 |
| 196 | Grammar-like Functional Rules for Representing Query Optimization Alternatives | 1988 | SIGMOD | 0.00025626873 |
| 273 | Extensible Query Processing in Starburst | 1989 | SIGMOD | 0.00022504729 |
| 321 | Measuring the Complexity of Join Enumeration in Query Optimization | 1990 | VLDB | 0.00021088704 |
| 344 | R* Optimizer Validation and Performance Evaluation for Distributed Queries | 1986 | VLDB | 0.00020461727 |
| 397 | R* Optimizer Validation and Performance Evaluation for Local Queries | 1986 | SIGMOD | 0.00019157058 |
| 1,935 | Extending the Algebraic Framework of Query Processing to Handle Outerjoins | 1984 | VLDB | 9.3389342e-05 |
| 4,390 | On Semantic Reefs and Efficient Processing of Correlation Queries with Aggregates | 1985 | VLDB | 6.6221941e-05 |
| 5,254 | Online Feedback for Nested Aggregate Queries with Multi-Threading | 1999 | VLDB | 6.2079513e-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.0023947656 |
| 405 | Distributed Query Processing In A Relational Data Base System | 1978 | SIGMOD | 0.00019065801 |
| 1,673 | On the Design of a Query Processing Strategy in a Distributed Database Environment | 1983 | SIGMOD | 9.9240164e-05 |
| 1,801 | A Heuristic Approach to Distributed Query Processing | 1982 | VLDB | 9.6087367e-05 |
| 5,279 | Overview of an Ada* Compatible Distributed Database Manager | 1983 | SIGMOD | 6.1994622e-05 |
Previous
Page 1 / 1
Next
Semantically Similar Papers
| # | Overall Rank | Paper | Year | Venue |
|---|---|---|---|---|
| 1 | 4,888 | Parallel Processing of Recursive Queries in Distributed Architectures | 1989 | VLDB |
| 2 | 1,773 | Rank-aware Query Optimization | 2004 | SIGMOD |
| 3 | 6,438 | Scalable Querying of Nested Data | 2021 | VLDB |
| 4 | 2,864 | Optimization and Dataflow Algorithms for Nested Tree Queries | 1989 | VLDB |
| 5 | 2,154 | A Recursive Algebra and Query Optimization for Nested Relations | 1989 | SIGMOD |
| 6 | 97 | Of Nests and Trees: A Unified Approach to Processing Queries That Contain Nested Subqueries, Aggregates, and Quantifiers | 1987 | VLDB |
| 7 | 132 | Optimization of Nested SQL Queries Revisited | 1987 | SIGMOD |
| 8 | 13,017 | A Nested Relational Approach to Processing SQL Subqueries | 2005 | SIGMOD |
| 9 | 344 | R* Optimizer Validation and Performance Evaluation for Distributed Queries | 1986 | VLDB |
| 10 | 397 | R* Optimizer Validation and Performance Evaluation for Local Queries | 1986 | SIGMOD |