DBScholar

Back to papers

Query Caching and Optimization in Distributed Mediator Systems

Summary: Proposes cost-based optimization for mediator systems over distributed sources by caching actual call stats to estimate plan costs. Adds a query-result cache and invariants to use semantic source info to reuse prior results when sources are unavailable, with experiments. (summarized by gpt-5-nano on Feb 09 2026)

Paper ID
hcf8e9a6ba9b55d97
Venue
SIGMOD
Year
1996
Pagerank
0.00019134783
Overall Rank
399 | 97.32%
DOI
10.1145/233269.233327

Incoming Non-self Citations Over Time

Authors

BibTeX Citation

@inproceedings{adali_sigmod96,
        title = {{Query Caching and Optimization in Distributed Mediator Systems}},
        author = {Adali, S. and Candan, K.S. and Papakonstantinou, Y. and Subrahmanian, V.S.},
        series = {{SIGMOD} '96},
        booktitle = {Proceedings of the {ACM} {SIGMOD} International Conference on Management of Data},
        publisher = {Association for Computing Machinery},
        doi = {10.1145/233269.233327},
        url = {https://dl.acm.org/doi/10.1145/233269.233327},
        year = {1996}
}

Incoming Citations (Sorted by Pagerank)

Showing 26 of 26 citing papers.

Rank Citing Paper Year Venue Pagerank
24 Data Integration: A Theoretical Perspective 2002 PODS 0.00055018384
117 Querying Heterogeneous Information Sources Using Source Descriptions 1996 VLDB 0.00031616101
334 An Adaptive Query Execution System for Data Integration* 1999 SIGMOD 0.00020682536
664 Your Mediators Need Data Conversion! 1998 SIGMOD 0.00014994399
807 Middle-Tier Database Caching for e-Business 2002 SIGMOD 0.00013772554
1,330 Catching the Boat with Strudel: Experiences with a Web-Site Management System 1998 SIGMOD 0.00010994625
1,567 Crossing the Structure Chasm 2003 CIDR 0.00010208293
1,898 Using Probabilistic Information in Data Integration 1997 VLDB 9.4059662e-05
2,043 Rewriting of Regular Expressions and Regular Path Queries 1999 PODS 9.1379399e-05
2,229 Physical Data Independence, Constraints, and Optimization with Universal Plans 1999 VLDB 8.7991965e-05
3,097 Query Containment for Data Integration Systems 2000 PODS 7.649698e-05
3,128 How to Win a Hot Dog Eating Contest: Distributed Incremental View Maintenance with Batch Updates 2016 SIGMOD 7.611678e-05
3,157 Form-Based Proxy Caching for Database-Backed Web Sites 2001 VLDB 7.5820874e-05
3,345 Cache Tables: Paving the Way for an Adaptive Database Cache 2003 VLDB 7.3914225e-05
3,820 STRUDEL: A Web-site Management System 1997 SIGMOD 7.0027332e-05
4,378 Optimization of Run-time Management of Data Intensive Web Sites 1999 VLDB 6.6254986e-05
4,516 View-Based Query Containment 2003 PODS 6.5619066e-05
4,776 Cost Models DO Matter: Providing Cost Information for Diverse Data Sources in a Federated System 1999 VLDB 6.418192e-05
5,245 View Invalidation for Dynamic Content Caching in Multitiered Architectures 2002 VLDB 6.2125756e-05
6,931 Using Latency-Recency Profiles for Data Delivery on the Web 2002 VLDB 5.6388024e-05
6,970 Efficient Evaluation of Queries in a Mediator for WebSources 2002 SIGMOD 5.6289228e-05
8,118 The Nimble Integration Engine 2001 SIGMOD 5.3917406e-05
9,223 A Layered Architecture for Querying Dynamic Web Content 1999 SIGMOD 5.2034607e-05
13,145 The Denodo Data Integration Platform 2002 VLDB 4.9769913e-05
13,219 A Multi-Similarity Algebra 1998 SIGMOD 4.9769913e-05
13,239 Bulk Loading Techniques for Object Databases and an Application to Relational Data 1998 VLDB 4.9769913e-05
Previous Page 1 / 1 Next

Outgoing Citations (Sorted by Pagerank)

Showing 14 of 14 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.0023943337
62 Maintaining Views Incrementally 1993 SIGMOD 0.00039040346
147 On Rules, Procedures, Caching And Views In Data Base Systems 1990 SIGMOD 0.00029006574
186 Federated Database Systems for Managing Distributed, Heterogeneous, and Autonomous Databases 1991 VLDB 0.00025938943
232 Adaptive Selectivity Estimation Using Query Feedback 1994 SIGMOD 0.0002378554
246 Deriving Production Rules for Incremental View Maintenance 1991 VLDB 0.00023204593
380 Maintenance Of Views 1984 SIGMOD 0.00019504209
689 Query Optimization in the Presence of Foreign Functions 1993 VLDB 0.00014746059
724 A Performance Analysis of View Materialization Strategies 1987 SIGMOD 0.00014480522
1,022 Querying and Updating the File 1993 VLDB 0.00012433667
1,076 Towards an Open Architecture for LDL 1989 VLDB 0.00012154177
1,165 Objects and Views 1991 SIGMOD 0.00011734796
3,631 Efficient Maintenance of Materialized Mediated Views (Extended Abstract) 1995 SIGMOD 7.1463149e-05
4,436 OdeFS: A File System Interface to an Object-Oriented Database 1994 VLDB 6.5983299e-05
Previous Page 1 / 1 Next

Semantically Similar Papers

# Overall Rank Paper Year Venue
1 1,673 On the Design of a Query Processing Strategy in a Distributed Database Environment 1983 SIGMOD
2 3,590 Scalable Multi-Query Optimization for Exploratory Queries over Federated Scientific Databases 2008 VLDB
3 4,776 Cost Models DO Matter: Providing Cost Information for Diverse Data Sources in a Federated System 1999 VLDB
4 8,262 Load Balancing in a Locally Distributed Database System 1986 SIGMOD
5 3,454 Locating Data Sources in Large Distributed Systems 2003 VLDB
6 8,642 An Iterative Method for Distributed Database Design 1991 VLDB
7 2,567 Computing Capabilities of Mediators 1999 SIGMOD
8 4,883 Loading a Cache with Query Results 1999 VLDB
9 12,759 An Access Cost-Aware Approach for Object Retrieval over Multiple Sources 2010 VLDB
10 6,970 Efficient Evaluation of Queries in a Mediator for WebSources 2002 SIGMOD