Method for configuring and displaying report based on statistical data
Technical Field
The invention relates to the technical field of data statistics, in particular to a method and a system for configuring and displaying a report based on statistical data.
Background
Various statistical data in network analysis are numerous, and people pay attention to how to more intuitively display massive statistical data to users, so that the users can conveniently find problems from display results, and the efficiency of finding the problems and solving the problems by the users is improved. The current report is a common display form, and only the conventional report has a series of problems that the data source cannot be flexibly set, and the data filtering is not supported.
Quite a few techniques are to fix only the fields of the report and to use the fixed fields for ordering the report content. This method is not only inflexible in operation but also has limitations in data presentation.
Disclosure of Invention
The technical problem to be solved by the invention is as follows: aiming at the existing problems, a method for configuring and displaying the report based on the statistical data is provided.
The technical scheme adopted by the invention is as follows: a method for configuring and displaying a report based on statistical data specifically comprises the following processes: step one, sorting all statistical tables in a statistical data memory according to specific fields to generate a report; step two, providing a report field configuration interface on the terminal, setting a report name, a report description, a report object and a configured field, and storing the report name, the report description, the report object and the configured field in a report configuration memory; step three, appointing fields in a configuration interface, wherein the appointed fields must comprise key fields, configuring required fields, and storing the configured fields in a report configuration memory; step four, sending the specified field data in the report configuration storage to a report production server, and assembling the report generation server according to html marks after data screening to generate a report displaying statistical data in html format; and fifthly, returning the report to the terminal, and displaying the statistical data through the report.
Further, the process of setting the report object in the second step specifically includes setting the report object as a global object or as a specified object.
Further, the designated object is configured to filter the data in each statistical table by means of physical address filtering, IP address filtering, network segment filtering, or application name filtering.
Further, the specific process of filtering by physical address is as follows: and inputting a single or a plurality of physical addresses or a single or a plurality of physical address ranges in the terminal configuration interface, wherein a plurality of physical addresses or a plurality of physical address ranges represent an OR relationship, and storing the configured physical addresses into a report configuration memory.
Further, the specific process of filtering through the IP address is as follows: and a single or a plurality of IP addresses or a single or a plurality of IP address ranges can be input in the terminal configuration interface, a plurality of IP addresses or a plurality of IP address ranges represent an OR relationship, and the configured IP addresses are stored in the report configuration memory.
Further, the specific process of filtering through the network segment is as follows: and inputting the network segment in the terminal configuration interface, and storing the configured network segment into a report configuration memory.
Further, the specific process of filtering by applying the name is as follows: and inputting an application in a terminal configuration interface, and storing the configured application into a report configuration memory.
Further, the maximum number of configurable fields is set in the terminal configuration interface.
Further, the configured fields are sorted in the terminal configuration interface, and the Top records are selected according to the sorting result.
The invention also provides a system for configuring and displaying the report based on the statistical data, which specifically comprises a terminal, a terminal and a report generation module, wherein the terminal is used for configuring the report field and displaying the generated report; the statistical data storage is used for storing statistical data, the statistical data are stored according to objects, the objects refer to IP addresses, physical addresses, network segments or applications, and each object corresponds to a separate statistical table; the report configuration memory is used for storing the fields of the report and the objects of the report; and the report generation server is used for providing a report template and generating a report.
Compared with the prior art, the beneficial effects of adopting the technical scheme are as follows: the fields of the report are configured, and the flexible fields are used for sequencing the report contents; the data display is flexible and changeable, the data filtering is supported, the data required by the user is displayed, and the user requirements are met.
Drawings
Fig. 1 is a schematic diagram of a configuration interface according to an embodiment of the present invention.
Fig. 2 is a schematic diagram of setting a specified object in the embodiment.
FIG. 3 is a report diagram illustrating the configuration of each statistical table.
Detailed Description
The invention is further described below with reference to the accompanying drawings.
As shown in fig. 1-3, a method for configuring and displaying a report based on statistical data specifically includes the following processes: step one, sorting all statistical tables in a statistical data memory according to specific fields to generate a report; in this embodiment, the specific field includes an endpoint, a total number of bytes, a total number of packets, a number of bytes sent, a number of packets sent, a number of bytes received, a number of packets received, a number of bytes per second, a number of packets per second, a number of bytes sent per second, a number of bytes received per second, a bit rate, a sending bit rate, and a receiving bit rate; step two, providing a report field configuration interface on the terminal, setting a report name, a report description, a report object and a configured field, and storing the report name, the report description, the report object and the configured field in a report configuration memory; selecting a plurality of fields required by enabling a specific field as a configured field, wherein the configured field is an end point, a total byte number, a total data packet, a sending byte number, a sending data packet number, a receiving byte number and a receiving data packet number; the final report only contains the information of the configured fields; step three, appointing fields in a configuration interface, wherein the appointed fields must comprise key fields and are configured with required fields, and the configured fields are stored in a report configuration memory; step four, the data in the report configuration storage is sent to a report production server, and the report generation server performs data screening and then assembles the data according to html marks to generate a report displaying statistical data in html format; fifthly, the report is returned to the terminal, and the statistical data is displayed through the report; the report displays information including end points, total byte numbers, total data packets, transmitting byte numbers, transmitting data packet numbers, receiving byte numbers and receiving data packet numbers.
The process of setting the report object in the second step specifically includes setting the report object as a global object or as a specified object. The setting as the designated object is to filter the data in each statistical table by means of physical address filtering, IP address filtering, network segment filtering or application name filtering.
The specific process of filtering through the physical address is as follows: inputting a single or a plurality of physical addresses or inputting a single or a plurality of physical address ranges in the terminal configuration interface, wherein a plurality of physical addresses or a plurality of physical address ranges represent an OR relationship, storing the configured physical addresses into a report configuration memory, and finally displaying only the statistical data of the physical addresses belonging to the input physical addresses. The specific process of filtering through the IP address is as follows: the terminal configuration interface can input single or multiple IP addresses or single or multiple IP address ranges, multiple IP addresses or multiple IP address ranges represent an OR relationship, the configured IP addresses can be stored in a report configuration memory, and finally only the statistical data of the IP addresses belonging to the input IP addresses are displayed. The specific process of filtering through the network segment is as follows: and inputting the network segment in a terminal configuration interface, storing the configured network segment into a report configuration memory, and finally displaying the statistical data of the network segment belonging to the input network segment. The specific process of filtering by applying the name is as follows: and inputting the application in a terminal configuration interface, storing the configured application in a report configuration memory, and finally displaying only the statistical data of the application belonging to the input application.
Setting the maximum number of configurable fields in the terminal configuration interface, preferably setting the maximum number of configurable fields to be 10, and selecting fields less than or equal to 10 when configuring the fields.
And sequencing the configured fields in a terminal configuration interface, and selecting the Top records according to the sequencing result.
The invention also provides a system for configuring and displaying the report based on the statistical data, which specifically comprises a terminal, a terminal and a report generation module, wherein the terminal is used for configuring the report field and displaying the generated report; the statistical data storage is used for storing statistical data, the statistical data are stored according to objects, the objects refer to IP addresses, physical addresses, network segments or applications, and each object corresponds to a separate statistical table; the report configuration memory is used for storing the fields of the report and the objects of the report; and the report generation server is used for providing a report template and generating a report.
The invention is not limited to the foregoing embodiments. The invention extends to any novel feature or any novel combination of features disclosed in this specification and any novel method or process steps or any novel combination of features disclosed. Those skilled in the art to which the invention pertains will appreciate that insubstantial changes or modifications can be made without departing from the spirit of the invention as defined by the appended claims.