Today we implement a simple word breaker, just do the demo using the following functions:1, the participle according to the space, the horizontal bar, the point number to divide;2, the implementation of HI and hello synonym query function;3, to achieve hi and hello synonym highlighting;Myanalyzer Implementation code:public class Myanalyzer extends Analyzer {private int analyzertype;public myanalyzer (int ty
Hit the synonym of the word forest, should be the product of the last century, the word is relatively old, but at least can also use synonyms of the role of the word forest, with the Word2vec to obtain similar function comparison, the two play a comparative effect, see the specific application bar1.First download the TXT,CSDN with synonyms on the link: http://download.csdn.net/download/answerme11/73077712.The contents of the TXT are as follows: each l
index on the corresponding column after the PRIMARY KEY or UNIQUE constraint is defined
Create manually : Users can create non-unique indexes on other columns to speed up the query
To create an index on one or more columns CREATE INDEX Index
on Table (column[, Column]...); To create an index on the column last_name of table employees CREATE INDEX on employees (last_name);
Index created.②, query IndexYou can use the data dictionary view user_indexes and user_ind_columns to view the
----------------------------------------------------------Lucene participle _ Chinese participle introduction----------------------------------------------------------Paoding: Discovering word breaker. No updates have been madeMMSEG: Using Sogou's Thesaurus1. Import package (with two packages: 1. With DIC, 2. Without dic)If you use non-DIC, you have to specify the thesaurus location2. Create Mmseganalyzer (indicates where the thesaurus is located)-------------------------------------------------
Oracle synonym loop chain problem solution
[SQL] 1. First check whether there is a loop synonym: select * from dba_synonyms where table_owner = 'test' and synonym_name
When the company's production database is established, the user name used in the program is ABB, and all the tables belong to ABB. In this way, the permissions of ABB users are almost unlimited, he can drop any table. Another time a few days ago, the developer mistakenly dropped a table.
According to the original plan, the database was changed last week (because the HDD logic was damaged) and upgraded to 10 Gb by the way. therefore, during the upgrade, all objects under the abb user are moved t
greater than 2% to 4%Table updated frequentlyIt is important to note that the creation of an index is also a certain amount of resources, 21 when using the index will speed up the query, the corresponding insertion speed is slow, because also to maintain the indexQuery Index: Use the data dictionary view user_indexs,user_ind_columns to view index informationSELECT Ic.index_name, Ic.column_name,Ic.column_position col_pos,ix.uniquenessFrom User_indexes IX, User_ind_columns ICWHERE Ic.index_name =
smallColumns are not often used as join conditions or are present in the WHERE clauseData queried is greater than 2% to 4%Tables are often updatedNote: The index does not need to be used, just to say that we are querying with name. Speed will be faster. Of course, the speed of the check is fast, the insertion speed will be slow.Because the same time you insert data, you need to maintain an index.5. Querying the IndexAbility to view index information using the data dictionary view user_indexes a
Synonyms in Oracle:Summary: In simple words, the tables of different users in Oracle are generally only available to their own users, and if you do not want to authorize other users to use them in an authorized way, then create the table with the table name in front ofSynonyms, which represents synonyms. In this way, a user-created table B can be used directly instead of a to grant B access to the table.Transferred from: Http://zhidao.baidu.com/link?url=BiYEkVVBEGI9Br7Ltph1lr81f8TQEJgA_q-Omz_wlX
Synonym: literally, it means an alias, which is similar to an attempt. Is a ing relationship.
(1. Create a synonym statement:
Create public synonym table_name for user. table_name;
The first table_name and the second table_name can be different.
In addition, to create a synonym for a table on a remote Database, you
The problem is that the synonym is invalid because it is queried by the table's synonym, and this table cannot be found, so the synonym is invalid.Analyze the reason, when we create synonyms, the system will not detect the existence of the original table. However, this error occurs when you manipulate the table with this synonym.Problem possibility:1. Whether the
Oracle Database provides the synonym management function. Synonyms are aliases of database solution objects. They are often used to simplify object access and improve object access security.
Oracle Database provides the synonym management function. Synonyms are aliases of database solution objects. They are often used to simplify object access and improve object access security.
Oracle Database provide
The required information: Create a dblink from the MM Library to the GG Library
The username and password of the MM library are mmn and mmk.
The user name and password of the GG library are ggn and ggk.
Prerequisites: The MM database has the permission to establish dblink, And the hosts on both sides can be pinged.
Step 1:
First, query the global_name of the two databases.
Select * from global_name;
For example, the MM database is MMDB, And the GG database is GGDB.
Setp2:
Create dblink
-- Create
After two days, I checked n more materials and finally made them. I put them in the background and sent them again.ArticleDirectly copy and paste the words in the article and replace them with my invincible 17000 synonym library. Here we use the ACCESS database, which is basically invisible to Baidu and Google, true pseudo-originality!
Collect data tomorrow and replace it automatically after collection!
Public String dealword (string CNT) // pseudo
view_name from User_views;View the SELECT statement that created the viewSql>set view_name,text_length from User_views;Sql>set Long 2000; Description: The size of the set long can be set according to the Text_length value of the viewSql>select text from User_views where View_name=upper (' view_name ');6. SynonymsView the name of a synonymSql>select * from user_synonyms;SELECT * from all_sysnonyms;7. Constraint conditionsView constraints on a tableSql>select constraint_name, Constraint_type,sear
Synonym and index in Oracle, oraclesynonym
Notes:
Oracle-Synonyms-- Use the user name (mode name). Table Name-- Authorization: grant create synonym to test1 (authorized by the system user ))-- PrivateCreate or replace synonym sy_test1 for gcs95.test1;-- TotalCreate public synonym public_sy_test1 for gcs95.test1;/* Priv
Google provides synonym search results to try natural language understanding Technology
Google's official blog today claims that it has used natural language understanding technology to identify synonyms in search. For example, Google search considers "pictures" and "Photos" to be the same in a certain context, taking the Query [pictures developed with coffee] as an example, we can see that the "Photos" in the search results has been bold. This is a
Oracle has ORA-01775: A synonym loop chain problem
1. When you use a program to connect or use plsql to query synonyms, if there is a problem like ora-01775: the loop chain of synonyms.
It is generally because there is a synonym, but there is no corresponding object for the synonym.
2. check whether there is a synonym
See a group of people asked the ordinary user access to the base table problem, the test is as follows:The x$ base table can be accessed by creating a view, and then creating a synonym, authorization, and access to the base table for ordinary users.Of course, ordinary users visit the base table is not reasonable, theoretically not necessary, permission control should also be disallowed. It is not considered reasonable here to experiment on this issue.
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.