Data Management

Automatic Partitioning of Database Applications

Download Now Date Added: Aug 2012
Format: PDF

Database-backed applications are nearly ubiquitous in user's daily lives. Applications that make many small accesses to the database create two challenges for developers: increased latency and wasted resources from numerous network round trips. A well-known technique to improve transactional database application performance is to convert part of the application into stored procedures that are executed on the database server. Unfortunately, this conversion is often difficult. In this paper, the authors describe Pyxis, a system that takes database-backed applications and automatically partitions their code into two pieces, one of which is executed on the application server and the other on the database server.