Tuning database design for high performance

Philippe Bonnet, Dennis Shasha

Research output: Chapter in Book/Report/Conference proceedingChapter

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 languageEnglish (US)
Title of host publicationComputing Handbook, Third Edition
Subtitle of host publicationInformation Systems and Information Technology
PublisherCRC Press
Pages9-1-9-15
ISBN (Electronic)9781439898567
ISBN (Print)9781439898543
DOIs
StatePublished - Jan 1 2014

Fingerprint

Database Design
Tuning
High Performance
Register Allocation
Arbitrage
Tuners
Database Systems
Compiler
Software System
Computer Science
Computer science
Hardware
Engineering
Sensor
Optimization
Sensors
Processing

ASJC Scopus subject areas

  • Mathematics(all)
  • Computer Science(all)

Cite this

Bonnet, P., & Shasha, D. (2014). Tuning database design for high performance. In Computing Handbook, Third Edition: Information Systems and Information Technology (pp. 9-1-9-15). CRC Press. https://doi.org/10.1201/b16768

Tuning database design for high performance. / Bonnet, Philippe; Shasha, Dennis.

Computing Handbook, Third Edition: Information Systems and Information Technology. CRC Press, 2014. p. 9-1-9-15.

Research output: Chapter in Book/Report/Conference proceedingChapter

Bonnet, P & Shasha, D 2014, Tuning database design for high performance. in Computing Handbook, Third Edition: Information Systems and Information Technology. CRC Press, pp. 9-1-9-15. https://doi.org/10.1201/b16768
Bonnet P, Shasha D. Tuning database design for high performance. In Computing Handbook, Third Edition: Information Systems and Information Technology. CRC Press. 2014. p. 9-1-9-15 https://doi.org/10.1201/b16768
Bonnet, Philippe ; Shasha, Dennis. / Tuning database design for high performance. Computing Handbook, Third Edition: Information Systems and Information Technology. CRC Press, 2014. pp. 9-1-9-15
@inbook{c6a298878b2e4568a298310d7e75ff12,
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 = "1",
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

SN - 9781439898543

SP - 9-1-9-15

BT - Computing Handbook, Third Edition

PB - CRC Press

ER -