An article in the Journal of Database Management [Experimental Study of a Self-Tuning Algorithm for DBMS Buffer
Question:
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 Transaction Processing Performance Council’s Version C On-Line Transaction Processing (TPC-C OLTP) 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. The average number of selects operations required for each type of transaction is shown.
(a) Determine the mean and standard deviation of the number of selects operations for a transaction from the distribution of types shown in the table.
(b) Determine the mean and standard deviation of the total number of operations (selects, updates,…, and joins) for a transaction from the distribution of types shown in the table.
DistributionThe word "distribution" has several meanings in the financial world, most of them pertaining to the payment of assets from a fund, account, or individual security to an investor or beneficiary. Retirement account distributions are among the most...
Step by Step Answer:
Applied Statistics And Probability For Engineers
ISBN: 9781118539712
6th Edition
Authors: Douglas C. Montgomery, George C. Runger