IBM å
(C) IBM Corp. 2000

Net Search Extender

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

SQL ½ºÄ®¶ó °Ë»ö ÇÔ¼ö »ç¿ë

±×¸² 3. °Ë»ö½Ã SQL ½ºÄ®¶ó °Ë»ö ÇÔ¼ö »ç¿ë

°Ë»ö½Ã SQL ½ºÄ®¶ó °Ë»ö ÇÔ¼ö »ç¿ë

Net Search Extender´Â SQL ³»¿¡¼­ ¿Ïº®ÇÏ°Ô ÅëÇյǴ ¼¼ °¡ÁöÀÇ ½ºÄ®¶ó ÅØ½ºÆ® °Ë»ö ±â´É(CONTAINS, NOOFMATCHES, SCORE)À» Á¦°øÇÕ´Ï´Ù. SQL Äõ¸®¿¡¼­ Ç¥ÁØ SQL Ç¥Çö½ÄÀ» »ç¿ëÇÏ·Á´Â ¹Ù·Î ±× À§Ä¡¿¡¼­ °Ë»ö ±â´ÉÀ» »ç¿ëÇÒ ¼ö ÀÖ½À´Ï´Ù. ÀϹÝÀûÀÎ Á¶È¸´Â ´ÙÀ½°ú °°½À´Ï´Ù.

SELECT * FROM books WHERE CONTAINS (abstract,'"relational databases"') = 1
          AND PRICE <10
 
SELECT ISBN, SCORE (abstract, '"relational databases"') as SCORE 
          from BOOKS
          where NUMBEROFMATCHES (abstract, '"relational databases"') 
          >5 AND PRICE <10 
          order by SCORE

SQL ½ºÄ®¶ó ÇÔ¼ö´Â ÅØ½ºÆ® ¹®¼­°¡ Á¦°øµÈ ÅØ½ºÆ® °Ë»ö Á¶°Ç°ú ¾î´À Á¤µµ ÀÏÄ¡Çß´ÂÁö¿¡ ´ëÇÑ Ç¥½Ã±â¸¦ ¸®ÅÏÇÕ´Ï´Ù. ±×·¯¸é SQL Äõ¸®ÀÎ SELECT ±¸¹®Àº ÀÏ¹Ý »ç¿ëÀÚ¿¡°Ô ¸®ÅÏµÈ Á¤º¸¸¦ ÆÇº°ÇÕ´Ï´Ù.

±âº» °Ë»ö ¸Þ¼Òµå·Î SQL ½ºÄ®¶ó °Ë»ö ±â´ÉÀ» »ç¿ëÇϽʽÿÀ. ÀÌ °Ë»ö ±â´ÉÀº ¿©·¯ »óȲ, ƯÈ÷ ÅØ½ºÆ® °Ë»ö Ç¥Çö½ÄÀÌ ´Ù¸¥ Á¶°Ç°ú °áÇյǾî ÀÖ´Â °æ¿ì¿¡ ÀûÇÕÇØ¾ß ÇÕ´Ï´Ù.

DB2 ¿ÉƼ¸¶ÀÌÀú´Â CONTAINS ¼ú¾î¿Í ÀÏÄ¡ÇÒ °ÍÀ¸·Î ¿¹»óÇÒ ¼ö ÀÖ´Â ÅØ½ºÆ® ¹®¼­ ¼ö¿Í ¾î´À Á¤µµ °æÁ¦ÀûÀ¸·Î ´Ù¸¥ ¾×¼¼½º Ç÷£ ´ë¾ÈÀÌ ÀÖÀ»Áö¸¦ ÀνÄÇÕ´Ï´Ù. ¿ÉƼ¸¶ÀÌÀú´Â °¡Àå ½Ñ ¾×¼¼½º Ç÷£À» ¼±ÅÃÇÕ´Ï´Ù.


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