Holistic Optimization by Prefetching Query Results
Summary: Holistic optimization via automatic prefetching of query results for database-backed apps; reduces wasted prefetches from naive pattern-prediction. Prefetching in caller procedures using DBridge for Java/JDBC (no intrusive code changes), extendable to Hibernate/Web services, with notable real-world gains. (summarized by gpt-5-nano on Feb 09 2026)
Incoming Non-self Citations Over Time
Authors
- 1. Karthik Ramachandra (Indian Institute of Technology Mumbai)
- 2. S Sudarshan (Indian Institute of Technology Mumbai)
BibTeX Citation
@inproceedings{ramachandra_sigmod12,
title = {{Holistic Optimization by Prefetching Query Results}},
author = {Ramachandra, Karthik and Sudarshan, S},
series = {{SIGMOD} '12},
booktitle = {Proceedings of the {ACM} {SIGMOD} International Conference on Management of Data},
publisher = {Association for Computing Machinery},
doi = {10.1145/2213836.2213852},
url = {https://dl.acm.org/doi/10.1145/2213836.2213852},
year = {2012}
}Incoming Citations (Sorted by Pagerank)
Showing 5 of 5 citing papers.
| Rank | Citing Paper | Year | Venue | Pagerank |
|---|---|---|---|---|
| 2,939 | Extracting Equivalent SQL from Imperative Code in Database Applications | 2016 | SIGMOD | 7.9395908e-05 |
| 3,900 | Sloth: Being Lazy is a Virtue (When Issuing Database Queries) | 2014 | SIGMOD | 7.0361352e-05 |
| 6,475 | WeBridge: Synthesizing Stored Procedures for Large-Scale Real-World Web Applications | 2024 | SIGMOD | 5.8687157e-05 |
| 6,714 | Towards Unified Ad-hoc Data Processing | 2014 | SIGMOD | 5.7959651e-05 |
| 7,722 | ChronoCache: Predictive and Adaptive Mid-Tier Query Result Caching | 2020 | SIGMOD | 5.5586232e-05 |
Previous
Page 1 / 1
Next
Outgoing Citations (Sorted by Pagerank)
Showing 3 of 3 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,261 | Rewriting Procedures for Batched Bindings | 2008 | VLDB | 0.0001143305 |
| 1,346 | Fido: A Cache That Learns to Fetch | 1991 | VLDB | 0.00011078024 |
| 4,771 | Loading a Cache with Query Results | 1999 | VLDB | 6.5158709e-05 |
Previous
Page 1 / 1
Next
Semantically Similar Papers
| # | Overall Rank | Paper | Year | Venue |
|---|---|---|---|---|
| 1 | 2,104 | Optimization of Multi-Way Join Queries for Parallel Execution | 1991 | VLDB |
| 2 | 434 | Query Optimization for Parallel Execution | 1992 | SIGMOD |
| 3 | 4,771 | Loading a Cache with Query Results | 1999 | VLDB |
| 4 | 1,261 | Rewriting Procedures for Batched Bindings | 2008 | VLDB |
| 5 | 2,939 | Extracting Equivalent SQL from Imperative Code in Database Applications | 2016 | SIGMOD |
| 6 | 1,073 | A General Framework for the Optimization of Object-Oriented Queries | 1992 | SIGMOD |
| 7 | 10,106 | How to Optimize SQL Queries? A Comparison Between Split, Holistic, and Hybrid Approaches | 2025 | VLDB |
| 8 | 6,475 | WeBridge: Synthesizing Stored Procedures for Large-Scale Real-World Web Applications | 2024 | SIGMOD |
| 9 | 2,578 | Query Optimization over Web Services | 2006 | VLDB |
| 10 | 7,297 | DBridge: Translating Imperative Code to SQL | 2017 | SIGMOD |