°ü¸® ¹× »ç¿ëÀÚ ¾È³»¼
µÎ °³ÀÇ SQL Å×ÀÌºí °ª ÁöÁ¤ ÇÔ¼ö(µÑ ´Ù db2ext.textsearch¶ó°í ÇÔ)°¡ ÀÖ½À´Ï´Ù. db2ext.highlight ÇÔ¼ö¸¦ »ç¿ëÇÏ·Á¸é db2ext.textsearch ÇÔ¼ö¸¦ Ãß°¡ numberOfHits ¹× hitInformation ¸Å°³º¯¼ö¿Í ÇÔ²² »ç¿ëÇϽʽÿÀ.
ÀÌ ¿¹¿¡¼, db2ext.textsearch ÇÔ¼ö¿¡ ÀÇÇØ ¹ß°ßµÈ °Ë»ö °á°ú¸¦ °Á¶Ç¥½ÃÇÏÁö ¾Ê°í Àüü ¹®¼¸¦ Ç¥½ÃÇϱâ À§ÇØ db2ext.highlight ÇÔ¼ö¸¦ È£ÃâÇϽʽÿÀ.
select p.docid, db2ext.highlight(p.comment, t.hitinformation, ' WINDOW_NUMBER = 0 ') as highlight from DB2EXT.TEXTTAB p, table (db2ext.textsearch('"bestseller" | "peacekeeping" | "soldiers" | "attention"', 'DB2EXT', 'COMMENT', 0, 20, cast(NULL as INTEGER), 10)) t where p.docid = t.primkey and p.docid = 2
°Ë»ö Àμö´Â ´ÙÀ½ °á°ú¸¦ ¸®ÅÏÇÕ´Ï´Ù.
DOCID HIGHLIGHT 2 A New York Times bestseller about peacekeeping soldiers called "Keepers" who devise a shocking scheme to get the worlds attention after their tour of duty ends. 1 ·¹Äڵ尡 ¼±ÅõǾú½À´Ï´Ù.
Âü°í |
---|
¸ðµç db2ext.highlight ¿¹¿¡¼, Å×À̺í ÇÔ¼ö db2ext.textsearch´Â "bestseller", "peacekeeping", "soldiers" ¶Ç´Â "attention" ´Ü¾î¸¦ °Ë»öÇÕ´Ï´Ù. |
ÀÌ ¿¹¿¡¼, db2ext.textsearch ÇÔ¼ö¿¡ ÀÇÇØ ¹ß°ßµÈ °Ë»ö °á°ú¸¦ °Á¶Ç¥½ÃÇϰí Àüü ¹®¼¸¦ Ç¥½ÃÇϱâ À§ÇØ db2ext.highlight ÇÔ¼ö¸¦ È£ÃâÇÕ´Ï´Ù.
select p.docid, db2ext.highlight(p.comment, t.hitinformation, ' WINDOW_NUMBER = 0, TAGS = ("<bf>", "</bf>" ) ') as highlight from DB2EXT.TEXTTAB p, table (db2ext.textsearch('"bestseller" | "peacekeeping" | "soldiers" | "attention"', 'DB2EXT', 'COMMENT', 0, 20, cast(NULL as INTEGER), 10)) t where p.docid = t.primkey and p.docid = 2
°Ë»ö Àμö´Â ´ÙÀ½ °á°ú¸¦ ¸®ÅÏÇÕ´Ï´Ù.
DOCID HIGHLIGHT 2 A New York Times <bf>bestseller</bf> about <bf>peacekeeping</bf> <bf>soldiers</bf> called "Keepers" who devise a shocking scheme to get the worlds <bf>attention</bf> after their tour of duty ends. 1 ·¹Äڵ尡 ¼±ÅõǾú½À´Ï´Ù.
ÀÌ ¿¹¿¡¼, ÃÖ´ë 10°³ÀÇ ¹®¼ ºÎºÐ(â)À» Ç¥½ÃÇϱâ À§ÇØ db2ext.highlight ÇÔ¼ö¸¦ È£ÃâÇÕ´Ï´Ù. °¢ âÀÇ Å©±â´Â 24À̸ç, À̰ÍÀº °Ë»ö °á°úÀÇ ¾çÂÊÀ¸·Î ¾à 12¹ÙÀÌÆ®ÀÇ µ¥ÀÌÅÍÀÔ´Ï´Ù. ¶ÇÇÑ Å×À̺í ÇÔ¼ö db2.textsearch¿¡ ÀÇÇØ ¹ß°ßµÈ °Ë»ö °á°ú°¡ °Á¶Ç¥½ÃµË´Ï´Ù.
select p.docid, db2ext.highlight(p.comment, t.hitinformation, ' WINDOW_NUMBER = 10, WINDOW_SIZE = 24, TAGS = ("<bf>", "</bf>" ) ') as highlight from DB2EXT.TEXTTAB p, table (db2ext.textsearch('"bestseller" | "peacekeeping" | "soldiers" | "attention"', 'DB2EXT', 'COMMENT', 0, 20, cast(NULL as INTEGER), 10)) t where p.docid = t.primkey and p.docid = 2
°Ë»ö Àμö´Â ´ÙÀ½ °á°ú¸¦ ¸®ÅÏÇÕ´Ï´Ù.
DOCID HIGHLIGHT 2 York Times <bf>bestseller</bf> about <bf>peacekeeping</bf> ... <bf>peacekeeping</bf> <bf>soldiers</bf> called "Keepers" ... the worlds <bf>attention</bf> after their 1 ·¹Äڵ尡 ¼±ÅõǾú½À´Ï´Ù.
óÀ½À¸·Î ¹ß°ßµÈ °Ë»ö °á°ú´Â <bf>bestseller</bf>À̸ç ÀÌ °Ë»ö °á°ú´Â ù ¹øÂ° âÀ» ÆÇº°ÇÕ´Ï´Ù. µÎ ¹øÂ° °Ë»ö °á°ú <bf>peacekeeping</bf>Àº ù ¹øÂ° °Ë»ö °á°ú¿¡¼ 8¹ÙÀÌÆ® ¶³¾îÁ® ÀÖÀ¸¸ç ù ¹øÂ° â¿¡ ¿ÏÀüÈ÷ Æ÷ÇԵ˴ϴÙ. ¼¼ ¹øÂ° °Ë»ö °á°ú <bf>soldiers</bf>´Â ù ¹øÂ° â¿¡¼ ¹þ¾î³ª¸ç »õ âÀ» ÆÇº°ÇÕ´Ï´Ù. µÎ ¹øÂ° °Ë»ö °á°ú <bf>peacekeeping</bf>Àº <bf>soldiers</bf> °Ë»ö °á°úÀÇ ¿ÞÂÊ¿¡¼ 2¹ÙÀÌÆ®¸¸ ¶³¾îÁ® ÀÖÀ¸¹Ç·Î µÎ ¹øÂ° â¿¡µµ Æ÷ÇÔµÇ°í °Á¶Ç¥½ÃµË´Ï´Ù. ³× ¹øÂ° °Ë»ö °á°ú <bf>attention</bf>Àº µÎ ¹øÂ° â¿¡¼ ¹þ¾î³ª¹Ç·Î »õ âÀ» ÆÇº°ÇÕ´Ï´Ù. ÀÌÀü ¶Ç´Â Ãß°¡ °Ë»ö °á°ú°¡ ÀÌ Ã¢ Å©±â ¾È¿¡ Æ÷ÇÔµÇÁö ¾ÊÀ¸¹Ç·Î °Ë»ö °á°ú¸¦ µÑ·¯½Ñ µ¥ÀÌÅ͸¸ÀÌ Ã¢¿¡ Æ÷ÇԵ˴ϴÙ.
¶ÇÇÑ WINDOW_SEPARATOR°¡ ÁöÁ¤µÇÁö ¾Ê¾ÒÀ¸¹Ç·Î µðÆúÆ® â ±¸ºÐÀÚÀÎ " ... "ÀÌ ¼¼ °³ÀÇ ¹®¼ âÀ» ³ª´©´Â µ¥ »ç¿ëµË´Ï´Ù.
Âü°í |
---|
db2ext.highlight ÇÔ¼ö¸¦ »ç¿ëÇÒ ¶§ ³ôÀº ¼º´ÉÀ» º¸ÀåÇÏ·Á¸é »ç¿ëÀÚ´Â °Ë»ö½Ã¸¶´Ù db2ext.textsearch Å×ÀÌºí °ª ÁöÁ¤ ÇÔ¼ö·Î °Ë»ö °á°ú¸¦ Á¦ÇÑÇϽʽÿÀ. |
¸Å°³º¯¼ö¿¡ ´ëÇÑ ¼¼ºÎ»çÇ×Àº DB2EXT.HIGHLIGHT¸¦ ÂüÁ¶ÇϽʽÿÀ.