Name
Abstract | ||
|---|---|---|
The performance of a database system depends strongly on the layout of database objects, such as indexes or tables, onto the underlying storage devices. A good layout will both balance the I/O workload generated by the database system and avoid the performance-degrading interference that can occur when concurrently accessed objects are stored on the same volume. In current practice, layout is typically guided by heuristics and rules of thumb, such as separating indexes and tables or striping all objects across all of the available storage devices. However, these guidelines may give poor results. In this paper, we address the problem of generating an optimized layout of a given set of database objects. Our layout optimizer goes beyond generic guidelines by making use of a description of the database system's I/O activity. We formulate the layout problem as a non-linear programming (NLP) problem and use the I/O description as input to an NLP solver. Our layout optimization technique, which is incorporated into a database layout advisor, identifies a layout that both balances load and avoids interference. We evaluate experimentally the efficacy of our approach and demonstrate that it can quickly identify non-trivial optimized layouts. |
Year | DOI | Venue |
|---|---|---|
2010 | 10.1145/1807167.1807268 | SIGMOD Conference |
Keywords | Field | DocType |
database object,workload-aware storage layout,o activity,layout optimizer,database system,layout problem,database layout advisor,optimized layout,non-trivial optimized layout,layout optimization technique,good layout,rule of thumb,physical design,indexation,non linear programming,storage system,layout | Data mining,Layout,Computer science,Layout Versus Schematic,IC layout editor,Database design,Heuristics,Rule of thumb,Physical design,Solver,Database | Conference |
Citations | PageRank | References |
15 | 0.72 | 18 |
Authors | ||
4 | ||
Name | Order | Citations | PageRank |
|---|---|---|---|
| Oguzhan Ozmen | 1 | 26 | 1.83 |
| Kenneth Salem | 2 | 906 | 235.03 |
| Jiri Schindler | 3 | 411 | 26.82 |
| Steve Daniel | 4 | 15 | 0.72 |