Leveraging Application Data Constraints to Optimize Database-Backed Web Applications
Summary: Coco analyzes database-backed application code to uncover data constraints missed by statistics-based methods. It uses enumerate-test-verify to generate provably equivalent query rewrites and optimize physical design, yielding significant gains across 14 real-world web applications. (summarized by gpt-5.6-luna on Jul 24 2026)
Incoming Non-self Citations Over Time
Authors
- 1. Xiaoxuan Liu (University of California Berkeley)
- 2. Shuxian Wang (University of California Berkeley)
- 3. Mengzhu Sun (University of California Berkeley)
- 4. Sicheng Pan (University of California Berkeley)
- 5. Ge Li (University of California Berkeley)
- 6. Siddharth Jha (University of California Berkeley)
- 7. Cong Yan (Microsoft)
- 8. Junwen Yang (Meta)
- 9. Shan Lu (University of Chicago)
- 10. Alvin Cheung (University of California Berkeley)
BibTeX Citation
@article{liu_vldb23,
title = {{Leveraging Application Data Constraints to Optimize Database-Backed Web Applications}},
author = {Liu, Xiaoxuan and Wang, Shuxian and Sun, Mengzhu and Pan, Sicheng and Li, Ge and Jha, Siddharth and Yan, Cong and Yang, Junwen and Lu, Shan and Cheung, Alvin},
journal = {PVLDB},
series = {{VLDB} '23},
volume = {16},
number = {6},
pages = {1208--1221},
doi = {10.14778/3583140.3583141},
url = {https://doi.org/10.14778/3583140.3583141},
year = {2023}
}
Incoming Citations (Sorted by Pagerank)
Showing 3 of 3 citing papers.
| Rank | Citing Paper | Year | Venue | Pagerank |
|---|---|---|---|---|
| 10,199 | Automated Discovery of Test Oracles for Database Management Systems Using LLMs | 2026 | SIGMOD | 5.093636e-05 |
| 11,221 | Mixed Covers of Keys and Functional Dependencies for Maintaining the Integrity of Data under Updates | 2024 | VLDB | 5.093636e-05 |
| 11,499 | Towards Auto-Generated Data Systems | 2023 | VLDB | 5.093636e-05 |
Previous
Page 1 / 1
Next
Outgoing Citations (Sorted by Pagerank)
Showing 16 of 16 cited papers.
Citations counted here include only citations to other VLDB/SIGMOD/CIDR/PODS papers in this database.
Previous
Page 1 / 1
Next
Semantically Similar Papers
| # | Overall Rank | Paper | Year | Venue |
|---|---|---|---|---|
| 1 | 4,287 | Optimization of Run-time Management of Data Intensive Web Sites | 1999 | VLDB |
| 2 | 2,811 | Constrained Physical Design Tuning | 2008 | VLDB |
| 3 | 1,982 | WeTune: Automatic Discovery and Verification of Query Rewrite Rules | 2022 | SIGMOD |
| 4 | 1,073 | A General Framework for the Optimization of Object-Oriented Queries | 1992 | SIGMOD |
| 5 | 7,703 | Constrained Optimalities in Query Personalization | 2005 | SIGMOD |
| 6 | 2,939 | Extracting Equivalent SQL from Imperative Code in Database Applications | 2016 | SIGMOD |
| 7 | 6,548 | Query Optimization over Crowdsourced Data | 2013 | VLDB |
| 8 | 2,591 | Knowledge-based Integrity Constraint Validation | 1986 | VLDB |
| 9 | 7,749 | CoCo: Interactive Exploration of Conformance Constraints for Data Understanding and Data Cleaning | 2021 | SIGMOD |
| 10 | 4,199 | Exploiting Constraint-Like Data Characterizations in Query Optimization | 2001 | SIGMOD |