Results 1 to 4 of 4
  1. #1
    Join Date
    Nov 2003
    Posts
    39

    Unanswered: How to rank results in Oracle Text

    I have question on Oracle Text:
    I am using Text Search on a table. It's a simple search.
    The text index is on a "Keywords" column.
    In this column we simply define comma separated keywords such as ....
    savings,checking,account,opening,closing,withdraw

    For example
    URL Keywords
    citibank1.com checking,saving
    citibank2.com checking,saving
    citibank3.com checking,saving,closing

    When it is searched on word "Saving" all the 3 rows gets displayed with same SCORE. But I want to display the ORDER based on following condition ....
    If the word is "checking" then citibank2.com should be on Top of the list
    If the word is "saving" then citibank1.com should be on Top of the list

    I mean i should get different SCORE for a row based on the keyword.
    One simple solution is to repeat the word e.g. saving,saving.
    this will get more score for that row. But this is not feasible ...

    Is there any syntax to get the output in the order that i want

    Thanks
    Yuwaraj

  2. #2
    Join Date
    Aug 2004
    Location
    France
    Posts
    754
    AFAIK the only way to achieve that is to repeat the word. BTW, how would you want the index to know which row should have a higher score for "saving" if it occurs the same time in every row ? IMO : simply impossible, so just repeat the word if you want a row to score better for this very word.

    HTH & Regards,

    rbaraer
    ORA-000TK : No bind variable detected... Shared Pool Alert code 5 - Nuclear query ready .

  3. #3
    Join Date
    May 2006
    Posts
    132
    Quote Originally Posted by ydj
    If the word is "checking" then citibank2.com should be on Top of the list
    If the word is "saving" then citibank1.com should be on Top of the list
    What's the rationale behind this ranking? What's the distinquishing factor? For example, should citibank1.com be on top for keyword "saving" because 1 is less than 2 ?

  4. #4
    Join Date
    Nov 2003
    Posts
    39
    >>What's the rationale behind this ranking? What's the distinquishing factor? For example, should citibank1.com be on top for keyword "saving" because 1 is less than 2 ?
    Rationale: both the results citibank1.com and citibank2.com will have some content related to word "saving" but citibank1.com has more relavance for the word "saving" than other result Or I just want the user to see the citibank1.com before citibank2.com based on the importance. So I would like to show it on Top in the Order of results.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •