The Case for Predictive Database Systems: Opportunities and Challenges

This paper argues that next generation database management systems should incorporate a predictive model management component to effectively support both inward-facing applications, such as self management, and user-facing applications such as data-driven predictive analytics. We draw an analogy between model management and data management functionality and discuss how model management can leverage profiling, physical design and query optimization techniques, as well as the pertinent challenges. We then describe the early design and architecture of Longview, a predictive DBMS prototype that we are building at Brown, along with a case study of how models can be used to predict query execution performance.

• Type: Journal
• Year: 2011
• Where: CIDR
• Authors: Mert Akdere, Ugur Çetintemel, Matteo Riondato, Eli Upfal, Stanley B. Zdonik
• Keywords: Algorithms, CIDR 2011, Database Management Systems, Execution Performance, Query Optimization Techniques