EXPLAIN WHERE YOU FIND THE The database has 500000 million records A database must store an employee table consisting of 100000records each of which is 80bytes long. Answer the following questions by assuming these congurations/parameters: B = 512bytes, interblock gap size G = 128bytes, numberof blockspertrack = 256, numberof trackspersurf ace = 400. The disk has 8 platters each with two heads (only one head can read at a time of all 16 heads), rotates at 7200rpm, has a track − to − trackseektime(m) of 1ms, s = 12ms, r = 4.16ms, and btt = 0.03255ms.   1. How many records can be stored per block (blocking factor) using spanned and unspanned congurations? 2. What is the utilization (%) for the unspanned conguration? 3. If the le is physically ordered, what is the average time in milli second to read a record in each conguration?

Computer Networking: A Top-Down Approach (7th Edition)
7th Edition
ISBN:9780133594140
Author:James Kurose, Keith Ross
Publisher:James Kurose, Keith Ross
Chapter1: Computer Networks And The Internet
Section: Chapter Questions
Problem R1RQ: What is the difference between a host and an end system? List several different types of end...
icon
Related questions
Question

EXPLAIN WHERE YOU FIND THE The database has 500000 million records

A database must store an employee table consisting of 100000records each of which is 80bytes
long. Answer the following questions by assuming these congurations/parameters: B = 512bytes,
interblock gap size G = 128bytes, numberof blockspertrack = 256, numberof trackspersurf ace =
400. The disk has 8 platters each with two heads (only one head can read at a time of all 16 heads),
rotates at 7200rpm, has a track − to − trackseektime(m) of 1ms, s = 12ms, r = 4.16ms, and
btt = 0.03255ms.

 

1. How many records can be stored per block (blocking factor) using spanned and unspanned
congurations?
2. What is the utilization (%) for the unspanned conguration?
3. If the le is physically ordered, what is the average time in milli second to read a record in
each conguration?

Expert Solution
steps

Step by step

Solved in 2 steps

Blurred answer
Knowledge Booster
Types of Database Architectures
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-engineering and related others by exploring similar questions and additional content below.
Recommended textbooks for you
Computer Networking: A Top-Down Approach (7th Edi…
Computer Networking: A Top-Down Approach (7th Edi…
Computer Engineering
ISBN:
9780133594140
Author:
James Kurose, Keith Ross
Publisher:
PEARSON
Computer Organization and Design MIPS Edition, Fi…
Computer Organization and Design MIPS Edition, Fi…
Computer Engineering
ISBN:
9780124077263
Author:
David A. Patterson, John L. Hennessy
Publisher:
Elsevier Science
Network+ Guide to Networks (MindTap Course List)
Network+ Guide to Networks (MindTap Course List)
Computer Engineering
ISBN:
9781337569330
Author:
Jill West, Tamara Dean, Jean Andrews
Publisher:
Cengage Learning
Concepts of Database Management
Concepts of Database Management
Computer Engineering
ISBN:
9781337093422
Author:
Joy L. Starks, Philip J. Pratt, Mary Z. Last
Publisher:
Cengage Learning
Prelude to Programming
Prelude to Programming
Computer Engineering
ISBN:
9780133750423
Author:
VENIT, Stewart
Publisher:
Pearson Education
Sc Business Data Communications and Networking, T…
Sc Business Data Communications and Networking, T…
Computer Engineering
ISBN:
9781119368830
Author:
FITZGERALD
Publisher:
WILEY