Data query method, device and system

A data query device and data query technology, applied in the field of databases, can solve problems such as slow data query speed and affecting data query speed, and achieve the effect of reducing cache requirements and improving query performance
CN105975498AInactive Publication Date: 2016-09-28HUAWEI TECH CO LTD +1
4 Cites 2 Cited by

Patent Information

Authority / Receiving Office
CN · China
Current Assignee / Owner
HUAWEI TECH CO LTD
Publication Date
2016-09-28
Estimated Expiration
Not applicable · inactive patent

Smart Images

  • Figure 1
    Figure 1
  • Figure 2
    Figure 2
  • Figure 3
    Figure 3
Patent Text Reader

Abstract

The invention discloses a data query method, device and system. The data query method comprises the following steps: acquiring a condition column corresponding to a query condition in a query request and a target column corresponding to a query target in the query request from a compressed data block through the data query device, wherein the compressed data block is obtained through compressing an original data block by taking column width as a unit; determining a line mask corresponding to at least one continuous first compression record in the condition column according to the query condition; if determining that a second compression record in the condition column corresponds to at least one original record and the at least one original record is correspondingly same as an original record corresponding to the at least one continuous first compression record one by one, determining that a line mask corresponding to the second compression record comprises a line mask corresponding to the at least one continuous first compression record; and determining a query result corresponding to the query request according to the line mask corresponding to each compression record in the condition column and the target column, so as to improve the data query speed.
Need to check novelty before this filing date? Find Prior Art

Description

technical field

[0001] The present invention relates to the field of databases, more specifically, to a data query method, device and system. Background technique

[0002] As the amount of data and the speed of data generation continue to grow, the amount of data that needs to be processed by database query operations increases exponentially, and the query delay continues to increase. Based on the growth of data volume and large-scale data analysis requests, columnar databases are getting more and more attention.

[0003] For columnar database query requests, two commonly used methods are the data query method based on the central processing unit (Central Processing Unit, CPU) software platform and the heterogeneous platform based on CPU+field-programmable gate array (Field-Programmable Gate Array, FPGA). data query method.

[0004] In the data query method based on the CPU software platform, the CPU reads the required data block from the disk to the memory, indexes the da...

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