An article in the Journal of Database Management [Experimental Study of a Self-T

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 TPC-C OLTP (Transaction Processing Performance Council's Version C On-Line Transaction Processing) benchmark, which simulates a typical order entry application Transaction Frequency Selects Updates Inserts Deletes Non-Unique Selects Joins New Order Payment Order Status Delivery Stock Level 9 12 0 0.6 0.6 0 0 0 43 5 4 4 1.6 3.5 135 0 197 10 5 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. Let A denote the event of transactions with an average number of selects operations of 12 or fewer. Let B denote the event of transactions with an average number of updates operations of 12 or fewer. Calculate the following probabilities. Round your answers to four decimal places (e.g. 98.7654) (a) P(A) (b) PB) (c) PAn B) (d) PAn B' (e) PIAu B)

Explanation / Answer

total frequency =44+43+5+4+4=100

a)P(A)=P( of select less then 12) =(43+5+4)/100=0.52

b)P(B) =(44+43+5+4)/100 =0.96

c)P(AnB) =(43+5+4)/100 =0.52

d)P(AnB') =0.96-0.52=0.44

e)P(AUB) =0.96

please revert .

Related Questions

Navigate

• Browse (All)
• Browse A
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.