Transparent Mid-Tier Database Caching in SQL Server

Summary: MTCache: mid-tier SQL Server cache using materialized views, replication and distributed queries at app servers. Integrated with the optimizer, it enables local/remote/hybrid plans and two-branch parameterized queries; backend updates; TPC-W demo. (summarized by gpt-5-nano on Feb 09 2026)

Paper ID: h31f9805498938265
Venue: SIGMOD
Year: 2003
Pagerank: 8.7082344e-05
Overall Rank: 2,274 | 84.72%
DOI: 10.1145/872757.872848

Incoming Non-self Citations Over Time

Authors

1. Per-Åke Larson (Microsoft)
2. Jonathan Goldstein (Microsoft)
3. Jingren Zhou (Columbia University)

BibTeX Citation

@inproceedings{larson_sigmod03,
        title = {{Transparent Mid-Tier Database Caching in SQL Server}},
        author = {Larson, Per-Åke and Goldstein, Jonathan and Zhou, Jingren},
        series = {{SIGMOD} '03},
        booktitle = {Proceedings of the {ACM} {SIGMOD} International Conference on Management of Data},
        publisher = {Association for Computing Machinery},
        doi = {10.1145/872757.872848},
        url = {https://dl.acm.org/doi/10.1145/872757.872848},
        year = {2003}
}

Incoming Citations (Sorted by Pagerank)

Showing 15 of 15 citing papers.

Rank	Citing Paper	Year	Venue	Pagerank
1,447	Consistency Rationing in the Cloud: Pay only when it matters	2009	VLDB	0.00010622872
2,086	An Architecture for Recycling Intermediates in a Column-store	2009	SIGMOD	9.0677901e-05
2,826	Relaxed Currency and Consistency: How to Say "Good Enough" in SQL	2004	SIGMOD	7.9641044e-05
3,616	Caching with "Good Enough" Currency, Consistency, and Completeness	2005	VLDB	7.1551409e-05
5,223	Efficient Streaming Subgraph Isomorphism with Graph Neural Networks	2021	VLDB	6.2201582e-05
5,451	Crystal: A Unified Cache Storage System for Analytical Databases	2021	VLDB	6.1238308e-05
5,500	Density-optimized Intersection-free Mapping and Matrix Multiplication for Join-Project Operations	2022	VLDB	6.1020763e-05
5,719	Indexing in an Actor-Oriented Database	2017	CIDR	6.0162188e-05
6,930	Balancing Performance and Data Freshness in Web Database Servers	2003	VLDB	5.6388024e-05
7,886	ChronoCache: Predictive and Adaptive Mid-Tier Query Result Caching	2020	SIGMOD	5.4313303e-05
8,018	Support for Relaxed Currency and Consistency Constraints in MTCache	2004	SIGMOD	5.4045484e-05
9,428	EIRES: Efficient Integration of Remote Data in Event Stream Processing	2021	SIGMOD	5.1778854e-05
12,309	Quaestor: Query Web Caching for Database-as-a-Service Providers	2017	VLDB	4.9769913e-05
12,831	Pangea: An Eager Database Replication Middleware guaranteeing Snapshot Isolation without Modification of Database Servers	2009	VLDB	4.9769913e-05
13,042	Database Change Notifications: Primitives for Efficient Database Query Result Caching	2005	VLDB	4.9769913e-05

Outgoing Citations (Sorted by Pagerank)

Showing 5 of 5 cited papers.

Citations counted here include only citations to other VLDB/SIGMOD/CIDR/PODS papers in this database.

Rank	Cited Paper	Year	Venue	Pagerank
807	Middle-Tier Database Caching for e-Business	2002	SIGMOD	0.00013772554
2,595	Web Caching for Database Applications with Oracle Web Cache	2002	SIGMOD	8.2399128e-05
5,219	High Performance and Scalability through Application-Tier, In-Memory Data Management	2000	VLDB	6.2211319e-05
5,890	Mid-Tier Caching: The TimesTen Approach	2002	SIGMOD	5.9545074e-05
7,137	DBCache: Database Caching For Web Application Servers	2002	SIGMOD	5.599008e-05

Semantically Similar Papers

#	Overall Rank	Paper	Year	Venue
1	13,042	Database Change Notifications: Primitives for Efficient Database Query Result Caching	2005	VLDB
2	2,431	Data Caching Tradeoffs in Client-Server DBMS Architectures	1991	SIGMOD
3	8,018	Support for Relaxed Currency and Consistency Constraints in MTCache	2004	SIGMOD
4	7,886	ChronoCache: Predictive and Adaptive Mid-Tier Query Result Caching	2020	SIGMOD
5	3,616	Caching with "Good Enough" Currency, Consistency, and Completeness	2005	VLDB
6	5,219	High Performance and Scalability through Application-Tier, In-Memory Data Management	2000	VLDB
7	3,345	Cache Tables: Paving the Way for an Adaptive Database Cache	2003	VLDB
8	5,890	Mid-Tier Caching: The TimesTen Approach	2002	SIGMOD
9	807	Middle-Tier Database Caching for e-Business	2002	SIGMOD
10	4,691	DBCache: Middle-tier Database Caching for Highly Scalable e-Business Architectures	2003	SIGMOD