°ü¸® ¹× »ç¿ëÀÚ ¾È³»¼
½ºÅä¾îµå ÇÁ·Î½ÃÀú °Ë»ö ¹× SQL ½ºÄ®¶ó °Ë»ö ÇÔ¼ö ¿Ü¿¡µµ, Net Search Extender´Â ½ºÅä¾îµå ÇÁ·Î½ÃÀú¿Í ¾ÆÁÖ À¯»çÇÏ°Ô º¸ÀÌ´Â µÎ °³ÀÇ SQL Å×ÀÌºí °ª ÁöÁ¤ ÇÔ¼ö¸¦ Á¦°øÇÕ´Ï´Ù.
µÎ Å×ÀÌºí °ª ÁöÁ¤ ÇÔ¼ö¸¦ ¸ðµÎ db2ext.textsearch¶ó°í ÇÕ´Ï´Ù. ÀÌ µÎ ÇÔ¼öÀÇ Â÷ÀÌÁ¡Àº Çϳª´Â HIGHLIGHT ÇÔ¼ö¸¦ Áö¿øÇÏ°í µÎ °³ÀÇ Ãß°¡ ¸Å°³º¯¼ö numberOfHits ¹× hitInformationÀÌ ÀÖ´Ù´Â °ÍÀÔ´Ï´Ù.
º¹ÇÕ ±âº» ۸¦ Æ÷ÇÔÇÏ´Â Å×ÀÌºí¿¡¼´Â Å×ÀÌºí °ª ÁöÁ¤ ÇÔ¼ö¸¦ »ç¿ëÇÒ ¼ö ¾ø½À´Ï´Ù.
HIGHLIGHT ÇÔ¼ö »ç¿ë¿¡ ´ëÇÑ Á¤º¸´Â DB2EXT.HIGHLIGHT¸¦ ÂüÁ¶ÇϽʽÿÀ.
Âü°í |
---|
Å×ÀÌºí °ª ÁöÁ¤ ÇÔ¼ö´Â »ç¿ëÀÚ Å×À̺íÀÌ ´ÜÀÏ ³ëµå Å×ÀÌºí ½ºÆäÀ̽º¿¡ ÀúÀåµÈ °æ¿ì¿¡¸¸ ºÐ»ê DB2 ȯ°æ¿¡¼ »ç¿ëÇÒ ¼ö ÀÖ½À´Ï´Ù. ¿Ã¹Ù¸¥ ³ëµå¿¡ ¿¬°áµÇ¾ú´ÂÁö È®ÀÎÇÏ·Á¸é DB2NODE ȯ°æ º¯¼ö¸¦ »ç¿ëÇÒ ¼öµµ ÀÖ½À´Ï´Ù. |
ÇÔ¼ö ±¸¹®
1. db2ext.textsearch without highlight support db2ext.textSearch ( query VARCHAR(4096), indexSchema VARCHAR(128), indexName VARCHAR(128), resultFirstRow INTEGER, resultNumberRows INTEGER, primKeyBinding <supported types>,// same type as primary key ) return table ( primKey <supported types>,// same type as primary key numberOfMatches INTEGER, score DOUBLE, totalNbResults INTEGER ) 2. db2ext.textsearch with highlight support db2ext.textSearch ( query VARCHAR(4096), indexSchema VARCHAR(128), indexName VARCHAR(128), resultFirstRow INTEGER, resultNumberRows INTEGER, primKeyBinding <supported types>,// same type as primary key numberOfHits INTEGER ) return table ( primKey <supported types>,// same type as primary key numberOfMatches INTEGER, score DOUBLE, totalNbResults INTEGER hitInformation BLOB(20K) )
ÇÔ¼ö ¸Å°³º¯¼ö
´ÙÀ½Àº ÀÔ·Â ¸Å°³º¯¼öÀÔ´Ï´Ù.
Äõ¸® °á°ú ¸ñ·ÏÀÇ Ã¹ ¹øÂ° ÇàÀº ¼ýÀÚ 0À¸·Î ½Äº°µË´Ï´Ù.
ÀÌ ¸Å°³º¯¼ö´Â Äõ¸® °á°ú ¸ñ·ÏÀÇ ÃÖ´ë Å©±â¸¦ ÆÇº°ÇÏ´Â °á°ú ÇѰè Äõ¸® ¸Å°³º¯¼ö¿Í ´Ù¸¨´Ï´Ù.
Ãß°¡·Î ¸Å°³º¯¼ö´Â ÅØ½ºÆ® °Ë»ö ¹üÀ§¸¦ ÆÇº°ÇÕ´Ï´Ù. primaryKeyBindingÀ» NULL("CAST(NULL as <type1>)"·Î ¼³Á¤ÇÏ¸é °Ë»ö ¹üÀ§´Â À妽º¿¡ ÀúÀåµÈ ¸ðµç ¹®¼°¡ µË´Ï´Ù. ¶Ç´Â primaryKeyBindingÀÌ ¹ÙÀεåµÈ ¹®¼·Î °Ë»öÀ» Á¦ÇÑÇÒ ¼ö ÀÖ½À´Ï´Ù.
¿¹¸¦ µé¾î, primaryKeyBindingÀ» CAST(5 as BIGINT)·Î ¼³Á¤ÇÏ¸é °Ë»öÀº BIGINT ±âº» Ű °ªÀÌ "5"ÀÎ ´ÜÀÏ ¹®¼·Î Á¦Çѵ˴ϴÙ.
SMALLINT, INTEGER, BIGINT, REAL, DOUBLE, VARCHAR FOR BIT DATA, DATE, TIME ¹× TIMESTAMP À¯ÇüÀ» °¡Áø ´ÜÀÏ Ä÷³ ±âº» ۸¸ÀÌ Áö¿øµË´Ï´Ù.
ÀÌ ¸Å°³º¯¼ö´Â db2ext.highlight ÇÔ¼ö¿¡ ÇÊ¿äÇÑ °Á¶Ç¥½Ã Á¤º¸¸¦ ±¸¼ºÇÏ´Â µ¥¸¸ ÇÊ¿äÇÕ´Ï´Ù.
ÇÔ¼ö ¸Å°³º¯¼ö
ÀÚ¼¼ÇÑ °á°ú¸¦ ¿äûÇÒ °æ¿ì, ´ÙÀ½ ¸®ÅϰªÀº º¸Åë Å×ÀÌºí¿¡ Á¶ÀεǾî¾ß ÇÏ´Â Àӽà Å×ÀÌºí¿¡ ÀúÀåµË´Ï´Ù. NUMBEROFMATCHES, SCORE, TOTALNUMBEROFRESULTS ¹× HITINFORMATIONÀº select¹®¿¡ ¿äûµÈ °æ¿ì¿¡¸¸ °è»êµË´Ï´Ù.
¶ÇÇÑ Äõ¸®¿¡¼ STOP SEARCH AFTER ¶Ç´Â RESULT LIMIT¸¦ SCORE ±¸¹®°ú ÇÔ²² »ç¿ëÇÏ´Â °æ¿ì ÀÌ ¼ö¸¦ ´õ ÀÌ»ó ½Å·ÚÇÒ ¼ö ¾ø½À´Ï´Ù.
numberOfHits¸¦ ÁöÁ¤ÇÑ °æ¿ì¿¡¸¸ ÀÌ °ªÀÌ ¸®Åϵ˴ϴÙ.
SQL Å×ÀÌºí °ª ÁöÁ¤ ÇÔ¼ö¸¦ »ç¿ëÇÏ¿© ½ºÅä¾îµå ÇÁ·Î½ÃÀú °Ë»ö¿¡¼ ¼öÇàÇÏ´ø °Í°ú µ¿ÀÏÇÑ ¹æ¹ýÀ¸·Î ºä¿¡ ´ëÇÑ °Ë»öÀ» ¼öÇàÇÒ ¼ö ÀÖ½À´Ï´Ù. ¿¹¿Ü°¡ ÀÖ´Ù¸é °øÀ¯ ¸Þ¸ð¸®°¡ ÇÊ¿äÇÏÁö ¾ÊÀ¸¹Ç·Î À妽º¸¦ Ȱ¼ºÈÇÒ Çʿ䰡 ¾ø´Ù´Â °ÍÀÔ´Ï´Ù.
ÀÌ ÇÔ¼ö´Â ±âº»ÀûÀ¸·Î ½ºÅä¾îµå ÇÁ·Î½ÃÀú °Ë»ö ³»¿¡¼ SQL Äõ¸®¸¦ »ç¿ëÇÏ´ø »ç¿ëÀÚ¸¦ À§ÇÑ °ÍÀÔ´Ï´Ù. ±×·¯³ª Á¦ÇÑ»çÇ×Àº ±âº» Å×ÀÌºí¿¡ ´ëÇØ ´ÜÀÏ Ä÷³ÀÇ ±âº» ۸¸ÀÌ Áö¿øµÈ´Ù´Â °ÍÀÔ´Ï´Ù.
´ÙÀ½ÀÇ ¿¹´Â ´ÙÁß Ä÷³ ±âº» Ű Å×ÀÌºí¿¡ ´ëÇØ ÀÛ¾÷ÇÏ´Â ¹æ¹ýÀ» Ç¥½ÃÇÕ´Ï´Ù.
select s.id from db2ext.sample s, table (db2ext.textSearch( '"characteristics"', 'DB2EXT', 'COMMANDS', 1, 20, cast(NULL as INTEGER))) t where s.id = t.primkey
ÀÌ ¿¹¿¡¼, ¸ÕÀú ´ÜÀÏ °íÀ¯ ۸¦ »ç¿ëÇÏ¿© ÀÌ Å×ÀÌºí¿¡ ´ëÇÑ ºä¸¦ ÀÛ¼ºÇÑ ÈÄ, ÀÌ ºä¿¡ ´ëÇÑ À妽º¸¦ ÀÛ¼ºÇϽʽÿÀ.
db2ext.highlight ÇÔ¼ö¿Í ÇÔ²² SQL Å×ÀÌºí °ª ÁöÁ¤ ÇÔ¼ö¸¦ »ç¿ëÇÏ´Â °æ¿ìÀÇ ¿¹´Â *** ÆäÀÌÁö¸¦ ÂüÁ¶ÇϽʽÿÀ.