Questions tagged [relevance]

Search Relevance is the practice of manipulating a search application's behavior to improve the quality of the search results based on the needs of the application's users

Search Relevance is the practice of improving the quality of search results in a search application. In relevance work, you line up a user audiences needs (as expressed in their natural language search string) with the content available in the search application.

For example, a customer typing the search "cancer" into a hospital site's search is likely to have very different expectations than doctors typing that term into a medical research site. In the hospital case, users want a "info desk" search user experience, and are likely interested in the hospital's cancer services. For doctors searching a research site, they're more likely to be interested in the latest cancer research.

With search relevance, you work to understand the user's needs and line up the search application's ranking behavior to match. Relevance work involves technical work to manipulate the ranking behavior of a commercial or open source search engine like Solr, Elasticsearch, Endeca, Algolia, etc. This means manipulating field weightings, query formulations, text analysis, and more complex search engine capabilities. It may also mean leveraging user behavioral data, NLP, statistical, and other machine learning techniques to modify or enrich the behavior of such a search engine.

More Reading

Blog

Books

273 questions
0
votes
1 answer

How to map rows of two tables to each other based on the relevance in MySQL?

I have following tables in my database: courses (whole data of sports classes), coursedata (with copies of courses.title and courses.description -- needed for FULLTEXT index / relevance search), sports (list of sports), and courses_sports…
automatix
  • 14,018
  • 26
  • 105
  • 230
0
votes
2 answers

How to obtain a relevance score in a table

I have a mysql table that has typetags for games, like table game_typetags: name typetag --------- -------- game#1 sports game#1 soccer game#2 race game#2 sports and another table games like name playcount ---------…
marvin
  • 365
  • 3
  • 7
  • 22
0
votes
1 answer

Handle Search Result relevance from multi Table using FREETEXTTABLE

I'm developing an application which allows the user to find Product references, searching by keywords (Using the FREETEXTTABLE feature of full-text indexed Table for SQL 2008). Those reference are extracted from two different databases that are both…
WizLiz
  • 2,068
  • 5
  • 25
  • 39
0
votes
2 answers

Sort table by number of keywords found

I have the following code for searching multiple keywords within a document title which works fine. I want now to have a column that shows the number of keywords that are found in each title row and order in a descendent way. For example if I'm…
cimm
0
votes
1 answer

Text search based on relevance in Django by matching relevanct data to each individual items in object

class Org(models.Model): org_name = models.CharField(max_length=255) name = models.CharField(max_length=50) phone = models.CharField(max_length=50) email_id = models.EmailField() incorporation_date = models.DateTimeField() …
Santosh S Kumar
  • 469
  • 1
  • 6
  • 30
0
votes
1 answer

Database searching and displaying results by relevance

Given the following tables, how can I search for a term in each of them and order results by relevance? Thank you. bands - band_id - band_name albums - album_id - album_name songs - song_id - song_name
Psyche
  • 8,513
  • 20
  • 70
  • 85
0
votes
0 answers

How to sort text by relevance/weight for search

I use a webservice that returns a number of short (<100 characters) textstrings. I need to sort these strings in some sort of textual relevance, eg better hits should be first and hits of less quality (matching the searchterm in the last position,…
0
votes
1 answer

How to order by relevancy including word order in SQL

I'm creating a 'smart' search engine that will look into database by relevancy. My system calculate how many words in your sentence correspond to the database field 'tag_clean' that contains text, and try to get the proper result (one per…
0
votes
1 answer

count search keyword via mysql query for relevance in search function

I need to count the repeats of search keyword in searched fields. For example, if i have table wp_posts like this ID post _content post_title ----------------------------------------------- 1 page page page page 2 …
Obhaso
  • 449
  • 1
  • 4
  • 14
0
votes
1 answer

Using "AS score" to return relevance score from mysql fulltext search

I'm selecting text from a full-text mysql dbTable, hits are returned ordered by relevance multiplied by a client supplied weight. The query works fine, though I'd like to as an "AS score" clause to the query to return the actual weighted…
mcb
  • 1
  • 1
0
votes
1 answer

passing mySQL full-text search relevance values back to PHP generated form

I'm using php generated forms to do mySQL full text queries on a database. Matches are ordered according to weighted relevances and returned to the form. My question is: Is there any way to pass the relevance values as well back to the form? I'd…
mcb
  • 1
  • 1
-1
votes
1 answer

How to calculate relevance score?

I am trying to calculate relevance score using a review from a json file. Every time I tried to run my code, it will only say "indirect" for output. What am I doing wrong? My code is below: import joblib, requests, json, sklearn.metrics,…
Wheng
  • 11
  • 6
-1
votes
1 answer

Mysql OR conditions and sort by relevance

I'm doing a query with a dynamic amount of OR conditions depending on the amount of terms retrieved by $_GET[]. if(isset($_GET['terms'])) { $concat_search = 'AND wp_posts.ID = wp_term_relationships.object_id'; …
user997593
  • 423
  • 5
  • 16
-1
votes
1 answer

How can i find the relevance of a page?

Say I have some features of a person and then i perform google search. A list of results display I want to mine those results and check how the contents of those results are relevant to that particular person.
-1
votes
2 answers

Computing the Dot Product for calculating proximity

I have already asked a similar question at Calculating Word Proximity in an inverted Index. However i felt that the question was too general and not refined enough. So here goes. I have a List which contains the location of tokens in a document.…
Win Coder
  • 6,628
  • 11
  • 54
  • 81
1 2 3
18
19