°ü¸® ¹× »ç¿ëÀÚ ¾È³»¼
±×¸² 3. °Ë»ö½Ã 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 ¼ú¾î¿Í ÀÏÄ¡ÇÒ °ÍÀ¸·Î ¿¹»óÇÒ ¼ö ÀÖ´Â ÅØ½ºÆ® ¹®¼ ¼ö¿Í ¾î´À Á¤µµ °æÁ¦ÀûÀ¸·Î ´Ù¸¥ ¾×¼¼½º Ç÷£ ´ë¾ÈÀÌ ÀÖÀ»Áö¸¦ ÀνÄÇÕ´Ï´Ù. ¿ÉƼ¸¶ÀÌÀú´Â °¡Àå ½Ñ ¾×¼¼½º Ç÷£À» ¼±ÅÃÇÕ´Ï´Ù.