Database Tuning.

Dennis Shasha, Steve Rozen: Database Tuning. VLDB 1992: 313
  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,}


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:
  1. How much main memory should you buy?
  2. What concurrency level of consistency should you use?
  3. For what queries is a non-clustering index better than a clustering one?
  4. 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:

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

ACM SIGMOD Anthology

CDROM Version: Load the CDROM "Volume 1 Issue 5, VLDB '89-'97" and ... DVD Version: Load ACM SIGMOD Anthology DVD 1" and ...

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 CiteSeerX Google scholar BibTeX bibliographical record in XML

Copyright © Tue Mar 16 02:22:02 2010 by Michael Ley (