Real-time data report statistical method under massive data

Abstract

The present invention discloses a real-time data report statistical method under the massive data in the field of data statistics. The method is characterized in that: while application data is storedin a database, statistical data is written into an in-memory database in real time according to statistical characteristics of the data; according to the statistical characteristics of the data, fromthe current statistical period, the statistical data of the previous statistical period is stored by the in-memory database in the database; and when a user views statistical report information, a data collection processor performs statistical analysis according to different statistical characteristics, extracts data from the database or the in-memory database, and returns a statistical result. According to the method disclosed by the present invention, the purposes of collecting statistics of real-time data and having relatively high performance results are achieved, and the user experienceis further improved.

Description

technical field [0001] The invention relates to the field of data statistics, in particular to a method for statistics of real-time data reports under massive data. Background technique [0002] Traditional report statistics usually use two methods: one is to regularly count the data of the application table, and then save the statistical table of the database, for example, the data of the previous day is counted on the current day and stored in the database, and the system interface is queried. For scenes that require real-time performance, the real-time performance is poor and the effect is not ideal. [0003] For real-time considerations, the other is to perform real-time statistics on the original data according to the statistical conditions entered by the user, and directly count the data in the data table. For the case of a large amount of data, group statistics will appear slower and affect System performance also affects user experience; [0004] Therefore, there i...

AI Technical Summary

Problems solved by technology

[0002] Traditional report statistics usually use two methods: one is to regularly count the data of the application table, and then save the statistical table of the database, for example, the data of the previous day is counted on the current day and stored in the database, and the system interface is queried. For scenarios that require real-time performance, poor real-time performance and unsatisfactory results

[0003] For real-time considerations, the other is to perform real-time statistics on the original data according to the statistical conditions entered by the user, and directly count the data in the data table. For the case of a large amount of data, group statistics will appear slower and affect System performance also affects user experience;

Images