The invention discloses a data aggregation
processing method and device,
computer equipment and a storage medium, belongs to the technical field of
big data, and is applied to data aggregation in the financial field. The method comprises the following steps: firstly, grouping dimension fields by utilizing a mapping rule and a
hierarchical clustering algorithm; and secondly, dynamic grouping mapping is established, one-time scanning is performed on the
source data table, and each data
record is directly attributed to a corresponding grouping structure, so that the
data processing efficiency is improved. Meanwhile, a
correlation index of the index and the data partition is constructed based on a Hash
mapping algorithm. Under the support of an indexed
data structure, the aggregation calculation function can efficiently execute operations such as summation and averaging, and rapid aggregation of multi-dimensional data is realized. Generally speaking, according to the method, the
correctness of an aggregation result is ensured, meanwhile, the calculation and storage pressure of the
system is remarkably reduced, the timeliness and expandability of
data analysis are improved, and the method is particularly suitable for real-time or quasi-real-time multi-
dimensional analysis requirements in a large-scale business scene.