Cache tables: paving the way for an adaptive database cache

Authors:
Mehmet Altinel;Christof Bornhövd;Sailesh Krishnamurthy;C. Mohan;Hamid Pirahesh;Berthold Reinwald
Affiliations:
IBM Almaden Research Center, San Jose, CA;IBM Almaden Research Center, San Jose, CA;Comp. Sci. Div, Dept EECS, UC Berkeley, Berkeley, CA;IBM Almaden Research Center, San Jose, CA;IBM Almaden Research Center, San Jose, CA;IBM Almaden Research Center, San Jose, CA
Venue:
VLDB '03 Proceedings of the 29th international conference on Very large data bases - Volume 29
Year:
2003

Citing 16
Cited 38

Query caching and optimization in distributed mediator systems

SIGMOD '96 Proceedings of the 1996 ACM SIGMOD international conference on Management of data
Client-server caching revisited

Readings in database systems (3rd ed.)
Materialized views: techniques, implementations, and applications

Materialized views: techniques, implementations, and applications
Answering complex SQL queries using automatic summary tables

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
Loading a Cache with Query Results

VLDB '99 Proceedings of the 25th 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
Caching Technologies for Web Applications

Proceedings of the 27th International Conference on Very Large Data Bases
A Comparative Study of Alternative Middle Tier Caching Solutions to Support Dynamic Web Content Acceleration

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
DBCache: middle-tier database caching for highly scalable e-business architectures

Proceedings of the 2003 ACM SIGMOD international conference on Management of data

MTCache: Transparent Mid-Tier Database Caching in SQL Server

ICDE '04 Proceedings of the 20th International Conference on Data Engineering
Challenges and practices in deploying web acceleration solutions for distributed enterprise systems

Proceedings of the 13th international conference on World Wide Web
Proxy-based acceleration of dynamically generated content on the world wide web: An approach and implementation

ACM Transactions on Database Systems (TODS)
Exploring the tradeoff between performance and data freshness in database-driven Web servers

The VLDB Journal — The International Journal on Very Large Data Bases
On demand synchronization and load distribution for database grid-based web applications

Data & Knowledge Engineering
Ganymed: scalable replication for transactional web applications

Proceedings of the 5th ACM/IFIP/USENIX international conference on Middleware
Caching with "good enough" currency, consistency, and completeness

VLDB '05 Proceedings of the 31st international conference on Very large data bases
Simultaneous scalability and security for data-intensive web applications

Proceedings of the 2006 ACM SIGMOD international conference on Management of data
Performance and overhead of semantic cache management

ACM Transactions on Internet Technology (TOIT)
Consistency-preserving caching of dynamic database content

Proceedings of the 16th international conference on World Wide Web
Load balancing and data placement for multi-tiered database systems

Data & Knowledge Engineering
Improving mobile database access over wide-area networks without degrading consistency

Proceedings of the 5th international conference on Mobile systems, applications and services
Improving parallelism of federated query processing

Data & Knowledge Engineering
Alternative data storage solution for mobile messaging services

Mobile Information Systems
Extending DBMSs with satellite databases

The VLDB Journal — The International Journal on Very Large Data Bases
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
Scalable query result caching for web applications

Proceedings of the VLDB Endowment
A survey on dynamic Web content generation and delivery techniques

Journal of Network and Computer Applications
Optimizing Maintenance of Constraint-Based Database Caches

ADBIS '09 Proceedings of the 13th East European Conference on Advances in Databases and Information Systems
Implementation and performance of a dynamic-content based cache for a backend database server

SE '08 Proceedings of the IASTED International Conference on Software Engineering
Caching and Materialization for Web Databases

Foundations and Trends in Databases
Sync kit: a persistent client-side database caching toolkit for data intensive websites

Proceedings of the 19th international conference on World wide web
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
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
Consistent caching of data objects in database driven websites

ADBIS'10 Proceedings of the 14th east European conference on Advances in databases and information systems
Consistent cache maintenance for database driven websites

ICWE'10 Proceedings of the 10th international conference on Current trends in web engineering
Graph based query trimming algorithm for relational data semantic cache

Proceedings of the International Conference on Management of Emergent Digital EcoSystems
Site-autonomous distributed semantic caching

Proceedings of the 2011 ACM Symposium on Applied Computing
Improving the performance of semantic web applications with SPARQL query caching

ESWC'10 Proceedings of the 7th international conference on The Semantic Web: research and Applications - Volume Part II
XML databases and beyond-plenty of architectural challenges ahead

ADBIS'05 Proceedings of the 9th East European conference on Advances in Databases and Information Systems
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
Mobile learning support with statistical inference-based cache management

ICWL'07 Proceedings of the 6th international conference on Advances in web based learning
Managing a fragmented XML data cube with oracle and timesten

Proceedings of the fifteenth international workshop on Data warehousing and OLAP
Cache augmented database management systems

Proceedings of the ACM SIGMOD Workshop on Databases and Social Networks

Quantified Score

Hi-index	0.00

Visualization

Abstract

We introduce a new database object called Cache Table that enables persistent caching of the full or partial content of a remote database table. The content of a cache table is either defined declaratively and populated in advance at setup time, or determined dynamically and populated on demand at query execution time. Dynamic cache tables exploit the characteristics of typical transactional web applications with a high volume of short transactions, simple equality predicates, and 3-4 way joins. Based on federated query processing capabilities, we developed a set of new technologies for database caching: cache tables, "Janus" (two-headed) query execution plans, cache constraints, and asynchronous cache population methods. Our solution supports transparent caching both at the edge of content-delivery networks and in the middle-tier of an enterprise application infrastructure, improving the response time, throughput and scalability of transactional web applications.