Tuning database design for high performance

Philippe Bonnet; Dennis Shasha

doi:10.1201/b16768

Tuning database design for high performance

Research output: Chapter in Book/Report/Conference proceeding › Chapter

Abstract

In fields ranging from arbitrage to sensor processing, speed of access to data can determine success or failure. Database tuning is the activity of making a database system run faster. Like optimization activities in other areas of computer science and engineering, database tuning must work within certain constraints. Just as compiler optimizers, for example, cannot directly change the underlying hardware but can change register allocations, database tuners cannot change the underlying database management system software, but can make use of the options it offers.

Original language	English (US)
Title of host publication	Computing Handbook, Third Edition
Subtitle of host publication	Information Systems and Information Technology
Publisher	CRC Press
Pages	9-1-9-15
ISBN (Electronic)	9781439898567
ISBN (Print)	9781439898543
DOIs	https://doi.org/10.1201/b16768
State	Published - Jan 1 2014

ASJC Scopus subject areas

General Mathematics
General Computer Science

Access to Document

10.1201/b16768

Cite this

@inbook{ea36765441fb464480f2ce669428263a,

title = "Tuning database design for high performance",

abstract = "In fields ranging from arbitrage to sensor processing, speed of access to data can determine success or failure. Database tuning is the activity of making a database system run faster. Like optimization activities in other areas of computer science and engineering, database tuning must work within certain constraints. Just as compiler optimizers, for example, cannot directly change the underlying hardware but can change register allocations, database tuners cannot change the underlying database management system software, but can make use of the options it offers.",

author = "Philippe Bonnet and Dennis Shasha",

year = "2014",

month = jan,

day = "1",

doi = "10.1201/b16768",

language = "English (US)",

isbn = "9781439898543",

pages = "9--1--9--15",

booktitle = "Computing Handbook, Third Edition",

publisher = "CRC Press",

}

TY - CHAP

T1 - Tuning database design for high performance

AU - Bonnet, Philippe

AU - Shasha, Dennis

PY - 2014/1/1

Y1 - 2014/1/1

N2 - In fields ranging from arbitrage to sensor processing, speed of access to data can determine success or failure. Database tuning is the activity of making a database system run faster. Like optimization activities in other areas of computer science and engineering, database tuning must work within certain constraints. Just as compiler optimizers, for example, cannot directly change the underlying hardware but can change register allocations, database tuners cannot change the underlying database management system software, but can make use of the options it offers.

AB - In fields ranging from arbitrage to sensor processing, speed of access to data can determine success or failure. Database tuning is the activity of making a database system run faster. Like optimization activities in other areas of computer science and engineering, database tuning must work within certain constraints. Just as compiler optimizers, for example, cannot directly change the underlying hardware but can change register allocations, database tuners cannot change the underlying database management system software, but can make use of the options it offers.

UR - http://www.scopus.com/inward/record.url?scp=85054769986&partnerID=8YFLogxK

UR - http://www.scopus.com/inward/citedby.url?scp=85054769986&partnerID=8YFLogxK

U2 - 10.1201/b16768

DO - 10.1201/b16768

M3 - Chapter

AN - SCOPUS:85054769986

SN - 9781439898543

SP - 9-1-9-15

BT - Computing Handbook, Third Edition

PB - CRC Press

ER -

Tuning database design for high performance

Abstract

ASJC Scopus subject areas

Access to Document

Other files and links

Fingerprint

Cite this