Database query method, device and system

Abstract

An embodiment of the invention provides a database query method, device and system. The database query method comprises the following steps: a query request containing more than one query keyword input by a user is received; a preset text library is queried according to the more than one query keyword, and at least one to-be-selected text message corresponding to the more than one query keyword is obtained; the preset text library is established on the basis of a data table in a database and contains more than one text message, and each text message comprises a unique identification of a record in the data table and information corresponding to the unique identification; at least one unique identification is obtained from the to-be-selected text messages; the database is queried according to the acquired unique identification, and the record information corresponding to the unique identification is acquired. Efficient and fast database query is realized in a relational database.

Description

technical field [0001] The embodiments of the present invention relate to computer technology, in particular to a database query method, device and system. Background technique [0002] Business operation support systems, such as telecommunications, banking, electric power, e-commerce, and household administration management operating systems, are all built on the basis of relational databases, usually with customer information management, and querying customer information is also a very common operation . In particular, fuzzy queries are used in many scenarios. By scanning the entire table in the relational database according to the name or some descriptive features to query various information, for example, to retrieve customer information based on the customer name, or based on the The last few digits of the vehicle plate number are used to find vehicle information, or to pay electricity bills based on the address. This is because customers need to conduct fuzzy queries ...

AI Technical Summary

Problems solved by technology

[0003] However, the full table scan of fuzzy query is very time-consuming. When the amount of data reaches more than 10 million, the efficiency of fuzzy query is very low, and when the amount of data reaches hundreds of millions, it is almost impossible to get search result

It can be seen that fuzzy query will seriously affect the execution efficiency of the business system, and even cause business response interruption due to excessive consumption of database resources

Images