1.
The performance of a database system is measured using the
following parameters:
- Throughput: It is measured as the system's ability to process
data. It depends of the CPU speed and I/O and will get impacted by
the parallel processing o the database server.
- Query optimization: This is used to speed up and reduce the
time taken for executing queries.
- Workload: Workload is the activity the DBMS is requested to
perform, which drives the processing demands placed on the system.
The workload can include a combination of transactions, batch jobs,
ad hoc queries, reporting and analysis applications, database
utilities and system commands.
- Contention: This happens when the demand is skewed. As
contention increases, throughput decreases.
Response time is defined as the time taken to run a single task,
whereas throughput is defined as the number of tasks completed in
one unit of time.