Explain leaf of b tree which holds a sublist

Assignment Help Database Management System
Reference no: EM1367457

Consider an inverted index containing, for each term, the posting list (i.e. the list of documents and occurrences within documents) for that term. The posting lists are accessed through a B+ tree with the terms serving as search keys. Each leaf of the B+ tree holds a sublist of alphabetically consecutive terms, and, with each term, a pointer to the posting list for that term.

Part a. An artificially small example of a B+ tree is shown here (pdf). (Note only part of the tree is shown in detail.) What nodes of the example B+ tree are visited to find the posting list for "dune"?

Part b. Suppose there are 2 million terms for a collection of 32 million documents of total size 200 gigabytes. We would like each internal node of the B+ tree and each leaf of the B+ tree to fit in one 8-kilobyte page of the file system. Recall that a B+ tree has a parameter m called the order of the tree, and each internal node of a B+ tree has between m+1 and 2m+1 children (except the root, which has between 2 and 2m+1). Assume that each term is represented using 16 bytes, and each pointer to a child in the tree or to a posting list is represented using 8 bytes. Find a value for the order m of the B+ tree so that one 8 kilobyte page can be assigned to each internal node and leaf, and so that an internal node will fill, but not overflow, its page when it has 2m+1 children. If you need to make additional assumptions, state what assumptions you are making.

Part c. For your m of Part b, estimate the height of the B+ tree. (Giving a range of heights is fine.) Also estimate the amount of memory needed to store the tree, including leaves but not including the posting lists themselves.

Part d. Estimate the aggregate size of the posting lists.

Reference no: EM1367457

Questions Cloud

Estimate consumer and producer surplus before quota : Estimate aggregate consumer and producer surplus before quota. Estimate new consumer and producer surplus after quota.
Explain specific challenges of facing designer : Explain specific challenges of facing the designer, specifically with regard to limitations of hardware, software and interface design two paragraph each.
Examples of a medical office implementing ehr : Research and provide examples of a medical office that has implemented EHRs. How has it helped them? Has it created any negative aspects.
Determine the growth rate of real gdp : Suppose last year's real GDP was $7,000 billion, this years nominal GDP is $8,820 billion, and GDP-deflator for this year is 120. Determine the growth rate of real GDP?
Explain leaf of b tree which holds a sublist : Artificially small example of B+ tree is shown here (pdf). (Note only part of tree is shown in detail.) What nodes of example B+ tree are visited to find posting list for "dune"?
Illustrate what do you think disrupted mcdonald plans : Within two weeks sales had fallen. Utilizing your knowledge of game theory, Illustrate what do you think disrupted McDonald's plans.
Evidence-based practice report : Identify a research topic that you intend to investigate and write about as an evidence-based practice report Project Topic such as COPD, Asthma, Cancer or other health topics)
Illustrate what is economy aggregate consumption function : Illustrate what is economy's aggregate consumption function. Illustrate what is marginal propensity to consume for economy.
Determine supply and demand for labor : Many factors discuss the supply and demand for labor. Identify and describe two factors that would increase or decrease the demand for labor.

Reviews

Write a Review

Database Management System Questions & Answers

  Create entity-relationship diagram for bookstore database

Create Entity-Relationship diagram for a bookstore database, that maintains information about books, professional journals, their authors, and publishers.

  Create microsoft access database

Create a Microsoft Access database. Create the tables, fi elds, data types, and primary key(s) for the database. Create the relationship(s) needed between the tables.

  Write sql queries for the books database

Write SQL queries for the books database that perform each of the following tasks: Select all authors from the Authors table with the columns in the order lastName, firstName and authorID.

  Sketch dfsa for identifiers-contain only letters and digits

Sketch a DFSA for identifiers which contain only letters and digits, where identifier should have at least one letter, but it need not be first character.

  Explaining weak relationship and weak entity

What is meant by a weak relationship? Provide an example. What is meant by weak entity? What do you understand by relationship degree?

  Design a set of 3nf tables for your database scenario

Draw an ER diagram for your database scenario. Design a set of 3NF tables for your database scenario.

  Write select statement that returns two columns

Write a SELECT statement that returns two columns: VendorName and PaymentSum, where PaymentSum is the sum of the PaymentTotal column.

  Write sql statements to calculate average salary

Write SQL statements that do the following: Calculate the average salary for all employees. Calculate the maximum salaries for exempt and non-exempt employees.

  Explaining unclustered b pus tree index

Suppose you have a table which contains 27,000 data records, and you have unclustered B+ Tree Index on the table.

  Importance have button that takes you back to main page

What is the importance to have a button that takes you back to the main page on each web page? How does dead end or orphan pages affect the continuity of a website?

  Characteristics of relational database management system

Describe the characteristics of a Relational Database Management System (RDBMS).

  Developing a database

You have been asked to develop a database utilizing only the written problem description given by the client. In reviewing the description.

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd