loading...
MTCache: Transparent Mid-Tier Database Caching in SQL Server
Boston, Massachusetts March 30-April 02
DOI Bookmark: http://doi.ieeecomputersociety.org/10.1109/ICDE.2004.131999420th International Conference on Data ...
 This Article 
 
PDF
HTML
 
 Share 
   
 Bibliographic References 
   
 Add to: 
 
Digg
Furl
Spurl
Blink
Simpy
Google
Del.icio.us
Y!MyWeb
 
 Search 
   
Per-?ke Larson, Microsoft
Jonathan Goldstein, Microsoft
Jingren Zhou, Columbia University
Many applications today run in a multi-tier environment with browser-based clients, mid-tier (application) servers and a backend database server. Mid-tier database caching attempts to improve system throughput and scalability by offloading part of the database workload to intermediate database servers that partially replicate data from the backend server. The fact that some queries are offloaded to an intermediate server should be completely transparent to applications - one of the key distinctions between caching and replication. MTCache is a prototype mid-tier database caching solution for SQL Server that achieves this transparency. It builds on SQL Server's support for materialized views, distributed queries and replication. This paper describes MTCache and reports experimental results on the TPC-W benchmark. The experiments show that a significant part of the query workload can be offloaded to cache servers, resulting in greatly improved scale-out on the read-dominated workloads of the benchmark. Replication overhead was small with an average replication delay of less than two seconds.
Citation:
Per-?ke Larson, Jonathan Goldstein, Jingren Zhou, "MTCache: Transparent Mid-Tier Database Caching in SQL Server," icde, pp.177, 20th International Conference on Data Engineering (ICDE'04), 2004
Usage of this product signifies your acceptance of the Terms of Use.


Suggestions