公开(公告)号：US20240346025A1

公开(公告)日：2024-10-17

申请号：US18630512

申请日：2024-04-09

Applicant: Beijing Zitiao Network Technology Co., Ltd.

Inventor： Yanchun Wu

IPC: G06F16/2455

CPC classification number: G06F16/24561

Abstract: Embodiments of the disclosure disclose a method, apparatus and electronic device for data querying. The method includes: traversing data records of a target data source; for each target data record, obtaining, based on an aggregation basis dimension of the target data source, a target aggregation basis path corresponding to the target data record, and updating, based on dimension types and dimension values of the target data record in aggregate computation dimensions, summarized values, corresponding to a plurality of summary types, of the target aggregation basis path in the aggregate computation dimensions in a data pivot table of the target data source; and after the data records of the target data source are traversed, performing a data pivot service of the target data source based on the data pivot table.

公开(公告)号：US20240346020A1

公开(公告)日：2024-10-17

申请号：US18633297

申请日：2024-04-11

Applicant: Beijing Zitiao Network Technology Co., Ltd.

Inventor： Yanchun Wu

IPC: G06F16/242 ,  G06F16/248

CPC classification number: G06F16/244 ,  G06F16/248

Abstract: The application discloses a method, apparatus, electronic device and storage medium for data aggregation. The method includes: obtaining an aggregation basis dimension and an aggregation calculation dimension, wherein the aggregation basis dimension and the aggregation calculation dimension are respectively fields in a data source table to be aggregated; obtaining an aggregation result by aggregating field values corresponding to the aggregation calculation dimension of at least one target row, wherein field values of the aggregation basis dimension of the at least one target row are the same; and recording a correspondence relationship between a target aggregation path and the corresponding aggregation result, wherein the target aggregation path is determined according to field values of the aggregation basis dimension of the target row.