Active Query Caching for Database Web Servers
نویسندگان
چکیده
A substantial portion of web traffic consists of queries to database web servers. Unfortunately, a common technique to improve web scalability, proxy caching, is ineffective for database web servers because existing web proxy servers cannot cache queries. To address this problem, we modify a recently proposed enhanced proxy server, called an active proxy, to enable Active Query Caching. Our approach works by having the server send the proxy a query applet, which can process simple queries at the proxy. This enables the proxy server to share the database server workload as well as to reduce the network traffic. We show both opportunities and limitations of this approach through a performance study.
منابع مشابه
Multi-tiered Cache Management for E-Commerce Web Sites
Response time is a key differentiation point among electronic commerce (e-commerce) applications. For many e-commerce applications, Web pages are created dynamically based on the current state of a business stored in database systems. To improve the response time, many e-commerce Web sites deploy caching solutions for acceleration of content delivery. There are multiple tiers in the content del...
متن کاملMultitiered Cache Management and Acceleration for Database-Driven Websites
Response time is a key differentiation point among electronic commerce (e-commerce) applications. For many e-commerce applications, web pages are created dynamically based on the current state of a business stored in database systems. To improve the response time, many e-commerce websites deploy caching solutions for acceleration of content delivery. There are multiple tiers in the content deli...
متن کاملForm-Based Proxy Caching for Database-Backed Web Sites
We explore a new proxy-caching framework that exploits the query semantics of HTML forms. We identify a common class of form-based queries, and study two representative caching schemes for them within this framework: (i) traditional passive query caching, and (ii) active query caching, in which the proxy cache can service a request by evaluating a query over the contents of the cache. Results f...
متن کاملDatabase Change Notifications: Primitives for Efficient Database Query Result Caching
Many database applications implement caching of data from a back-end database server to avoid repeated round trips to the back-end and to improve response times for end-user requests. For example, consider a web application that caches dynamic web content in the mid-tier [3, 2]. The content of dynamic web pages is usually assembled from data stored in the underlying database system and subject ...
متن کاملAn Approach Toward Web Caching and Prefetching for Database Management System
In this report, we explore a new approach toward web caching and prefetching for OLTP of DBMS. We first abstract the query in OLTP into query patterns which consists of both the pattern information and the real query parameters which can be used to build real query from the query pattern. We also include the result information of real query in the query representation that can be used to predic...
متن کامل