Reducing Multidatabase Query Response Time By Tree Balancing

Summary: Two-phase optimization for multidatabase queries: build an optimal left-deep join tree, then balance with simple transformations for lower latency. Balancing lowers response time and resource use for sort-merge/hash-join plans, with low overhead. (summarized by gpt-5-nano on Feb 09 2026)

Paper ID: 2870
Venue: SIGMOD
Year: 1995
Pagerank: 6.4525702e-05
Overall Rank: 4,902 | 66.37%
DOI: 10.1145/223784.223846

Incoming Non-self Citations Over Time

Authors

1. Weimin Du (Hewlett Packard Enterprise)
2. Ming-Chien Shan (Hewlett Packard Enterprise)
3. Umeshwar Dayal (Hewlett Packard Enterprise)

BibTeX Citation

@inproceedings{du_sigmod95,
        title = {{Reducing Multidatabase Query Response Time By Tree Balancing}},
        author = {Du, Weimin and Shan, Ming-Chien and Dayal, Umeshwar},
        series = {{SIGMOD} '95},
        booktitle = {Proceedings of the {ACM} {SIGMOD} International Conference on Management of Data},
        publisher = {Association for Computing Machinery},
        doi = {10.1145/223784.223846},
        url = {https://dl.acm.org/doi/10.1145/223784.223846},
        year = {1995}
}

Incoming Citations (Sorted by Pagerank)

Showing 3 of 3 citing papers.

Rank	Citing Paper	Year	Venue	Pagerank
419	Cost-based Query Scrambling for Initial Delays	1998	SIGMOD	0.0001879684
4,091	Of Snowstorms and Bushy Trees	2014	VLDB	6.9090244e-05
4,700	Cost Models DO Matter: Providing Cost Information for Diverse Data Sources in a Federated System	1999	VLDB	6.5557492e-05

Outgoing Citations (Sorted by Pagerank)

Showing 6 of 6 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
182	Federated Database Systems for Managing Distributed, Heterogeneous, and Autonomous Databases	1991	VLDB	0.00026367971
479	Randomized Algorithms For Optimizing Large Join Queries	1990	SIGMOD	0.00017789732
830	Exploiting Inter-Operation Parallelism in XPRS	1992	SIGMOD	0.00013761367
1,595	Query Optimization in Heterogeneous DBMS	1992	VLDB	0.00010249433
2,577	Processing Queries Over Generalization Hierarchies in a Multidatabase System	1983	VLDB	8.3947293e-05

Semantically Similar Papers

#	Overall Rank	Paper	Year	Venue
1	7,858	Optimization of Multiple-Relation Multiple-Disjunct Queries	1988	PODS
2	3,726	Parallelizing Query Optimization	2008	VLDB
3	143	Optimization of Nonrecursive Queries	1986	VLDB
4	1,720	Using Segmented Right-Deep Trees for the Execution of Pipelined Hash Joins	1992	VLDB
5	10,296	Succinct Structure Representations for Efficient Query Optimization	2026	SIGMOD
6	13,231	Using Semiouterjoins to Process Queries in Multidatabase Systems	1984	PODS
7	434	Query Optimization for Parallel Execution	1992	SIGMOD
8	1,740	Adopting Worst-Case Optimal Joins in Relational Database Systems	2020	VLDB
9	2,104	Optimization of Multi-Way Join Queries for Parallel Execution	1991	VLDB
10	904	Tradeoffs in Processing Complex Join Queries via Hashing in Multiprocessor Database Machines	1990	VLDB