Name
Abstract | ||
|---|---|---|
We introduce AdaptPD, an automated physical design tool that improves database performance by continuously monitoring changes in the workload and adapting the physical design to suit the incoming workload. Current physical design tools are offline and require specification of a representative workload. AdaptPD is "always on" and incorporates online algorithms which profile the incoming workload to calculate the relative benefit of transitioning to an alternative design. Efficient query and transition cost estimation modules allow AdaptPD to quickly decide between various design configurations. We evaluate AdaptPD with the SkyServer Astronomy database using queries submitted by SkyServer's users. Experiments show that AdaptPD adapts to changes in the workload, improves query performance substantially over offline tools, and introduces minor computational overhead. |
Year | DOI | Venue |
|---|---|---|
2009 | 10.1007/978-3-642-02279-1_11 | SSDBM |
Keywords | Field | DocType |
database performance,automated physical design tool,skyserver astronomy database,adaptpd adapts,current physical design tool,physical design,incoming workload,adaptive physical design,curated archives,alternative design,various design configuration,representative workload,user experience,cost estimation,online algorithm | Data mining,Overhead (computing),Online algorithm,Database tuning,Computer science,Workload,Cost estimate,Physical design,Database,Query plan | Conference |
Volume | ISSN | Citations |
5566 | 0302-9743 | 5 |
PageRank | References | Authors |
0.43 | 19 | 6 |
Name | Order | Citations | PageRank |
|---|---|---|---|
| Tanu Malik | 1 | 304 | 35.97 |
| Xiaodan Wang | 2 | 326 | 32.31 |
| Debabrata Dash | 3 | 242 | 13.27 |
| Amitabh Chaudhary | 4 | 185 | 19.77 |
| Anastasia Ailamaki | 5 | 4178 | 349.12 |
| Randal Burns | 6 | 1955 | 115.15 |