Stanford InfoLab Publication Server

Proactive Re-optimization with Rio

Babu, Shivnath and Bizarro, Pedro and DeWitt, David (2005) Proactive Re-optimization with Rio. In: 24th ACM International Conference on Management of Data (SIGMOD 2005), June 14-16, 2005, Baltimore, Maryland.




Traditional query optimizers rely on the accuracy of estimated statistics of intermediate subexpressions to choose good query execution plans. This design often leads to suboptimal plan choices for complex queries since errors in estimates grow exponentially in the presence of skewed and correlated data distributions. We propose to demonstrate the <i>Rio</i> prototype database system that uses <i>proactive re-optimization</i> to address the problems with traditional optimizers. Rio supports three new techniques: <ol> <li>Intervals of uncertainty are considered around estimates of statistics during plan enumeration and costing </li> <li>These intervals are used to pick execution plans that are robust to deviations of actual values of statistics from estimated values, or to defer the choice of execution plan until the uncertainty in estimates can be resolved </li> <li> Statistics of intermediate subexpressions are collected quickly, accurately, and efficiently during query execution </li> </ol> These three features are fully functional in the current Rio prototype which is built using the <i>Predator</i> open-source DBMS. In this proposal, we first describe the novel features of Rio, then we use an example query to illustrate the main aspects of our demonstration.

Item Type:Conference or Workshop Item (Paper)
Uncontrolled Keywords:Adaptive query processing. Query optimization.
Subjects:Computer Science > Query Processing
Related URLs:Project Homepage
ID Code:710
Deposited By:Import Account
Deposited On:24 Mar 2005 16:00
Last Modified:22 Dec 2008 17:49

Download statistics

Repository Staff Only: item control page