Method and system for solving complex text query of databases based on full-text retrieval of memories

Abstract

The invention provides a method for solving complex text query of databases based on full-text retrieval of memories. A plurality of servers need to be provided; and each server provides a memory, so that a memory cluster is formed. The method comprises the following steps of 1, creating a memory database in each memory, and equably loading all fields in a relational database instance into the memory database of each memory, as key values; 2, establishing a corresponding index library for the memory database in each memory; and 3, performing text query on each index library in the memory through a retriever in a broadcast form, and returning a result to an application system. The invention furthermore provides a system for solving complex text query of the databases based on full-text retrieval of the memories. Therefore, the database query efficiency is greatly improved and the flexibility and expansibility are enhanced.

Description

technical field [0001] The invention relates to the field of databases, in particular to a method and system for solving complex text queries in databases based on memory full-text retrieval. Background technique [0002] With the continuous development of the information society, there are more and more types of businesses in all walks of life, and the people who use them are more complex. The complexity of informatization directly leads to the increase of fields in relational database instances, and the more complex the field content , when the number of records and the number of complex fields in the database instance reach a certain level, using like query will consume a lot of time and affect the smooth operation of the business. In the prior art, Lucene is used to query the database, and the index is saved to the disk through Lucene , When the database instance is too large, the index creation speed is not fast enough, so that the Lucene index needs to be innovated or ...

AI Technical Summary

Problems solved by technology

[0002] With the continuous development of the information society, there are more and more types of businesses in all walks of life, and the people who use them are more complex. The complexity of informatization directly leads to the increase of fields in relational database instances, and the more complex the field content , when the number of records and the number of complex fields in the database instance reach a certain level, using like query will consume a lot of time and affect the smooth operation of the business. In the prior art, Lucene is used to query the database, and the index is saved to the disk through Lucene , when the database instance is too large, the index creation speed is not fast enough, resulting in the need to innovate or update the Lucene index during business idle time, which will cause inconvenience in application and low query efficiency

Images