CN109002448A

CN109002448A - A kind of report form statistics method, apparatus and system

Info

Publication number: CN109002448A
Application number: CN201710423452.4A
Authority: CN
Inventors: 姚海宏
Original assignee: China Mobile Communications Group Co Ltd; China Mobile Group Gansu Co Ltd
Current assignee: China Mobile Communications Group Co Ltd; China Mobile Group Gansu Co Ltd
Priority date: 2017-06-07
Filing date: 2017-06-07
Publication date: 2018-12-14
Anticipated expiration: 2037-06-07
Also published as: CN109002448B

Abstract

The invention discloses a kind of report form statistics method, apparatus and systems, and at high cost to solve existing reporting system extension, Statistical Speed is slow, the problem of performance difference.The described method includes: the report form statistics request for the first field groups of carrying that server receiving terminal is sent；First field groups the second field groups corresponding with each resource node are matched, when there are when target resource node for determination, terminal is sent to by the identification information of target resource node and according to the SQL statement that the first field groups generate, make terminal according to the identification information of the target resource node, the SQL statement is sent to target resource node, target resource node is made to send report form statistics result to the terminal.Server has saved the extension cost of server without report form statistics, and because the report form statistics of each terminal has been requested assignment to corresponding target resource node by server, it is completed without concentrating by server is unified, therefore improves the speed of each report form statistics.

Description

A kind of report form statistics method, apparatus and system

Technical field

The present invention relates to business support technical field, in particular to a kind of report form statistics method, apparatus and system.

Background technique

Currently, the reporting system in business support field is mainly by business operation support system (Business& Operation Support System, BOSS) it provides, total framework of reporting system is with C/S (client/server) framework It is main, when client (terminal) needs to carry out report form statistics, report form statistics request is sent to server, server is united according to report After meter request carries out report form statistics, statistical result is sent to terminal.The data for carrying out report form statistics are needed to be stored in server In, and statistic processes is also completed in the server.

With the development of BOSS system, business growth rate is getting faster, and new challenge is brought to server, on the one hand The data volume for needing to store constantly increases, and brings the pressure of data storage aspect, on the other hand requests the client of report form statistics It is required that Statistical Speed be also getting faster.

In order to meet the needs of business growth, server can vertically be extended according to the difference of type of server And/or it is extending transversely, vertical extension can for example increase the memory capacity or computing capability of original server, it is extending transversely for example It can be newly-increased server.No matter but which kind of extend, the cost needed is all very high.In addition since it is desired that the number of statistics According to leaving concentratedly, need to be traversed for all data in statistics, therefore single Statistical Speed does not almost get a promotion, so even if into It has gone extension, the speed concurrently counted also only can be improved, for single Statistical Speed, effect is little.

In addition, the storage resource and computing resource of server are shared for all terminals, storage data quantity is big, and calculating speed is slow The case where, the resource exhaustion of server may be influenced the demand of other normal works of server.

Summary of the invention

The embodiment of the invention discloses a kind of report form statistics method, apparatus and systems, to solve existing reporting system Extend at high cost, Statistical Speed is slow, the problem of performance difference.

In order to achieve the above objectives, the embodiment of the invention discloses a kind of report form statistics methods, which comprises

The report form statistics request for the first field groups of carrying that server receiving terminal is sent, wherein the first field groups packet Include at least one first field；

By the first field of each of first field groups the second field groups corresponding with each resource node prestored Each of the second field matched, it is determined whether exist carry out report form statistics target resource node；

If so, being looked by the identification information of the target resource node and according to the structuring that first field groups generate It askes language SQL statement and is sent to the terminal, make the terminal according to the identification information of the target resource node, it will be described SQL statement is sent to the target resource node, and the target resource node is made to send report form statistics result to the terminal.

Further, the first field of each of first field groups is corresponding with each resource node prestored Before the second field of each of second field groups is matched, the method also includes:

For the first field of each of first field groups, first category belonging to first field is identified, judge Whether the first category corresponding burst information is preserved；If it is not, then carrying out subsequent step；

If so, judging to whether there is and the successful third field of first fields match in the burst information；If There are the third fields of successful match to carry out subsequent step for the corresponding each resource node of the third field.

Further, successfully third field if there is no match, or there is no the target resources for carrying out report form statistics Node, the method also includes:

According to the SQL statement and the first report data for itself prestoring, report form statistics is carried out, and by report form statistics result It is sent to the terminal.

Further, if each first field the second field groups corresponding at least two resource nodes prestored Each of the success of the second fields match, the determining target resource node for carrying out report form statistics include:

According to the current attribute information of at least two resource node, the target resource section for carrying out report form statistics is determined Point.

Further, the attribute information comprises at least one of the following:

IP address, network speed, cpu busy percentage and memory size.

Further, the method also includes:

For each resource node, according to the palmic rate of the resource node, determine whether the resource node is effectively to provide Source node；If not, by the second word of each of the identification information of the resource node of preservation and its corresponding second field groups Section is deleted.

Further, the method also includes:

Receive the attribute information of itself that each terminal is sent；

For each terminal, judged whether according to the attribute information of the terminal using the terminal as resource node；Such as Fruit is corresponding second report data to be sent to the terminal, and according to the second report data of transmission corresponding each second Field, the corresponding relationship for the second field groups that the identification information and each second field for saving the terminal are constituted.

The embodiment of the invention discloses a kind of report form statistics system, the system comprises: first terminal, server and target Resource node；

The first terminal, for sending the report form statistics request for carrying the first field groups to server, wherein described the One field groups include at least one first field；

The server, the report form statistics request of the first field groups of carrying for receiving first terminal transmission；It will be described The second word of each of the first field of each of first field groups the second field groups corresponding with each resource node prestored Duan Jinhang matching, it is determined whether there is the target resource node for carrying out report form statistics；If so, by the target resource node Identification information and according to first field groups generate structured query language SQL statement be sent to the first terminal；

The first terminal is also used to be sent to the SQL statement according to the identification information of the target resource node The target resource node；

The target resource node, the SQL statement for being sent according to the first terminal and the report itself prestored Table data carry out report form statistics, and report form statistics result are sent to the first terminal；

The first terminal is also used to receive the report form statistics result that the target resource node is sent.

Further, the system also includes second terminals

The second terminal, for sending itself attribute information to server；

The server is also used to receive the attribute information of itself of second terminal transmission, according to the institute of the second terminal Attribute information is stated to judge whether using the second terminal as resource node；If so, by corresponding report data be sent to this Two terminals, and according to corresponding each second field of report data, save the identification information and each second word of the second terminal The corresponding relationship for the second field groups that section is constituted；

The second terminal is also used to receive the report data of server transmission and preservation.

The embodiment of the invention discloses a kind of report form statistics device, described device includes:

The report form statistics of receiving module, the first field groups of carrying for server receiving terminal transmission is requested, wherein institute Stating the first field groups includes at least one first field；

Determining module is matched, for by the first field of each of first field groups and each resource node for prestoring The second field of each of corresponding second field groups is matched, it is determined whether there is the target resource section for carrying out report form statistics Point；

Sending module, for being when being, by the mark of the target resource node in the matching result for matching determining module Information and according to first field groups generate structured query language SQL statement be sent to the terminal, make the terminal According to the identification information of the target resource node, the SQL statement is sent to the target resource node, makes the target Resource node sends report form statistics result to the terminal.

Further, described device further include:

First judgment module, for identifying the first field institute for the first field of each of first field groups The first category of category judges whether to preserve the corresponding burst information of the first category；When sentencing for the first judgment module When disconnected result is no, triggering matching determining module；

Second judgment module, for judging the burst information when the judging result of the first judgment module, which is, is In whether there is and the successful third field of first fields match；If the judging result of the second judgment module be it is yes, for The corresponding each resource node of the third field, triggering matching determining module.

Further, described device further include:

Statistical module, for the judging result in the second judgment module be it is no when, or matching determining module matching result When being no, according to the SQL statement and the first report data itself prestored, report form statistics is carried out；

The sending module is also used to report form statistics result being sent to the terminal.

Further, the matching determining module, if specifically for each first field with prestore at least two Each of corresponding second field groups of a resource node the second fields match success, according at least two resource node Current attribute information determines the target resource node for carrying out report form statistics.

Further, described device further include:

Node administration module, for determining the resource according to the palmic rate of the resource node for each resource node Whether node is efficient resource node；If not, by the identification information of the resource node of preservation and its corresponding second field The second field of each of group is deleted.

Further,

The receiving module is also used to receive the attribute information of itself that each terminal is sent；

Described device further include:

Distribute preserving module, for being directed to each terminal, is judged whether according to the attribute information of the terminal by the end End is used as resource node；If so, corresponding second report data is sent to the terminal, and according to the second report number of transmission According to corresponding each second field, it is corresponding with the second field groups that each second field is constituted to save the identification information of the terminal Relationship.

The embodiment of the invention discloses a kind of report form statistics method, apparatus and systems, which comprises server receives The report form statistics request for the first field groups of carrying that terminal is sent, wherein first field groups include at least one first word Section；It will be every in the first field of each of first field groups the second field groups corresponding with each resource node prestored A second field is matched, it is determined whether there is the target resource node for carrying out report form statistics；If so, the target is provided The identification information of source node and according to first field groups generate structured query language SQL statement be sent to the end End, makes the terminal according to the identification information of the target resource node, the SQL statement is sent to the target resource section Point makes the target resource node send report form statistics result to the terminal.Since in embodiments of the present invention, server will Each of report form statistics request the first field each second field corresponding with each resource node prestored is matched, really Set the goal resource node, provides report form statistics result to the terminal by target resource node.And server only generates SQL language Sentence and determining target resource node have saved the extension cost of server without report form statistics, and because server will be every The report form statistics of a terminal has requested assignment to corresponding target resource node, is completed without concentrating by server is unified, because This improves the speed of each report form statistics.

Detailed description of the invention

In order to more clearly explain the embodiment of the invention or the technical proposal in the existing technology, to embodiment or will show below There is attached drawing needed in technical description to be briefly described, it should be apparent that, the accompanying drawings in the following description is only this Some embodiments of invention for those of ordinary skill in the art without creative efforts, can be with It obtains other drawings based on these drawings.

Fig. 1 is a kind of report form statistics process schematic that the embodiment of the present invention 1 provides；

Fig. 2 is a kind of report form statistics process schematic that the embodiment of the present invention 3 provides；

Fig. 3 is a kind of report form statistics process schematic provided in an embodiment of the present invention；

Fig. 4 is a kind of schematic diagram of the report data of determining resource node provided in an embodiment of the present invention；

Fig. 5 is a kind of report form statistics system construction drawing that the embodiment of the present invention 7 provides；

Fig. 6 is a kind of system flow chart provided in an embodiment of the present invention；

Fig. 7 is a kind of report form statistics structure drawing of device provided in an embodiment of the present invention.

Specific embodiment

In order to save Server Extension cost, Statistical Speed and performance are improved, the embodiment of the invention provides a kind of reports Statistical method, apparatus and system.

Following will be combined with the drawings in the embodiments of the present invention, and technical solution in the embodiment of the present invention carries out clear, complete Site preparation description, it is clear that described embodiments are only a part of the embodiments of the present invention, instead of all the embodiments.It is based on Embodiment in the present invention, it is obtained by those of ordinary skill in the art without making creative efforts every other Embodiment shall fall within the protection scope of the present invention.

Embodiment 1:

Fig. 1 is a kind of report form statistics process schematic that provides of the embodiment of the present invention 1, the process the following steps are included:

S101: the report form statistics request for the first field groups of carrying that terminal is sent is received, wherein the first field groups packet Include at least one first field.

Report form statistics method provided in an embodiment of the present invention is applied to server.

The report form statistics that server receiving terminal is sent is requested, and carries the first field groups in report form statistics request, wherein First field groups include at least one first field.First field can be statistical time or statistical time section, example Such as, on January 3rd, 2017 or 2 months -2017 years in January, 2017, it can be statistical item, for example, newborn population, is also possible to unite Meter area, for example, Tianjin, Shanghai etc..

S102: by the first field of each of first field groups the second word corresponding with each resource node prestored The second field of each of Duan Zuzhong is matched, it is determined whether there is the target resource node for carrying out report form statistics, if it is, S103 is carried out, if it is not, then output prompt information.

The second field of each of corresponding second field groups of each resource node is pre-saved in server, specifically Ground, identification information the corresponding of the second field groups with each second field is constituted that can be each resource node of preservation are closed System, the corresponding relationship for the second field groups that the identification information of each resource node of preservation and each second field can be constituted It is stored in resource node concordance list.Corresponding second field groups of each resource node are the every report saved in the resource node The combination of the corresponding all fields of table data.

It, can be by described first when server receives the report form statistics request of the first field groups of carrying of terminal transmission The second field of each of the first field of each of field groups the second field groups corresponding with each resource node prestored into Row matching, it is determined whether there is the target resource node for carrying out report form statistics.If the server determine that there is no carry out report system The target resource node of meter, can export prompt information.

When corresponding second field groups of some resource node include all first fields in the first field groups, then it is assumed that The first field of each of first field groups the second field groups successful match corresponding with each resource node prestored, then The resource node is determined as target resource node.

Corresponding second field groups of resource node are related with the report data that the resource node saves.If there is no match , then illustrate to save the corresponding report data of the first field groups in no resource node.If there is matched, then illustrate to correspond to Target resource node in preserve the corresponding report data of the first field groups, report form statistics can be carried out.

S103: it is sent out by the identification information of the target resource node and according to the SQL statement that first field groups generate The terminal is given, makes the terminal according to the identification information of the target resource node, the SQL statement is sent to described Target resource node makes the target resource node send report form statistics result to the terminal.

If the server determine that there is the target resource node for carrying out report form statistics, then by the mark of the target resource node Know information and is sent to the terminal.And server can be generated according to the first field groups in the report form statistics request received SQL statement, and the SQL statement is sent to the terminal.Wherein, server generates SQL statement according to the first field groups Process belongs to the prior art, in embodiments of the present invention to the process without repeating.

Server is sent out by the identification information of the target resource node and according to the SQL statement that first field groups generate The terminal is given, makes the terminal according to the identification information of the target resource node, the SQL statement is sent to described Target resource node, the target resource node carries out report form statistics according to the SQL statement, and sends report to the terminal Statistical result.

It is above-mentioned when determining target resource node, if in corresponding second field groups of an only resource node include institute All first fields in the first field groups are stated, then a resource node are directly determined as target resource node.

For each resource node, multiple report datas may be stored in the resource node, then the resource node is corresponding Multiple second field groups, when being matched, the first field groups possibility and a second field groups successful match, it is also possible to Multiple second field groups successful match.If illustrating that the resource node can basis with multiple second field groups successful match The statistics of multiple reports progress report data.

Due in embodiments of the present invention, report form statistics each of is requested the first field and each of prestored by server Corresponding each second field of resource node is matched, and determines target resource node, by target resource node to the end End provides report form statistics result.And be that server only generates SQL statement and determines target resource node, without report form statistics, The extension cost of server is saved, and the report form statistics of each terminal has been requested assignment to corresponding target and provided by server Source node is completed by server is unified without concentrating, therefore improves the speed of each report form statistics.

Embodiment 2:

In order to improve the speed for determining whether there is the target resource node for carrying out report form statistics, to further increase report The speed of table statistics, on the basis of the above embodiments, in embodiments of the present invention, by each of described first field groups It is described before the second field of each of first field the second field groups corresponding with each resource node prestored is matched Method further include:

Because general all comprising fields such as time, project, areas in the report data saved in server, for side Just inquire and count, can the classification according to belonging to above-mentioned field, to report data carry out fragment.Such as when the classification of field is When regional, fragment, the institute in the fragment can be carried out comprising report data corresponding to this kind of other fields in area by all Some report datas all include area information, also, according to comprising area difference, for each fragment save it is corresponding Field.

Specifically, server can recorde the field for which classification and preserve fragment letter in embodiments of the present invention Breath, and which third field has corresponding fragment all include to record in the burst information.In addition, being directed to each third word Section, server are also preserved in the corresponding each resource node of the third field and corresponding second field groups of each resource node Each of the second field.The corresponding third field of each fragment can be stored in fragment concordance list.

If server is that " area " has carried out fragment according to classification, the corresponding third field of burst information be can be The report data in the area such as the Tianjin of preservation, Beijing is carried out fragment processing by the areas such as " Tianjin ", " Beijing ", server, will be every A area is used as third field.When third field is Tianjin, the report data comprising field " Tianjin " is preserved in server, And the identification information and every report data correspondence for the resource node that the report data comprising field " Tianjin " is counted The second field groups, that is, preserve the corresponding each resource node in Tianjin and corresponding second field groups of each resource node；When Preserve the report data comprising field " Beijing " when third field is Beijing, in server, and to including field " Beijing " The report data identification information and corresponding second field groups of every report data of the resource node that are counted, that is, save There are the corresponding each resource node in Beijing and corresponding second field groups of each resource node.

After server receives the report form statistics request of the first field groups of carrying of terminal transmission, the first word can be determined Classification belonging to the first field of each of Duan Zuzhong is believed according to classification belonging to each first field and each fragment of preservation Corresponding classification is ceased, burst information screening is carried out, target resource node is then determined in the burst information after screening.Specifically , it can be for each of first field groups the first field, identify first category belonging to first field, judge Whether the first category corresponding burst information is preserved；If preserving the corresponding burst information of the first category, sentence It whether there is and the successful third field of first fields match in the burst information of breaking；If there is with first field With successful third field, for the corresponding each resource node of the third field, by each of described first field groups The second word of each of corresponding second field groups of first field each resource node corresponding with the third field prestored Duan Jinhang matching, it is determined whether there is the target resource node for carrying out report form statistics.

When server, which determines, there is third field successful with first fields match, the corresponding fragment of third field It is properly termed as target fragment.

Server can preset the corresponding classification of burst information when determining the corresponding third field of burst information, The field for meeting the category in the second field groups in the burst information is determined as the corresponding third field of the burst information.

If server judgement does not save the corresponding burst information of the corresponding first category of any one first field, Then illustrate not carry out fragment for the corresponding first category of any one first field, then it can be directly by first field groups Each of the second field of each of the first field the second field groups corresponding with each resource node prestored matched, Determine whether there is the target resource node for carrying out report form statistics.

If preserving the corresponding burst information of the first category, but do not exist and the first category in burst information The corresponding successful third field of first fields match then illustrates to have carried out fragment according to first category, but the first category In corresponding burst information there is no with the successful third field of first fields match, also just be not present target resource node.

Embodiment 3:

Server is when target resource node is not present in determination, in order to provide corresponding statistical result, the clothes for user Being engaged in device can be with the report data progress report form statistics of itself preservation, and statistical result is returned to terminal.In above-mentioned each implementation On the basis of example, in embodiments of the present invention, successfully third field if there is no match, or there is no carry out report form statistics Target resource node, the method also includes:

The SQL statement generated according to first field groups and the first report data itself prestored, carry out report form statistics, And report form statistics result is sent to the terminal.

In embodiments of the present invention, server if it is determined that there is no with the successful third field of first fields match, Or there is no the target resource node for carrying out report form statistics, then illustrate that server does not deposit the corresponding report data of the first field It stores up in resource node, then the SQL statement that server is generated according to first field groups and the first report number itself prestored According to, progress report form statistics, and report form statistics result is sent to the terminal.

Server is being determined there is no when the target resource node for carrying out report form statistics, can be by directly by the first word The second field of each of the first field of each of Duan Zuzhong the second field groups corresponding with each resource node prestored carries out Matching determination；

It is also possible to after first judging not preserve the corresponding burst information of the first category, then by by the first field groups Each of the second field of each of the first field the second field groups corresponding with each resource node prestored matched Determining；

It can also be that first the corresponding burst information of the first category is preserved in judgement, and exist in the burst information After the successful third field of first fields match, for the corresponding each resource node of the third field, by by Corresponding second field groups of the first field of each of one field groups each resource node corresponding with the third field prestored Each of the second field to carry out matching determining.

Fig. 2 is a kind of report form statistics process schematic that provides of the embodiment of the present invention 3, the process the following steps are included:

S201: the report form statistics request for the first field groups of carrying that terminal is sent is received, wherein the first field groups packet Include at least one first field.

S202: for the first field of each of first field groups, identifying first category belonging to first field, Judge whether to preserve the corresponding burst information of the first category, if it is, S203 is executed, if it is not, then executing S204.

S203: judge in the burst information with the presence or absence of with the successful third field of first fields match, if It is then to be directed to the corresponding each resource node of the third field, executes S204, if it is not, then executes S206.

S204: by the first field of each of first field groups the second word corresponding with each resource node prestored The second field of each of Duan Zuzhong is matched, it is determined whether there is the target resource node for carrying out report form statistics, if it is, S205 is executed, if it is not, then executing S206.

S205: it is sent out by the identification information of the target resource node and according to the SQL statement that first field groups generate The terminal is given, makes the terminal according to the identification information of the target resource node, the SQL statement is sent to described Target resource node makes the target resource node send report form statistics result to the terminal.

S206: the SQL statement generated according to first field groups and the first report data itself prestored carry out report Statistics, and report form statistics result is sent to the terminal.

Embodiment 4:

If there is including all the in first field groups in corresponding second field groups of at least two resource nodes Any one resource node at least two resource node can be determined as target resource node by one field.In order to Keep the performance of determining target resource node more excellent, improves statistic property.On the basis of the various embodiments described above, of the invention real It applies in example, if each of each first field second field groups corresponding at least two resource nodes prestored The success of two fields match, the determining target resource node for carrying out report form statistics include:

The attribute information comprises at least one of the following: IP address, network speed, cpu busy percentage and memory size.

When the attribute information is the IP address, server can according to the IP address of the terminal and it is described at least The IP address of two resource nodes, the determining and terminal are target resource node apart from nearest resource node；Or,

When the attribute information is network speed, server detects the network speed of at least two resource node, by net The highest resource node of network speed is determined as target resource node；Or,

When the attribute information is cpu busy percentage and memory size, server detects at least two resource node Cpu busy percentage and memory size, according to preset weighting algorithm at least two resource node determine target resource Node；Or

IP address, the IP address of at least two resource node, described at least two of the server according to the terminal The cpu busy percentage and memory size and preset weighting algorithm of the network speed of resource node and at least two resource node, Target resource node is determined at least two resource node.

Report form statistics process schematic as shown in Figure 3, server receiving terminal send the report for carrying the first field groups Statistics request generates SQL statement according to the first field groups in report form statistics request, and is according to the determination of fragment concordance list It is no that there are target fragments.If there is no target fragment, then report is carried out according to the report data of itself and the SQL statement of generation Statistics, is sent to the terminal for report form statistics result.

If there is target fragment, then target resource node is determined whether there is according to resource node concordance list.If no There are target resource nodes, then report form statistics are carried out according to the report data of itself and the SQL statement of generation, by report form statistics knot Fruit is sent to the terminal.If there is the resource node for carrying out report form statistics be one, then directly by the resource node The terminal is sent to as target resource node, and by the SQL statement of the identification information of the target resource node and generation.Such as The resource node that report form statistics can be carried out existing for fruit is at least two, then according to the attribute information of resource node, selects one Resource node is sent to institute as target resource node, and by the SQL statement of the identification information of the target resource node and generation State terminal.

Embodiment 5:

After receiving report form statistics request, server determines that the report form statistics requests corresponding target resource node, Before this, server needs for corresponding terminal to be determined as resource node, and determines the report data of each resource node storage, Field information is extracted according to the data of each resource node storage to be saved, and it is corresponding just to can be carried out above-mentioned determining statistics request The process of target resource node.On the basis of the various embodiments described above, in embodiments of the present invention, the method also includes:

Receive the attribute information of itself that each terminal is sent；

For each terminal, judged whether according to the attribute information of the terminal using the terminal as resource node；Such as Fruit is corresponding second report data to be sent to the terminal, and according to corresponding each second field of the second report data, protect The corresponding relationship for the second field groups that the identification information and each second field for depositing the terminal are constituted.

In embodiments of the present invention, server can determine resource node using dynamical fashion when determining resource node, Determined whether the terminal being determined as resource node according to the attribute information of each terminal, the specific can be that, server connects Receive the attribute information of itself that each terminal is sent；For each terminal, judged whether according to the attribute information of the terminal Using the terminal as resource node.The attribute information comprises at least one of the following: IP address, network speed, cpu busy percentage and memory Capacity.

The attribute information that terminal to server sends itself can be the transmission when sending report form statistics request, be also possible to It is sent by the preset period.

When server determines that the terminal is resource node, corresponding second report data can be sent to the terminal, And according to corresponding each second field of the second report data, what the identification information and each second field for saving the terminal were constituted The corresponding relationship of second field groups.

Server can be stored when determining corresponding second report data of resource node according to the residue of the resource node The memory capacity that capacity and report data occupy is determined, and the storage volume that each report data occupies may be different , first the size for the memory capacity that each report data occupies can be ranked up, then carry out report data distribution, specifically Determination process is herein without limiting.

Server can also determine resource node, i.e. matching according to user using static mode when determining resource node It sets, saves the identification information that each resource connects node.Generally in report form statistics business, statistics has periodically, in a week Interim, report data is almost fixation, what the occupied memory capacity of report data was namely fixed, therefore can be for report The memory capacity that table data occupy chooses the resource node of fixed quantity from prefectures and cities, according to the of the storage of each resource node Two report datas, the corresponding relationship for the second field groups that the identification information and each second field for saving the resource node are constituted.

Server can also be determined when determining resource node in such a way that static and dynamic combines, according to The quantity of total resource node of demand, determines the first quantity and the second quantity, wherein the sum of the first quantity and the second quantity is Total quantity, first quantity and the second quantity may be the same or different.User occupies according to all report datas Storage volume, the resource node for choosing the first quantity from prefectures and cities, which is configured in server, is used as resource node, but first The resource node of quantity can not be all in storage server report data, server can be sent further according to terminal itself Attribute information, the resource node of the second quantity is determined, to guarantee all report datas being stored into corresponding resource In node.

When determining the corresponding report data of resource node, server can directly hold according to the remaining storage of resource node The size for the memory capacity that amount and each report data occupy is determined.If server carries out fragment, root to report data The residual storage capacity of the storage volume and each resource node that occupy according to the report data in each fragment is determined by which Resource node stores the report data in the fragment, and the report data in the fragment is then distributed to the corresponding resource section Point.

For example, if the residual storage capacity of each resource node is A, when all report datas are carried out fragment, Be divided into D fragment, the report quantity B in each fragment be also it is identical, and every report occupy memory capacity C phase Together, then: individual report of the quantity X=of resource node occupies each fragment report quantity B/ resource section of memory capacity C* fragment number D* The residual storage capacity A of point.

When store some fragment in report data some resource node when something goes wrong, in order to guarantee report form statistics It operates normally, more parts can be saved for the report data in the fragment, that is, at least two will be given with a report data A resource node is saved, when a resource node when something goes wrong, resource node in addition can carry out report form statistics.

The number of preservation of each report in fragment is known as redundancy Y, then the quantity S of the total resource node needed =X*Y.

Before carrying out fragment processing to report data, report data can be arranged according to report form statistics bore Intermediate data is generated, for example, being adjusted according to time or area to report data.Intermediate data is generated to carry out at fragment again Reason guarantees that target resource node when carrying out report data statistics, counts in single report data as far as possible, reduces target money The complexity of source node statistical.

The schematic diagram of the report data of determination resource node as shown in Figure 4 unites all report datas according to report It counts bore and generates intermediate data, fragment processing is carried out to intermediate data according to regionality, generates 1-N fragment.For fragment 1, Report data in the fragment 1 is distributed to 1-M resource node.Wherein report form statistics bore is some word in report data Section.Likewise, similarly there is the above process, the report data in each fragment is distributed to corresponding for other fragments Resource node, wherein the corresponding resource node of each fragment can not be identical, it can also be partly or entirely identical.

Embodiment 6:

After server has determined resource node, which can also be managed, in the base of the various embodiments described above On plinth, in embodiments of the present invention, the method also includes:

In embodiments of the present invention, resource node can send heartbeat detection packet to server, for each resource node, clothes The frequency i.e. palmic rate of the resource node for receiving the heartbeat detection packet that the resource node is sent is preserved in business device, if clothes Business device detects that the frequency of received heartbeat detection packet and the frequency of preservation are not met, it is determined that the resource node is not effectively to provide Source node then illustrates that the resource node fails, not can be carried out report form statistics, and server is by the resource node of the failure of preservation The second field of each of identification information and corresponding second field groups of the resource node of the failure is deleted.

Report data clearance order can also be sent to the resource node of the failure simultaneously, make the resource node of the failure The report data of itself preservation is removed, so as to the demand of other work.

Embodiment 7:

Fig. 5 is a kind of report form statistics system construction drawing that the embodiment of the present invention 7 provides, the system comprises: first terminal 51, server 52 and target resource node 53；

The first terminal 51, for sending the report form statistics request for carrying the first field groups to server 52, wherein institute Stating the first field groups includes at least one first field；

The server 52, the report form statistics request of the first field groups of carrying for receiving the transmission of first terminal 51；It will Each of the first field of each of first field groups second field groups corresponding with each resource node prestored Two fields are matched, it is determined whether there is the target resource node 53 for carrying out report form statistics；If so, by the target resource The identification information of node 53 and according to first field groups generate structured query language SQL statement be sent to described first Terminal 51；

The first terminal 51 is also used to be sent out the SQL statement according to the identification information of the target resource node 53 Give the target resource node 53；

The target resource node 53, the SQL statement for being sent according to the first terminal 51 and itself prestores Report data, carry out report form statistics, and report form statistics result be sent to the first terminal 51；

The first terminal 51 is also used to receive the report form statistics result that the target resource node 53 is sent.

Report form statistics system provided in an embodiment of the present invention includes first terminal, server and target resource node.

Itself, there are when report form statistics request, the report for carrying the first field groups is sent to server when first terminal identifies Statistics request, wherein first field groups include at least one first field.Wherein first field groups include at least one A first field.First field can be statistical time or statistical time section, for example, on January 3rd, 2017 or 2017 In 2 months -2017 years January, it can be statistical item, for example, newborn population, is also possible to statistics area, for example, Tianjin, Shanghai etc..

It, can will be described when server receives the report form statistics request of the first field groups of carrying of first terminal transmission The second word of each of the first field of each of first field groups the second field groups corresponding with each resource node prestored Duan Jinhang matching, it is determined whether there is the target resource node for carrying out report form statistics.If the server determine that there is no reported The target resource node of table statistics, can export prompt information.

If the server determine that there is the target resource node for carrying out report form statistics, then by the mark of the target resource node Know information and is sent to the first terminal.And server can be according to the first field groups in the report form statistics request received SQL statement is generated, and the SQL statement is sent to the first terminal.Wherein, server is generated according to the first field groups The process of SQL statement belongs to the prior art, in embodiments of the present invention to the process without repeating.

Server is sent out by the identification information of the target resource node and according to the SQL statement that first field groups generate The first terminal is given, the first terminal sends the SQL statement according to the identification information of the target resource node To the target resource node, the SQL statement that the target resource node is sent according to the first terminal is pre- with itself The report data deposited carries out report form statistics, and report form statistics result is sent to the first terminal, and the first terminal receives The report form statistics result that the target resource node is sent is shown.

Above-mentioned server is when determining target resource node, if in corresponding second field groups of an only resource node Comprising all first fields in first field groups, then a resource node is directly determined as target resource node. If there is including all first fields in first field groups in corresponding second field groups of at least two resource nodes, then Any one resource node at least two resource node can be determined as target resource node.

Due in embodiments of the present invention, report form statistics each of is requested the first field and each of prestored by server Corresponding each second field of resource node is matched, and determines target resource node, by target resource node to the end End sends report form statistics result.And server only generates SQL statement and determines target resource node, without report form statistics, section The about extension cost of server, and the report form statistics of each terminal has been requested assignment to corresponding target resource by server Node is completed by server is unified without concentrating, therefore improves the speed of each report form statistics.

Embodiment 8:

After server receives report form statistics request, determine that the report form statistics requests corresponding target resource node, herein Before, server needs for corresponding terminal to be determined as resource node, and determines the report data of each resource node storage, root Field information is extracted according to the data of each resource node storage to be saved, and just be can be carried out above-mentioned determining statistics and is requested corresponding mesh Mark the process of resource node.On the basis of above-described embodiment 7, in embodiments of the present invention, the system also includes: second eventually End, the second terminal, for sending itself attribute information to server；

In embodiments of the present invention, server can determine resource node using dynamical fashion when determining resource node, Determined whether the second terminal being determined as resource node according to the attribute information of each second terminal, the specific can be that, Second terminal sends the attribute information of itself to server, and server receives the attribute of itself letter that each second terminal is sent Breath；For each second terminal, judged whether according to the attribute information of the second terminal using the second terminal as resource Node.The attribute information comprises at least one of the following: IP address, network speed, cpu busy percentage and memory size.

Second terminal can be the transmission when sending report form statistics and requesting to the attribute information that server sends itself, can also Being sent by the preset period.

When server determines that the second terminal is resource node, corresponding second report data can be sent to this Two terminals, and according to corresponding each second field of the second report data save the identification information and each the of the second terminal The corresponding relationship for the second field groups that two fields are constituted.

Server can also determine resource node in such a way that static state determines when determining resource node, i.e., according to The configuration at family saves the identification information that each resource connects node.Generally in report form statistics business, statistics has periodicity, In a cycle, report data be almost it is fixed, the occupied memory capacity of report data is namely fixed, therefore can be with For the memory capacity that report data occupies, the resource node of fixed quantity is chosen from prefectures and cities, is deposited according to each resource node It is corresponding with the second field groups that each second field is constituted to save the identification information of the resource node for second report data of storage Relationship.

Server can also be determined when determining resource node in such a way that static and dynamic combines, according to The quantity of total resource node of demand, determines the first quantity and the second quantity, wherein the sum of the first quantity and the second quantity is Total quantity, first quantity and the second quantity may be the same or different.User occupies according to all report datas Storage volume, the resource node for choosing the first quantity from prefectures and cities, which is configured in server, is used as resource node, but first The resource node of quantity can not be all in storage server report data, what server can be sent further according to second terminal The attribute information of itself determines the resource node of the second quantity, corresponding to guarantee for all report datas to be stored into In resource node.

First terminal and second terminal mentioned above may be the same or different.

Embodiment 9:

After server has determined resource node, which can also be managed, in above-described embodiment 7 and 8 On the basis of, in embodiments of the present invention, if the terminal is resource node, the terminal is also used to send the heart to server Jump detection packet；

The server is also used to receive the heartbeat detection packet that the terminal is sent, according to receiving heartbeat detection packet Frequency and preset target frequency determine whether the terminal is efficient resource node；If not, by the mark of the terminal of preservation Know the second field of each of information and its corresponding second field groups to delete.

In embodiments of the present invention, resource node can send heartbeat detection packet to server, for each resource node, clothes The frequency for receiving the heartbeat detection packet that the resource node is sent is preserved in business device, if server detects received heartbeat packet Frequency and the frequency of preservation do not meet, it is determined that the resource node is not efficient resource node, then illustrates that the resource node loses Effect, not can be carried out report form statistics, and server is by the identification information of the resource node of the failure of preservation and the resource section of the failure The second field of each of corresponding second field groups of point is deleted.

Server can also send the resource node of the report data clearance order failure to the resource node of the failure After receiving clear instruction, the report data of itself preservation is removed, so as to the demand of other work.

The terminal for sending report form statistics request can be resource node, may not be resource node, when the terminal is money When source node, which may be target resource node, it is also possible to not be target resource node.

Fig. 6 is system flow chart provided in an embodiment of the present invention, and server determines resource node, and carries out to resource node Management, server send report data to resource node.When terminal to server sends report form statistics request, server is returned SQL statement is sent to target according to the identification information of resource node by the identification information and SQL statement of target resource node, terminal Resource node, the report data that target resource node is saved according to itself and the SQL statement received carry out report form statistics, and Report form statistics result is sent to the terminal.

Description according to the above embodiments, it can be concluded that the function that server has are as follows: resource connects the pipe of node Reason, comprising: heartbeat detection, Performance Evaluation；The distribution of data, comprising: fragment processing, distribution processor；Target resource node is really Fixed and generation of SQL statement etc..

If terminal is ordinary terminal, function are as follows: send report form statistics request, position target resource node, send attribute Information etc..

If terminal is resource node, on the basis of ordinary terminal, which also has report form statistics, and sends heartbeat inspection Survey the function of packet.

Fig. 7 is a kind of report form statistics structure drawing of device provided in an embodiment of the present invention, and described device includes:

Receiving module 71, for the report form statistics request for the first field groups of carrying that server receiving terminal is sent, wherein First field groups include at least one first field；

Determining module 72 is matched, for by the first field of each of first field groups and each resource section for prestoring The second field of each of corresponding second field groups of point is matched, it is determined whether there is the target resource for carrying out report form statistics Node；

Sending module 73, for being when being, by the mark of the target resource node in the matching result for matching determining module Know information and the terminal is sent to according to the structured query language SQL statement that first field groups generate, makes the end The SQL statement is sent to the target resource node, makes the mesh by end according to the identification information of the target resource node It marks resource node and sends report form statistics result to the terminal.

Described device further include:

First judgment module 74, for identifying first field for the first field of each of first field groups Affiliated first category judges whether to preserve the corresponding burst information of the first category；When the first judgment module 74 Judging result be it is no when, triggering matching determining module 72；

Second judgment module 75, for judging the fragment when the judging result of the first judgment module 74, which is, is It whether there is and the successful third field of first fields match in information；If the judging result of the second judgment module 75 is It is, for the corresponding each resource node of the third field, triggering matching determining module 72.

Described device further include:

Statistical module 76, for the judging result in the second judgment module 75 be it is no when, or matching determining module 72 When with result being no, according to the SQL statement and the first report data for itself prestoring, report form statistics is carried out；

The sending module 73 is also used to report form statistics result being sent to the terminal.

The matching determining module 72, if specifically for each first field and at least two resource sections prestored Each of corresponding second field groups of point the second fields match success, according to the current category of at least two resource node Property information, determine carry out report form statistics target resource node.

Described device further include:

Node administration module 77, for determining the money according to the palmic rate of the resource node for each resource node Whether source node is efficient resource node；If not, by the identification information of the resource node of preservation and its corresponding second word The second field of each of Duan Zuzhong is deleted.

The receiving module 71 is also used to receive the attribute information of itself that each terminal is sent；

Described device further include:

Distribute preserving module 78, for being directed to each terminal, judging whether according to the attribute information of the terminal should Terminal is as resource node；If so, corresponding second report data is sent to the terminal, and according to the second report of transmission Corresponding each second field of data, pair for the second field groups that the identification information and each second field for saving the terminal are constituted It should be related to.

For systems/devices embodiment, since it is substantially similar to the method embodiment, so the comparison of description is simple Single, the relevent part can refer to the partial explaination of embodiments of method.

It should be noted that, in this document, relational terms such as first and second and the like are used merely to a reality Body or an operation are distinguished with another entity or another operation, without necessarily requiring or implying these entities Or there are any actual relationship or orders between operation.

It should be understood by those skilled in the art that, embodiments herein can provide as method, system or computer program Product.Therefore, the reality of complete hardware embodiment, complete Application Example or connected applications and hardware aspect can be used in the application Apply the form of example.Moreover, it wherein includes the computer of computer usable program code that the application, which can be used in one or more, The computer program implemented in usable storage medium (including but not limited to magnetic disk storage, CD-ROM, optical memory etc.) produces The form of product.

The application is referring to method, the process of equipment (system) and computer program product according to the embodiment of the present application Figure and/or block diagram describe.It should be understood that every one stream in flowchart and/or the block diagram can be realized by computer program instructions The combination of process and/or box in journey and/or box and flowchart and/or the block diagram.It can provide these computer programs Instruct the processor of general purpose computer, special purpose computer, Embedded Processor or other programmable data processing devices to produce A raw machine, so that being generated by the instruction that computer or the processor of other programmable data processing devices execute for real The device for the function of being specified in present one or more flows of the flowchart and/or one or more blocks of the block diagram.

These computer program instructions, which may also be stored in, is able to guide computer or other programmable data processing devices with spy Determine in the computer-readable memory that mode works, so that it includes referring to that instruction stored in the computer readable memory, which generates, Enable the manufacture of device, the command device realize in one box of one or more flows of the flowchart and/or block diagram or The function of being specified in multiple boxes.

These computer program instructions also can be loaded onto a computer or other programmable data processing device, so that counting Series of operation steps are executed on calculation machine or other programmable devices to generate computer implemented processing, thus in computer or The instruction executed on other programmable devices is provided for realizing in one or more flows of the flowchart and/or block diagram one The step of function of being specified in a box or multiple boxes.

Although the preferred embodiment of the application has been described, it is created once a person skilled in the art knows basic Property concept, then additional changes and modifications can be made to these embodiments.So it includes excellent that the following claims are intended to be interpreted as It selects embodiment and falls into all change and modification of the application range.

Obviously, those skilled in the art can carry out various modification and variations without departing from the essence of the application to the application Mind and range.In this way, if these modifications and variations of the application belong to the range of the claim of this application and its equivalent technologies Within, then the application is also intended to include these modifications and variations.

Claims

1. a kind of report form statistics method, which is characterized in that the described method includes:

The report form statistics request for the first field groups of carrying that server receiving terminal is sent, wherein first field groups include extremely Few first field；

It will be in the first field of each of first field groups the second field groups corresponding with each resource node prestored Each second field is matched, it is determined whether there is the target resource node for carrying out report form statistics；

If so, by the identification information of the target resource node and the structuralized query language generated according to first field groups Speech SQL statement is sent to the terminal, makes the terminal according to the identification information of the target resource node, by the SQL language Sentence is sent to the target resource node, and the target resource node is made to send report form statistics result to the terminal.

2. the method as described in claim 1, which is characterized in that by the first field of each of first field groups and in advance Before the second field of each of corresponding second field groups of each resource node deposited is matched, the method also includes:

For the first field of each of first field groups, identifies first category belonging to first field, judge whether Preserve the corresponding burst information of the first category；If it is not, then carrying out subsequent step；

If so, judging to whether there is and the successful third field of first fields match in the burst information；If there is The third field of successful match carries out subsequent step for the corresponding each resource node of the third field.

3. method according to claim 2, which is characterized in that successful third field if there is no match, or be not present The target resource node for carrying out report form statistics, the method also includes:

According to the SQL statement and the first report data itself prestored, report form statistics is carried out, and report form statistics result is sent To the terminal.

4. method according to claim 1 or 2, which is characterized in that if each first field with prestore at least two The the second fields match success of each of corresponding second field groups of a resource node, the determining target for carrying out report form statistics Resource node includes:

According to the current attribute information of at least two resource node, the target resource node for carrying out report form statistics is determined.

5. method as claimed in claim 4, which is characterized in that the attribute information comprises at least one of the following:

IP address, network speed, cpu busy percentage and memory size.

6. the method as described in claim 1, which is characterized in that the method also includes:

For each resource node, according to the palmic rate of the resource node, determine whether the resource node is efficient resource section Point；If not, the second field of each of the identification information of the resource node of preservation and its corresponding second field groups is deleted It removes.

7. method as described in claim 1 or 6, which is characterized in that the method also includes:

Receive the attribute information of itself that each terminal is sent；

For each terminal, judged whether according to the attribute information of the terminal using the terminal as resource node；If so, Corresponding second report data is sent to the terminal, and according to corresponding each second field of the second report data of transmission, The corresponding relationship for the second field groups that the identification information and each second field for saving the terminal are constituted.

8. a kind of report form statistics system, which is characterized in that the system comprises: first terminal, server and target resource node；

The first terminal, for sending the report form statistics request for carrying the first field groups to server, wherein first word Section group includes at least one first field；

The server, the report form statistics request of the first field groups of carrying for receiving first terminal transmission；By described first The second field of each of the first field of each of field groups the second field groups corresponding with each resource node prestored into Row matching, it is determined whether there is the target resource node for carrying out report form statistics；If so, by the mark of the target resource node Information and according to first field groups generate structured query language SQL statement be sent to the first terminal；

The first terminal is also used to the identification information according to the target resource node, the SQL statement is sent to described Target resource node；

The target resource node, the SQL statement for being sent according to the first terminal and the report number itself prestored According to, progress report form statistics, and report form statistics result is sent to the first terminal；

9. system as claimed in claim 8, which is characterized in that the system also includes: second terminal

The second terminal, for sending itself attribute information to server；

The server is also used to receive the attribute information of itself of second terminal transmission, according to the category of the second terminal Property information judges whether using the second terminal as resource node；If so, corresponding report data is sent to second end End, and according to corresponding each second field of report data, save the identification information and each second field structure of the second terminal At the second field groups corresponding relationship；

10. a kind of report form statistics device, which is characterized in that described device includes:

Receiving module, for the report form statistics request for the first field groups of carrying that server receiving terminal is sent, wherein described the One field groups include at least one first field；

Determining module is matched, for the first field of each of first field groups is corresponding with each resource node prestored The second field of each of the second field groups matched, it is determined whether there is the target resource node for carrying out report form statistics；

Sending module, for being when being, by the identification information of the target resource node in the matching result for matching determining module Be sent to the terminal with the structured query language SQL statement generated according to first field groups, make the terminal according to The SQL statement is sent to the target resource node, makes the target resource by the identification information of the target resource node Node sends report form statistics result to the terminal.

11. device as claimed in claim 10, which is characterized in that described device further include:

First judgment module, for identifying belonging to first field for the first field of each of first field groups First category judges whether to preserve the corresponding burst information of the first category；When the judgement knot of the first judgment module When fruit is no, triggering matching determining module；

Second judgment module, for when the judging result of the first judgment module be when, judge be in the burst information It is no to exist and the successful third field of first fields match；If the judging result of the second judgment module be it is yes, for described The corresponding each resource node of third field, triggering matching determining module.

12. device as claimed in claim 11, which is characterized in that described device further include:

Statistical module, for the judging result in the second judgment module be it is no when, or matching determining module matching result be no When, according to the SQL statement and the first report data itself prestored, carry out report form statistics；

13. device as described in claim 10 or 11, which is characterized in that the matching determining module, if being specifically used for institute The second fields match of each of the second field groups corresponding at least two resource nodes prestored of stating each first field at Function determines the target resource node for carrying out report form statistics according to the current attribute information of at least two resource node.

14. device as claimed in claim 10, which is characterized in that described device further include:

Node administration module, for determining the resource node according to the palmic rate of the resource node for each resource node It whether is efficient resource node；If not, by the identification information of the resource node of preservation and its corresponding second field groups Each of the second field delete.

15. the device as described in claim 10 or 14, which is characterized in that

Described device further include:

Distribute preserving module, for being directed to each terminal, judges whether to make the terminal according to the attribute information of the terminal For resource node；If so, corresponding second report data is sent to the terminal, and according to the second report data pair of transmission The second field each of is answered, the identification information of the terminal and the corresponding pass for the second field groups that each second field is constituted are saved System.