Sciweavers

EDBT
2010
ACM

PARINDA: an interactive physical designer for PostgreSQL

14 years 2 months ago
PARINDA: an interactive physical designer for PostgreSQL
One of the most challenging tasks for the database administrator is to physically design the database to attain optimal performance for a given workload. Physical design is hard because it requires the selection of an optimal set of design features from a vast search space. There have been many commercial tools available to automatically suggest the physical design, for a given a set of queries. These tools are, however, based on greedy heuristic pruning, which reduces their usefulness. Furthermore, they are not interactive, as the APIs to simulate the indexes and tables are product specific and hidden from the database administrators. Finally, all these tools are built specifically for commercial systems and there is lack of automated physical designers for open source DBMSs. In this demonstration we introduce
Cristina Maier, Debabrata Dash, Ioannis Alagiannis
Added 13 Oct 2010
Updated 13 Oct 2010
Type Conference
Year 2010
Where EDBT
Authors Cristina Maier, Debabrata Dash, Ioannis Alagiannis, Anastasia Ailamaki, Thomas Heinis
Comments (0)