论文标题
利用应用程序数据约束来优化数据库支持的Web应用程序
Leveraging Application Data Constraints to Optimize Database-Backed Web Applications
论文作者
论文摘要
数据之间的关系是经典查询优化技术。由于持续数据越来越多地创建和维护，因此从数据统计信息中渗透数据关系的先前工作会错过一个重要的机会。我们提供Constropt，这是第一个通过分析数据库支持的应用程序来标识数据关系的工具。一旦确定，约束就利用约束来优化应用程序的物理设计和查询执行。 Constopt没有开发固定的预定义重写规则，而是采用枚举检验验证技术来自动利用发现的数据约束来改善查询执行。事实证明，每个结果的重写都等同于原始查询。我们的实验使用14个现实世界的Web应用程序表明，Constropt可以从代码分析中发现许多数据约束，并显着改善现实的应用程序性能。
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 ConstrOpt, the first tool that identifies data relationships by analyzing database-backed applications. Once identified, ConstrOpt leverages the constraints to optimize the application's physical design and query execution. Instead of developing a fixed set of predefined rewriting rules, ConstrOpt 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 ConstrOpt can discover numerous data constraints from code analysis and improve real-world application performance significantly.
