A data query method and device

Abstract

The invention discloses a data querying method and device. The data querying method and device are used for determining querying paths of all querying statements according to own judgment when data querying is conducted to improve the data querying efficiency. The data querying method comprises the steps that the querying statements sent by a user are received and converted into a logic execution plan tree; whether the querying statements are complex statements or not is judged according to arithmetic operators included in the converted logic execution plan tree, if yes, data querying is conducted according to a database querying mode, and otherwise, data querying is conducted according to pre-created indexes in a search engine mode or in an index engine mode.

Description

technical field [0001] The invention relates to the field of communication technology, in particular to a data query method and device. Background technique [0002] With a large amount of business data and social networks accumulating more and more various data, how to quickly query records that meet the conditions in massive data storage is a relatively big challenge. [0003] At present, the full-text search engine (lucene), which is a relatively common and mature search engine framework, realizes relatively powerful data query through inverted index technology. The index engine has its own query syntax and has considerable advantages for search; in addition, For existing database systems, there are a large number of indexing technologies, such as B+ tree indexing, bitmap indexing, etc., which also greatly improve the query speed. [0004] Of course, in the text search function of the database at present, the inverted index has a relatively common application. It is a m...

AI Technical Summary

Problems solved by technology

However, when using the index engine to query data, when the query statement includes a join operation, the operation of the distributed index needs to obtain all the records that meet the filter conditions, and then perform the join operation among all the obtained records that meet the conditions, and get all the records that meet the conditions The efficiency of conditional records is very low. Since Lucene is a paging query, only a small number of records are obtained in one query, resulting in the need for multiple operations to finally meet the conditions; when using a database to query data, when the amount of data is large, ordinary query , the speed of fuzzy query is not as fast as that of search engine query, thus reducing the efficiency of data query

Images