.. -*- rst -*- .. highlightlang:: none .. groonga-command .. database: tutorial-query-expansion ã¯ã¨ãªæ¡å¼µ ========== groongaã§ã¯ã :doc:`/reference/commands/select` ã³ãã³ãã«query_expanderãã©ã¡ã¼ã¿ãæå®ãããã¨ã«ãã£ã¦ãã¦ã¼ã¶ãæå®ããæ¤ç´¢æååãé©å®æ¡å¼µãããã¨ãå¯è½ã§ãã ãã¨ãã°ãã¦ã¼ã¶ã'ã·ã¼ã¯ã®ã¼ãµã¼'ã¨ããæååã§æ¤ç´¢ããå ´åã«ã'ã·ã¼ã¯ã®ã¼ãµã¼ OR ã·ã¼ã¯ã¡ã¼ãµã¼'ã§æ¤ç´¢ããå ´åã¨åä¸ã®çµæãè¿ããã¨ã«ãã£ã¦ãæ¬æ¥ã¦ã¼ã¶ãå¿ è¦ã¨ããçµæããããããªãæ¤ç´¢ã§ããããã«ãªãã¾ãã æºå ---- ã¯ã¨ãªæ¡å¼µæ©è½ã使ç¨ããããã«ã¯ãæ¤ç´¢å¯¾è±¡ã¨ãªãææ¸ãæ ¼ç´ãããã¼ãã«(ããã§ã¯ææ¸ãã¼ãã«ã¨å¼ã³ã¾ã)以å¤ã«ãã¦ã¼ã¶ã®æå®ããæ¤ç´¢æååãç½®æããããã®ãã¼ãã«(ããã§ã¯ç½®æãã¼ãã«ã¨å¼ã³ã¾ã)ãæºåãã¾ããç½®æãã¼ãã«ã§ã¯ããã®ä¸»ãã¼ãç½®æåã®æååã¨ãªããæååå(ShortText)ã®ã«ã©ã ã®å¤ãç½®æå¾ã®æååã¨ãªãã¾ãã TODO: æåååã®ãã¯ã¿ã¼ã«ã©ã ã§ãå¯è½ã§ããããã®å ´åã¯åè¦ç´ ãORã§ã¤ãªãããã®ã«ç½®æãããã¨ãããã¨ãè¨è¿°ããã å®éã«ææ¸ãã¼ãã«ã¨ç½®æãã¼ãã«ãä½æãã¦ã¿ã¾ãããã .. groonga-command .. include:: ../example/tutorial/query_expansion-1.log .. table_create Doc TABLE_PAT_KEY ShortText .. column_create Doc body COLUMN_SCALAR ShortText .. table_create Term TABLE_PAT_KEY|KEY_NORMALIZE ShortText --default_tokenizer TokenBigram .. column_create Term Doc_body COLUMN_INDEX|WITH_POSITION Doc body .. table_create Synonym TABLE_PAT_KEY ShortText .. column_create Synonym body COLUMN_SCALAR ShortText .. load --table Doc .. [ .. {"_key": "001", "body": "ãã£ã±ãããã¦ã¨çãã·ã¼ã¯ã¡ã¼ãµã¼"}, .. {"_key": "002", "body": "ã·ã¼ã¯ã®ã¼ãµã¼ã¸ã¥ã¼ã¹ã¨ã´ã¼ã¤ãã£ã³ãã«"}, .. ] .. load --table Synonym .. [ .. {"_key": "ã·ã¼ã¯ã¡ã¼ãµã¼", "body": "(ã·ã¼ã¯ã¡ã¼ãµã¼ OR ã·ã¼ã¯ã®ã¼ãµã¼)"}, .. {"_key": "ã·ã¼ã¯ã®ã¼ãµã¼", "body": "(ã·ã¼ã¯ã¡ã¼ãµã¼ OR ã·ã¼ã¯ã®ã¼ãµã¼)"}, .. ] ãã®ä¾ã§ã¯ãã¦ã¼ã¶ã"ã·ã¼ã¯ã¡ã¼ãµã¼"ã¨å ¥åãã¦ãã"ã·ã¼ã¯ã®ã¼ãµã¼"ã¨å ¥åãã¦ããããããã®ç°ãªã表è¨ã®ææ¸ããããªãæ¤ç´¢ããããã®ç½®æãã¼ãã«ãä½æãã¦ãã¾ãã æ¤ç´¢ ---- ããã§ã¯å®éã«ãæºåããç½®æãã¼ãã«ã使ã£ã¦ã¿ã¾ããããã¾ãã¯ãquery_expanderãã©ã¡ã¼ã¿ãæå®ããã«selectã³ãã³ãã使ã£ã¦æ¤ç´¢ãã¦ã¿ã¾ãã .. groonga-command .. include:: ../example/tutorial/query_expansion-2.log .. select Doc --match_columns body --query "ã·ã¼ã¯ã¡ã¼ãµã¼" .. select Doc --match_columns body --query "ã·ã¼ã¯ã®ã¼ãµã¼" æå®ãããæååã«å®å ¨ã«ä¸è´ããã¬ã³ã¼ãã®ã¿ãããããããããã¾ãã次ã«ãquery_expanderãã©ã¡ã¼ã¿ã«ãæºåããSynonymãã¼ãã«ã®bodyã«ã©ã ãæå®ãã¦ã¿ã¾ãããã .. groonga-command .. include:: ../example/tutorial/query_expansion-3.log .. select Doc --match_columns body --query "ã·ã¼ã¯ã¡ã¼ãµã¼" --query_expander Synonym.body .. select Doc --match_columns body --query "ã·ã¼ã¯ã®ã¼ãµã¼" --query_expander Synonym.body ã©ã¡ãã®ã¯ã¨ãªæååãã"(ã·ã¼ã¯ã¡ã¼ãµã¼ OR ã·ã¼ã¯ã®ã¼ãµã¼)"ã¨ããæååã«ç½®æããã¦ããæ¤ç´¢ãããããã表è¨ã®æºããå¸åãã¦æ¤ç´¢ã§ããããã«ãªãã¾ããã