An Online Approach to Physical Design Tuning

11 years 7 months ago
An Online Approach to Physical Design Tuning
There has been considerable work on automated physical design tuning for database systems. Existing solutions require offline invocations of the tuning tool and depend on DBAs identifying representative workloads manually. In this work, we propose an alternative approach to the physical design problem. Specifically, we design algorithms that are always-on and continuously modify the current physical design reacting to changes in the query workload. Our techniques have low overhead and take into account storage constraints, update statements, and the cost to create temporary physical structures.
Nicolas Bruno, Surajit Chaudhuri
Added 01 Nov 2009
Updated 01 Nov 2009
Type Conference
Year 2007
Where ICDE
Authors Nicolas Bruno, Surajit Chaudhuri
Comments (0)