Database System Concepts
Database System Concepts
7th Edition
ISBN: 9780078022159
Author: Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher: McGraw-Hill Education
Question
Book Icon
Chapter 25, Problem 11E
Program Plan Intro

  Performance tuning:

  • Performance tuning improves the performance of the system.
  • It helps in increasing the volume of the data which can be processed quickly.
  • Also, performance of the system depends on how much load any system can hold.
  • Hence performance tuning refers to increasing the load of the system without any decrease in performance.
  • Thus performance tuning refers to change the original system in a way that it can take more load with the same performance.

  Hardware tuning:

  • For viewing the performance of the system, many things are taken into consideration.
  • Hardware plays an important role in performance of the system.
  • Therefore, hardware tuning refers to the change in the hardware devices of the system so that the after changing it, the performance must be improved.
  • The hardware tuning can be implemented by increasing hardware capacity, hardware processing speed or any other performance factors.

  Transaction tuning:

  • Transaction refers to performing various actions of data accessing, data size, data form that is how the data is stored.
  • Transaction tuning refers to change in the data related tasks so that it can be done for efficiently than original one.

Blurred answer
Knowledge Booster
Background pattern image
Recommended textbooks for you
Text book image
Database System Concepts
Computer Science
ISBN:9780078022159
Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:McGraw-Hill Education
Text book image
Starting Out with Python (4th Edition)
Computer Science
ISBN:9780134444321
Author:Tony Gaddis
Publisher:PEARSON
Text book image
Digital Fundamentals (11th Edition)
Computer Science
ISBN:9780132737968
Author:Thomas L. Floyd
Publisher:PEARSON
Text book image
C How to Program (8th Edition)
Computer Science
ISBN:9780133976892
Author:Paul J. Deitel, Harvey Deitel
Publisher:PEARSON
Text book image
Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781337627900
Author:Carlos Coronel, Steven Morris
Publisher:Cengage Learning
Text book image
Programmable Logic Controllers
Computer Science
ISBN:9780073373843
Author:Frank D. Petruzella
Publisher:McGraw-Hill Education