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 Processin 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 Inserts Deletes Non-unique Joins Selects New order 43 23 11 12 Payment 44 4.2 1 0.6 Order Status 4 11.4 0.6 Delivery 5 130 120 10 Stock Level 4 1 The frequency of each type of transaction (in the second column) can be used as the percentage of each type o 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: (c) P(X < 6, Y < 6|Z = 0) = Round your answer to three decimal places (e. i 98.765). (d) E(X | Y = 0, Z = 0) Round your answer to one decimal place (e.g. 98.7) i

A First Course in Probability (10th Edition)
10th Edition
ISBN:9780134753119
Author:Sheldon Ross
Publisher:Sheldon Ross
Chapter1: Combinatorial Analysis
Section: Chapter Questions
Problem 1.1P: a. How many different 7-place license plates are possible if the first 2 places are for letters and...
icon
Related questions
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.
Average frequencies and operations in TPC-c
Transaction
Frequency Selects Updates Inserts Deletes Non-unique Joins
Selects
New order
43
23
11
12
Payment
44
4.2
3.
0.6
Order Status 4
11.4
0.6
Delivery
5
130
120
10
Stock Level
4
1
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:
(c) P(X < 6, Y < 6|Z = 0) =
Round your answer to three decimal places (e.g.
i
98.765).
(d) E(X | Y = 0, Z = 0)
Round your answer to one decimal place (e.g. 98.7).
Transcribed Image Text: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. Average frequencies and operations in TPC-c Transaction Frequency Selects Updates Inserts Deletes Non-unique Joins Selects New order 43 23 11 12 Payment 44 4.2 3. 0.6 Order Status 4 11.4 0.6 Delivery 5 130 120 10 Stock Level 4 1 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: (c) P(X < 6, Y < 6|Z = 0) = Round your answer to three decimal places (e.g. i 98.765). (d) E(X | Y = 0, Z = 0) Round your answer to one decimal place (e.g. 98.7).
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps with 2 images

Blurred answer
Similar questions
Recommended textbooks for you
A First Course in Probability (10th Edition)
A First Course in Probability (10th Edition)
Probability
ISBN:
9780134753119
Author:
Sheldon Ross
Publisher:
PEARSON
A First Course in Probability
A First Course in Probability
Probability
ISBN:
9780321794772
Author:
Sheldon Ross
Publisher:
PEARSON