US 11,989,176 B2
Data query method and apparatus, device, and computer-readable storage medium
Wei Li, Shenzhen (CN); Rui Li, Shenzhen (CN); and Mingjin Wu, Shenzhen (CN)
Assigned to TENCENT TECHNOLOGY (SHENZHEN) COMPANY LIMITED, Guangdong (CN)
Filed by Tencent Technology (Shenzhen) Company Limited, Guangdong (CN)
Filed on Nov. 3, 2022, as Appl. No. 17/980,380.
Application 17/980,380 is a continuation of application No. PCT/CN2021/128244, filed on Nov. 2, 2021.
Claims priority of application No. 202011452389.5 (CN), filed on Dec. 11, 2020.
Prior Publication US 2023/0073666 A1, Mar. 9, 2023
Int. Cl. G06F 16/242 (2019.01); G06F 16/28 (2019.01)
CPC G06F 16/2425 (2019.01) [G06F 16/2428 (2019.01); G06F 16/244 (2019.01); G06F 16/283 (2019.01)] 19 Claims
OG exemplary drawing
 
1. A data query method, the method comprising:
obtaining a data query request for a target data model;
determining, by processing circuitry of a relational online analytical processing (ROLAP) engine and based on the data query request and target metadata of a plurality of physical tables corresponding to the target data model, a target physical table corresponding to the data query request from the plurality of physical tables corresponding to the target data model, the target metadata being determined based on the plurality of physical tables, the plurality of physical tables including a basic table and a pre-aggregated table, the basic table being configured to record basic data of one granularity, and the pre-aggregated table being configured to record data of a plurality of granularities;
determining a target structured query statement based on the data query request and table identification information of the determined target physical table; and
executing, by the ROLAP engine, the target structured query statement in a database storing the target physical table, to obtain target query data corresponding to the data query request.