Unlock instant, AI-driven research and patent intelligence for your innovation.

Data query method and device, computer equipment and storage medium

A data query and data retrieval technology, applied in the field of data processing, can solve problems such as loss of statistical data, timeout, query failure, etc., to achieve the effect of reducing pressure, reducing network traffic usage, and reducing service costs

Pending Publication Date: 2022-05-27
北京恒安嘉新安全技术有限公司
View PDF0 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0003] In the course of the invention, the inventor found that the defects of the prior art are as follows: at present, data query and statistical ranking are carried out from the browser to the server. When performing statistical ranking query on a table database, if the statistical ranking is performed on all sub-tables at one time, it will often time out, causing the query to fail; if the statistical ranking is performed on the sub-tables in a loop, the statistical data will be lost

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 device, computer equipment and storage medium
  • Data query method and device, computer equipment and storage medium
  • Data query method and device, computer equipment and storage medium

Examples

Experimental program
Comparison scheme
Effect test

Embodiment 1

[0041] figure 1 This is a flow chart of a data query method provided in Embodiment 1 of the present invention. This embodiment can be applied to various situations in which it is necessary to perform statistical ranking on a large number of data sub-tables. The method in this embodiment may be executed by a data query apparatus, which may be implemented in software and / or hardware, and the apparatus may be configured in a computer device, which may be a terminal device, executed by a client, and implemented by the present invention. The example does not limit the type of computer equipment.

[0042] Correspondingly, the method specifically includes the following steps:

[0043] S110. Obtain a statistical sorting request input by the user.

[0044] Wherein, the statistical sorting request includes sorting conditions and the required number of rankings.

[0045] The statistical ranking request may be a request for statistical ranking sent by the client to the server. Specifi...

Embodiment 2

[0066] figure 2 This is a flowchart of another data query method provided by the second embodiment of the present invention. This embodiment can be applied to various situations in which it is necessary to perform statistical ranking on a large number of data sub-tables. The method in this embodiment may be executed by a data query apparatus, and the apparatus may be implemented in software and / or hardware. The apparatus may be configured in a computer device, and the computer device may be a server and executed by the server. This embodiment of the present invention does not The type of computer equipment is not limited.

[0067] Correspondingly, the method specifically includes the following steps:

[0068] S210. Receive a statistical sorting request sent by the client, and extract sorting conditions and the required number of rankings from the statistical sorting request.

[0069] Exemplarily, the server receives a statistical sorting request from the client. Specifical...

Embodiment 3

[0088] image 3 This is a schematic structural diagram of a data query apparatus provided in Embodiment 3 of the present invention. A data query apparatus provided by this embodiment may be implemented by software and / or hardware, and may be configured in a terminal device to implement the embodiments of the present invention A data query method in . like image 3 As shown, the device may specifically include: a statistical sorting request acquisition module 310, a unified query identifier and a sub-table quantity receiving module 320 for retrieving sub-tables, a sub-table sorting result generating module 330, a target sorting result acquiring module 340, and a target sorting result receiving module Module 350.

[0089] The statistical sorting request obtaining module 310 is configured to obtain a statistical sorting request input by the user, where the statistical sorting request includes sorting conditions and the required number of rankings;

[0090] The unified query id...

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 embodiment of the invention discloses a data query method and device, computer equipment and a storage medium. The method comprises the steps of obtaining a statistical sorting request input by a user; sending the statistical sorting request to a server, and receiving a unified query identifier fed back by the server and the sub-table quantity of the retrieved sub-tables; data retrieval requests matched with the number of the sub-tables are sequentially sent to the server so as to indicate the server to sequentially generate sub-table sorting results corresponding to the sub-tables, and the summarizing sorting results are updated; when it is determined that sending of all the data retrieval requests is completed, a sorting result obtaining request is sent to a server so as to indicate the server to obtain target sorting results matched with the required ranking number in the currently updated summarized sorting results; and receiving a target sorting result fed back by the server. According to the embodiment of the invention, the problem of timeout caused by large processing data volume when the user performs ranking statistics on the sub-table circulation is solved, the network traffic occupation is reduced, and the service cost is reduced.

Description

technical field [0001] Embodiments of the present invention relate to the technical field of data processing, and in particular, to a data query method, apparatus, computer equipment, and storage medium. Background technique [0002] With the continuous progress of the times, science and technology also continue to develop. The browser needs to frequently request data from the server, and needs to perform data query and statistical ranking from the browser to the server. Therefore, the amount of data that needs to be accessed is sometimes tens of thousands. [0003] In the process of invention, the inventor found that the defects of the prior art are: at present, data query and statistical ranking are carried out from the browser to the server. When performing a statistical ranking query on a table database, if the statistical ranking is performed on all the sub-tables at one time, it will often time out, causing the query to fail; if the statistical ranking is performed on...

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
IPC IPC(8): G06F16/23G06F16/2458G06F16/953G06F16/9538
CPCG06F16/953G06F16/9538G06F16/2471G06F16/2365
Inventor 杨玉奇张红宝周忠义傅强阿曼太梁彧田野王杰杨满智蔡琳金红陈晓光
Owner 北京恒安嘉新安全技术有限公司