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

Data query method and device, electronic equipment, medium and program product

A data query and data technology, applied in the field of database query, can solve problems such as low efficiency and large amount of calculation, and achieve the effect of reducing the amount of calculation and improving efficiency

Pending Publication Date: 2022-02-18
北京人大金仓信息技术股份有限公司
View PDF0 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0003] However, using the existing technology, it is necessary to traverse each data in the database and call the aggregation function for calculation, resulting in a large amount of calculation and low efficiency when determining the target value in the database

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, electronic equipment, medium and program product
  • Data query method and device, electronic equipment, medium and program product
  • Data query method and device, electronic equipment, medium and program product

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0041] In order to more clearly understand the above objects, features and advantages of the present disclosure, the solutions of the present disclosure will be further described below. It should be noted that, in the case of no conflict, the embodiments of the present disclosure and the features in the embodiments can be combined with each other.

[0042] In the following description, many specific details are set forth in order to fully understand the present disclosure, but the present disclosure can also be implemented in other ways than described here; obviously, the embodiments in the description are only some of the embodiments of the present disclosure, and Not all examples.

[0043] At present, the database system is widely used in computer application technology. Since more and more data are stored in the database, the efficiency of data query in the database is getting lower and lower. In the prior art, when performing data query in the database, it is necessary to...

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 the technical field of database query, and provides a data query method and device, electronic equipment, a medium and a program product. The method comprises the steps: obtaining a query request, wherein the query request is used for querying data in a database; based on the database, obtaining at least two pieces of data in the database, and sorting the data to obtain a first index column; according to a first preset condition, determining a second index column in the first index column, wherein data in the second index column and data in the first index column have the same sequence; based on the query request and the sequence of the data in the second index column, determining a target numerical value in the second index column, wherein the target numerical value is the maximum value of the data in the second index column and / or the minimum value of the data in the second index column, and the target numerical value is one or more of at least two pieces of data in the database. By adopting the mode, the calculation amount can be reduced, and the data query efficiency is improved.

Description

technical field [0001] The present disclosure relates to the technical field of database query, in particular to a data query method, device, electronic equipment, media and program product. Background technique [0002] At present, the database system is widely used in computer application technology. Since more and more data are stored in the database, the efficiency of data query in the database is getting lower and lower. In the prior art, when performing data query in the database, it is necessary to traverse all the data in the database to obtain at least two data in the database, and then call an aggregate function to compare at least two data in the database to obtain This determines the target value in the database. [0003] However, with the existing technology, it is necessary to traverse each data in the database and call an aggregation function for calculation, resulting in a large amount of calculation and low efficiency when determining the target value in th...

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/2455G06F16/22
CPCG06F16/24556G06F16/221
Inventor 范国腾尹强
Owner 北京人大金仓信息技术股份有限公司