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

Claim 9:
10. The server device according to claim 8, wherein the dimension table comprises a plurality of pieces of dimension data and a change in each piece of dimension data, and the event table comprises a plurality of pieces of event data and a change in each piece of event data, wherein when filtering through the full data to obtain the incremental data, sorting the incremental data and storing the sorted data in the dimension table and the event table of the data warehouse detail layer, the processor is further configured to execute the computer program, so as to:
filter through the full data stored in a corresponding partition of the DFS by date to obtain the incremental data;
identify the incremental data in accordance with preset data types;
store the dimension data in the dimension table sequentially in accordance with lifecycles and an order of change times of the data;
generate the surrogate key in accordance with lifecycles of the dimension data; and
store the event data in the event table in accordance with the lifecycles and the change times of the data, and a correspondence between lifecycles of the event data and the surrogate keys.