IBM å
(C) IBM Corp. 2000

Net Search Extender

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

Áö¿øµÇÁö ¾Ê´Â µ¥ÀÌÅÍ À¯Çü¿¡ ´ëÇÑ ÅØ½ºÆ® À妽º ÀÛ¼º

À妽º¸¦ ÀÛ¼ºÇÏ·Á¸é ÅØ½ºÆ® Ä÷³Àº ´ÙÀ½ µ¥ÀÌÅÍ À¯Çü Áß Çϳª¸¦ °¡Á®¾ß ÇÕ´Ï´Ù.

¹®¼­°¡ »ç¿ëÀÚ Á¤ÀÇ À¯Çü(UDT)°ú °°ÀÌ ´Ù¸¥ À¯ÇüÀ» °¡Áø Ä÷³¿¡ ÀÖÀ¸¸é ÀÔ·ÂÀ¸·Î »ç¿ëÀÚ À¯ÇüÀ» °¡Á®¿À°í À§¿¡¼­ ¾ð±ÞÇÑ Çü½Ä Áß Çϳª¸¦ Ãâ·Â À¯ÇüÀ¸·Î Á¦°øÇÏ´Â ±â´ÉÀ» Á¦°øÇØ¾ß ÇÕ´Ï´Ù.

º¯È¯ ÇÔ¼öÀÇ À̸§À» ÁöÁ¤ÇϽʽÿÀ. ÀÚ¼¼ÇÑ Á¤º¸´Â CREATE INDEX¸¦ ÂüÁ¶ÇϽʽÿÀ.

¿¹: Å×ÀÌºí¿¡ ¾ÐÃàµÈ ÅØ½ºÆ®¸¦ ÀúÀåÇÏ·Á°í ÇÕ´Ï´Ù.

  1. ´ëÈ­½Ä SQL ¼¼¼Ç¿¡ ÅØ½ºÆ®¿¡ ´ëÇÑ »ç¿ëÀÚ Á¤ÀÇ À¯Çü(UDT)À» ÀÛ¼ºÇϽʽÿÀ.
    db2 "CREATE DISTINCT TYPE COMPRESSED_TEXT AS CLOB(1M)"
    
  2. Å×À̺íÀ» ÀÛ¼ºÇϰí ÅØ½ºÆ®¸¦ »ðÀÔÇϽʽÿÀ.
    db2 "CREATE TABLE UDTTABLE (author VARCHAR(50) not null,
                                  text COMPRESSED_TEXT, primary key (author))"
    db2 "INSERT ..."
    
  3. uncompress »ç¿ëÀÚ Á¤ÀÇ ÇÔ¼ö(UDF)¸¦ ÀÛ¼ºÇϽʽÿÀ. À̰ÍÀº À¯ÇüÀÌ COMPRESSED_TEXTÀÎ °ªÀ» ¹Þ¾Æ ÀÌ °ª¿¡ ÇØ´çÇÏ´Â ¾ÐÃàµÇÁö ¾ÊÀº ÅØ½ºÆ®¸¦ CLOB(10M) °ªÀ¸·Î ¸®ÅÏÇÕ´Ï´Ù.
  4. ´ÙÀ½ ÅØ½ºÆ® À妽º¸¦ ÀÛ¼ºÇÏ¿© uncompress UDF¸¦ ÁöÁ¤ÇϽʽÿÀ.
    db2text "CREATE INDEX UDTINDEX for text ON UDTTABLE
                                   (uncompress(text))
                                   ..."
    


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