WO2018161403A1 - Data statistics method and system for report forms - Google Patents

Abstract

The invention provides a data statistics method and system for report forms and relates to the technical field of report forms. The method comprises following steps: obtaining report form data information, wherein the report form data information comprises object properties and corresponding data of the object properties (S101); sequencing the data corresponding to the object properties according to the object properties to obtain a sequential data set, wherein the data of the same object property are arranged next to each other (S102); and calculating the data in the sequential data set to obtain a calculation result (S103). According to the invention, a statistics algorithm of sequencing firstly and then generalizing is used so as to increase the statistics efficiency of memory data.

Description

Report data statistics method and system

The present application claims priority to Chinese Patent Application No. CN201710145193.3, entitled "Data Statistics Method and System for Reports", filed on March 10, 2017, the entire contents of which is incorporated herein by reference. in.

Technical field

The present invention relates to the field of report technology, and in particular, to a data statistics method and system for a report.

Background technique

In a report, it is often necessary to count all data for the same object attribute, for example, to accumulate all the values of the same object attribute for statistics. However, in the database, each data is saved separately. Therefore, in the process of statistics, each data needs to be grouped and calculated in memory to obtain statistical results. In the prior art, for the original data in the memory, the statistical method is: first save the first data; compare the second data with the first data, if the two belong to different object attributes, then The second data is saved separately; the third data is compared with the first data, if it is a different object attribute, and then compared with the second data, if it is the same object attribute, the third data and the second data The data is accumulated and saved, and so on, each data is compared to all of the previously saved data until all the data has been processed.

It can be seen from the above steps that this processing method needs to traverse each data in front of all the data already existing, and the statistical efficiency for a large amount of data will be very low.

Summary of the invention

In view of this, the object of the present invention is to provide a data statistics method and system for a report, and a statistical algorithm that first sorts and then summarizes can improve the statistical efficiency of the memory data.

In a first aspect, an embodiment of the present invention provides a data statistics method for a report, where the method includes the following steps:

Obtaining report data information, where the report data information includes an object attribute and data corresponding to the object attribute;

Sorting data corresponding to the object attribute according to the object attribute to obtain a sequential data group, wherein the data with the same object attribute is closely arranged;

Calculating the data in the sequential data set to obtain a calculation result.

With reference to the first aspect, the embodiment of the present invention provides a first possible implementation manner of the first aspect, wherein the step of calculating data in the sequential data group to obtain a calculation result includes:

Performing a summation calculation on the data in the sequential data group to obtain a summation result;

or,

Performing averaging calculation on the data in the sequential data group to obtain an averaging result;

or,

The data in the sequential data set is subjected to a maximum value calculation to obtain a maximum value result.

With reference to the first possible implementation manner of the first aspect, the embodiment of the present invention provides the second possible implementation manner of the first aspect, wherein the sequence data group includes first data and second data, the pair The step of performing the summation calculation on the data in the sequential data set to obtain the summation result includes repeatedly performing the following processing until all the data of the sequential data group is traversed:

Saving the first data, and comparing the second data with the first data to obtain a comparison result;

If the comparison result is belonging to the same object attribute, adding the first data to the second data to obtain third data;

If the comparison result is belonging to different object attributes, the second data is separately protected Save.

With reference to the first aspect, the embodiment of the present invention provides a third possible implementation manner of the first aspect, wherein the object attribute is a plurality of object attributes in a statistical item of the report.

In conjunction with the first aspect, an embodiment of the present invention provides a fourth possible implementation manner of the first aspect, wherein the report data information and the calculation result are saved in a database.

In a second aspect, the embodiment of the present invention further provides a data statistics system for a report, including:

An obtaining unit, configured to acquire report data information, where the report data information includes an object attribute and data corresponding to the object attribute;

a sorting unit configured to sort the data corresponding to the object attribute according to the object attribute to obtain a sequential data group, wherein the data with the same object attribute is closely arranged;

The calculating unit is configured to calculate data in the sequential data group to obtain a calculation result.

With reference to the second aspect, the embodiment of the present invention provides a first possible implementation manner of the second aspect, wherein the calculating unit includes:

a summation unit configured to perform a summation calculation on the data in the sequential data group to obtain a summation result;

An averaging unit configured to perform averaging calculation on data in the sequential data group to obtain an averaging result;

The most value unit is configured to perform a maximum value calculation on the data in the sequential data group to obtain a maximum value result.

With reference to the first possible implementation manner of the second aspect, the embodiment of the present invention provides the second possible implementation manner of the second aspect, wherein the sequential data group includes first data and second data, And units include:

a matching unit configured to save the first data and the second data and the first A data is compared and a comparison result is obtained;

The accumulating unit is configured to add the first data and the second data to obtain the third data if the comparison result is belonging to the same object attribute;

The saving unit is configured to separately save the second data if the comparison result is a different object attribute.

With reference to the second aspect, the embodiment of the present invention provides a third possible implementation manner of the second aspect, wherein the object attribute is a plurality of object attributes in a statistical item of the report.

With reference to the second aspect, the embodiment of the present invention provides a fourth possible implementation manner of the second aspect, wherein the report data information and the calculation result are saved in a database.

The present invention provides a data statistics method and system for a report, the method comprising: obtaining report data information, the report data information including data corresponding to an object attribute and an object attribute; and sorting data corresponding to the object attribute according to the object attribute to obtain a sequential data group , wherein the data with the same object attributes are closely arranged; the data in the sequential data group is calculated to obtain a calculation result. The statistical efficiency of memory data can be improved by using a statistical algorithm that sorts and then generalizes.

Other features and advantages of the invention will be set forth in the description which follows, and The objectives and other advantages of the invention are realized and attained by the invention particularly pointed in

The above described objects, features and advantages of the present invention will become more apparent from the aspects of the appended claims.

DRAWINGS

In order to more clearly illustrate the specific embodiments of the present invention or the technical solutions in the prior art, the following is a brief description of the drawings used in the specific embodiments or the description of the prior art. The drawings in the following description are some embodiments of the present invention, and those skilled in the art can obtain other drawings based on these drawings without any creative work.

1 is a flowchart of a data statistics method for a report according to Embodiment 1 of the present invention;

2 is another flowchart of a data statistics method for a report according to Embodiment 1 of the present invention;

3 is a schematic structural diagram of a data statistics system of a report according to Embodiment 1 of the present invention;

4 is a schematic structural diagram of a computing unit of a data statistics system of a report according to Embodiment 2 of the present invention;

FIG. 5 is a schematic structural diagram of a summation unit of a data statistics system of a report according to Embodiment 2 of the present invention.

icon:

10-acquisition unit; 20-sorting unit; 30-computing unit; 31 summing unit; 32-averaging unit; 33-finalizing unit; 310-aligning unit; 311-accumulating unit;

detailed description

The embodiments of the present invention will be clearly and completely described in detail with reference to the accompanying drawings. An embodiment. All other embodiments obtained by those skilled in the art based on the embodiments of the present invention without creative efforts are within the scope of the present invention.

At present, in the prior art, the statistical method used for the original data in the memory is: first save the first data; compare the second data with the first data, if the two belong to different object attributes, then Save the second data separately; compare the third data with the first data, if it is a different object attribute, compare it with the second data, if it is the same object attribute, then the third data and the second data The data is accumulated and saved, and so on, each data is compared to all of the saved data in front of it until all the data has been processed. This kind of processing method needs to traverse each data in front of it. All the data that already exists, for a large amount of data, its statistical efficiency will be very low. Based on this, the data statistics method and system for the report provided by the embodiment of the present invention can improve the statistical efficiency of the memory data by using a statistical algorithm that is first sorted and then summarized.

In order to facilitate the understanding of the embodiment, the data statistics method of the report disclosed in the embodiment of the present invention is first introduced in detail.

Embodiment 1:

FIG. 1 is a flowchart of a data statistics method for a report according to Embodiment 1 of the present invention.

Referring to Figure 1, the data statistics method of the report includes:

Step S101: Acquire report data information, where the report data information includes data corresponding to the object attribute and the object attribute;

Specifically, if A, B, C, D, and E represent object attributes, the object attributes here represent various object attributes of the statistical items in the report, for example, each object includes multiple products, and the statistical items include document number, organization name, The organization code, product name, date, etc., can be customized by the user and then saved in the database. When the statistical item is a document number, the object attribute includes the specific document number, including RT00117012350001, RT00117012350001, and so on. In the reporting system, it is usually necessary to count all the data of the same object attribute, that is, all the data under the same object attribute is statistically calculated. However, in the database, each data is stored separately, as shown in Table 1, with A, B, C, C, B, D, E object attributes and data corresponding to each object attribute 1, 2, 3, 4, 5, 6, and 7 are examples, showing the storage form of the data corresponding to the object attribute and the object attribute in the database.

Table 1

Object property	data
A	1
B	2
C	5
C	3
B	4

D	6
E	7

Step S102, sorting the data corresponding to the object attribute according to the object attribute to obtain a sequential data group, wherein the data with the same object attribute is tightly arranged;

Specifically, taking the object attributes and data in Table 1 as an example, all the data 1, 2, 5, 3, 4, 6, and 7 are sorted by object attributes to obtain a new data group, that is, 1, 2, 4, 5, 3, 6, and 7, as shown in Table 2, because the object properties of each data can be determined before the operation, so only need to compare the adjacent data, the cost of this algorithm Only in the sorting, the traditional Linq algorithm needs to compare each data with all the data existing in front, and finally group the data. The sorting algorithm in this embodiment is much simpler than the Linq algorithm, and the overall time cost is It is about 10 times faster than the traditional Linq algorithm in some specific scenarios.

Table 2

Object property	data
A	1
B	2
B	4
C	5
C	3
D	6
E	7

In step S103, the data in the sequential data group is calculated to obtain a calculation result.

Further, step S103 includes:

Step S1031: performing a summation calculation on the data in the sequential data group to obtain a summation result;

Or,

Step S1032, performing averaging calculation on the data in the sequential data group to obtain an averaging result;

or,

In step S1033, the data in the sequential data group is calculated to obtain the most value result.

Further, the sequential data group includes first data and second data. As shown in FIG. 2, step S1031 includes repeatedly performing the following processing until all data of the sequential data group is traversed:

S201: save the first data, and compare the second data with the first data to obtain a comparison result;

S202, if the comparison result belongs to the same object attribute, adding the first data and the second data to obtain the third data;

S203. If the comparison result belongs to different object attributes, the second data is separately saved.

Specifically, in the embodiment, the A, B, C, C, B, D, and E object attributes are taken as an example, and the corresponding data is 1, 2, 5, 3, 4, 6, and 7. The above data is sorted by object attributes, and then statistical calculations are performed. Specific steps are as follows:

Sorting the corresponding data according to the object attributes to obtain 1, 2, 4, 5, 3, 6, and 7, the data group;

Save the first data 1 first;

Comparing the second data 2 with the first data 1, the two belonging to different object attributes, the second data 2 is separately saved;

Comparing the third data 4 with the second data 2, and the two belong to the same object attribute, then the two are accumulated and saved;

Comparing the fourth data 5 with the third data 4, the two belonging to different object attributes, the fourth data 5 is separately saved;

Comparing the fifth data 3 with the fourth data 5, and the two belong to the same object attribute, then the two are cumulatively saved;

Comparing the sixth data 6 with the fifth data 3, the two belonging to different object attributes, the sixth data 6 is separately saved;

Comparing the 7th data 7 with the 6th data 6 and the two belong to different object attributes, the 7th data 7 is separately saved;

Through the above steps, the statistics of each object attribute and the accumulated data corresponding to each object attribute are obtained. For details, refer to Table 3.

table 3

Object property	data
A	1
B	7
C	7
D	6
E	7

It can be seen from the above steps that the embodiment does not need to traverse each of the previously existing group entries, thereby eliminating the process of matching calculation and improving the calculation efficiency. Especially when the amount of data is large, the efficiency is improved significantly.

It should be noted that the averaging calculation and the calculation of the maximum value of the data in the sequential data group are similar to the above-mentioned summation calculation, that is, averaging or maximizing all the data with the same object attribute, wherein, Find the maximum value including the maximum value and the minimum value. You can compare the adjacent data of the sequential data group. If they belong to the same object attribute, compare the size and finally get the maximum or minimum value of all the data with the same object attribute. I will not repeat them here.

Further, the object attribute is a plurality of object attributes in the statistical item of the report.

Further, the report data information and the calculation result are saved in the database.

Embodiment 2:

FIG. 3 is a schematic structural diagram of a data statistics system of a report according to Embodiment 1 of the present invention.

Referring to Figure 3, the data statistics system of the report includes:

The obtaining unit 10 is configured to obtain memory data information of the report, where the memory data information includes an object attribute and corresponding data;

The sorting unit 20 is configured to sort the data corresponding to the object attribute according to the object attribute to obtain a sequential data group, wherein the data with the same object attribute is closely arranged;

The calculating unit 30 is configured to calculate data in the sequential data group to obtain a calculation result.

Further, as shown in FIG. 4, the computing unit 30 includes:

a summation unit 31, configured to perform a summation calculation on the data in the sequential data group to obtain a summation result;

The averaging unit 32 is configured to perform averaging calculation on the data in the sequential data group to obtain an averaging result;

The most value unit 33 is configured to perform the most value calculation on the data in the sequential data group to obtain the most valued result.

Further, the sequential data group includes first data and second data. As shown in FIG. 5, the summation unit 31 includes:

The comparing unit 310 is configured to save the first data, and compare the second data with the first data to obtain a comparison result;

The accumulating unit 311 is configured to add the first data and the second data to obtain the third data if the comparison result is belonging to the same object attribute;

The saving unit 312 is configured to separately save the second data if the comparison result is belonging to different object attributes.

Further, the object attribute is a plurality of object attributes in the statistical item of the report.

Further, the report data information and the calculation result are saved in the database.

The data statistics system of the report provided by the embodiment of the present invention has the same technical features as the data statistics method of the report provided by the foregoing embodiment, so that the same technical problem can be solved and the same technical effect can be achieved.

The present invention provides a data statistics method and system for a report, the method comprising: obtaining report data information, the report data information including data corresponding to an object attribute and an object attribute; and sorting data corresponding to the object attribute according to the object attribute, obtaining a sequence A data group in which data having the same object attribute is closely arranged; the data in the sequential data group is calculated to obtain a calculation result. The statistical efficiency of memory data can be improved by using a statistical algorithm that sorts and then generalizes.

The computer program product provided by the embodiment of the present invention includes a computer readable storage medium storing the program code, and the program code includes instructions for executing the method described in the foregoing method embodiment. For the specific implementation, refer to the method embodiment. , will not repeat them here.

A person skilled in the art can clearly understand that for the convenience and brevity of the description, the specific working process of the system and the device described above can refer to the corresponding process in the foregoing method embodiments, and details are not described herein again.

In addition, in the description of the embodiments of the present invention, the terms "installation", "connected", and "connected" are to be understood broadly, and may be a fixed connection or a detachable connection, unless otherwise explicitly defined and defined. , or connected integrally; may be mechanical connection or electrical connection; may be directly connected, or may be indirectly connected through an intermediate medium, and may be internal communication between the two elements. The specific meaning of the above terms in the present invention can be understood in a specific case by those skilled in the art.

The functions may be stored in a computer readable storage medium if implemented in the form of a software functional unit and sold or used as a standalone product. Based on such understanding, the technical solution of the present invention may contribute to the prior art or part of the technical solution. Illustrated in the form of a software product stored in a storage medium, comprising instructions for causing a computer device (which may be a personal computer, server, or network device, etc.) to perform the embodiments of the present invention All or part of the steps of the method. The foregoing storage medium includes: a U disk, a mobile hard disk, a read-only memory (ROM), a random access memory (RAM), a magnetic disk, or an optical disk, and the like. .

In the description of the present invention, it is to be noted that the terms "center", "upper", "lower", "left", "right", "vertical", "horizontal", "inside", "outside", etc. The orientation or positional relationship of the indications is based on the orientation or positional relationship shown in the drawings, and is merely for the convenience of the description of the invention and the simplified description, rather than indicating or implying that the device or component referred to has a specific orientation, in a specific orientation. The construction and operation are therefore not to be construed as limiting the invention. Moreover, the terms "first," "second," and "third" are used for descriptive purposes only and are not to be construed as indicating or implying relative importance.

Finally, it should be noted that the above-mentioned embodiments are merely specific embodiments of the present invention, and are used to explain the technical solutions of the present invention, and are not limited thereto, and the scope of protection of the present invention is not limited thereto, although reference is made to the foregoing. The present invention has been described in detail, and those skilled in the art should understand that any one skilled in the art can still modify the technical solutions described in the foregoing embodiments within the technical scope disclosed by the present invention. The changes may be easily conceived, or equivalents may be substituted for some of the technical features. The modifications, variations, or substitutions of the present invention are not intended to depart from the spirit and scope of the technical solutions of the embodiments of the present invention. Within the scope of protection. Therefore, the scope of the invention should be determined by the scope of the appended claims.

Claims (10)

1. A data statistics method for a report, characterized in that the method comprises the following steps:

   Obtaining report data information, where the report data information includes an object attribute and data corresponding to the object attribute;

   Sorting data corresponding to the object attribute according to the object attribute to obtain a sequential data group, wherein the data with the same object attribute is closely arranged;

   Calculating the data in the sequential data set to obtain a calculation result.
2. The data statistics method of the report according to claim 1, wherein the step of calculating the data in the sequential data group to obtain a calculation result comprises:

   Performing a summation calculation on the data in the sequential data group to obtain a summation result;

   or,

   Performing averaging calculation on the data in the sequential data group to obtain an averaging result;

   or,

   The data in the sequential data set is subjected to a maximum value calculation to obtain a maximum value result.
3. The data statistics method of the report according to claim 2, wherein the sequential data group comprises first data and second data, and the summation of the data in the sequential data group is performed to obtain a summation result. The steps include repeating the following processing until all data of the sequential data group is traversed:

   Saving the first data, and comparing the second data with the first data to obtain a comparison result;

   If the comparison result is belonging to the same object attribute, adding the first data to the second data to obtain third data;

   If the comparison result is belonging to a different object attribute, the second data is separately saved.
4. The data statistics method of the report according to claim 1, wherein the object attribute is a plurality of object attributes in a statistical item of the report.
5. The data statistics method of a report according to claim 1, wherein the report data information and the calculation result are saved in a database.
6. A data statistics system for a report, comprising:

   An obtaining unit, configured to acquire report data information, where the report data information includes an object attribute and data corresponding to the object attribute;

   a sorting unit configured to sort the data corresponding to the object attribute according to the object attribute to obtain a sequential data group, wherein the data with the same object attribute is closely arranged;

   The calculating unit is configured to calculate data in the sequential data group to obtain a calculation result.
7. The data statistics system of the report according to claim 6, wherein the calculating unit comprises:

   a summation unit configured to perform a summation calculation on the data in the sequential data group to obtain a summation result;

   An averaging unit configured to perform averaging calculation on data in the sequential data group to obtain an averaging result;

   The most value unit is configured to perform a maximum value calculation on the data in the sequential data group to obtain a maximum value result.
8. The data statistics system of the report according to claim 7, wherein the sequential data group comprises first data and second data, and the summation unit comprises:

   a matching unit configured to save the first data and the second data and the first A data is compared and a comparison result is obtained;

   The accumulating unit is configured to add the first data and the second data to obtain the third data if the comparison result is belonging to the same object attribute;

   The saving unit is configured to separately save the second data if the comparison result is a different object attribute.
9. The data statistics system of the report according to claim 6, wherein the object attribute is a plurality of object attributes in a statistical item of the report.
10. The data statistics system for a report according to claim 6, wherein the report data information and the calculation result are saved in a database.

Images