a. Consider that the data-file has 750000 records of employees. The employee-records are ordered based on...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
a. Consider that the data-file has 750000 records of employees. The employee-records are ordered based on non-key field project_id and size of that field is 8 bytes. Each of the employee records has size of 100 bytes. Consider none of the records are allowed to cross block boundaries. Consider clustering index structure for the data file has been created to speed up the retrieval of the records where indexing field is based on the project id and a block pointer which is 5 bytes long. Assume the Block size is 8 Kilobytes. Find out the total number of block accesses to search for an employee record using the said index. Consider, there are 50 employees working on each project. [7] b. Suppose you are going to implement dynamic multilevel indexing using B tree and B* trees. Consider size of the data pointer, key, and the block pointer or tree pointer is 8 bytes each, block size is 5 kilobytes. Suppose, a single intermal node of the tree (B tree or B* tree) can fit into a single block. Find out the order of the said trees. [5] a. Consider that the data-file has 750000 records of employees. The employee-records are ordered based on non-key field project_id and size of that field is 8 bytes. Each of the employee records has size of 100 bytes. Consider none of the records are allowed to cross block boundaries. Consider clustering index structure for the data file has been created to speed up the retrieval of the records where indexing field is based on the project id and a block pointer which is 5 bytes long. Assume the Block size is 8 Kilobytes. Find out the total number of block accesses to search for an employee record using the said index. Consider, there are 50 employees working on each project. [7] b. Suppose you are going to implement dynamic multilevel indexing using B tree and B* trees. Consider size of the data pointer, key, and the block pointer or tree pointer is 8 bytes each, block size is 5 kilobytes. Suppose, a single intermal node of the tree (B tree or B* tree) can fit into a single block. Find out the order of the said trees. [5]
Expert Answer:
Related Book For
Payroll Accounting 2016
ISBN: 978-1259572197
2nd edition
Authors: Jeanette Landin, Paulette Schirmer
Posted Date:
Students also viewed these computer engineering questions
-
Recall from Exercise 10.1.22 that the data file TVLife provides information on life expectancy and number of televisions per thousand people in a sample of 22 countries, as reported by the 2006 World...
-
Recall from Exercise 10.1.13 that the data file HeightAnd FingerLength contains data on the height (inches) and the length of the index finger of the dominant hand (cm) for students in a statistics...
-
Recall from Exercise 10.1.11 that the data file HousePrices contains data on prices ($) and sizes (in square feet) for a random sample of houses that sold in the year 2006 in Arroyo Grande,...
-
In April 1999, one of Capital Blue Cross' health-care insurance plans had been in the field for three years, but hadn't performed as well as expected. The ratio of premiums to claims payments wasn't...
-
Sarvan Corporation is preparing its balanced scorecard for the past quarter. The balanced scorecard contains four perspectives: financial, customer, internal business process, and learning and...
-
Certain item descriptions and amounts are missing from the monthly schedule of cost of goods manufactured and income statement of Charlie Manufacturing Company. Fill in the blanks with the missing...
-
Kim-Klark Consumer Products Company is considering an investment in one of two new product offerings. The investment required for either product is $420,000. The net cash flows associated with each...
-
Finer Company uses a sales journal, a purchases journal, a cash receipts journal, a cash disbursements journal, and a general journal. The following transactions occur in the month of May. May 2 Sold...
-
Use MM theory to explain the effect of capital structure on the equity cost of capital and WACC in perfect markets and when corporate tax exists
-
Based on the information presented in the minicase, and the discussion in both Chapter 2 and this chapter, to what extent does Elon Musk fit the general charac- teristics of an entrepreneur and a...
-
International Strategic Management is an ongoing management planning process aimed at developing strategies to allow an organization to expand abroad and compete internationally. International...
-
find the x - intercept and the y ' intetcept of the line 8 x + 3 y = - 1 5
-
(e) Find the volatility of the portfolio in (d). (f) Would anyone prefer stock A to the portfolio in (d)? Why or why not. Suppose that there are two assets: A and B. Asset A has expected return of...
-
a) Meta-Technetium-99 is a radioisotope commonly used in radiopharmaceutical applications. It is obtained from the decay of Molybdenum-99, which is itself produced artificially either by neutron...
-
Suppose that an economist hypothesizes that the annual quantity demanded of a specific computer brand (Q D ) is determined by the price of the computer (P) and the average income of consumers (Y)...
-
118. Match the following columns. Column-I Column-II A Ladybird () Methanobacterium B Mycorrhiza (II) Trichoderma C Biological control (III) Aphids D Biogas (IV) Glomus (1) A-2 B-4; C-3; D-1 (2) A-3;...
-
Find the range of the data set represented by the graph. Click the icon to view the graph. The range of the data set is Le Graph Frequency Woman's Age at First Childbirth 24 25 26 27 28 29 30 31 32...
-
As water moves through the hydrologic cycle, water quality changes are common because of natural phenomena or anthropogenic pollution. Using Figure 11.1, describe how water-quality changes occur...
-
You have been hired as a consultant for a company facing an IRS audit of their accounting records. During your review, you notice anomalies in the payroll system involving overpayments of labor and...
-
What are an advantage and disadvantage of direct deposit?
-
Candy Farms, Inc. has the following voluntary withholdings to remit?
-
Find number of stages needed for a countercurrent extractor if 10 \(\mathrm{kmol} / \mathrm{h}\) feed that is \(10 \mathrm{~mol} \% \mathrm{CCl}_{4}\) and \(90 \mathrm{~mol} \%\) acetic acid is...
-
The horizontal settler calculation in Example 13-7 was done for a settler diameter of \(\mathrm{D}_{\mathrm{s}}=1.023 \mathrm{~m}\) with the dispersion band assumed to be at the center of the circle....
-
Suppose in Example 13-7 that we decide to build the settler with a diameter of \(1.0 \mathrm{~m}\) and a length of \(4.0 \mathrm{~m}\). What safety factor are we employing? Example 13-7 Design a...
Study smarter with the SolutionInn App