Encyclopedia of Database Systems

2018 Edition
| Editors: Ling Liu, M. Tamer Özsu

Physical Layer Tuning

  • Philippe Bonnet
  • Dennis Shasha
Reference work entry
DOI: https://doi.org/10.1007/978-1-4614-8265-9_268

Definition

Tuning the physical layer entails choosing and configuring the underlying hardware and operating system to improve the performance of a database system running a given set of applications.

Historical Background

Ultimately, a database management system runs on processor and memory chips as well as secondary devices such as flash memory and disks. Trying to use those physical resources in the best way possible has been a problem since the first databases were available. Many researchers have noticed that disk capacity has been less of an issue than disk speed (or aggregate bandwidth from an entire disk array). Main memory size has always been a critical factor, because accesses to main memory are so much faster than accesses to disk. Processor speed has been important in applications that mix sophisticated computation with data access (for example in financial analysis), such computations are often handled outside the database server. New technologies have improved the...

This is a preview of subscription content, log in to check access.

Recommended Reading

  1. 1.
    Gray J, Kukol P. Sequential disk IO tests for GBps land speed record. MS Research Technical Report MSR-TR-2004-62.Google Scholar
  2. 2.
    Gray J, Shanoy PJ. Rules of thumb in data engineering. In: Proceedings of the 18th International Conference on Data Engineering; 2000.Google Scholar
  3. 3.
    Hall C, Bonnet Ph. Getting priorities straight: improving Linux support for database I/O. In: Proceedings of the 31st International Conference on Very Large Data Bases; 2005.Google Scholar
  4. 4.
    Shasha D, Bonnet P. Database tuning: principles, experiments and troubleshooting techniques. San Francisco: Morgan Kaufmann; 2002.Google Scholar

Copyright information

© Springer Science+Business Media, LLC, part of Springer Nature 2018

Authors and Affiliations

  1. 1.Department of Computer ScienceIT University of CopenhagenCopenhagenDenmark
  2. 2.Department of Computer ScienceNew York UniversityNew YorkUSA

Section editors and affiliations

  • Dennis Shasha
    • 1
  1. 1.Dep. of Computer ScienceNew York Univ.New YorkUSA