Patent ID: 11907264
Assignee: BOE TECHNOLOGY GROUP CO., LTD.
Field: Computer technology (Electrical engineering)
Classification: CPC G | IPC G

Claim 0:
1. A data processing method, comprising:
pulling full data regularly in accordance with a predetermined time, partitioning a Distributed File System (DFS) by date, and storing the full data in a corresponding partition of the DFS;
filtering through the full data to obtain incremental data, sorting the incremental data, and storing the sorted data in a dimension table and an event table of a data warehouse detail layer, the dimension table being associated with the event table through a surrogate key, wherein fields of the dimension table comprises (i) one or more fields associated with user attributes, (ii) one or more fields regarding change times of the user attributes, and (iii) one or more fields about the surrogate key obtained by ranking lifecycles of the user attributes in accordance with the change times of the user attributes; and wherein fields of the event table comprises (iv) one or more fields about the surrogate key, (v) one or more fields about event details, and (vi) one or more fields regarding update times of the event details; and wherein the surrogate key is used to realize an association between changes of the user attributes and updates of the event details; and
associating the dimension table with the event table to generate a report, generating an aggregate table in accordance with a predetermined aggregation demand, and storing the generated aggregate table at a reporting layer.