Device and method for inquiring data

Abstract

The invention provides a device and method for inquiring data. The method comprises steps of receiving a first connection operation clause,wherein first connection operation clause carries a first selection condition targeting a first data table and a second selection condition for targeting a second data table, determining at least one main key value according to data information in the first selection condition and the first data table, successively obtaining a plurality of candidate items corresponding to the first main key value in a preset regulation indication inqury table according to each first main key value in at least first main key value, wherein each item comprises a first table value and a second table value related to the first table value, and determining a final item according with the first selection condition and the second selection condition according to the second selection condition. The device and method for inquiring data simplifies the inqury process and improves the inqury speed.

Description

technical field [0001] Embodiments of the present invention relate to the field of information technology, and in particular, to a method and device for processing query data. Background technique [0002] In the field of data warehouse and online analytical processing (On-Line Analytical Processing, OLAP for short), fast response to query statements is particularly important. In the field of OLAP, queries need to process G-level, T-level or even P-level data volumes. In the case of such a large amount of data, fast response to queries is required, which poses a great challenge to database processing performance. In a common query statement, a join operation between two data tables is usually included, so improving the speed of the join operation between the data tables is very important for database query performance. [0003] Take the following data sheet Table 1 and Table 2 as examples to illustrate: [0004] Table 1 [0005] [0006] Table 2 [0007] sid ...

AI Technical Summary

Problems solved by technology

[0014] Through the above execution process, table 1 and table 2 need to be connected multiple times to obtain query results that satisfy the selection conditions for table 1 and table 2 at the same time. The process is very complicated and time-consuming, making the database poor query performance

Images