Index table creation method, data query method and apparatus

By creating index tables in the data tables, storing indexes in column-row format, and storing redundant columns in column-column format, the problem of balancing OLAP and OLTP performance is solved, enabling efficient hybrid transaction/analytic processing of the database and improving query efficiency.

CN117520349BActive Publication Date: 2026-06-30BEIJING OCEANBASE TECHNOLOGY CO LTD
3 Cites 0 Cited by

Patent Information

Authority / Receiving Office
CN · China
Patent Type
Patents(China)
Current Assignee / Owner
BEIJING OCEANBASE TECHNOLOGY CO LTD
Filing Date
2023-11-20
Publication Date
2026-06-30

AI Technical Summary

Technical Problem

Existing technologies make it difficult to achieve efficient queries for both Online Analytical Processing (OLAP) and Online Transaction Processing (OLTP) on the same data table simultaneously, resulting in database performance failing to meet the needs of both OLAP and OLTP.

Method used

By creating an index table, index columns are stored in row format and redundant columns are stored in column format. The index table includes an index key and redundant columns. Redundant columns are used to accelerate OLAP queries, and index columns support OLTP queries, enabling hybrid transactional/analytic processing (HTAP) scenarios.

Benefits of technology

It improves the OLAP and OLTP performance of the database, supports mixed transaction/analytic processing, reduces storage costs, and improves query efficiency.

✦ Generated by Eureka AI based on patent content.

Smart Images

  • Figure CN117520349B_ABST
    Figure CN117520349B_ABST
Patent Text Reader

Abstract

This specification provides one or more embodiments of an index table creation method, a data query method, and an apparatus, relating to the field of database technology. The method can determine index columns and redundant columns associated with the index columns in a data table; create an index table, which includes index columns and redundant columns. The index columns serve as the index keys of the index table. Data in the index columns is stored in row-oriented storage, while data in the redundant columns is stored in column-oriented storage. The redundant columns in the index table are used to accelerate the data query process for the data table. The solution provided in this specification can utilize index tables to simultaneously improve the OLAP and OLTP performance of the database, thereby enabling the database to support HTAP application scenarios.
Need to check novelty before this filing date? Find Prior Art