>>-+-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 ±â´ÉÀ» »ç¿ëÇÏ¿©, ¹ß°ßÇÑ ¹®¼ÀÇ ¼øÀ§¸¦ ¾Ë ¼ö ÀÖ½À´Ï´Ù.
¾Æ·¡¿¡ ±× ¿¹°¡ ³ª¿Í ÀÖ½À´Ï´Ù.
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 °ªÀ» ¸®ÅÏÇÕ´Ï´Ù.