Middle-tier database caching for e-business

Scaling up to the enormous and growing Internet population with unpredictable usage patterns, Ecommerce applications face severe challenges in cost and manageability, especially for database servers that are deployed as those applications' back-ends in a multi-tier configuration. Middle-tier database caching is one solution to this problem. In this paper, we present a simple extension to the existing federated features in DB2 UDB, which enables a "regular" DB2 instance to become a DBCache without any application modification. On deployment of a DBCache at an application server, arbitrary SQL statements generated from the unchanged application hitherto intended for a back-end database server, can be answered: at the cache, at the back-end database server, or at both locations in a distributed manner. The factors that determine the distribution of workload include the SQL statement type, the cache content, the application requirement on data freshness, and cost-based opti...

• Type: Conference
• Year: 2002
• Where: SIGMOD
• Authors: Qiong Luo, Sailesh Krishnamurthy, C. Mohan, Hamid Pirahesh, Honguk Woo, Bruce G. Lindsay, Jeffrey F. Naughton
• Keywords: Back-end Database Server, Database, Middle-tier Database Caching, SIGMOD 2002, Unchanged Application Hitherto