Compute the ranking scores for all documents

Assignment Help Database Management System
Reference no: EM13815737

Task Description

Vector Model

This question requires you to use the following data. Assume a repository of 10 documents over eight key terms. Table 1 gives the document-term table that shows the raw frequencies with which the eight key terms appear 1 in each of the 10 documents, as well as the TF values for a query document.

Using the information from Table 1, which documents would be returned by the following queries:

a) Term2 AND Term7

b) Term4 OR Term2

c) (Term2 OR Term7) AND (NOT Term7)

A2: Document-Term and Query-Term Table

 

Term 1

Term 2

Term 3

Term 4

Term 5

Term 6

Term 7

Term 8

Doc 1

4

8

9

0

10

8

0

9

Doc 2

1

5

0

0

12

0

1

3

Doc 3

0

3

0

0

0

4

2

0

Doc 4

1

0

4

3

9

0

0

0

Doc 5

0

4

0

0

0

5

1

0

Doc 6

1

2

2

0

3

1

0

1

Doc 7

0

5

3

1

0

0

4

2

Doc 8

0

7

0

3

0

0

3

3

Doc 9

0

5

0

0

0

4

1

2

Doc 10

0

3

4

0

0

2

4

0

Query

2

3

1

2

2

0

1

0

Is it possible to rank the documents returned in (a) to (c)? If it is possible, then supply the rankings in each case. If it is not possible, then state why.

Exercise 1. Answer the following questions.

a) Using the information from Table 2.1, calculate the ranking score for each of the ten documents based on each of the following query-document similarity measures: dot product using TF weight for both documents and query vectors cosine coefficient using TF weight for both documents and query vectors.

b) Compare the rankings that you obtained using the two similarity measures. If there are differences between the rankings, then discuss why you think these differences occurred.

Exercise 21. Answer the following questions.

a) Using the information in Table 2.1, calculate the idf (inverse document frequency) weight vector. Make sure you show how your calculation was performed.

b) Construct a table similar Table 2.1, but, instead of raw term frequencies, show the tf-idf weights.

c) Using tf weights for the query vector, and tf-idf weights for the document vectors, and the cosine coefficient as a similarity measure, compute the ranking scores using the cosine coefficient. Show how your calculations were performed for the first document only.

d) How does this ranking compare with ranking obtained using the cosine similarity measure in Exercise 20? If there are differences between the rankings, then discuss why you think these differences occurred.

Exercise 2. Answer the following questions.

a) This time, using tf-idf weights for both the query and document vectors, and the cosine coefficient as a similarity measure, compute the ranking scores using the cosine coefficient. Show how your calculations were performed for the first document only.

b) How does this ranking compare with ranking obtained in Exercise 21? If there are differences between the rankings, then discuss why you think these differences occurred.

Exercise 3. This time, use tf weights for the query vector, tf-idf weights for the document vectors, and the Dice coefficient rather than the Cosine coefficient as the similarity measure.

a) Compute the ranking scores for all documents. Show how your calculations were performed for the first document only.

b) How does the ranking compare with ranking obtained in Exercise 1? If there are differences between the rankings, then discuss why you think these differences occurred.

IR Evaluation

Exercise 4. The following data displays retrieval results for two different algorithms (Algorithm 1 and Algorithm 2) in response to two distinct queries (Query 1 and Query 2). An expert has manually labelled each of the documents as being either relevant or not relevant to the queries.

Algorithm 1 Returns the following results:

Algorithm 2 Returns the following results:

Relevance The known one is as follows:

a) For Algorithm 1, plot the precision versus recall curves for Query 1 and Query 2, interpolated to the 11 standard recall levels. Also plot the average precision versus recall curve for Algorithm 1 (all three curves should be on a single chart).

b) For Algorithm 2, plot the precision versus recall curves for Query 1 and Query 2, interpolated to the 11 standard recall levels. Also plot the average precision versus recall curve for Algorithm 2 (all three curves should be on a single chart, but a separate chart from that used in part (a)).

c) Plot the averages for Algorithm 1 and Algorithm 2 on a separate chart, and compare the algorithms in terms of precision and recall. Do you think one of the algorithms is superior? Why?

Reference no: EM13815737

Questions Cloud

What will be the new market equilibrium price and quantity : A perfectly competitive industry has a large number of potential entrants. all firms have identical cost structure and minimize cost at the same point where Min AC=MC. what will be the new market equilibrium price and quantity?
Compare and contrast important interviewing techniques : Compare and contrast important interviewing techniques
Significant environmental issue : Select one significant environmental issue. What are the costs and benefits of our current environmental issues from an economic standpoint? What type of market failure could those problems is defined as? What can you as an individual do to help in a..
Ethical effects of alcoholism : Ethical Effects of Alcoholism
Compute the ranking scores for all documents : How does this ranking compare with ranking obtained using the cosine similarity measure in Exercise 20? If there are differences between the rankings, then discuss why you think these differences occurred.
Competitive market the market demand for a good : In a perfectly competitive market the market demand for a good A is P=50-Q and the market supply is p=5+0.5Q. find the equilibrium price, quantity and the total welfare in this market. a unit tax=$15/unit is imposed on good A. calculate the amount of..
Write a history paper about the river niger- world theme : Write a history paper about The River Niger- World Theme, The Telegraph-Us Theme and The District of Columbia Board of Nursing-Us Theme.
Elements of the fourth amendment reasonableness test : What are the two elements of the Fourth Amendment reasonableness test? Explain how the "totality of circumstances" test works in practice
Examine how behavior exhibits motivation : Examine how behavior exhibits motivation

Reviews

Write a Review

Database Management System Questions & Answers

  Describe the importance of data management for organizations

Prepare a minimum 2 page paper describe the importance of Data Management for organizations

  What physical and logical topologies are recommend

Draw a simple floor plan for New Cenrury Wellness group and include the placement of all network nodes including the placement of a server, and network equipment. How many ports will your switch need to accommodate?

  Your team supervisor requested a meeting to discuss the

your team supervisor requested a meeting to discuss the following trends for issues and concerns and how they may be

  What the join method is and how it works

What the join method is and how it works. Given the mantra, "Fewer page reads means better performance," describe how an index can improve performance. Refer to one or more figures in the textbook if that helps your description

  Modifying a database design in visio

Modifying a Database Design in Visio-  Discuss the degree to which you believe the Visio diagram reflects the database design

  How would you do it and what changes would you make

Describe how you use the database, and how you think the database makes that process easier. In addition, if you could redesign the database you described, how would you do it and what changes would you make

  Let t1 encompass the operations rx wx ry wy and t2 have the

let t1 have the operations rx wx ry wy and t2 have the operations rx wx. consider adding either a commit or abort to

  What a query execution plan

What a query execution plan? Discuss the reasons for converting SQL queries into relational algebra queries before optimization is done

  Describe technology options associated with an edms

Identify and describe the technology options and functionality associated with an EDMS. describe EHR functionality for ambulatory care facilities, considering the key clinical processes performed and data needed in such a facility.

  Assignment related to the prestige hotel

Import the Location data from the Excel file a02m2location into your database as a new table. Set the LocationlD Indexed property to Yes (No Duplicates), and then set the data type to Long Integer. Select the LocationlD field as the primary key. N..

  When does oracle stop processing the query

How does Oracle process this query? That is, what does Explain Plan tell you about how the query is processed - how would you recognize that the results were not correct?

  Co-related sub-query to return one row per customer

Use a co-related sub-query to return one row per customer, representing the customer's oldest order (the one with the earliest date).

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