UTCache: Updatable Transactional Cache For Database-Driven Applications
Most popular applications rely on the remote database server for data storage. In response to usersâErequests, applications interactively read or update the data in databases through DML like SQL. Caching database results can eliminate the network latency of remote access but also may violate transaction isolation provided by the database. To avoid anomalies caused by the cache, existing works designed transactional cache, which can manage concurrent access to cache entries and invalidate stale ones automatically. For some OLTP workloads with frequent updates, invalidation will reduce the cache hit ratio and hurt performance. To handle these workloads better, we propose UTCache, a transactional cache that supports updating stale entries. UTCache caches database results in different ways according to the characteristic of queries. After the data in the database is modified, it will automatically update the affected cache entries without re-execution if possible. Updating the stale cached entries can avoid cache miss caused by invalidation. Our evaluation shows that in typical OLTP workloads, TPC-C and SmallBank, UTCache can outperform invalidation-based cache a lot and achieve higher throughput with lower latency and network traffic.
Fri 9 DecDisplayed time zone: Osaka, Sapporo, Tokyo change
09:20 - 10:30 | Microservices and WebERA - Early Research Achievements / Technical Track at Room2 Chair(s): Norihiro Yoshida Ritsumeikan University | ||
09:20 15mPaper | Testing for Event-Driven Microservices Based on Consumer-Driven Contracts and State Models ERA - Early Research Achievements Chu-Fei Wu National Taiwan Ocean University, Shang-Pin Ma National Taiwan Ocean University, An-Chi Shau National Taiwan Ocean University, Hang-Wei Yeh National Taiwan Ocean University | ||
09:35 15mPaper | Analyzing and Monitoring Kubernetes Microservices based on Distributed Tracing and Service Mesh ERA - Early Research Achievements Yu-Te Wang National Taiwan Ocean University, Shang-Pin Ma National Taiwan Ocean University, Yue-Jun Lai National Taiwan Ocean University, Yan-Cih Liang National Taiwan Ocean University | ||
09:50 15mPaper | Managing Complexity in Microservices Architecture: A Nested MultiTree Domain-Driven Approach ERA - Early Research Achievements Duc Minh Le Swinburne Vietnam, FPT University | ||
10:05 20mPaper | UTCache: Updatable Transactional Cache For Database-Driven Applications Technical Track |