°ü¸® ¹× »ç¿ëÀÚ ¾È³»¼
DB2 Net Search Extender ¿¹¿¡ ÀÖ´Â ´ÙÀ½ ´Ü°è¸¦ »ç¿ëÇϽʽÿÀ.
±âÁ¸ÀÇ µ¥ÀÌÅͺ£À̽º¸¦ »ç¿ëÇÏ¿© ¿î¿µ üÁ¦ÀÇ ¸í·ÉÇà¿¡¼ »ùÇà ¸í·ÉÀ» ¹ßÇàÇÒ ¼ö ÀÖ½À´Ï´Ù. ´ÙÀ½ ¿¹¿¡¼ µ¥ÀÌÅͺ£À̽º À̸§Àº sampleÀÔ´Ï´Ù.
db2 "create database sample"
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¸¦ Å×ÀÌºí¿¡ ·ÎµåÇÕ´Ï´Ù.
db2text "UPDATE INDEX db2ext.myTextIndex FOR TEXT CONNECT TO sample"
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´Â °á°ú ¹®¼¿¡¼ ¹ß°ßµÈ Äõ¸® ¿ë¾î ÀÏÄ¡ ¼ö¸¦ ¸®ÅÏÇÕ´Ï´Ù.