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
2940
Venue
SIGMOD
Year
1996
Pagerank
0.00019549294
Overall Rank
381 | 97.39%
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
22 Data Integration: A Theoretical Perspective 2002 PODS 0.00056204792
117 Querying Heterogeneous Information Sources Using Source Descriptions 1996 VLDB 0.00032192665
328 An Adaptive Query Execution System for Data Integration* 1999 SIGMOD 0.00021081317
645 Your Mediators Need Data Conversion! 1998 SIGMOD 0.00015338713
785 Middle-Tier Database Caching for e-Business 2002 SIGMOD 0.00014068999
1,302 Catching the Boat with Strudel: Experiences with a Web-Site Management System 1998 SIGMOD 0.00011238375
1,540 Crossing the Structure Chasm 2003 CIDR 0.00010430413
1,858 Using Probabilistic Information in Data Integration 1997 VLDB 9.6035277e-05
2,066 Rewriting of Regular Expressions and Regular Path Queries 1999 PODS 9.2348082e-05
2,189 Physical Data Independence, Constraints, and Optimization with Universal Plans 1999 VLDB 8.9856333e-05
3,039 Query Containment for Data Integration Systems 2000 PODS 7.8265533e-05
3,087 How to Win a Hot Dog Eating Contest: Distributed Incremental View Maintenance with Batch Updates 2016 SIGMOD 7.7702906e-05
3,101 Form-Based Proxy Caching for Database-Backed Web Sites 2001 VLDB 7.7577635e-05
3,305 Cache Tables: Paving the Way for an Adaptive Database Cache 2003 VLDB 7.5402501e-05
3,734 STRUDEL: A Web-site Management System 1997 SIGMOD 7.1649073e-05
4,287 Optimization of Run-time Management of Data Intensive Web Sites 1999 VLDB 6.7803604e-05
4,445 View-Based Query Containment 2003 PODS 6.699172e-05
4,700 Cost Models DO Matter: Providing Cost Information for Diverse Data Sources in a Federated System 1999 VLDB 6.5557492e-05
5,117 View Invalidation for Dynamic Content Caching in Multitiered Architectures 2002 VLDB 6.3581741e-05
6,796 Using Latency-Recency Profiles for Data Delivery on the Web 2002 VLDB 5.7707686e-05
6,833 Efficient Evaluation of Queries in a Mediator for WebSources 2002 SIGMOD 5.7596307e-05
7,943 The Nimble Integration Engine 2001 SIGMOD 5.5181056e-05
9,043 A Layered Architecture for Querying Dynamic Web Content 1999 SIGMOD 5.3253843e-05
12,849 The Denodo Data Integration Platform 2002 VLDB 5.093636e-05
12,923 A Multi-Similarity Algebra 1998 SIGMOD 5.093636e-05
12,943 Bulk Loading Techniques for Object Databases and an Application to Relational Data 1998 VLDB 5.093636e-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.0024089429
61 Maintaining Views Incrementally 1993 SIGMOD 0.00039026867
146 On Rules, Procedures, Caching And Views In Data Base Systems 1990 SIGMOD 0.00029540467
182 Federated Database Systems for Managing Distributed, Heterogeneous, and Autonomous Databases 1991 VLDB 0.00026367971
222 Adaptive Selectivity Estimation Using Query Feedback 1994 SIGMOD 0.00024193708
258 Deriving Production Rules for Incremental View Maintenance 1991 VLDB 0.00023131981
373 Maintenance Of Views 1984 SIGMOD 0.00019797816
677 Query Optimization in the Presence of Foreign Functions 1993 VLDB 0.00015065909
707 A Performance Analysis of View Materialization Strategies 1987 SIGMOD 0.00014771849
1,001 Querying and Updating the File 1993 VLDB 0.00012714843
1,062 Towards an Open Architecture for LDL 1989 VLDB 0.000123618
1,145 Objects and Views 1991 SIGMOD 0.00011987662
3,607 Efficient Maintenance of Materialized Mediated Views (Extended Abstract) 1995 SIGMOD 7.262291e-05
4,352 OdeFS: A File System Interface to an Object-Oriented Database 1994 VLDB 6.7491841e-05
Previous Page 1 / 1 Next

Semantically Similar Papers

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