IBM å
(C) IBM Corp. 2000

Net Search Extender

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


ºä¿¡ ´ëÇÑ ÅØ½ºÆ® À妽º

½ºÅä¾îµå ÇÁ·Î½ÃÀú¸¦ »ç¿ëÇÏ¿© ºä¿¡ ´ëÇÑ ÅØ½ºÆ® À妽º¸¦ ÀÛ¼ºÇÒ ¼ö ÀÖ½À´Ï´Ù. ±×·¯³ª ÇÑ °¡Áö Áß¿äÇÑ ´ÜÁ¡Àº ºä¿¡ ´ëÇÑ Æ®¸®°Å¸¦ ÀÛ¼ºÇÒ ¼ö ¾ø±â ¶§¹®¿¡ ±âÃʰ¡ µÇ´Â ±âº» Å×À̺íÀÇ º¯°æ»çÇ×À» ÀνÄÇÒ ¼ö ¾ø´Ù´Â °ÍÀÔ´Ï´Ù.

±×·¯¹Ç·Î ÁõºÐ À妽º °»½Å¿¡¼­ ÅØ½ºÆ® À妽º¸¦ µ¥ÀÌÅͺ£À̽º¿Í µ¿±âÈ­ÇÏ·Á¸é ¾î¶² ¹®¼­°¡ Ãß°¡, °»½Å ¶Ç´Â »èÁ¦µÇ¾ú´ÂÁö¸¦ ¾Ë¾Æ¾ßÇÕ´Ï´Ù. À̸¦ ¼öÇàÇÏ·Á¸é ¸ðµç º¯°æ»çÇ×À» ·Î±× Å×ÀÌºí¿¡ Ãß°¡ÇØ¾ß ÇÕ´Ï´Ù. ÀÌ ÇÁ·Î¼¼½º´Â ´ÙÀ½ »ùÇÿ¡ ³ª¿Í ÀÖ½À´Ï´Ù.

  1. ´ÙÀ½ ¸í·ÉÀ» »ç¿ëÇÏ¿© ±âº» Å×À̺íÀ» ÀÛ¼ºÇϽʽÿÀ.

    db2 "create table sample (key INTEGER not null  PRIMARY KEY, name 
                VARCHAR(50) not null, comment VARCHAR(90))" 
    
  2. ÀϺΠÇ׸ñÀ» Ãß°¡ÇÏ·Á¸é ´ÙÀ½ ¸í·ÉÀ» »ç¿ëÇϽʽÿÀ.

    db2 "insert into sample values(1,'Claus','works in room 301')"
    db2 "insert into sample values(2,'Manja','is in the same office as Juergen')"
    db2 "insert into sample values(2,'Juergen','has the longest way to Raiko')"
    db2 "insert into sample values(3,'Raiko','is sitting in the office 
                besides Claus ')"
    
  3. ºä¸¦ ÀÛ¼ºÇÏ·Á¸é ´ÙÀ½ ¸í·ÉÀ» »ç¿ëÇϽʽÿÀ.

    db2 "create view sampleview as select key, comment from sample"
    
  4. ´ÙÀ½ ¸í·ÉÀ» »ç¿ëÇÏ¿© ÅØ½ºÆ® À妽º¸¦ ÀÛ¼º, °»½Å ¹× Ȱ¼ºÈ­ÇϽʽÿÀ.

    db2text "create index indexview for text on hde.sampleview(comment) 
                cache table (comment) maximum cache size 1 key columns 
                for index on view (key)" 
    db2text "update index indexview for text"
    db2text "activate cache for index indexview for text"
    
    Âü°í

    ºä¿¡¼­ ÅØ½ºÆ® À妽º¸¦ ÀÛ¼ºÇÒ ¼ö ÀÖµµ·Ï ij½Ã Å×À̺íÀ» ÁöÁ¤ÇϽʽÿÀ. ¿Ã¹Ù¸¥ ·Î±× Å×À̺íÀ» ÀÛ¼ºÇÏ·Á¸é ºä¿¡¼­ À妽ºÀÇ Å° Ä÷³À» ÁöÁ¤ÇϽʽÿÀ.

    ºÐ»ê DB2 ȯ°æ¿¡¼­´Â ´ÜÀÏ ³ëµå¿¡ ÀÖ´Â °ü¸® Å×ÀÌºí¿¡ ´ëÇÑ Å×ÀÌºí ½ºÆäÀ̽º¸¦ ¸í½ÃÀûÀ¸·Î ÁöÁ¤Çϰí ÀÌ ³ëµå¿¡¼­ ¸í½ÃÀûÀ¸·Î È£ÃâÇØ¾ß ÇÕ´Ï´Ù.

    ¿Ã¹Ù¸¥ ³ëµå¿¡ ¿¬°áµÇ¾ú´ÂÁö È®ÀÎÇÏ·Á¸é DB2NODE ȯ°æ º¯¼ö¸¦ »ç¿ëÇϽʽÿÀ.

  5. Å×À̺íÀ» °»½ÅÇÏ·Á¸é ´ÙÀ½ ¸í·ÉÀ» »ç¿ëÇϽʽÿÀ.

    db2 "insert into sample values(4,'Bernhard','is working in the same floor 
                as Manja, but not as Claus')"
    db2 "insert into sample values(5,'Guenter','shares the office with Raiko')"
    
  6. ±×·± ÈÄ, ·Î±× Å×À̺íÀ» °»½ÅÇϽʽÿÀ. ·Î±× Å×À̺í À̸§À» °¡Á®¿À·Á¸é ´ÙÀ½ ¸í·ÉÀ» »ç¿ëÇϽʽÿÀ.

    db2 "select INDSCHEMA,INDNAME,LOGVIEWSCHEMA,LOGVIEWNAME 
                from db2ext.textindexes"
    
    ´ÙÀ½Àº ·Î±× Å×À̺íÀÇ ·¹À̾ƿôÀÔ´Ï´Ù.

    sqltype               sqllen  sqlname.data             sqlname.length
    --------------------  ------  -----------------------  --------------
    496   INTEGER              4  OPERATION                             9  
    392   TIMESTAMP           26  TIME                                  4  
    497   INTEGER              4  PK01                                  4   
    
    Ç׸ñÀ» ·Î±× Å×ÀÌºí¿¡ Ãß°¡ÇÏ·Á¸é ´ÙÀ½ ¸í·ÉÀ» »ç¿ëÇϽʽÿÀ.

    db2 "insert into sample values(0,CURRENT TIMESTAMP,4)"
    db2 "insert into sample values(0,CURRENT TIMESTAMP,5)"
    
    ù ¹øÂ° °ªÀº Á¶ÀÛ(0 = »ðÀÔ, 1 = °»½Å, 2 = »èÁ¦)¿¡ ´ëÇÑ ¼³¸íÀÌ°í µÎ ¹øÂ° °ªÀº Ç×»ó CURRENT TIMESTAMPÀ̾î¾ß ÇÏ¸ç ¸¶Áö¸· °ªÀº »ðÀÔµÈ Å°ÀÔ´Ï´Ù.
  7. ´ÙÀ½ ¸í·ÉÀ» »ç¿ëÇÏ¿© À妽º¸¦ ´Ù½Ã °»½ÅÇϽʽÿÀ.

    db2text "update index indexview for text"
    

ÀÌÁ¦ ½ºÅä¾îµå ÇÁ·Î½ÃÀú¸¦ »ç¿ëÇÏ¿© »õ °ª¿¡ ´ëÇÑ °Ë»öÀ» ¼öÇàÇÒ ¼ö ÀÖ½À´Ï´Ù.


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