Reference no: EM132144441
Question :
Suppose we want to build a B+ tree that has space for 200,000 data entries in its leaf pages. Each data entry is made up of a key and its corresponding data value. Let us assume the following specifications.
Each page (leaf or internal) is 4096 bytes long. Each page holds three 8-byte pointers (parent, left sibling, right sibling) in addition to the bytes consumed by all of the keys and their accompanying 8-byte values.
(In the case of leaf pages, these "values" are simply pointers that locate the full data record corresponding to the key (e.g., customer record for the given key.)
We want to use an even number of data entries in the leaf pages. Internally, we also want an even number. The keys have unique values. For all of the following questions, show your work:
a) Suppose each key is 56 bytes long, and suppose we fill the leaf pages to capacity (i.e., as much as possible). Compute the number of leaf pages that we need.
b) Compute the number of internal pages, at each level, that we "need" (i.e., assume that you can fill the parents to capacity (to the maximum even number of keys)). This will result in a structure that has the fewest number of pages. Note, however, that the root can have as few as one key.
What is the expected price of easy clean stock
: What is the expected price of Easy Clean stock in Year 5 (i.e., FIND P5)? [NOTE: Be careful! Round dividend to nearest penny before calculating price.]
|
What is glude required rate of return
: Glude Corp has a market beta of 1.20, a size beta of -0.30, and a value beta of 0.30. What is Glude's required rate of return using the Fama-French model.
|
Savings account for five years
: Mary Smith has $10,000 that she can deposit into a savings account for five years. Bank A compounds interest annually, Bank B twice a year
|
What could be the possible error
: Suppose that you are working with GPS data from an Excel spreadsheet and that you map it in ArcMap.
|
Compute the number of internal pages
: Compute the number of internal pages, at each level, that we "need" (i.e., assume that you can fill the parents to capacity (to the maximum even number of keys)
|
How much should your client pay for this business
: Based on this information, how much should your client pay for this business?
|
Deposit in his individual retirement
: Your client wants to save $500,000 for his retirement. He plans to retire in 20 years. How much must he deposit in his individual retirement
|
Which of the following characterizes a market order
: i. Which of the following characterizes a market order? a) A market order, which is considered a small order, is when 100 shares of a stock are ordered
|
How that the real data is transferred from the main memory
: With neat sketch, explain and show how that the real data is transferred from the main memory to the MBR.
|