论文信息 - MTCache: Mid-Tier Database Caching for SQL Server

MTCache: Mid-Tier Database Caching for SQL Server

MTCache is a prototype mid-tier database caching solution for SQL Server that transparently offloads part of the query workload from a backend server to front-end servers. The goal is to improve system throughput and scalability but without requiring application changes. This paper outlines the architecture of MTCache and highlights several of its key features: modeling of data as materialized views, integration with query optimization, and support for queries with explicit data currency and consistency requirements.

Jonathan Goldstein | Jingren Zhou | Per-Åke Larson | Hongfei Guo

[1] Times-Ten Team. Mid-tier caching: the TimesTen approach , 2002, SIGMOD '02.

[2] Hamid Pirahesh,et al. DBCache: database caching for web application servers , 2002, SIGMOD '02.

[3] Jonathan Goldstein,et al. Relaxed currency and consistency: how to say "good enough" in SQL , 2004, SIGMOD '04.

[4] Timesten Team. High-Performance and Scalability through Application Tier,In-Memory Data Management , 2000, VLDB.

[5] Hamid Pirahesh,et al. Cache Tables: Paving the Way for an Adaptive Database Cache , 2003, VLDB.

[6] Jonathan Goldstein,et al. Transparent mid-tier database caching in SQL server , 2003, SIGMOD '03.

[7] Hamid Pirahesh,et al. DBCache: middle-tier database caching for highly scalable e-business architectures , 2003, SIGMOD '03.

[8] Jeffrey F. Naughton,et al. Middle-tier database caching for e-business , 2002, SIGMOD '02.

[9] Jonathan Goldstein,et al. MTCache: transparent mid-tier database caching in SQL server , 2004, Proceedings. 20th International Conference on Data Engineering.

[10] Jonathan Goldstein,et al. Optimizing queries using materialized views: a practical, scalable solution , 2001, SIGMOD '01.