Data table query method and device

Abstract

Embodiments of the invention disclose a data table query method and device. The method comprises the following steps of: obtaining an initial query condition, wherein the initial query condition comprises a first inequation; converting the first inequation to obtain a target query condition, wherein the target query condition comprises a first equation; and querying a data table according to the target query condition. According to the method and device, the data table query efficiency can be improved.

Description

technical field [0001] The embodiments of the present invention relate to the computer field, in particular to a method and device for querying data tables in the computer field. Background technique [0002] Database Management System (DBMS for short) is a layer of database management software located between the user and the operating system. Database tuning can make database applications run faster, and its goal is to make the database have higher throughput. volume and shorter response times. [0003] For the database kernel, it mainly realizes the optimization technology at the Structured Query Language (Structured Query Language, referred to as "SQL") level, including: query reuse technology, query rewriting rule technology, query algorithm optimization technology, parallel query optimization technology, Distributed query optimization technology and other optimization technologies, etc. However, in a parallel computing parallel database cluster (Massively Parallel Pro...

AI Technical Summary

Problems solved by technology

[0003] For the database kernel, it mainly realizes the optimization technology at the Structured Query Language (Structured Query Language, referred to as "SQL") level, including: query reuse technology, query rewriting rule technology, query algorithm optimization technology, parallel query optimization technology, Distributed query optimization technology and other optimization technologies, etc. However, in a parallel computing parallel database cluster (Massively Parallel Processing Database, referred to as "MPPDB"), the optimizer module performs job optimization according to the statement type, execution The cost estimation value of the job and the data distribution on each data node, etc., generate the optimal execution plan, but the optimal execution plan generated by the optimizer module may not be able to achieve high-efficiency optimization, for example, in the ticketing system of the airline company For example, in the database of the aviation system, passenger A and passenger B who boarded at the same place within 60 minutes of time difference are found. However, during the execution process, it is found that there are hundreds of millions of Passenger boarding records, when querying different passengers and time differences in the database, the efficiency is low

Images