PARINDA: An Interactive Physical Designer for PostgreSQL

Source: Association for Computing Machinery

Favorite

Free registration required

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.
Format:PDF Size:301.00
Date:Mar 2010
People who downloaded this item also downloaded