Skip to main content
OSTI.GOVU.S. Department of Energy Office of Scientific and Technical Information
U.S. Department of Energy
Office of Scientific and Technical Information
 

Leveraging Application Data Constraints to Optimize Database-Backed Web Applications

Journal Article · · Proceedings of the VLDB Endowment
 [1];  [2];  [2];  [2];  [2];  [2];  [3];  [4];  [5];  [2]
  1. University of California, Berkeley; OSTI
  2. University of California, Berkeley
  3. Microsoft Research
  4. Meta
  5. University of Chicago
+ Show Author Affiliations

Exploiting the relationships among data is a classical query optimization technique. As persistent data is increasingly being created and maintained programmatically, prior work that infers data relationships from data statistics misses an important opportunity. We present Coco, the first tool that identifies data relationships by analyzing database-backed applications. Once identified, Coco leverages the constraints to optimize the application's physical design and query execution. Instead of developing a fixed set of predefined rewriting rules, Coco employs an enumerate-test-verify technique to automatically exploit the discovered data constraints to improve query execution. Each resulting rewrite is provably equivalent to the original query. Using 14 real-world web applications, our experiments show that Coco can discover numerous data constraints from code analysis and improve real-world application performance significantly.

Research Organization:
Univ. of Washington, Seattle, WA (United States)
Sponsoring Organization:
USDOE Office of Science (SC)
DOE Contract Number:
SC0016260
OSTI ID:
2420483
Journal Information:
Proceedings of the VLDB Endowment, Journal Name: Proceedings of the VLDB Endowment Journal Issue: 6 Vol. 16; ISSN 2150-8097
Publisher:
Association for Computing Machinery (ACM)
Country of Publication:
United States
Language:
English

References (15)

HoTTSQL: proving query rewrites with univalent SQL semantics journal June 2017
Logic-based approach to semantic query optimization journal June 1990
Correlation maps journal August 2009
Exploiting soft and hard correlations in big data query optimization journal August 2016
Extensible/rule based query rewrite optimization in Starburst journal June 1992
Leveraging Application Data Constraints to Optimize Database-Backed Web Applications preprint January 2022
Cords conference June 2004
Semantic query optimization in the presence of types journal September 2013
How not to structure your database-backed web applications conference May 2018
A system for semantic query optimization journal December 1987
SCODED: Statistical Constraint Oriented Data Error Detection conference May 2020
A Hybrid Approach to Functional Dependency Discovery conference June 2016
Axiomatic foundations and algorithms for deciding semantic equivalences of SQL queries journal July 2018
Apache Calcite conference May 2018
Wander Join conference June 2016

Similar Records

Optimization of extended relational database systems
Thesis/Dissertation · 1985 · OSTI ID:5911885
Fast Search for Dynamic Multi-Relational Graphs
Conference · 2013 · OSTI ID:1144833
Query relaxation for portable brick-based applications
Conference · 2021 · Proceedings of the 8th ACM International Conference on Systems for Energy-Efficient Buildings, Cities, and Transportation · OSTI ID:1880038

Related Subjects

Computer Science