×
Log in to StudySoup
Get Full Access to Applied Statistics And Probability For Engineers - 6 Edition - Chapter 3.4 - Problem 69e
Join StudySoup for FREE
Get Full Access to Applied Statistics And Probability For Engineers - 6 Edition - Chapter 3.4 - Problem 69e

Already have an account? Login here
×
Reset your password

Solved: An article in the Journal of Database Management

Applied Statistics and Probability for Engineers | 6th Edition | ISBN: 9781118539712 | Authors: Douglas C. Montgomery, George C. Runger ISBN: 9781118539712 55

Solution for problem 69E Chapter 3.4

Applied Statistics and Probability for Engineers | 6th Edition

  • Textbook Solutions
  • 2901 Step-by-step solutions solved by professors and subject experts
  • Get 24/7 help from StudySoup virtual teaching assistants
Applied Statistics and Probability for Engineers | 6th Edition | ISBN: 9781118539712 | Authors: Douglas C. Montgomery, George C. Runger

Applied Statistics and Probability for Engineers | 6th Edition

4 5 1 257 Reviews
11
3
Problem 69E Problem 69E

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 Transaction Processing Performance Council’s Version C On-Line Transaction Processing (TPC-C OLTP) 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 of 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.

Step-by-Step Solution:

Solution:

Step 1 of 3:

Here the data regarding the frequency of each type of transactions is given.

Transaction

Frequency

Selects

Updates

Inserts

Delets

Nonunique selects

Joins

New order

43

23

11

12

0

0

0

Payment

44

4.2

3

1

0

0.6

0

Old status

4

11.4

0

0

0

0.6

0

Delivery

5

130

120

0

10

0

0

Stock level

4

0

0

0

0

0

1

Using this we need to find the required values.


Step 2 of 3

Chapter 3.4, Problem 69E is Solved
Step 3 of 3

Textbook: Applied Statistics and Probability for Engineers
Edition: 6
Author: Douglas C. Montgomery, George C. Runger
ISBN: 9781118539712

Other solutions

People also purchased

Related chapters

Unlock Textbook Solution

Enter your email below to unlock your verified solution to:

Solved: An article in the Journal of Database Management