Database tuning principles, experiments, and troubleshooting techniques

  • Authors:
  • Dennis Shasha;Philippe Bonnet;Nancy Hartline Bercich

  • Affiliations:
  • -;-;-

  • Venue:
  • ACM SIGMOD Record
  • Year:
  • 2004

Quantified Score

Hi-index 0.00

Visualization

Abstract

As our reliance on computers and computerized data has increased, we have come to expect more from our computers. We no longer expect our computers to act as large expensive calculators that merely spit out bills and paychecks. We now, additionally, expect our systems to rapidly access and interactively present us with large volumes of accurate data. In fact, our expectations have changed so much, in the past decade, that we no longer focus on what our systems are but rather on what they do. We no longer refer to our systems as computer systems but rather information systems. With these new expectations have come new responsibilities for the information systems professional. We can no longer concern ourselves merely with keeping our systems up and running. We now need to concern ourselves with subjective concepts such as response time and throughput. With current expectations what they are, performance tuning has become vitally important.