Data Processing Method, Data Querying Method, and Server Device

2. The data processing method according to claim 1, wherein subsequent to associating the dimension table with the event table to generate the report, generating the aggregate table in accordance with the predetermined aggregation demand and storing the aggregate table at the reporting layer, the data processing method further comprises synchronizing the report and the aggregate table to a column-oriented memory database in an incremental manner.

4. The data processing method according to claim 3, wherein the generating the surrogate key in accordance with the lifecycle of the dimension data further comprises ranking the lifecycles of the dimension data in accordance with the change times, and taking each serial number as the surrogate key.

5. The data processing method according to claim 3, wherein a change frequency of the dimension data is substantially smaller than a preset frequency threshold, and a change frequency of the event data is substantially greater than the preset frequency threshold.

6. The data processing method according to claim 1, wherein the 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 further comprises sorting historical data in the incremental data, and storing data sorting results in the dimension table and the event table of the data warehouse detail layer respectively.

7. The data processing method according to claim 1, wherein the 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 further comprises sorting the incremental data, and storing data sorting results in the dimension table and the event table of the data warehouse detail layer respectively.

9. The server device according to claim 8, wherein subsequent to associating the dimension table with the event table to generate the report, generating the aggregate table in accordance with the predetermined aggregation demand and storing the aggregate table at the reporting layer, the processor is further configured to execute the computer program, so as to synchronize the report and the aggregate table to a column-oriented memory database in an incremental manner.

11. The server device according to claim 10, wherein when generating the surrogate key in accordance with the lifecycle of the dimension data, the processor is further configured to execute the computer program, so as to rank the lifecycles of the dimension data in accordance with the change times, and take each serial number as the surrogate key.

12. The server device according to claim 10, wherein a change frequency of the dimension data is substantially smaller than a preset frequency threshold, and a change frequency of the event data is substantially greater than the preset frequency threshold.

13. The server device according to claim 8, 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 sort historical data in the incremental data, and store data sorting results in the dimension table and the event table of the data warehouse detail layer respectively.

14. The server device according to claim 8, 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 sort the incremental data, and store data sorting results in the dimension table and the event table of the data warehouse detail layer respectively.

16. The data querying method according to claim 15, wherein the server device further comprises a report query circuitry configured to synchronize the report and the aggregate table to the column-oriented memory database in an incremental manner, and the querying the report and/or the aggregate table at the reporting layer in response to the query request from the client device and outputting the query result comprises querying the report and/or the aggregate table in the column-oriented memory database in response to the query request from the client device and outputting the query result.

18. The data querying method according to claim 17, wherein the server device further comprises a report query circuitry configured to synchronize the report and the aggregate table to the column-oriented memory database in an incremental manner, wherein the data querying method further comprises generating the query request in response to the user's operation, and transmitting the query request to the server device, so that the server device queries data in accordance with the report and/or the aggregate table in the column-oriented memory database.

20. The non-transitory computer-readable storage medium according to claim 19, wherein subsequent to associating the dimension table with the event table to generate the report, generating the aggregate table in accordance with the predetermined aggregation demand and storing the aggregate table at the reporting layer, the computer program is further executed by the processor, so as to synchronize the report and the aggregate table to a column-oriented memory database in an incremental manner.