Database Tuning.
Dennis Shasha, Steve Rozen:
Database Tuning.
VLDB 1992: 313@inproceedings{DBLP:conf/vldb/ShashaR92,
author = {Dennis Shasha and
Steve Rozen},
editor = {Li-Yan Yuan},
title = {Database Tuning},
booktitle = {18th International Conference on Very Large Data Bases, August
23-27, 1992, Vancouver, Canada, Proceedings},
publisher = {Morgan Kaufmann},
year = {1992},
isbn = {1-55860-151-1},
pages = {313},
ee = {db/conf/vldb/ShashaR92.html},
crossref = {DBLP:conf/vldb/92},
bibsource = {DBLP, http://dblp.uni-trier.de}
}
BibTeX
Abstract
Database tuning is the activity of making a database application run more quickly.
Tuning is difficult because it requires global knowledge of an information system, from the hardware to the operating system to the transaction subsystem to the query language to the application.
This tutorial will discuss the principles of tuning in a way that can be immediately applied.
Some typical questions it will address are:
- How much main memory should you buy?
- What concurrency level of consistency should you use?
- For what queries is a non-clustering index better than a clustering one?
- How should you partition a hot table and its indexes across disks in read-intensive and write-intensive applications?
The tutorial will cover the following:
- Four general tuning principles
- Tuning the hardware, operating system, and transaction subsystem
- Choosing indexes
- Relational system tuning
Copyright © 1992 by the VLDB Endowment.
Permission to copy without fee all or part of this material is granted provided that the copies are not made or
distributed for direct commercial advantage, the VLDB
copyright notice and the title of the publication and
its date appear, and notice is given that copying
is by the permission of the Very Large Data Base
Endowment. To copy otherwise, or to republish, requires
a fee and/or special permission from the Endowment.
Online Paper
CDROM Version: Load the CDROM "Volume 1 Issue 5, VLDB '89-'97" and ...
DVD Version: Load ACM SIGMOD Anthology DVD 1" and ...
BibTeX
Printed Edition
Li-Yan Yuan (Ed.):
18th International Conference on Very Large Data Bases, August 23-27, 1992, Vancouver, Canada, Proceedings.
Morgan Kaufmann 1992, ISBN 1-55860-151-1
Contents BibTeX
BibTeX
ACM SIGMOD Anthology - DBLP:
[Home | Search: Author, Title | Conferences | Journals]
VLDB Proceedings: Copyright © by VLDB Endowment,
ACM SIGMOD Anthology: Copyright © by ACM (info@acm.org), Corrections: anthology@acm.org
DBLP: Copyright © by Michael Ley (ley@uni-trier.de), last change: Sat May 16 23:45:52 2009