MTCache:: Transparent mid-tier database caching in SQL server

被引：39

作者：

Larson, PÅ ^{[1
]}

Goldstein, J ^{[1
]}

Zhou, JR ^{[1
]}

机构：

[1] Microsoft Corp, Redmond, WA 98052 USA

来源：

20TH INTERNATIONAL CONFERENCE ON DATA ENGINEERING, PROCEEDINGS | 2004年

关键词：

D O I：

10.1109/ICDE.2004.1319994

中图分类号：

TP [自动化技术、计算机技术];

学科分类号：

0812 ;

摘要：

Many applications today run in a multiplier 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.

引用

页码：177 / 188

页数：12