IBM Books
(C) IBM Corp. 2000

Net Search Extender

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


SQL ½ºÄ®¶ó °Ë»ö ÇÔ¼ö¸¦ »ç¿ëÇÏ´Â ´Ü¼ø ¿¹

DB2 Net Search Extender ¿¹¿¡ ÀÖ´Â ´ÙÀ½ ´Ü°è¸¦ »ç¿ëÇϽʽÿÀ.

  1. µ¥ÀÌÅͺ£À̽º ÀÛ¼º
  2. ÅØ½ºÆ® °Ë»ö¿¡ µ¥ÀÌÅͺ£À̽º »ç¿ë
  3. Å×À̺í ÀÛ¼º
  4. Àüü ÅØ½ºÆ® À妽º ÀÛ¼º
  5. »ùÇà µ¥ÀÌÅÍ ·Îµå
  6. ÅØ½ºÆ® À妽º µ¿±âÈ­
  7. ÅØ½ºÆ® À妽º·Î °Ë»ö

±âÁ¸ÀÇ µ¥ÀÌÅͺ£À̽º¸¦ »ç¿ëÇÏ¿© ¿î¿µ üÁ¦ÀÇ ¸í·ÉÇà¿¡¼­ »ùÇà ¸í·ÉÀ» ¹ßÇàÇÒ ¼ö ÀÖ½À´Ï´Ù. ´ÙÀ½ ¿¹¿¡¼­ µ¥ÀÌÅͺ£À̽º À̸§Àº sampleÀÔ´Ï´Ù.

µ¥ÀÌÅͺ£À̽º ÀÛ¼º
´ÙÀ½ ¸í·ÉÀ» »ç¿ëÇÏ¿© DB2¿¡ µ¥ÀÌÅͺ£À̽º¸¦ ÀÛ¼ºÇÒ ¼ö ÀÖ½À´Ï´Ù.

db2 "create database sample"

ÅØ½ºÆ® °Ë»ö¿¡ µ¥ÀÌÅͺ£À̽º »ç¿ë
¿î¿µ üÁ¦ÀÇ ¸í·ÉÇà¿¡¼­ DB2 ¸í·É°ú °°Àº ¹æ¹ýÀ¸·Î DB2 Net Search Extender ¸í·ÉÀ» ¹ßÇàÇÒ ¼ö ÀÖ½À´Ï´Ù. ¿¹¸¦ µé¾î, ´ÙÀ½ ¸í·ÉÀ» »ç¿ëÇÏ¿© Net Search Extender ÀνºÅϽº ¼­ºñ½º¸¦ ½ÃÀÛÇϽʽÿÀ.

db2text "START"

´ÙÀ½ ¸í·ÉÀ» »ç¿ëÇÏ¿© DB2 Net Search Extender¸¦ »ç¿ëÇϱâ À§ÇÑ µ¥ÀÌÅͺ£À̽º¸¦ ÁغñÇϽʽÿÀ.

db2text "ENABLE DATABASE FOR TEXT CONNECT TO sample"

ÀÌ ´Ü°è´Â °¢ µ¥ÀÌÅͺ£À̽º¸¶´Ù ÇÑ ¹ø¸¸ ¼öÇàÇÒ ¼ö ÀÖ½À´Ï´Ù.

Å×À̺í ÀÛ¼º
db2 "CREATE TABLE books (isbn VARCHAR(18) not null PRIMARY KEY,
      author VARCHAR(30), story LONG VARCHAR, year INTEGER)"

ÀÌ DB2 ¸í·ÉÀº È£ÃâµÈ books Å×À̺íÀ» ÀÛ¼ºÇÕ´Ï´Ù. ÀÌ Å×ÀÌºí¿¡´Â author, story, isbn number ¹× Ã¥ÀÌ ¹ßÇàµÈ year¿¡ ´ëÇÑ Ä÷³ÀÌ Æ÷ÇԵ˴ϴÙ.

Àüü ÅØ½ºÆ® À妽º ÀÛ¼º
db2text "CREATE INDEX db2ext.myTextIndex FOR TEXT ON books (story)
        CONNECT TO sample"

ÀÌ ¸í·ÉÀº Ä÷³ story¿¡ ´ëÇÑ Àüü ÅØ½ºÆ® À妽º¸¦ ÀÛ¼ºÇÕ´Ï´Ù. ÅØ½ºÆ® À妽º À̸§Àº db2ext.myTextIndexÀÔ´Ï´Ù.

»ùÇà µ¥ÀÌÅÍ ·Îµå
db2 "INSERT INTO books VALUES ('0-13-086755-1','John', 'A man was 
     running down the street.',2001)"
db2 "INSERT INTO books VALUES ('0-13-086755-2','Mike', 'The cat hunts
     some mice.', 2000)"
db2 "INSERT INTO books VALUES ('0-13-086755-3','Peter', 'Some men 
     were standing beside the table.',1999)"

ÀÌ·¯ÇÑ ¸í·ÉÀº ¼¼ °¡Áö Ã¥¿¡ ´ëÇÑ isbn, author, story ¹× publishing year¸¦ Å×ÀÌºí¿¡ ·ÎµåÇÕ´Ï´Ù.

ÅØ½ºÆ® À妽º µ¿±âÈ­
´ÙÀ½ ¸í·ÉÀ» »ç¿ëÇÏ¿© sample Å×ÀÌºí¿¡¼­ µ¥ÀÌÅÍ¿¡ ´ëÇÑ ÅØ½ºÆ® À妽º¸¦ °»½ÅÇϽʽÿÀ.

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

ÅØ½ºÆ® À妽º·Î °Ë»ö
´ÙÀ½ CONTAINS ½ºÄ®¶ó °Ë»ö ÇÔ¼ö¸¦ »ç¿ëÇÏ¿© ÅØ½ºÆ® À妽º¸¦ °Ë»öÇϽʽÿÀ.

db2 "SELECT author, story FROM books WHERE CONTAINS
    (story, '\"cat\"') = 1 AND YEAR >= 2000"
Âü°í

»ç¿ë ÁßÀÎ ¿î¿µ üÁ¦ ½©¿¡ µû¶ó, ÅØ½ºÆ® °Ë»ö ¹®±¸¸¦ ¿¡¿ö½Î´Â Å«µû¿ÈÇ¥ ¾Õ¿¡ ´Ù¸¥ Escape ¹®ÀÚ°¡ ÇÊ¿äÇÒ ¼ö ÀÖ½À´Ï´Ù. À§ ¿¹¿¡¼­´Â Escape ¹®ÀÚ·Î "\"¸¦ »ç¿ëÇÕ´Ï´Ù.

ÀÌ Äõ¸®´Â 2000³âµµ ÀÌÈÄÀÇ cat ¿ë¾î¿¡ ´ëÇÑ ¸ðµç Ã¥À» °Ë»öÇÕ´Ï´Ù. Äõ¸®´Â ´ÙÀ½ °á°ú Å×À̺íÀ» ¸®ÅÏÇÕ´Ï´Ù.

AUTHOR    STORY
Mike      The cat hunts some mice.

Áö¿øµÇ´Â ±âŸ ±â´É¿¡´Â SCORE ¹× NUMBEROFMATCHES°¡ ÀÖ½À´Ï´Ù. SCORE´Â °Ë»ö Àμö°¡ ãÀº ¹®¼­¸¦ ¾î´À Á¤µµ·Î Àß ¼³¸íÇÏ´ÂÁö¿¡ ´ëÇÑ Ç¥½Ã±â¸¦ ¸®ÅÏÇÕ´Ï´Ù. NUMBEROFMATCHES´Â °á°ú ¹®¼­¿¡¼­ ¹ß°ßµÈ Äõ¸® ¿ë¾î ÀÏÄ¡ ¼ö¸¦ ¸®ÅÏÇÕ´Ï´Ù.


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