ÅØ½ºÆ® °Ë»ö Á¶È¸ Ãß°¡

DB2 Text Extender´Â ÅØ½ºÆ® °Ë»ö ÇÏÀ§ Á¶È¸¸¦ SQL Á¶È¸¿¡ Æ÷ÇÔÇÒ ¼ö ÀÖµµ·Ï ÇÏ´Â SQL ±â´ÉÀ» Á¦°øÇÕ´Ï´Ù. ÀÌ·¯ÇÑ ±â´ÉÀ» UDF(User Defined Function)¶ó°í ÇÕ´Ï´Ù. ´ÙÀ½Àº DB2 Text ExtenderÀÇ UDF¸¦ »ç¿ëÇÏ¿© commerce µ¥ÀÌÅͺ£À̽º¸¦ Á¶È¸ÇÏ´Â SQL¹®ÀÇ ¿¹ÀÔ´Ï´Ù.
    SELECT CATENTRY_ID, SHORTDESCRIPTION
    FROM CATENTDESC
    WHERE DB2TX.CONTAINS (DESCHANDLE, '("boots" IN SAME PARAGRAPH AS
    "hiking" AND SYNONYM FORM OF "footwear")')=1
¿©±â¼­, DB2TX.CONTAINS´Â ¿©·¯ DB2 Text Extender ±â´É Áß ÇϳªÀ̰í, DESCHANDLEÀº °Ë»öÇÒ ÅØ½ºÆ® µ¥ÀÌÅͰ¡ µé¾î ÀÖ´Â ¿­ÀÇ ¿­ ÇÚµé À̸§ÀÔ´Ï´Ù. ÀÌ À̸§Àº DB2 Text Extender¿¡ ´ëÇØ ¿­ÀÌ Ã³À½À¸·Î ÀÛµ¿ÇÒ ¶§ ÁöÁ¤µÈ ¿­ ÇÚµé À̸§ÀÔ´Ï´Ù.

¸í·É¹®ÀÇ ³ª¸ÓÁö ºÎºÐÀº "boots," "hiking," ¹× "footwear" ¶Ç´Â ÇÑ ´Ü¶ô¿¡¼­ ³ªÅ¸³ª´Â À̵éÀÇ µ¿ÀǾ ã½À´Ï´Ù.

ÀÌÀü ¿¹ÀÇ º¯ÇüÀº ´ÙÀ½°ú °°½À´Ï´Ù.
    SELECT CATENTRY_ID, SHORTDESCRIPTION
    FROM CATENTDESC
    WHERE DB2TX.CONTAINS (DESCHANDLE, '("boots" & "hiking" | "equipment"
    & "skiing")')=1
ÀÌ º¯Çü¿¡¼­, Æò°¡ ¼ø¼­´Â ¿ÞÂÊ¿¡¼­ ¿À¸¥ÂÊÀÔ´Ï´Ù. ·ÎÁ÷ AND (&) ¿¬»êÀÚ ¹ÙÀεå´Â ·ÎÁ÷ OR (|) ¿¬»êÀÚº¸´Ù °­ÇÕ´Ï´Ù.
    SELECT CATENTRY_ID, SHORTDESCRIPTION
    FROM CATENTDESC
    WHERE DB2TX.CONTAINS (DESCHANDLE, '("hiking", "skiing",
    "sports")')=1
ÀÌ º¯Çü¿¡¼­, °Ë»ö Àμö¿¡ µÑ ÀÌ»óÀÇ Á¶°ÇÀÌ ÁöÁ¤µÇ¾ú½À´Ï´Ù. Á¶°ÇÀº ½°Ç¥(,)¸¦ »ç¿ëÇÏ¿© °áÇյǾú½À´Ï´Ù.

°ü·Ã °³³ä

°ü·Ã ŽºÅ©

IBM copyright