Documentation
(C) IBM Corp. 1996, 2000

DB2 Text Extender
°ü¸® ¹× ÇÁ·Î±×·¡¹Ö


ÅØ½ºÆ® Ž»ö

>>-+-CONTAINS------+--(--ÇÚµé--,--search-argument--)-----------><
   +-NO_OF_MATCHES-+
   '-RANK----------'
 
>>-SEARCH_RESULT------------------------------------------------>
 
>----(--½ºÅ°¸¶--,--Å×À̺í--,--ÇÚµé--,--search-argument--)------><
 

ÀÌ Àý¿¡¼­´Â DB2 Text Extender¿¡¼­ Á¦°øÇÏ´Â SQL ±â´ÉÀ» »ç¿ëÇÏ¿© ÅØ½ºÆ®°¡ ÀÖ´Â DB2 µ¥ÀÌÅͺ£À̽º¸¦ Ž»öÇÏ´Â ¹æ¹ýÀ» ¼³¸íÇÕ´Ï´Ù. ´ÙÀ½À» ½ÇÇàÇÏ´Â ¹æ¹ýÀ» ¼³¸íÇÕ´Ï´Ù.

SEARCH_RESULTÀÇ »ç¿ë¿¡ ´ëÇØ¼­´Â Ž»ö ¼º´É Çâ»ó¿¡ ¼³¸íµÇ¾î ÀÖ½À´Ï´Ù.

°¢°¢ÀÇ À̵é DB2 Text Extender ±â´ÉÀº ÅØ½ºÆ® »öÀο¡¼­ Ž»ö ÀμöÀÇ ¹ß»ýÀ» Ž»öÇÕ´Ï´Ù. Å×ÀÌºí¿¡ 100 000 ÅØ½ºÆ® ¹®¼­°¡ ÀÖ´Ù¸é, CONTAINS, RANK ¶Ç´Â NO_OF_MATCHES ±â´ÉÀÌ 100 000¹ø È£ÃâµË´Ï´Ù. ±×·¯³ª ÅØ½ºÆ® »öÀÎÀº 100 000¹øÀ» Ž»öÇÏÁö ¾Ê½À´Ï´Ù. ´ë½Å, ±â´ÉÀ» óÀ½ È£ÃâÇÒ ¶§, Ž»ö ¿ë¾î°¡ µé¾î ÀÖ´Â ¸ðµç ¹®¼­ÀÇ ³»ºÎ ¸ñ·ÏÀÌ ÀÛ¼ºµË´Ï´Ù. À̾îÁö´Â ±â´É È£ÃâÀº °ü·Ã ¹®¼­°¡ ¸ñ·Ï¿¡ ÀÖ´ÂÁö ÆÇº°ÇÕ´Ï´Ù.
Ãß°¡ Á¤º¸

DB2 Text Extender ±â´ÉÀ» »ç¿ëÇÏ¿© Å×ÀÌºí¿¡¼­ Ž»öÇÒ °æ¿ì, ÅØ½ºÆ® Ä÷³ÀÌ ¾Æ´Ï¶ó ÇÚµé Ä÷³À» ±â´É¿¡ Àü´ÞÇØ¾ß ÇÕ´Ï´Ù. ÅØ½ºÆ® Ä÷³¿¡¼­ Ž»öÀ» ½ÃµµÇÏ´Â °æ¿ì, SQLÀº µ¥ÀÌÅÍ À¯ÇüÀÌ À߸øµÈ °ÍÀ» ³ªÅ¸³»´Â ¸Þ½ÃÁö·Î ÀÀ´äÇÕ´Ï´Ù. ¿¹¸¦ µé¸é,

No function by the name "CONTAINS" having compatible
arguments was found in the function path.

ENABLE TEXT TABLE ¶Ç´Â ENABLE TEXT COLUMN ¸í·ÉÀ» ¹ßÇàÇÑ Á÷ÈÄ¿¡ ÅØ½ºÆ®¸¦ ãÀ¸¸é, ÀÌ ¸í·É¿¡ ÀÇÇØ ÀÛ¼º ÁßÀÎ »öÀÎÀÌ ¾ÆÁ÷ Á¸ÀçÇÏÁö ¾ÊÀ½À» ³ªÅ¸³»´Â RC_SE_EMPTY_INDEX ¿À·ù°¡ ¹ß»ýÇÒ ¼ö ÀÖ½À´Ï´Ù. »öÀÎ ÀÛ¼º¿¡ °É¸®´Â ½Ã°£Àº »öÀÎ ÀÛ¼º ÁßÀÎ ¹®¼­ ¼ö, »öÀÎ ÀÛ¼ºÀ» ¼öÇàÇÏ´Â ½Ã½ºÅÛ ¼º´É°ú °°Àº Àμö¿¡ ÀÇÇØ °áÁ¤µË´Ï´Ù. ¸î ºÐ¿¡¼­ ¸î ½Ã°£±îÁö ´Þ¶óÁú ¼ö ÀÖ°í ½Ã½ºÅÛÀÇ ºÎÇϰ¡ ÀûÀº ¹ã °°Àº ¶§ ½ÇÇàµÇ¾î¾ß ÇÕ´Ï´Ù.

¸Þ½ÃÁö°¡ ³ªÅ¸³ª¸é, ³ªÁß¿¡ ´Ù½Ã Ž»öÀ» ½ÃµµÇϰųª GET INDEX STATUS¸¦ »ç¿ëÇÏ¿© »öÀÎ ÀÛ¼º Áß ¿À·ù°¡ ¹ß»ýÇß´ÂÁö Á¡°ËÇϽʽÿÀ.

Á¶È¸ ÀÛ¼º

ÀÌ ¿¹¿¡¼­´Â CONTAINS ÇÔ¼ö°¡ ÇÚµéÀÌ ½Äº°ÇÑ ¹®¼­¿¡¼­ ÅØ½ºÆ®¸¦ Ž»öÇÏ´Â ¹æ½ÄÀ» º¸¿©ÁÝ´Ï´Ù. ÅØ½ºÆ®°¡ Ž»ö Àμö¿¡ ÀûÇÕÇϸé 1À» ¸®ÅÏÇÏ°í ±×·¸Áö ¾ÊÀ¸¸é 0À» ¸®ÅÏÇÕ´Ï´Ù.

db2=>SELECT DATE, SUBJECT
            FROM DB2TX.SAMPLE
        WHERE DB2TX.CONTAINS (COMMENTHANDLE, '"compress"') = 1

ÀÌ ¿¹¿¡¼­, ¿ë¾î compress¸¦ Ä÷³ COMMENTHANDLE¿¡¼­ Çڵ鿡 ÀÇÇØ ÂüÁ¶µÈ ÅØ½ºÆ®¿¡¼­ Ž»öÇÕ´Ï´Ù. COMMENTHANDLE Ä÷³ÀÇ ÇÚµéÀº COMMENT ÅØ½ºÆ®°¡ »öÀÎ ÀÛ¼ºµÈ À§Ä¡¸¦ ³ªÅ¸³À´Ï´Ù.
Ãß°¡ Á¤º¸

Å×À̺íÀ̳ª Ä÷³¿¡ ´ëÇØ ´ë¼Ò¹®ÀÚ°¡ È¥ÇÕµÈ ±ÔÁ¤ÀÚ¸¦ ÀÛ¼ºÇÑ °æ¿ì, ÀÌ À̸§À» ¹Ýµå½Ã Å« µû¿ÈÇ¥·Î ¹­¾î¾ß ÇÕ´Ï´Ù. ¿¹´Â ´ÙÀ½°ú °°½À´Ï´Ù.

db2=>SELECT DATE, SUBJECT
        FROM "db2tx.sample"
        WHERE DB2TX.CONTAINS (COMMENTHANDLE, '"compress"') = 1

DB2 UDB ¼±Åà ¸í·É¹®À» ¸í·ÉÇà¿¡¼­ ÁöÁ¤ÇÏ´Â °æ¿ì, ¿î¿µ üÁ¦ ¸í·ÉÇà ±¸¹®ºÐ¼®±â´Â ¸í·É ¹®ÀÚ¿­¿¡¼­ Å« µû¿ÈÇ¥¿Í °°Àº Ư¼ö ¹®ÀÚ¸¦ Á¦°ÅÇÏ¸ç ¹é½½·¡½Ã¸¦ »ç¿ëÇÏ¿© ÀÌ·± Ư¼ö ±âÈ£¸¦ ¸¶½ºÅ©ÇØ¾ß ÇÕ´Ï´Ù. ¿¹´Â ´ÙÀ½°ú °°½À´Ï´Ù.

    DB2 "SELECT DB2TX.file(COMMENTHANDLE)
        FROM db2tx.sample"
        WHERE DB2TX.CONTAINS (COMMENTHANDLE, '\"compress\"') = 1
 

¹ß°ßÇÑ ÀÏÄ¡ °Ç¼öÀÇ Å½»ö ¹× ¸®ÅÏ

°¢ ÅØ½ºÆ® ¹®¼­¿¡¼­ Ž»ö ±âÁØÀÌ ¹ß°ßµÇ´Â Ƚ¼ö¸¦ ÆÇº°ÇÏ·Á¸é NO_OF_MATCHES ÇÔ¼ö¸¦ »ç¿ëÇϽʽÿÀ.

db2=>WITH TEMPTABLE(DATE, SUBJECT, MATCHES)
    AS (SELECT DATE, SUBJECT,
                    DB2TX.NO_OF_MATCHES(COMMENTHANDLE,'"compress"')
        FROM DB2TX.SAMPLE)
    SELECT *
        FROM TEMPTABLE
             WHERE MATCHES > 0

NO_OF_MATCHES´Â Á¤¼ö°ªÀ» ¸®ÅÏÇÕ´Ï´Ù.

¹ß°ßµÈ ÅØ½ºÆ® ¹®¼­ÀÇ ¼øÀ§(rank) Ž»ö°ú ¸®ÅÏ

RANK´Â ¹ß°ßµÈ ´Ù¸¥ ¹®¼­¿ÍÀÇ °ü·Ã Ž»ö ±âÁØ¿¡ ¹®¼­°¡ ¾ó¸¶³ª ºÎÇÕÇÏ´ÂÁö ³ªÅ¸³»´Â Àý´ë°ªÀÔ´Ï´Ù. ÀÌ °ªÀº ¹®¼­ Å©±â¿Í °ü·ÃÇÏ¿© ¹®¼­¿¡¼­ ¹ß°ßµÇ´Â ÀÏÄ¡ °ªÀÇ ¼ö¸¦ Áö½ÃÇÕ´Ï´Ù. RANK ±â´ÉÀ» »ç¿ëÇÏ¿©, ¹ß°ßÇÑ ¹®¼­ÀÇ ¼øÀ§¸¦ ¾Ë ¼ö ÀÖ½À´Ï´Ù.

¾Æ·¡¿¡ ±× ¿¹°¡ ³ª¿Í ÀÖ½À´Ï´Ù.

db2=>WITH TEMPTABLE(DATE, SUBJECT, RANK)
    AS (SELECT DATE, SUBJECT,
               DB2TX.RANK(COMMENTHANDLE,'"compress"')
        FROM DB2TX.SAMPLE)
    SELECT *
        FROM TEMPTABLE
         WHERE RANK > 0
        ORDER BY RANK DESC

RANK´Â 0°ú 1 »çÀÌÀÇ DOUBLE °ªÀ» ¸®ÅÏÇÕ´Ï´Ù.


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