°ü¸® ¹× »ç¿ëÀÚ ¾È³»¼
DB2 Net Search Extender ½ºÅä¾îµå ÇÁ·Î½ÃÀú °Ë»ö ¿¹¿¡ ÀÖ´Â ´ÙÀ½ ´Ü°è¸¦ »ç¿ëÇϽʽÿÀ.
Âü°í |
---|
½ºÅä¾îµå ÇÁ·Î½ÃÀú ¿¹¿¡¼´Â ÀÌÀü ¿¹ÀÇ ´Ü°èµéÀÌ ¿Ï·áµÇ¾ú°í µ¥ÀÌÅͺ£À̽º°¡ °è¼Ó »ç¿ë °¡´ÉÇÏ´Ù°í °¡Á¤ÇÕ´Ï´Ù. |
db2text "CREATE INDEX db2ext.mySTPTextIndex FOR TEXT ON books (story) CACHE TABLE (author, story) MAXIMUM CACHE SIZE 1 CONNECT TO sample"
¿¹¿¡¼, Àüü ÅØ½ºÆ® À妽º´Â Ä÷³ story¿¡ ´ëÇÑ °ÍÀ¸·Î Ä÷³ author ¹× story¿¡ ´ëÇÑ Ä³½Ã Å×À̺íÀ» ÁöÁ¤ÇÕ´Ï´Ù. ÅØ½ºÆ® À妽º À̸§Àº mySTPTextIndexÀÔ´Ï´Ù.
db2text "UPDATE INDEX db2ext.mySTPTextIndex FOR TEXT CONNECT TO sample"
´ÙÀ½ ¸í·ÉÀ» »ç¿ëÇÏ¿© ij½Ã¸¦ Ȱ¼ºÈÇϽʽÿÀ.
db2text "ACTIVATE CACHE FOR INDEX db2ext.mySTPTextIndex FOR TEXT CONNECT TO sample"
db2 "call db2ext.textSearch ('\"cat\"','DB2EXT','MYSTPTEXTINDEX',0,2,0,0,?,?)"
ÀÌ Äõ¸®´Â cat¿¡ ´ëÇÑ ¸ðµç Ã¥À» °Ë»öÇÏÁö¸¸ óÀ½ µÎ °³ÀÇ °á°ú¸¸ ¸®ÅÏÇÕ´Ï´Ù. ÀÌ °æ¿ì, Äõ¸®´Â ´ÙÀ½ °á°ú Å×À̺íÀ» ¸®ÅÏÇÕ´Ï´Ù.
Ãâ·Â ¸Å°³º¯¼öÀÇ °ª -------------------------- ¸Å°³º¯¼ö À̸§ : SEARCHTERMCOUNTS ¸Å°³º¯¼ö °ª : 1 ¸Å°³º¯¼ö À̸§ : TOTALNUMBEROFRESULTS ¸Å°³º¯¼ö °ª : 1 AUTHOR STORY Mike The cat hunts some mice. ¸®ÅÏ »óÅ = 0
°Ë»ö ±¸¹®¿¡ ´ëÇÑ Ãß°¡ »ùÇÃÀº sqllib\sample\db2ext\search ÆÄÀÏÀ» Á¡°ËÇϽʽÿÀ.
Äõ¸®¿¡¼ »ç¿ëµÇ´Â ´Ù¸¥ ¸Å°³º¯¼ö¿¡ ´ëÇÑ ¼¼ºÎ»çÇ×Àº ½ºÅä¾îµå ÇÁ·Î½ÃÀú °Ë»öÀ» »ç¿ëÇÑ ÅØ½ºÆ® °Ë»öÀ» ÂüÁ¶ÇϽʽÿÀ.