Query caching and optimization in distributed mediator systems
SIGMOD '96 Proceedings of the 1996 ACM SIGMOD international conference on Management of data
Semantic cache mechanism for heterogeneous Web querying
WWW '99 Proceedings of the eighth international conference on World Wide Web
SIGMOD '00 Proceedings of the 2000 ACM SIGMOD international conference on Management of data
Optimizing queries using materialized views: a practical, scalable solution
SIGMOD '01 Proceedings of the 2001 ACM SIGMOD international conference on Management of data
Enabling dynamic content caching for database-driven web sites
SIGMOD '01 Proceedings of the 2001 ACM SIGMOD international conference on Management of data
Mid-tier caching: the TimesTen approach
Proceedings of the 2002 ACM SIGMOD international conference on Management of data
Web caching for database applications with Oracle Web Cache
Proceedings of the 2002 ACM SIGMOD international conference on Management of data
Middle-tier database caching for e-business
Proceedings of the 2002 ACM SIGMOD international conference on Management of data
DBCache: database caching for web application servers
Proceedings of the 2002 ACM SIGMOD international conference on Management of data
High-Performance and Scalability through Application Tier,In-Memory Data Management
VLDB '00 Proceedings of the 26th International Conference on Very Large Data Bases
Form-Based Proxy Caching for Database-Backed Web Sites
Proceedings of the 27th International Conference on Very Large Data Bases
Proceedings of the 27th International Conference on Very Large Data Bases
Semantic Data Caching and Replacement
VLDB '96 Proceedings of the 22th International Conference on Very Large Data Bases
Building and Customizing Data-Intensive Web Sites Using Weave
VLDB '00 Proceedings of the 26th International Conference on Very Large Data Bases
A predicate-based caching scheme for client-server database architectures
The VLDB Journal — The International Journal on Very Large Data Bases
Transparent mid-tier database caching in SQL server
Proceedings of the 2003 ACM SIGMOD international conference on Management of data
DBCache: middle-tier database caching for highly scalable e-business architectures
Proceedings of the 2003 ACM SIGMOD international conference on Management of data
Cache tables: paving the way for an adaptive database cache
VLDB '03 Proceedings of the 29th international conference on Very large data bases - Volume 29
Relaxed currency and consistency: how to say "good enough" in SQL
SIGMOD '04 Proceedings of the 2004 ACM SIGMOD international conference on Management of data
Support for relaxed currency and consistency constraints in MTCache
SIGMOD '04 Proceedings of the 2004 ACM SIGMOD international conference on Management of data
Exploring the tradeoff between performance and data freshness in database-driven Web servers
The VLDB Journal — The International Journal on Very Large Data Bases
Caching with "good enough" currency, consistency, and completeness
VLDB '05 Proceedings of the 31st international conference on Very large data bases
Database change notifications: primitives for efficient database query result caching
VLDB '05 Proceedings of the 31st international conference on Very large data bases
Lazy database replication with snapshot isolation
VLDB '06 Proceedings of the 32nd international conference on Very large data bases
Load balancing and data placement for multi-tiered database systems
Data & Knowledge Engineering
Partition-based workload scheduling in living data warehouse environments
Proceedings of the ACM tenth international workshop on Data warehousing and OLAP
Improving parallelism of federated query processing
Data & Knowledge Engineering
Value complete, column complete, predicate complete
The VLDB Journal — The International Journal on Very Large Data Bases
Enabling policy-based access control in BI applications
Data & Knowledge Engineering
Partition-based workload scheduling in living data warehouse environments
Information Systems
An architecture for recycling intermediates in a column-store
Proceedings of the 2009 ACM SIGMOD International Conference on Management of data
Optimizing Maintenance of Constraint-Based Database Caches
ADBIS '09 Proceedings of the 13th East European Conference on Advances in Databases and Information Systems
Consistency rationing in the cloud: pay only when it matters
Proceedings of the VLDB Endowment
Proceedings of the VLDB Endowment
Correlation aware synchronization for near real time decision support systems
Proceedings of the 13th International Conference on Extending Database Technology
Caching and Materialization for Web Databases
Foundations and Trends in Databases
Freshness-aware caching in a cluster of J2EE application servers
WISE'07 Proceedings of the 8th international conference on Web information systems engineering
Making the most of cache groups
DASFAA'07 Proceedings of the 12th international conference on Database systems for advanced applications
A workload-driven unit of cache replacement for mid-tier database caching
DASFAA'07 Proceedings of the 12th international conference on Database systems for advanced applications
An architecture for recycling intermediates in a column-store
ACM Transactions on Database Systems (TODS)
Concurrency and replica control for constraint-based database caching
ADBIS'10 Proceedings of the 14th east European conference on Advances in databases and information systems
Distributed database caching for web applications and web services
Proceedings of the International Conference & Workshop on Emerging Trends in Technology
Schema-based cache validation of dynamic content to improve query performance of web services
Journal of Web Engineering
Enabling fine-grained HTTP caching of SPARQL query results
ISWC'11 Proceedings of the 10th international conference on The semantic web - Volume Part I
Semantic caching for web services
ICSOC'05 Proceedings of the Third international conference on Service-Oriented Computing
A middleware-based approach to database caching
ADBIS'06 Proceedings of the 10th East European conference on Advances in Databases and Information Systems
Caching over the entire user-to-data path in the internet
Data Management in a Connected World
A trigger-based middleware cache for ORMs
Middleware'11 Proceedings of the 12th ACM/IFIP/USENIX international conference on Middleware
A trigger-based middleware cache for ORMs
Proceedings of the 12th International Middleware Conference
TileHeat: a framework for tile selection
Proceedings of the 20th International Conference on Advances in Geographic Information Systems
WISE'12 Proceedings of the 13th international conference on Web Information Systems Engineering
Memory-Efficient index for cache invalidation mechanism with OpenJPA
WISE'12 Proceedings of the 13th international conference on Web Information Systems Engineering
Cache augmented database management systems
Proceedings of the ACM SIGMOD Workshop on Databases and Social Networks
| Hi-index | 0.00 |
Many applications today run in a multi-tier environmentwith browser-based clients, mid-tier (application)servers and a backend database server.Mid-tier databasecaching attempts to improve system throughput and scalabilityby offloading part of the database workload to intermediatedatabase servers that partially replicate datafrom the backend server.The fact that some queries areoffloaded to an intermediate server should be completelytransparent to applications - one of the key distinctionsbetween caching and replication.MTCache is a prototypemid-tier database caching solution for SQL Server thatachieves this transparency.It builds on SQL Server's supportfor materialized views, distributed queries and replication.This paper describes MTCache and reportsexperimental results on the TPC-W benchmark.The experimentsshow that a significant part of the query workloadcan be offloaded to cache servers, resulting in greatlyimproved scale-out on the read-dominated workloads ofthe benchmark.Replication overhead was small with anaverage replication delay of less than two seconds.