An article in the Journal of Database Management "Experimental Study of a Self-Tuning Algorithm for DBMS Buffer Pools," (2005, Vol. 16, pp. 1-20) provided the workload used in the TPC-C OLTP (Transaction Processing Performance Council's Version C On-Line Transaction Processing) benchmark, which simulates a typical order entry application.
The frequency of each type of transaction (in the second column) can be used as the percentage of each type of transaction. Let X, Y, and Z denote the average number of selects, updates, and inserts operations required for each type of transaction, respectively. Calculate the following:
(a) Round your answer to three decimal places (e.g. 98.765).
(b) Round your answer to one decimal place (e.g. 98.7).