PhD seminar • Apollo: Learning Database Query Correlations for Predictive Caching

Brad Glasbergen, PhD candidate
David R. Cheriton School of Computer Science

The performance of modern database applications is increasingly dependent on remote access latencies. The worldwide distribution of users results in significant latency for clients that are distant from the application's data center. Systems that reduce latencies by caching query data closer to clients are becoming more popular but do not take advantage of application-specific behaviour patterns. In this talk, I will present Apollo, a system that learns database query patterns and exploits them to enhance query performance via predictive caching. Experiments demonstrate Apollo's efficacy as a predictive cache for geo-distributed database applications.