Method for carrying out term matching on data in database

Abstract

The invention discloses a method for carrying out term matching on data in a database. The method is characterized in comprising a step of establishing an index and a step of carrying out term search matching by employing the index. The step of establishing the index is as follows: traversing the database and generating a double-array dictionary tree according to a source character string and a target character string; inserting character string data into the double-array dictionary tree, thereby realizing a first-level index of the character string data; establishing a corresponding relationship between an ID of the character string data and a keyword filed of a data record in which the character string data is located, wherein the data record is in the database, and the corresponding relationship is used for realizing a second-level index of the character string data; and storing the second-level index in a memory cache system. The step of carrying out term search matching by employing the index is as follows: searching an object ID and term bank ID of the data record corresponding to the character string in the database according to the ID of the second-level index, searching according to the object ID and the term bank ID and obtaining a searching result. Various searching demands of the term matching can be satisfied, and the integrated matching performance is improved.

Description

technical field [0001] The invention belongs to the field of computer communication, in particular to a method for matching terms to data in a database. Background technique [0002] At present, computer-assisted translation is an important means to improve the consistency and efficiency of translation. It requires the software to continuously memorize the latest terms and corpus, and to call out terms or corpus that meet the corresponding conditions in a timely manner for selection in the subsequent translation process. . With the continuous expansion of terminology and corpus, the efficiency of retrieving complete translation information directly from the original text or translation based on traditional relational databases or newer non-relational databases will decrease significantly. For relatively large manuscripts to be translated, the speed is naturally unacceptable. Taking mongo database as an example, each document record contains document ID, original text, tr...

AI Technical Summary

Problems solved by technology

[0004] The technical problem to be solved by the present invention is that the current term matching engine based on the database is relatively slow in word search efficiency, and the way to improve this problem is to build a fast index for the terms in the database, and the introduction of a double-array dictionary tree can solve a large number of problems. The problem of slow terminology indexing and slow query

Images