|
| This Article | ||
| ||
| Share | ||
| Bibliographic References | ||
| Add to: | ||
| | ||
| Search | ||
| ||
19th International Conference on Data Engineering (ICDE'03)
Automating Layout of Relational Databases
Bangalore, India
March 05-March 08
ISBN: 0-7803-7665-X
| ASCII Text | x | ||
| Sanjay Agrawal, Surajit Chaudhuri, Abhinandan Das, Vivek Narasayya, "Automating Layout of Relational Databases," Data Engineering, International Conference on, pp. 607, 19th International Conference on Data Engineering (ICDE'03), 2003. | |||
| BibTex | x | ||
| @article{ 10.1109/ICDE.2003.1260825, author = {Sanjay Agrawal and Surajit Chaudhuri and Abhinandan Das and Vivek Narasayya}, title = {Automating Layout of Relational Databases}, journal ={Data Engineering, International Conference on}, volume = {0}, year = {2003}, issn = {1063-6382}, pages = {607}, doi = {http://doi.ieeecomputersociety.org/10.1109/ICDE.2003.1260825}, publisher = {IEEE Computer Society}, address = {Los Alamitos, CA, USA}, } | |||
| RefWorks Procite/RefMan/Endnote | x | ||
| TY - CONF JO - Data Engineering, International Conference on TI - Automating Layout of Relational Databases SN - 1063-6382 SP EP A1 - Sanjay Agrawal, A1 - Surajit Chaudhuri, A1 - Abhinandan Das, A1 - Vivek Narasayya, PY - 2003 KW - null VL - 0 JA - Data Engineering, International Conference on ER - | |||
The choice of database layout, i.e., how database objects such as tables and indexes are assigned to disk drives can significantly impact the I/O performance of the system. Today, DBAs typically rely on fully striping objects across all available disk drives as the basic mechanism for optimizing I/O performance. While full striping maximizes I/O parallelism, when query execution involves co-access of two or more large objects, e.g., a merge join of two tables, the above strategy may be sub-optimal due to the increased number of random I/O accesses on each disk drive. In this paper, we propose a framework for automating the choice of database layout for a given database that also takes into account the effects of co-accessed objects in the workload faced by the system. We formulate the above as an optimization problem and present an efficient solution to the problem that judiciously takes into account the trade-off between I/O parallelism and random I/O accesses. Our experiments on Microsoft SQL Server show the superior I/O performance of our techniques compared to the traditional approach of fully striping each database object across all disk drives.
Citation:
Sanjay Agrawal, Surajit Chaudhuri, Abhinandan Das, Vivek Narasayya, "Automating Layout of Relational Databases," icde, pp.607, 19th International Conference on Data Engineering (ICDE'03), 2003
Usage of this product signifies your acceptance of the Terms of Use.
