Holistic Application Analysis for Update­-Independence

Current database performance optimizations stop at the border between the database application and the database system, focusing either on improving the performance of just the database system or the application’s execution in isolation of the other. We argue that typical database application design enables a more holistic analysis that maintains the relationship between the database and application data. We describe techniques to maintain this relationship and introduce several optimizations to improve the efficiency of Web application execution in a distributed environment. We show that our holistic analysis outperforms traditional nonholistic methods both statically and when used as part of a dynamic, distributed environment for executing Web applications using database caches.

[1]  Arun Iyengar,et al.  A scalable system for consistently caching dynamic Web data , 1999, IEEE INFOCOM '99. Conference on Computer Communications. Proceedings. Eighteenth Annual Joint Conference of the IEEE Computer and Communications Societies. The Future is Now (Cat. No.99CH36320).

[2]  Per-Åke Larson,et al.  Updating derived relations: detecting irrelevant and autonomously computable updates , 1986, VLDB.

[3]  Bruce M. Maggs,et al.  Increasing the scalability of dynamic web applications , 2008 .

[4]  Philip A. Bernstein,et al.  Compiling mappings to bridge applications and databases , 2007, SIGMOD '07.

[5]  Bruce M. Maggs,et al.  Scalable query result caching for web applications , 2008, Proc. VLDB Endow..

[6]  Bruce M. Maggs,et al.  A Scalability Service for Dynamic Web Applications , 2005, CIDR.

[7]  Arun Iyengar,et al.  A fragment-based approach for efficiently creating dynamic web content , 2005, TOIT.

[8]  Mesaac Makpangou,et al.  Caching Dynamic Content with Automatic Fragmentation , 2005, iiWAS.

[9]  Alon Y. Halevy,et al.  Queries Independent of Updates , 1993, VLDB.

[10]  Charles Elkan,et al.  Independence of logic database queries and update , 1990, PODS '90.