基于联机分析处理的数据查询方法、装置和电子设备
By introducing coded columns into the fact tables of OLAP databases, mixed row and column storage is achieved, which solves the problem of low random read efficiency caused by column storage in existing technologies and improves query and write performance.
CN117349288BActive Publication Date: 2026-07-17BEIJING VOLCANO ENGINE TECH CO LTD
Patent Information
- Authority / Receiving Office
- CN · China
- Patent Type
- Patents(China)
- Current Assignee / Owner
- BEIJING VOLCANO ENGINE TECH CO LTD
- Filing Date
- 2023-10-24
- Publication Date
- 2026-07-17
AI Technical Summary
Technical Problem
In scenarios involving high-frequency updates and high-frequency point queries, existing OLAP databases using columnar storage suffer from low random read efficiency, making it difficult to meet the needs of efficient queries.
Method used
A row-column hybrid storage method is adopted. By introducing a coding column into the fact table of the database, the field values of the same row are encoded into the coding column, realizing row-by-row storage. For query requests of preset types, the query is performed in the row storage part, which improves efficiency.
Benefits of technology
In query requests of the preset type, query efficiency is improved by storing data row by row, random reads are reduced, and query and write performance is enhanced.
✦ Generated by Eureka AI based on patent content.
Smart Images
Figure CN117349288B_ABST
Abstract
本公开实施例公开了基于联机分析处理的数据查询方法、装置和电子设备。该方法的一具体实施方式包括：接收第一查询请求，以及确定第一查询请求的请求类型；响应于所述请求类型为预设类型，在数据库的事实表中的行存部分，进行查询；根据查询到的目标数据，生成查询结果；所述事实表包括列存部分和行存部分，列存部分包括多个数据行；行存部分包括编码列，编码列中的每个编码信息包括列存部分属于同一数据行的行数据。由此，提供了一种新的数据处理方式，实现在数据库的按列存储的事实表中，通过将属于同一行的字段值编码至编码列的编码信息中，可以在按列存储的事实表中实现按行存储。由此，对于符合预设类型的查询请求，在行存部分进行查询，提高查询效率。
Need to check novelty before this filing date? Find Prior Art