Program analysis and transformation for holistic optimization of database applications

Ramachandra, K and Guravannavar, R and Sudarshan, S (2012) Program analysis and transformation for holistic optimization of database applications. In: International Workshop on State of the Art in Java Program Analysis, 14 June 2012, Beijing; China.

Full text not available from this repository. (Request a copy)


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 tool.

[error in script]
IITH Creators:
IITH CreatorsORCiD
Item Type: Conference or Workshop Item (Paper)
Additional Information: Database applications; Database queries; Java program; Optimization framework; Prefetching; Program analysis; Program transformations; Query results; Service access; Transformation tools
Subjects: Computer science > Computer programming, programs, data
Depositing User: Users 3 not found.
Date Deposited: 28 Oct 2014 08:35
Last Modified: 28 Oct 2014 08:35
Publisher URL:
Related URLs:

Actions (login required)

View Item View Item
Statistics for RAIITH ePrint 433 Statistics for this ePrint Item