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: 3540
Venue: SIGMOD
Year: 2003
Pagerank: 8.8980681e-05
Overall Rank: 2,231 | 84.70%
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,423	Consistency Rationing in the Cloud: Pay only when it matters	2009	VLDB	0.00010822279
2,151	An Architecture for Recycling Intermediates in a Column-store	2009	SIGMOD	9.0784444e-05
2,770	Relaxed Currency and Consistency: How to Say "Good Enough" in SQL	2004	SIGMOD	8.1458395e-05
3,569	Caching with "Good Enough" Currency, Consistency, and Completeness	2005	VLDB	7.3011823e-05
5,118	Efficient Streaming Subgraph Isomorphism with Graph Neural Networks	2021	VLDB	6.3580186e-05
5,348	Crystal: A Unified Cache Storage System for Analytical Databases	2021	VLDB	6.2562688e-05
5,368	Density-optimized Intersection-free Mapping and Matrix Multiplication for Join-Project Operations	2022	VLDB	6.2448114e-05
5,607	Indexing in an Actor-Oriented Database	2017	CIDR	6.1520776e-05
6,795	Balancing Performance and Data Freshness in Web Database Servers	2003	VLDB	5.7707686e-05
7,722	ChronoCache: Predictive and Adaptive Mid-Tier Query Result Caching	2020	SIGMOD	5.5586232e-05
7,854	Support for Relaxed Currency and Consistency Constraints in MTCache	2004	SIGMOD	5.5311858e-05
9,246	EIRES: Efficient Integration of Remote Data in Event Stream Processing	2021	SIGMOD	5.2992384e-05
12,007	Quaestor: Query Web Caching for Database-as-a-Service Providers	2017	VLDB	5.093636e-05
12,535	Pangea: An Eager Database Replication Middleware guaranteeing Snapshot Isolation without Modification of Database Servers	2009	VLDB	5.093636e-05
12,746	Database Change Notifications: Primitives for Efficient Database Query Result Caching	2005	VLDB	5.093636e-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
785	Middle-Tier Database Caching for e-Business	2002	SIGMOD	0.00014068999
2,549	Web Caching for Database Applications with Oracle Web Cache	2002	SIGMOD	8.4300694e-05
5,093	High Performance and Scalability through Application-Tier, In-Memory Data Management	2000	VLDB	6.3659168e-05
5,771	Mid-Tier Caching: The TimesTen Approach	2002	SIGMOD	6.0930434e-05
6,998	DBCache: Database Caching For Web Application Servers	2002	SIGMOD	5.7292123e-05

Semantically Similar Papers

#	Overall Rank	Paper	Year	Venue
1	12,746	Database Change Notifications: Primitives for Efficient Database Query Result Caching	2005	VLDB
2	2,376	Data Caching Tradeoffs in Client-Server DBMS Architectures	1991	SIGMOD
3	7,854	Support for Relaxed Currency and Consistency Constraints in MTCache	2004	SIGMOD
4	7,722	ChronoCache: Predictive and Adaptive Mid-Tier Query Result Caching	2020	SIGMOD
5	3,569	Caching with "Good Enough" Currency, Consistency, and Completeness	2005	VLDB
6	5,093	High Performance and Scalability through Application-Tier, In-Memory Data Management	2000	VLDB
7	3,305	Cache Tables: Paving the Way for an Adaptive Database Cache	2003	VLDB
8	5,771	Mid-Tier Caching: The TimesTen Approach	2002	SIGMOD
9	785	Middle-Tier Database Caching for e-Business	2002	SIGMOD
10	4,586	DBCache: Middle-tier Database Caching for Highly Scalable e-Business Architectures	2003	SIGMOD