IBM Books
(C) IBM Corp. 2000

Net Search Extender

°ü¸® ¹× »ç¿ëÀÚ ¾È³»¼­

°Ë»ö ÈÄ Ã£Àº ÅØ½ºÆ® ¹®¼­ÀÇ ¼øÀ§ ¸®ÅÏ

SCORE ÇÔ¼ö´Â ãÀº ´Ù¸¥ ¹®¼­¿Í ºñ±³ÇÏ¿© ¹®¼­°¡ °Ë»ö °ªÀ» ¸¸Á·½ÃŰ´Â Á¤µµ¸¦ Ç¥½ÃÇÏ´Â Àý´ë °ªÀÔ´Ï´Ù. °ªÀº ¹®¼­ÀÇ Å©±â¿Í °ü·ÃÇÏ¿© ¹®¼­¿¡¼­ ÀÏÄ¡µÈ Ƚ¼ö¸¦ Ç¥½ÃÇÕ´Ï´Ù. ´ÙÀ½ ¿¹¿¡¼­, SCORE ÇÔ¼ö¸¦ »ç¿ëÇÏ¿© ãÀº ¹®¼­ÀÇ ¼øÀ§¸¦ °¡Á®¿Ã ¼ö ÀÖ½À´Ï´Ù.

WITH TEMPTABLE(docid,score)
        AS (SELECT docid,
                   SCORE(COMMENT,'"book"')
        FROM DB2EXT.TEXTTAB)
SELECT *
         FROM TEMPTABLE
        WHERE score > 0 
        ORDER BY score ASC

SCORE ÇÔ¼ö´Â 0¿¡¼­ 1 »çÀÌÀÇ DOUBLE °ªÀ» ¸®ÅÏÇÕ´Ï´Ù.

Âü°í

ºä¿¡¼­ ÀÛ¼ºµÈ À妽ºÀÇ °æ¿ì CONTAINS, SCORE ¹× NUMBEROFMATCHES °Ë»ö ÇÔ¼ö¸¦ »ç¿ëÇÒ ¼ö ¾ø½À´Ï´Ù.

ºÐ»ê DB2 ȯ°æ¿¡¼­´Â SCORE °ªÀÌ ´Ù¸¨´Ï´Ù.

  • ºñºÐ»ê ȯ°æ¿¡¼­´Â ¸ðµç ¹®¼­°¡ ´ÜÀÏ Å×ÀÌºí¿¡ ÀÖ½À´Ï´Ù. SCORE °ªÀº ´ÜÀÏ Å×ÀÌºí ¹× Å×À̺íÀÇ ´Ù¸¥ ¸ðµç ¹®¼­¿¡ ´ëÇÑ ¹®¼­ °ü°è¸¦ ±âÃÊ·Î ÇÕ´Ï´Ù.
  • ºÐ»ê DB2 ȯ°æ¿¡¼­´Â ¸ðµç ¹®¼­°¡ ¼­·Î ´Ù¸¥ ³ëµå¿¡ ÀÖ½À´Ï´Ù. Àε¦½Ì µµÁß ·ÎÄà ¹®¼­¸¸ ÅØ½ºÆ® À妽º¸¦ ºôµåÇÏ´Â µ¥ »ç¿ëµÇ¸ç, ÀÌ ÅØ½ºÆ® À妽º´Â ¸ðµç ³ëµå¿¡¼­ ·ÎÄÃÀÔ´Ï´Ù. ÀÌ °æ¿ì SCORE °ªÀº ¿©·¯ ³ëµå Áß Çϳª¿¡¸¸ ÀÖ´Â ¸ðµç ¹®¼­¿ÍÀÇ ¹®¼­ °ü°è¸¦ ±âÃÊ·Î ÇÕ´Ï´Ù.


[ ÆäÀÌÁöÀÇ ¸Ç À§ | ÀÌÀü ÆäÀÌÁö | ´ÙÀ½ ÆäÀÌÁö | ¸ñÂ÷ | »öÀÎ ]