Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

An article in the J , rnal of Database Management Experimental Study of a Self - Tuning Algorithm for DBMS Buffer Pools, ( 2 0

An article in the J, rnal of Database Management "Experimental Study of a Self-Tuning Algorithm for DBMS Buffer Pools," (2005, Vol. 16, pp.1-20) provicted 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
\table[[Transaction,Frequency,Selects,Updates,Inserts,Deles,,],[New order,43,23,11,12,0,0,0],[Payment,44,4.2,3,1,0,0.6,0],[Order 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]]
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 number of selects and updates operations, respectively, required for each type transaction. Determine the following. Round your answers to two decimal places (e.g.98.76).
(a)P(x5)=
image text in transcribed

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Databases questions