An article in the Journal of Database Management [Experimental Study of a Self-Tuning
Chapter 3, Problem 3-59(choose chapter or problem)
An article in the Journal of Database Management [Experimental Study of a Self-Tuning Algorithm for DBMS Buffer Pools (2005, Vol. 16, pp. 120)] provided the workload used in the TPC-C OLTP (Transaction Processing Performance Councils 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. The average number of selects operations required for each type 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.
Unfortunately, we don't have that question answered yet. But you can get it answered in just 5 hours by Logging in or Becoming a subscriber.
Becoming a subscriber
Or look for another answer