IBM Books
(C) IBM Corp. 2000

Net Search Extender

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


ij½Ã ¹× ½ºÅä¾îµå ÇÁ·Î½ÃÀú °Ë»öÀ» »ç¿ëÇÏ´Â ´Ü¼ø ¿¹

DB2 Net Search Extender ½ºÅä¾îµå ÇÁ·Î½ÃÀú °Ë»ö ¿¹¿¡ ÀÖ´Â ´ÙÀ½ ´Ü°è¸¦ »ç¿ëÇϽʽÿÀ.

  1. ij½Ã ¿É¼ÇÀ¸·Î ÅØ½ºÆ® À妽º ÀÛ¼º
  2. À妽º µ¿±âÈ­ ¹× ij½Ã Ȱ¼ºÈ­
  3. TEXTSEARCH ½ºÅä¾îµå ÇÁ·Î½ÃÀú·Î °Ë»ö
Âü°í

½ºÅä¾îµå ÇÁ·Î½ÃÀú ¿¹¿¡¼­´Â ÀÌÀü ¿¹ÀÇ ´Ü°èµéÀÌ ¿Ï·áµÇ¾ú°í µ¥ÀÌÅͺ£À̽º°¡ °è¼Ó »ç¿ë °¡´ÉÇÏ´Ù°í °¡Á¤ÇÕ´Ï´Ù.

ij½Ã ¿É¼ÇÀ¸·Î ÅØ½ºÆ® À妽º ÀÛ¼º
µ¥ÀÌÅͺ£À̽º°¡ ÀÌ¹Ì »ç¿ë °¡´ÉÇÏ°Ô µÇ¾úÀ¸¹Ç·Î, ´ÙÀ½ ¸í·ÉÀ» »ç¿ëÇÏ¿© Àüü ÅØ½ºÆ® À妽º¸¦ ÀÛ¼ºÇϽʽÿÀ.

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ÀÔ´Ï´Ù.

À妽º µ¿±âÈ­ ¹× ij½Ã Ȱ¼ºÈ­
´ÙÀ½ ¸í·ÉÀ» »ç¿ëÇÏ¿© Å×ÀÌºí¿¡ »ðÀÔµÈ µ¥ÀÌÅÍ¿¡ µû¶ó À妽º¸¦ °»½ÅÇϽʽÿÀ.

db2text "UPDATE INDEX db2ext.mySTPTextIndex FOR TEXT CONNECT TO sample"

´ÙÀ½ ¸í·ÉÀ» »ç¿ëÇÏ¿© ij½Ã¸¦ Ȱ¼ºÈ­ÇϽʽÿÀ.

db2text "ACTIVATE CACHE FOR INDEX db2ext.mySTPTextIndex FOR TEXT 
        CONNECT TO sample"

TEXTSEARCH ½ºÅä¾îµå ÇÁ·Î½ÃÀú·Î °Ë»ö
DB2 Net Search Extender ½ºÅä¾îµå ÇÁ·Î½ÃÀú´Â ƯÁ¤ÇÑ °æ¿ì¿¡¸¸ »ç¿ëÇÒ ¼ö ÀÖ½À´Ï´Ù. ÀÚ¼¼ÇÑ Á¤º¸´Â ½ºÅä¾îµå ÇÁ·Î½ÃÀú °Ë»ö »ç¿ëÀ» ÂüÁ¶ÇϽʽÿÀ.

 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 ÆÄÀÏÀ» Á¡°ËÇϽʽÿÀ.

Äõ¸®¿¡¼­ »ç¿ëµÇ´Â ´Ù¸¥ ¸Å°³º¯¼ö¿¡ ´ëÇÑ ¼¼ºÎ»çÇ×Àº ½ºÅä¾îµå ÇÁ·Î½ÃÀú °Ë»öÀ» »ç¿ëÇÏ¿© ÅØ½ºÆ® °Ë»öÀ» ÂüÁ¶ÇϽʽÿÀ.


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