5.1.6 WP 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) bench- mark, which simulates a typical order entry application. See the table at the bottom of the page. The frequency of each type of transaction (in the second column) can be used as the percentage of each type of transaction. Let X and Y denote the average num- ber of selects and updates operations, respectively, required for each type transaction. 5.4.4 For the Transaction Processing Performance Council's benchmark in Exercise 5.1.6, 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: a. Correlation between X and Y b. Correlation between X and Z Average Frequencies and Operations in TPC-C Frequency Selects 43 23.0 44 4.2 4 11.4 5 130.0 4 0 Transaction New order Payment Order status Delivery Stock level Updates Inserts 11 12 3 0 120 0 1 0 0 0 Deletes 0 0 0 10 0 Non-unique Selects 0.6 T 0.6 Joins 0 0 0 0 1

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
5.1.6 WP 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) bench-
mark, which simulates a typical order entry application. See the
table at the bottom of the page. The frequency of each type of
transaction (in the second column) can be used as the percentage
of each type of transaction. Let X and Y denote the average num-
ber of selects and updates operations, respectively, required for
each type transaction.
5.4.4 For the Transaction Processing Performance Council's
benchmark in Exercise 5.1.6, 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:
a. Correlation between X and Y
b. Correlation between X and Z
Average Frequencies and Operations in TPC-C
Frequency Selects
43
23.0
44
4.2
4
11.4
5
130.0
0
4
Transaction
New order
Payment
Order status
Delivery
Stock level
Updates Inserts
11
12
1
0
0
0
3
0
120
0
Deletes
0
0
0
10
0
Non-unique Selects
0
0.6
0.6
0
0
Joins
0
0
0
0
1
Transcribed Image Text:5.1.6 WP 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) bench- mark, which simulates a typical order entry application. See the table at the bottom of the page. The frequency of each type of transaction (in the second column) can be used as the percentage of each type of transaction. Let X and Y denote the average num- ber of selects and updates operations, respectively, required for each type transaction. 5.4.4 For the Transaction Processing Performance Council's benchmark in Exercise 5.1.6, 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: a. Correlation between X and Y b. Correlation between X and Z Average Frequencies and Operations in TPC-C Frequency Selects 43 23.0 44 4.2 4 11.4 5 130.0 0 4 Transaction New order Payment Order status Delivery Stock level Updates Inserts 11 12 1 0 0 0 3 0 120 0 Deletes 0 0 0 10 0 Non-unique Selects 0 0.6 0.6 0 0 Joins 0 0 0 0 1
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 4 steps

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