Data query method and system and electronic equipment

A data query and data table technology, which is applied in the field of telecommunications, can solve problems such as long time consumption, low efficiency, and affecting user perception and experience, and achieve the effect of improving query efficiency and improving experience

Pending Publication Date: 2020-09-25
北京思特奇信息技术股份有限公司
View PDF10 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

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

Method used

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
View more

Image

Smart Image Click on the blue labels to locate them in the text.
Viewing Examples
Smart Image
  • Data query method and system and electronic equipment
  • Data query method and system and electronic equipment

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0040] like figure 1 As shown, a data query method in the embodiment of the present invention includes the following steps:

[0041] S1. Generate multiple result data tables from the data of the relational database according to different business types at preset time intervals;

[0042] S2. When receiving the query request sent by the client, query the target data from multiple newly generated result data tables according to the query request, and feed back the query target data to the client.

[0043] First of all, every preset time period, according to different business types, the data of the relational database is generated into multiple result data tables, and by regularly updating the multiple result data tables, it is ensured that more results are stored in the latest multiple result data tables. When receiving the query request sent by the user through the client, the target data is queried from the newly generated multiple result data tables according to the query re...

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to view more

PUM

No PUM Login to view more

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...

Claims

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to view more

Application Information

Patent Timeline
no application Login to view more
Patent Type & Authority Applications(China)
IPC IPC(8): G06F16/28G06F16/22G06F16/2453G06F16/2455
CPCG06F16/284G06F16/2282G06F16/2453G06F16/2455
Inventor 吕彪
Owner 北京思特奇信息技术股份有限公司
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Try Eureka
PatSnap group products