oracleÈ«ÎÄË÷ÒýÖ®About_INDEX_THEMES²Ù×÷
OracleµÄÈ«ÎÄË÷Òý³ýÁËÖ§³ÖÎÄ×ÖÆ¥Åä²éѯ£¬»¹Ö§³Ö¶ÔÎÄÕºÒåµÄ²éѯ¡£ÕâÊÇͨ¹ýABOUT²Ù×÷ʵÏֵġ£
OracleĬÈÏÇé¿öÏÂÖ§³ÖÓ¢Îĺͷ¨ÎĵÄÎÄÕºÒåÖ§³Ö¡£ÆäËûÓïÑÔ¿ÉÒÔÌí¼Óͨ¹ýÓû§×Ô¶¨ÒåµÄÓïÑÔ¿âÀ´ÊµÏÖÏàÓ¦µÄ¹¦ÄÜ¡£
ÔÚ
Õâ֮ǰÐèÒªÏÈ°²×°Companion CD µÄOracle Database 10g Products Installation
Type,ÆäÖаüÀ¨ÁËOracle Text Supplied Knowledge
Bases£¬·ñÔòÔÚ½¨Á¢º¬ÓÐaboutµÄË÷Òýʱ»á³ö´í¡£Companion CD¿ÉÖ±½ÓÔÚ¹ÙÍøÏÂÔØ£¬°²×°Ò²·Ç³£¼òµ¥¡£
ÏÂÃæ¿´¿´Ó¢ÎÄ»·¾³Ï¼òµ¥µÄABOUT²Ù×÷Ó÷¨£º
SQL> conn myuser/myuser
Connected.
SQL> CREATE TABLE T (ID NUMBER PRIMARY KEY, DOCS VARCHAR2(1000));
Table created.
SQL> INSERT INTO T VALUES (1, 'You can augment the knowledge base to define concepts and terms specific to your
industry or query application. When you do so, ABOUT queries are more precise for the added concepts.');
1 row created.
SQL> INSERT INTO T VALUES (2, 'ABOUT queries perform best when you create a theme component in your index. Theme
components are created by default for English and French.');
1 row created.
SQL> COMMIT;
Commit complete.
SQL> CREATE INDEX IND_T_DOCS ON T(DOCS) INDEXTYPE IS CTXSYS.CONTEXT;
Index created.
SQL> SELECT ID from T WHERE CONTAINS(DOCS, 'ABOUT(queries)') > 0;
ID
----------
1
2
SQL> SELECT ID from T WHERE CONTAINS(DOCS, 'queries') > 0;
ID
----------
1
2
ĬÈϵÄLEXERÊÇBASIC_LEXER£¬Òò´Ë£¬¿ÉÒÔABOUT²Ù×÷ÒѾ¿ÉÒÔÆð×÷ÓÃÁË£¬µ«ÊÇÓÉÓÚ²ÉÓÃĬÈÏÉèÖã¬ABOUT²éѯµÄ¾«¶È²»¸ß¡£ËäÈ»¿ÉÒÔ²éѯµ½£¬µ«ÊÇÕâ¸öµ¥´Ê±¾Éí¾ÍÊÇÔÚÎÄÕÂÖгöÏֵģ¬Èç¹ûʹÓÃÎÄÕÂÖÐûÓгöÏֵĵ¥´Ê£¬ABOUT»¹ÊDzéѯ²»µ½¡£
SQL> SELECT ID from T WHERE CONTAINS(DOCS, 'ABOUT(definition)') > 0;
no rows selected
SQL> SELECT ID from T WHERE CONTAINS(DOCS, 'definition') > 0;
no rows selected
Èç¹ûÏ£ÍûÌá¸ßABOUT²Ù×÷µÄ²éѯ¾«¶È£¬¿ÉÒÔÉèÖÃBASIC_LEXERÖеÄINDEX_THEMESÊôÐÔµÄֵΪYES¡£
SQL> BEGIN
2 CTX_DDL.CREATE_PREFERENCE('TEST_ABOUT', 'BASIC_LEXER');
3 CTX_DDL.SET_ATTRIBUTE('TEST_ABOUT', 'INDEX_THEMES', 'YES');
4 CTX_DDL.
Ïà¹ØÎĵµ£º
¡¡¡¡Á½Ì¨²»Í¬µÄÊý¾Ý¿â·þÎñÆ÷£¬´Óһ̨Êý¾Ý¿â·þÎñÆ÷µÄÒ»¸öÓû§¶ÁÈ¡Áíһ̨Êý¾Ý¿â·þÎñÆ÷ϵÄij¸öÓû§µÄÊý¾Ý£¬Õâ¸öʱºò¿ÉÒÔʹÓÃdblink¡£
¡¡¡¡ÆäʵdblinkºÍÊý¾Ý¿âÖеÄview²î²»¶à£¬½¨dblinkµÄʱºòÐèÒªÖªµÀ´ý¶ÁÈ¡Êý¾Ý¿âµÄipµØÖ·£¬ssidÒÔ¼°Êý¾Ý¿âÓû§ÃûºÍÃÜÂë¡£
¡¡¡¡´´½¨¿ÉÒÔ²ÉÓÃÁ½ÖÖ·½Ê½£º
¡¡¡¡1¡¢ÒѾÅäÖñ¾µØ·þÎñ
ÒÔÏ ......
1.ÔÚAÓû§ÏÂÊÚȨ“ÉÌ»§ÐÅÏ¢±í”¸øBÓû§
grant all on TBL_INF_MCHNT_INF to B;
commit;
2.ÔÚBÓû§Ï½¨Á¢Í¬Òå´Ê
create synonym TBL_INF_MCHNT_INF for A.TBL_INF_MCHNT_INF;
3. ²éѯÊý¾Ý¿âËùÓÐͬÒå´Êselect * from sys.synonyms ......
½éÉÜÍêOracleÈ«ÎÄË÷ÒýµÄFILTERÊôÐÔ£¬¼ÌÐø½éÉÜOracleµÄLEXERÊôÐÔ¡£
OracleÈ«ÎÄË÷ÒýµÄLEXERÊôÐÔÓÃÓÚ´¦Àí¸÷ÖÖ²»Í¬µÄÓïÑÔ¡£×î»ù±¾µÄÓ¢ÎÄʹÓÃBASE_FILTER£¬¶øÈç¹ûÐèҪʹÓÃÖÐÎÄÔò¿ÉÒÔʹÓÃCHINESE_VGRAM_LEXER»òCHINESE_LEXER¡£
ÕâƪÎÄÕ¼òµ¥ËµÃ÷BASIC_LEXERÊôÐÔ¡£BASIC_LEXERÊôÐÔÖ§³Ö¶àÖÖÓïÑÔ£¬±ÈÈçÓ¢Óï¡¢µÂÓï¡¢ºÉÀ¼ÓŲ ......
OracleÈ«ÎÄË÷ÒýµÄSTORAGEÊôÐÔÊÇΪÁ˸øÈ«ÎÄË÷ÒýÉú³ÉµÄ¸¨Öú±íÉèÖô洢²ÎÊýµÄ¡£
OracleµÄÈ«ÎÄË÷Òý»áÉú³ÉÒ»ÕÅ»ò¶àÕŸ¨Öú±í£¬ÓÉÓÚÕâЩ±íÊÇOracle×Ô¶¯Éú³ÉµÄ£¬Óû§Ã»Óа취ֱ½ÓÉèÖÃÕâЩ±íºÍË÷ÒýµÄÎïÀí²ÎÊý£¬Òò´ËOracleÌṩÁËSTORAGEÊôÐÔ£¬×¨ÃÅÉèÖÃÕâЩ¸¨Öú±íºÍË÷ÒýµÄÎïÀí²ÎÊý¡£
SQL> SELECT * from TAB;
TNAME ......