What is the best page size if entries now become 128 bytes

Chapter 5, Problem 5.10.1

(choose chapter or problem)

Get Unlimited Answers
QUESTION:

What is the best page size if entries now become 128 bytes?

Questions & Answers

QUESTION:

What is the best page size if entries now become 128 bytes?

ANSWER:

Problem 5.10.1

For a high-performance system such as a B-tree index for a database, the page size is determined mainly by the data size and disk performance. Assume that on average a B-tree index page is 70% full with fix-sized entries. The utility of a page is its B-tree depth, calculated as log2 (entries). The following table shows that for 16-byte entries and a 10-year-old disk with a 10 ms latency and 10 MB/s transfer rate, the optimal page size is 16K.

What is the best page size if entries now become 128 bytes?

                                                               Step by Step Solution

Step 1 of 3

The Page Utility is found as  

Add to cart


Study Tools You Might Need

Not The Solution You Need? Search for Your Answer Here:

×

Login

Login or Sign up for access to all of our study tools and educational content!

Forgot password?
Register Now

×

Register

Sign up for access to all content on our site!

Or login if you already have an account

×

Reset password

If you have an active account we’ll send you an e-mail for password recovery

Or login if you have your password back