$2\mathrm{.}3\mathrm{.}10.$WP 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

Council$$s Version C On$-$Line Transaction Processing$)$ benchmark,

which simulates a typical order entry application.

Average Frequencies and Operations in TPC$-$C

Transaction Frequency Selects Updates

New order $432311$

Payment $444\mathrm{.}23$

Order status $411\mathrm{.}40$

Delivery $5130120$

Stock level $400$

The frequency of each type of transaction $($in the second

column$)$ can be used as the percentage of each type of transac$-$

tion. The average number of selects operations required for each

type of transaction is shown. Let A denote the event of trans$-$

actions with an average number of selects operations of $12$ or

fewer. Let B denote the event of transactions with an average num$-$

ber of updates operations of $12$ or fewer. Calculate the following

probabilities.

a$.$ P$($A$)$ b$.$ P$($B$)$ c$.$ P$($A $\backslash$cap B$)$

d$.$ P$($A $\backslash$cap B$$

$)$ e$.$ P$($A $\backslash$cup B$)$