Create a merged inverted list

Assignment Help Database Management System
Reference no: EM131973471

Question 1

Suppose you have joined a search engine development team to design a search algorithm based on both the Vector model and the Boolean model.

You have collected the following documents (unstructured) and plan to apply an index technique to convert them into an inverted index.

Doc 1:Information retrieval is the activity of obtaining information resources relevant to an information need from a collection of information resources. Searches can be based on full-text or other content-based indexing.

Doc 2:Information retrieval is finding material of an unstructured nature that satisfies an information need from within large collections.

Doc 3:Information systems is the study of complementary networks of hardware and software that people and organizations use to collect, filter, process, create, and distribute data.

In the process of creating the inverted index, please complete the following steps:

a. Remove all stop words and punctuation, and then apply Porter's stemming algorithm to the documents. The list of stop words for this task is provided as follows: Is, The, Of, To, An, A, From, Can, Be, On, Or, That, Within, And, Use

b. Create a merged inverted list including the within-document frequencies for each term.

c. Use the index created in part (b) to create a dictionary and the related posting file.

d. You may like to test the inverted index by using the following keywords: information, system, index

e. Please design three Boolean queries, (for example, web AND search) and list the relevant documents for each query.

f. Please use the Vector model to query on the inverted index, and compare the result with the Boolean model. (Hint: you can use cosine similarity and set a similarity threshold).

Question 2 (IR Evaluation)
In this question, you are required to evaluate the performance of different search engines. First, please find two search engines you are familiar with, such as Google, Bing, Yahoo!, etc.

Second, please choose one target from the following list, and design two queries to search in both search engines. So both query 1 and query 2 have to be tested in both search engines.

i. Target 1: obtain the course information for S779.
ii. Target 2: obtain the price of the new Samsung Tablet.
iii. Target 3: obtain the manual of installing tera term.
iv. Target 4: obtain the oracle SQL tutorial.
v. Target 5: obtain the price of new Xbox one.

Third, select the first 20 results in both search engines, if they return the target, then mark them as relevant documents, otherwise, they are irrelevant. Assume that you have 14 relevant documents in total (retrieved and not-retrieved).

The following questions are based on your search results.

a) List your target, results and designed search queries (You can use any keywords you think are related to the target).

Get the precision and recall values for 20 documents for query 1 in search engine 1. Interpolate them to 11 standard recall levels. Then plot them into a chart. Get the precision and recall values for 20 documents for query 2 in search engine 1. Interpolate them to 11 standard recall levels. Then plot them into the same chart as above.

Now find the average precision of query 1 and query 2 for search engine 1 and plot it into the same chart.

So you will have total of 3 curves in one single chart.

b) List your target, results and designed search queries

Get the precision and recall values for 20 documents for query 1 in search engine 2. Interpolate them to 11 standard recall levels. Then plot them into a chart. Get the precision and recall values for 20 documents for query 2 in search engine 2. Interpolate them to 11 standard recall levels. Then plot them into the same chart as above.

Now find the average precision of query 1 and query 2 for search engine 2 and plot it into the same chart.

So, you will have total of 3 curves in one single chart, separate to that of part (a). c) Plot the averages for Search Engine 1 and Search Engine 2 on a separate chart, and compare the algorithms in terms of precision and recall. Which search engine do you think is superior? Why?

Reference no: EM131973471

Questions Cloud

Information those documents would disclose : In other words no person can plead ignorance as to what information those documents would disclose.
Some ways that social media has changed your daily life : What are some ways that social media has changed your daily life? What can marketers take advantage of for their promotional purposes?
Explain the process of social change set in motion : Explain the process of social change set in motion by invention of the printing press. Compare the powers of French president to those of American president.
Would you adopt something your peer suggested : In your response, compare and contrast your own approach to the subject to that of your peer. Would you adopt something your peer suggested.
Create a merged inverted list : Search engine development team to design a search algorithm based on both the Vector model and the Boolean model
Data in healthcare administration today : Discuss key sources for gathering data in healthcare administration today.
How is the anti-colonial discourse generated : How is the anti-colonial discourse generated by the Left over the question of Algeria related to anti-globalization campaigns such as those undertaken.
Forgetting to put something in a contract : As real estate agent describe some mistakes you have made in your real estate careers - from a "legal" aspect. This could be forgetting to put something.
Complete the Varney Federal income tax return : ACCT 4331 Tax Return Project. Complete the Varney's Federal income tax return for 2017. Assume that the Varneys are filing their return on time

Reviews

len1973471

5/7/2018 3:53:08 AM

Interpolation of both curves of search engine 1 and 2. 3 marks Provide correct interpolations for both curves. 2 marks Provide approximate correct interpolation but with some key points missing 1 mark Provide one correct interpolation but other’s a wrong Average curves and compare two engines 3 marks Obtain correct comparison result with full explanation and the average curves. 2 marks Obtain correct comparison result, but does not provide enough explanation/curves. 1 mark Compare part of result, but the result in doubtable Overall score Level 4 24 or more Level 3 16 or more Level 2 8 or more

len1973471

5/7/2018 3:53:02 AM

Question 2 Excellent Good Fair List the target, results and related queries 3 marks List target, both queries and results for both queries. 2 marks List target and results, but only one query 1 mark List target, but not queries/results Search engine 1: Plot recall and precision curve to interpolated levels 3 marks Both Precision and recall values and curves are correct. 2 marks Precision and recall values for both queries are correct, but related curves are incorrect. 1 mark Precision and recall values for one query are correct, but another one is incorrect. Search engine 2: Plot recall and precision curve to interpolated levels 3 marks Both values and curves are correct. 2 marks Precision and recall values for both queries are correct, but related curves are incorrect. 1 mark Precision and recall values for one query are correct, but another one is incorrect.

len1973471

5/7/2018 3:52:51 AM

Boolean model 3 marks The correct documents for all of the three queries are correct. 2 marks The correct documents for two of the three queries are correct. 1 mark The correct documents for one of the three queries are correct. Vector Model 3 marks The correct documents for all of the three queries are correct. Provide compare result. 2 marks The correct documents for two of the three queries are correct. Provide the compare result 1 mark The correct documents for one of the three queries are correct. Provide the compare result

len1973471

5/7/2018 3:52:45 AM

Question 1 Excellent Good Fair Unsatisfactory Output porter stemming results 3 marks Output suitable word list on all of the three documents. 2 marks Output suitable word list on two of the three documents. 1 mark Output suitable word list on one of the documents. 0 mark Fail to output stemming results on any document. Create a merged inverted list including the within-document frequencies list index 3 marks Successfully created the merged inverted list index. 2 marks 2/3 of terms are correctly indexed. 1 mark Half of the terms are correctly indexed. 0 mark Fail to create an inverted list index. Create a dictionary and the related posting file 3 marks Successfully created the dictionary. All terms are pointing to the posting file 2 marks 2/3 of the dictionary file is correct. All related terms are pointing to the posting file 1 mark Half of the dictionary file is correct. All related terms are pointing to the posting file 0 mark Fail to create a dictionary and the related posting file.

Write a Review

Database Management System Questions & Answers

  Knowledge and data warehousing

Design a dimensional model for analysing Purchases for Adventure Works Cycles and implement it as cubes using SQL Server Analysis Services. The AdventureWorks OLTP sample database is the data source for you BI analysis.

  Design a database schema

Design a Database schema

  Entity-relationship diagram

Create an entity-relationship diagram and design accompanying table layout using sound relational modeling practices and concepts.

  Implement a database of courses and students for a school

Implement a database of courses and students for a school.

  Prepare the e-r diagram for the movie database

Energy in the home, personal energy use and home energy efficiency and Efficient use of ‘waste' heat and renewable heat sources

  Design relation schemas for the entire database

Design relation schemas for the entire database.

  Prepare the relational schema for database

Prepare the relational schema for database

  Data modeling and normalization

Data Modeling and Normalization

  Use cases perform a requirements analysis for the case study

Use Cases Perform a requirements analysis for the Case Study

  Knowledge and data warehousing

Knowledge and Data Warehousing

  Stack and queue data structure

Identify and explain the differences between a stack and a queue data structure

  Practice on topic of normalization

Practice on topic of Normalization

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