Data query method and system and electronic equipment

Abstract

The invention relates to a data query method and system and electronic equipment. The method comprises the following steps: firstly, every preset time period, a plurality of result data tables are generated from the data of the relational database according to different service types, a plurality of result data tables are periodically updated; more data can be stored in a plurality of latest result data tables; when a query request sent by a user through a client is received, target data is queried from a plurality of newly generated result data tables according to the query request, and the queried target data is fed back to the client of the user, so that the data in the relational database at the bottommost layer does not need to be compared one by one, and data drilling is also not needed. Compared with a mode of directly querying from a relational database, the query efficiency of the method and the device provided by the invention is at least improved by 5 times, and the user experience is improved.

Description

technical field [0001] The invention relates to the technical field of the telecommunications industry, in particular to a data query method, system and electronic equipment. Background technique [0002] With the development of the Internet, more and more data needs to be stored. In order to further facilitate storage, these data are often stored in relational databases. The following examples are used to illustrate: [0003] When receiving a query request from a user for opening an account, such as a mobile phone number, it is necessary to compare all the data stored in the relational database with the query request one by one before finding the account opening information corresponding to the user’s query request, which is inefficient, especially When data drill-down is required to find the data corresponding to the user's query request, data drill-down specifically refers to: assuming that the user's newly opened mobile phone number belongs to Handan City, it is necessar...

AI Technical Summary

Problems solved by technology

[0003] When receiving a query request from a user for opening an account, such as a mobile phone number, it is necessary to compare all the data stored in the relational database with the query request one by one before finding the account opening information corresponding to the user’s query request, which is inefficient, especially When data drill-down is required to find the data corresponding to the user's query request, data drill-down specifically refers to: assuming that the user's newly opened mobile phone number belongs to Handan City, it is necessary to find Hebei Province from various provinces, and then from When finding Handan in Hebei Province, and then find the account opening information when the user opened a new mobile phone number from all the data in Handan City, it needs to query the data of each level, that is, the data of the whole country, Hebei Province, Handan City, etc., and it will take a long time to find out. Return the data corresponding to the query request to the user, seriously affecting user perception and experience

Images