Program analysis and transformation for holistic optimization of database applications
Authors:
Open Access
- 14 June 2012
- conference paper
- Published by Association for Computing Machinery (ACM)
- p. 39-44
Abstract
We describe DBridge, a novel program analysis and transformation tool to optimize database and web service access. Traditionally, rewrite of queries and programs are done independently, by the database query optimizer and the language compiler respectively, leaving out many optimization opportunities. Our tool aims to bridge this gap by performing holistic transformations, which include both program and query rewrite. There has been earlier research in this area involving program analysis and transformation for automatically rewriting database applications to perform optimizations; for example, our earlier work has addressed batching or asynchronous submission of iterative queries, and prefetching query results. DBridge implements these techniques for Java programs and internally uses Soot, a Java optimization framework, for static analysis and transformation. DBridge can perform such optimizations on Java programs that use the JDBC API to access the database. It is currently being extended to handle the Hibernate API, and Web Services. In this paper, we describe the program transformations that DBridge can perform.We then discuss the design and implementation of DBridge with a focus on how the Soot framework has been used to achieve these goals. Finally, we conclude by discussing some of the future directions for our toolKeywords
This publication has 7 references indexed in Scilit:
- Holistic optimization by prefetching query results2012
- DBridge: A program rewrite tool for set-oriented query execution2011
- Program transformations for asynchronous query submission2011
- A Static Analysis Framework for Database ApplicationsInternational Conference on Data Engineering, 2009
- Holistic Query Transformations for Dynamic Web ApplicationsInternational Conference on Data Engineering, 2009
- Execution strategies for SQL subqueries2007
- On optimizing an SQL-like nested queryACM Transactions on Database Systems, 1982