CN104408057A - Data summarization method and device - Google Patents
Data summarization method and device Download PDFInfo
- Publication number
- CN104408057A CN104408057A CN201410593735.XA CN201410593735A CN104408057A CN 104408057 A CN104408057 A CN 104408057A CN 201410593735 A CN201410593735 A CN 201410593735A CN 104408057 A CN104408057 A CN 104408057A
- Authority
- CN
- China
- Prior art keywords
- identification information
- data
- data record
- upper level
- record
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Granted
Links
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/24—Querying
- G06F16/245—Query processing
- G06F16/2458—Special types of queries, e.g. statistical queries, fuzzy queries or distributed queries
- G06F16/2462—Approximate or statistical queries
Landscapes
- Engineering & Computer Science (AREA)
- Physics & Mathematics (AREA)
- Probability & Statistics with Applications (AREA)
- Theoretical Computer Science (AREA)
- Computational Linguistics (AREA)
- Software Systems (AREA)
- Mathematical Physics (AREA)
- Data Mining & Analysis (AREA)
- Databases & Information Systems (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Fuzzy Systems (AREA)
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention provides a data summarization method and device. The method comprises the following steps that each piece of mark information, with the upper stage of mark information, in a data table is obtained; each stage of mark information and corresponding data records of each stage of mark information are stored in the data table; data records corresponding to each piece of obtained mark information are summarized to obtain summarized data records; data records corresponding to the upper stage of mark information are obtained according to the summarized data records. Through the implementation of the embodiment of the invention, when the summarization value of a certain summarization target needs to be obtained, the next stage of data of the summarization target is directly added, the summarized data can be obtained, the addition through obtaining huge data from a bottom layer is not needed, and the calculation pressure of a summarization tool is greatly reduced.
Description
Technical field
The present invention relates to field of computer technology, particularly relate to a kind of method and device of data summarization.
Background technology
Data summarization has application in all trades and professions, especially use comparatively frequent in banking, the data volume related to due to bank is huge, the hierarchical structure of summarized results is complicated, so require higher to the Method and kit for of process bank data, the method of the data summarization generally applied in current the sector is: the hierarchical structure pre-determining summarized results, comprise in each level and somely gather target, from huge bottom data, screening belongs to some bottom datas gathering target and gathers, and what obtain gathering target gathers value.
The defect that prior art exists is, with reference to Fig. 1 citing: A, B and C is for gathering target, D, E, F, G, H and I are bottom data, B and C belongs to the lower DBMS of A, D, E and F belong to the lower DBMS of B, G, H and I belong to the lower DBMS of C, so when gathering, gathering target B and being obtained by D+E+F, gather target C and obtained by G+H+I, gather target A to be obtained by D+E+F+G+H+I, when the hierarchical structure of summarized results is complicated, adopts above-mentioned method of summary can make to gather instrument and bear huge calculating pressure, sometimes even directly cause gathering instrument collapse.
Summary of the invention
The embodiment of the invention discloses a kind of method and device of data summarization, for solving in above-mentioned technology when the hierarchical structure of summarized results is complicated, gathering instrument and can bear this problem of huge calculating pressure.
First aspect, embodiments provides a kind of method of data summarization, comprising:
Obtain each identification information in tables of data with identical upper level identification information, described tables of data stores the identification information of each grade and the data record of correspondence thereof;
The data record corresponding to each identification information described in acquisition gathers, and obtains combined data record;
Data record corresponding to described upper level identification information is obtained according to described combined data record.
Second aspect, embodiments provides a kind of device of data summarization, comprising:
First acquiring unit, for obtaining in tables of data each identification information with identical upper level identification information, described tables of data stores the identification information of each grade and the data record of correspondence thereof;
First collection unit, gathers for the data record corresponding to each identification information described in described first acquiring unit acquisition, obtains combined data record;
First computing unit, the described combined data record for obtaining according to described first collection unit obtains data record corresponding to described upper level identification information.
By implementing the embodiment of the present invention, when to obtain a certain gather target gather value time, directly sum up to obtain to these next stage data gathering target and gather value, and do not need to obtain huge data from bottom and sum up, substantially reduce the calculating pressure gathering instrument, to solve in prior art when the hierarchical structure of summarized results is complicated, gather the problem that instrument can bear huge calculating pressure; After identification information structure changes, only the data corresponding to local identification information adjust instead of adjust all data, enormously simplify the step recalculated, reduce the calculating pressure gathering instrument to a certain extent; In addition, can also review the source of combined data as required, particularly when identification information changes and causes partial data to recalculate, can by reviewing the data of searching identification information and the correspondence thereof changed.
Accompanying drawing explanation
In order to be illustrated more clearly in the embodiment of the present invention or technical scheme of the prior art, be briefly described to the accompanying drawing used required in embodiment or description of the prior art below, apparently, accompanying drawing in the following describes is only some embodiments of the present invention, for those of ordinary skill in the art, under the prerequisite not paying creative work, other accompanying drawing can also be obtained according to these accompanying drawings.
Fig. 1 is the schematic flow sheet of the method for the data summarization of prior art;
Fig. 2 is the schematic flow sheet of the method for the data summarization that the embodiment of the present invention provides;
Fig. 3 is the schematic flow sheet of the method for the data summarization of another embodiment provided by the invention;
Fig. 4 is the schematic flow sheet of the method for the data summarization of another embodiment provided by the invention;
Fig. 5 is one provided by the invention and is determining the application example in scene;
Fig. 6 is the structural representation of the device of the data summarization that the embodiment of the present invention provides;
Fig. 7 is the structural representation of the device of the data summarization of another embodiment provided by the invention;
Fig. 8 is the structural representation of the device of the data summarization of another embodiment provided by the invention;
Fig. 9 is the structural representation of the device of the data summarization of another embodiment provided by the invention.
Embodiment
Below in conjunction with the accompanying drawing in the embodiment of the present invention, be clearly and completely described the technical scheme in the embodiment of the present invention, obviously, described embodiment is only the present invention's part embodiment, instead of whole embodiments.Based on the embodiment in the present invention, those of ordinary skill in the art, not making the every other embodiment obtained under creative work prerequisite, belong to the scope of protection of the invention.
It should be noted that, the term used in embodiments of the present invention is only for the object describing specific embodiment, and not intended to be limiting the present invention." one ", " described " and " being somebody's turn to do " of the singulative used in the embodiment of the present invention and appended claims is also intended to comprise most form, unless context clearly represents other implications.It is also understood that term "and/or" used herein refer to and comprise one or more project of listing be associated any or all may combine.
See Fig. 2, be the schematic flow sheet of the method for the data summarization that the embodiment of the present invention provides, the method comprises:
Step S201: obtain each identification information in tables of data with identical upper level identification information, described tables of data stores the identification information of each grade and the data record of correspondence thereof;
Particularly, in tables of data, storage has many identification informations, each identification information is all to having fixing grade and the superior and the subordinate's identification information, each identification information is a corresponding data record also, identification information is usually according to " mechanism ", " natural subject ", types such as " responsibility centers " is named, such as, three identification informations are named: Guangdong Province according to " mechanism ", Shenzhen, Dongguan City, three identification informations are named: 10002 according to " natural subject ", 10225, 10223, the grade that each identification information is corresponding and the superior and the subordinate pre-set, such as, the grade of " Shenzhen " is the fourth stage, higher level is " Guangdong Province ", subordinate has " Futian District ", " Nanshan District " etc., concrete grade and relation are as the criterion to preset, when processing the identification information in tables of data, can be artificial or operational order designation data handling implement by pre-setting, filter out in tables of data with each identification information that a certain identification information is upper level identification information, such as, in the hierarchical relationship preset, the higher level of " Shenzhen " and " Dongguan City " is " Guangdong Province ", so when the identification information that acquisition is upper level identification information with " Guangdong Province ", can be filtered out " Shenzhen " and " Dongguan City " by pre-conditioned.
Will be understood that, identification information can be simple with the name of dimension, also can name according to the combination of multiple dimension, in a lot of complicated tables of data, usual meeting various dimensions some data are added up, such as, article one, the dimension that data record is corresponding comprises: natural subject, responsibility, mechanism, the large class of client, general ledger source and group internal contact etc., the data category that can add up as required carries out combining (one or more) to select corresponding dimension, forms identification information; The above-mentioned dimension mentioned is only limitted to citing, is not used in the scope of restriction identification information.
Further, data record can comprise data, also can comprise many data, determines by pre-setting.
Step S202: the data record corresponding to each identification information described in acquisition gathers, and obtains combined data record;
Particularly, after filtering out each identification information with identical upper level identification information, according to the corresponding relation of identification information and data record, obtain the data record that each identification information is corresponding, then these data records are gathered, obtain a combined data record.
Will be understood that, in time comprising data in data record, aggregation process is added up at data in each data record, obtains the data record that comprises data; When comprising multiple data in data record, aggregation process can be a certain class data correspondence in each data record is added obtain one comprise multiple data but wherein have data be cumulative come data record, also can be obtain one and comprise multiple data by cumulative for n class data correspondence in each data record but wherein have n data to be add up the data record of coming.
Further, " adding up " that above-mentioned aggregation process is mentioned is the one in compute mode, if change other compute modes such as work " is multiplied ", as long as can reach lumped effect, also belongs to the scope of this programme protection.
Step S203: obtain data record corresponding to described upper level identification information according to described combined data.
Particularly, the combined data record obtained with step S202 obtains data record corresponding to upper level identification information by assignment, covering, computing or other mode.
Will be understood that, the process being obtained data record corresponding to upper level identification information by combined data record can be obtain corresponding data in data record corresponding in upper level identification information by the data of in combined data record, also can be obtain corresponding multiple data in data record corresponding to upper level identification information by the multiple data in combined data record, concrete grammar be determined by pre-setting of tables of data.
Further, the schematic diagram of the method for the data summarization of another embodiment provided by the invention as shown in Figure 3, comprising:
Step S301: obtain each identification information in tables of data with identical upper level identification information, described tables of data stores the identification information of each grade and the data record of correspondence thereof;
Particularly, step S301 can be corresponding to step S201 in Fig. 2 embodiment;
Step S302: the first data in data record corresponding for each identification information described in described acquisition are added up, obtains combined data record;
Particularly, after filtering out each identification information with identical upper level identification information, according to the corresponding relation of identification information and data record, obtain the first data in data record corresponding to each identification information, then the first all data are added up, obtain a cumulative data, the type of cumulative data is consistent with the data type of cumulative front each first data, citing, in bank data statistics, the type of the first data in the embodiment of the present invention in tables of data is " ending balance ", the data type obtained after so gathering is still " ending balance ", apparently, these first data are not limited to " ending balance ", here just one of them citing.
Step S303: by the data assignment in the described combined data record that obtains after cumulative to the first data in data record corresponding to described upper level identification information;
Particularly, the first data in data record corresponding to upper level identification information are covered by being gathered the cumulative data that obtains by step S302.
Will be understood that, in the data record that upper level identification information is corresponding except comprising the first data, can also comprise other data, although these data are not directly obtained by cumulative data, first data that may indirectly be obtained by cumulative data obtain through some computings.
Step S304: according to described identification information himself upper level identification information corresponding, obtain the 3rd identification information in described first identification information common higher level's identification information corresponding with described second identification information, described 3rd identification information is first degree identification information in common higher level's identification information that described first identification information is corresponding with described second identification information;
Particularly, each identification information is all corresponding its upper level identification information (this relation can preset), that is, after an identification information is determined, just can obtain its upper level identification information, when a certain bar identification information in identification information becomes the second identification information from the first identification information, according to each identification information all its upper level identification informations of correspondence, can up resolve layer by layer, and then obtain the hierarchical organization of all higher level's identification informations corresponding to the first identification information, in like manner obtain the hierarchical organization of all higher level's identification informations corresponding to the second identification information, two the hierarchical organization contrasts obtained can be drawn the identification information all comprised in two hierarchical organizations, again identification information minimum for the identification information middle grade all comprised is screened, as the 3rd identification information.
Will be understood that, after the first identification information becomes the second identification information, the first identification information is not just present in tables of data, and the data record that the data record that the second identification information is corresponding is corresponding with the first identification information before change is identical.
Further, first identification information becomes the second identification information and can occur in step 301, step 302 and step 303 before or after any step, and namely no matter when identification information there occurs change can obtain the 3rd identification information according to this change.
Preferably, in the present embodiment, the first identification information becomes the second identification information generation after step 303.
Again further, the method obtaining the 3rd identification information can also be, from the identification information that two hierarchical organization middle grades are minimum, judge that whether this flag information is common higher level's identification information of the first identification information and the second identification information, if not, then again judge toward upper level, by that analogy, until find out common higher level's identification information of two identification informations, and using this identification information as the 3rd identification information, the acquisition methods of above 3rd identification information is only limitted to citing, does not get rid of additive method in addition.
Step S305: the first data in data record corresponding for upper level identification information corresponding for described first identification information are deducted the data that the first data in data record corresponding to described first identification information obtain, covers the first data in data record corresponding to upper level identification information corresponding to described first identification information;
Particularly, for convenience of description, still illustrate with bank data, data in the data record making the first identification information corresponding are: ending balance (the first data): 50, data in the upper level identification information corresponding data record that first identification information is corresponding are: ending balance (the first data): 200, deduct 50 by 200 and equal 150, now, the data in the data record that the upper level identification information that the first identification information is corresponding is corresponding become 150 from 200.
Step S306: the first data in data record corresponding for upper level identification information corresponding for described second identification information are added the data that the first data in the data record that described second identification information is corresponding obtain, covers the first data in data record corresponding to upper level identification information corresponding to described second identification information;
Particularly, for convenience of description, still illustrate with bank data, data in the data record making the second identification information corresponding are: ending balance (the first data): 50, data in the data record that the upper level identification information that second identification information is corresponding is corresponding are: ending balance (the first data): 220, add that by 220 50 equal 270, now, the data in the data record that the upper level identification information that the second identification information is corresponding is corresponding become 270 from 220.
Step S307: the first data in data record corresponding for described upper level identification information are deducted the 3rd data in the data record that described in data cover that the second data in data record corresponding to described upper level identification information obtain, upper level identification information is corresponding;
Particularly, after the first data are calculated, also to calculate the 3rd data by the first data, in data record, second data are known quantity, and the second data can not change because next stage identification information changes, the method calculating the 3rd data is: the 3rd data equal the first data and deduct the second data, still for bank data, first data are " ending balance ", second data are " beginning balance " and the 3rd data is " amount ", namely " amount " can deduct " beginning balance " by " ending balance " and obtain, wherein " ending balance " for subordinate's identification information change after recalculate, " beginning balance " for subordinate's identification information change before " beginning balance ".
It should be noted that, when identification information becomes the second identification information from the first identification information, the data record causing the first data to change because of this change all will recalculate, concrete, will recalculate the first data and the 3rd data.
Step S308: the second data in data record corresponding for described first identification information are multiplied by-1, and the data assignment obtained being multiplied gives the 4th data in the data record that upper level identification information corresponding to described first identification information is corresponding; The 4th data in the data record that upper level identification information corresponding to described second identification information is corresponding are given by the second data assignment in data record corresponding for described second identification information.
Particularly, the data record that the upper level identification information that described first identification information is corresponding is corresponding and data record corresponding to upper level identification information corresponding to described second identification information all comprise the 4th data.4th data are used to the data of another type of difference first data, the second data and the 3rd data, such as, in the data of bank, 4th data can classify as " adjustment amount " by the embodiment of the present invention, 4th data are not that each article of data record all has, the data record that the upper level identification information that identification information before and after only changing is corresponding is corresponding just has, and subordinate's identification information that it may be used for embodying this higher level's identification information there occurs adjustment.The second data in data record corresponding for first identification information are multiplied by-1, and the data assignment obtained being multiplied gives the 4th data in the data record that upper level identification information corresponding to the first identification information is corresponding, illustrate according to above-mentioned bank data, " beginning balance (the second data) " in the data record that first identification information is corresponding are " adjustment amount (the 4th data) " in the data record that upper level identification information that the 100, first identification information is corresponding is corresponding is that 100 × (-1) equals-100, the 4th data in the data record that upper level identification information corresponding to described second identification information is corresponding are given by the second data assignment in data record corresponding for described second identification information, illustrate according to above-mentioned bank data, " beginning balance (the second data) " in the data record that second identification information is corresponding are 100 (the data record that the data record that the second identification information is corresponding is corresponding with the first identification information is identical), " adjustment amount (the 4th data) " in the data record that the upper level identification information that second identification information is corresponding is corresponding is 100.
Further, the schematic diagram of the method for the data summarization of another embodiment provided by the invention as shown in Figure 4, comprising:
Step S401: obtain each identification information in tables of data with identical upper level identification information, described tables of data stores the identification information of each grade and the data record of correspondence thereof;
Step S402: the first data in data record corresponding for each identification information described in described acquisition are added up, obtains combined data record;
Step S403: by the data assignment in the described combined data record that obtains after cumulative to the first data in data record corresponding to described upper level identification information;
Step S404: according to described identification information himself upper level identification information corresponding, obtain the 3rd identification information in described first identification information common higher level's identification information corresponding with described second identification information, described 3rd identification information is first degree identification information in common higher level's identification information that described first identification information is corresponding with described second identification information;
Step S405: the first data in data record corresponding for upper level identification information corresponding for described first identification information are deducted the data that the first data in data record corresponding to described first identification information obtain, covers the first data in data record corresponding to upper level identification information corresponding to described first identification information;
Step S406: the first data in data record corresponding for upper level identification information corresponding for described second identification information are added the data that the first data in the data record that described second identification information is corresponding obtain, covers the first data in data record corresponding to upper level identification information corresponding to described second identification information;
Step S407: the first data in data record corresponding for described upper level identification information are deducted the 3rd data in the data record that described in data cover that the second data in data record corresponding to described upper level identification information obtain, upper level identification information is corresponding;
Step S408: the second data in data record corresponding for described first identification information are multiplied by-1, and the data assignment obtained being multiplied gives the 4th data in the data record that upper level identification information corresponding to described first identification information is corresponding; The 4th data in the data record that upper level identification information corresponding to described second identification information is corresponding are given by the second data assignment in data record corresponding for described second identification information;
The specific implementation of step S401 to step S408 can step S301 in corresponding reference example to step S308, repeat no more here.
Step S409: according to described identification information himself upper level identification information corresponding, obtaining take the 4th identification information as each article of identification information of common upper level identification information;
Particularly, 4th identification information is any one article of identification information determined, when needing to review the source of data record corresponding to the 4th identification information or composition information, first filtering out with the 4th identification information is each article of identification information of common upper level identification information.
It should be noted that, 4th identification information is any one article of identification information in tables of data, can be determined by directly selected, search or other modes, then perform the operation filtering out with the 4th identification information each article of identification information being common upper level identification information.
Step S410: each self-corresponding data record of each article of identification information described in showing with the 4th identification information being common upper level identification information.
Particularly, by the mode of a form or image or pop-up window etc., show with the 4th identification information to be each self-corresponding data record of each article of identification information of common upper level identification information.
It should be noted that, to the displaying of data record, can be show the class data in this data record, also can multi-class data in display data record, for bank data, only can show " amount ", also can show " amount ", " beginning balance " and " ending balance " simultaneously, concrete data type of showing is determined by pre-setting of tables of data.
Further, when there are the 4th data in the data record that the 4th identification information is corresponding, when showing with the 4th identification information the 3rd data in each self-corresponding data record of each article of identification information being common upper level identification information, the 4th data in the data record that displaying the 4th identification information is corresponding can also be selected, same for bank data, when showing with " amount (the 3rd data) " in each self-corresponding data record of all subordinates identification information of the 4th identification information, together can show " adjustment amount (the 4th data) " in the data record that the 4th identification information is corresponding, identification information structure can be got information about very much from " adjustment amount (the 4th data) " shown and there occurs change, generally speaking, the mode of data record display is determined by pre-setting.
Again further, to the data record displayed, can do and review further, and then obtain source and the composition situation of the data record displayed, so analogize, can down review step by step, trace back to first degree data always, in addition, no matter whether identification information structure changes, and can review data, just when identification information change review again time, can trace back to " adjustment amount ", and when identification information does not change, then can not trace back to " adjustment amount ".
Conveniently understand, with bank data for exemplifying an embody rule example, this example comprises the process of data summarization, identification information changes and cause part to gather the process that target gathers again and the process of reviewing combined data; As shown in Figure 5, gather subject (beginning balance, amount, ending balance) identification information (the second data in corresponding claims, 3rd data, first data), gather subject (beginning balance, amount, ending balance, adjustment amount) identification information (the second data in corresponding claims, 3rd data, first data, the 4th data), the section's object upper level that gathers before and after only changing gathers subject and just has " adjustment amount ".
Aggregation process: adopt and gather step by step, namely subject D is gathered by gathering subject G, H, I gathers, particularly, gather " ending balance " in subject D by gathering subject G, " ending balance " in H and I adds up, " beginning balance " gathered in subject D equals " ending balance " that is gathered subject D accounting period, " amount " equals " ending balance " and deducts " beginning balance ", gather subject B to gather by gathering subject D and E, gather subject A to gather by gathering subject B and C, by that analogy, up gather step by step from the bottom, finally can draw and allly gather section's object combined data.
Structural adjustment process: change when gathering subject I, and cause gathering subject I by the subordinate gathering subject D gather subject become the subordinate gathering subject F gather subject I' time, first find the common higher level of I and I' gather subject middle grade minimum gather subject, namely subject A is gathered, then the subject (C and F) that gathers gathered between subject (B and D) and I' and A between I and A is gathered again, wherein special a little to gathering again gathering of subject D and F, when D is gathered again, " beginning balance " in D remains unchanged, " ending balance " of G and H is added the data that obtain " ending balance " as D, " ending balance " of D is deducted arriving new " amount " of " beginning balance ", then data " adjustment amount " are added to gathering subject D, " beginning balance " that " adjustment amount " equals I is multiplied by-1, " adjustment amount " should add that " amount " that " amount " of G adds H just equaled " amount " of D, " beginning balance " of I has been regarded a part for " amount " of D by whole process, ensure that " beginning balance " of D is constant, even if therefore gather subject structure to there occurs change, " beginning balance " of current accounting period still maintained continuity with " ending balance " of a upper accounting period, when F is gathered again, " beginning balance " in F remains unchanged, " ending balance " of M and N is added the data that obtain " ending balance " as F, " ending balance " of F is deducted arriving new " amount " of " beginning balance ", then data " adjustment amount " are added to gathering subject F, " adjustment amount " equals " beginning balance " of I', " adjustment amount " should add that " amount " that " amount " of M adds N just equaled " amount " of F, " beginning balance " of I' has been regarded a part for " amount " of F by whole process, ensure that " beginning balance " of F is constant, even if therefore gather subject structure to there occurs change, " beginning balance " of current accounting period still maintained continuity with " ending balance " of a upper accounting period.
For gathering subject B and gathering recalculating of subject C, calculate according to normal computation rule, namely " beginning balance " of subject B remains unchanged, " ending balance " equals " ending balance " addition that subordinate gathers subject D and E, and " amount " equals " ending balance " and deduct " beginning balance "; " beginning balance " of subject C remains unchanged, and " ending balance " equals " ending balance " that subordinate gathers subject F, and " amount " equals " ending balance " and deduct " beginning balance ".
Combined data trace back process: to when gathering that in subject A, " amount " reviews, double-click the data record of A, eject " amount " two data that a window display gathers subject B and C, further " amount " of B is reviewed, eject " amount " two data that a window display gathers subject D and E, further " amount " of D is reviewed again, eject a window display and gather " amount " of subject G and E and " adjustment amount " three data of D, by that analogy, can review any section's object " amount " that gathers.
The reviewing to change and do reviewing other data " amount " mentioned in citing, display mode can also be other modes such as form, image except passing through " pop-up window ", " double-click " wherein mentioned can also be other modes such as to point to, click, gathering before subject reviews to a certain, can by manually to search or the mode such as search obtains this and a certainly gathers subject.
It should be noted that, above-mentioned application scenarios is only limitted to citing, is not used in restriction range of application of the present invention.
For the ease of implementing the such scheme of the embodiment of the present invention better, the present invention is the corresponding device providing a kind of data summarization also, the structural representation of the device of the data summarization that the embodiment of the present invention as shown in Figure 6 provides, the device 60 of data summarization can comprise: the first acquiring unit 601, first collection unit 602 and the first computing unit 603, wherein
First acquiring unit 601 has each identification information of identical upper level identification information for obtaining in tables of data, tables of data stores the identification information of each grade and the data record of correspondence thereof;
First collection unit 602 gathers for the data record corresponding to each identification information of the first acquiring unit acquisition, obtains combined data record;
First computing unit 603 obtains data record corresponding to upper level identification information for the combined data record obtained according to the first collection unit.
Will be understood that, in the device 60 of data summarization, the function of modules may correspond to the embodiment with reference to Fig. 2 embodiment in said method embodiment, repeats no more here.
Further, the structural representation of the device 60 of the data summarization of another embodiment provided by the invention as shown in Figure 7, the device 60 of data summarization is except comprising the first acquiring unit 601, first collection unit 602 and the first computing unit 603, can also comprise: second acquisition unit 604, second computing unit 605 and the 3rd computing unit 606, wherein
Second acquisition unit 604 is for according to identification information himself upper level identification information corresponding, obtain the 3rd identification information in the first identification information common higher level's identification information corresponding with the second identification information, the 3rd identification information is first degree identification information in common higher level's identification information that the first identification information is corresponding with the second identification information;
Second computing unit 605 recalculates lower than the data record that higher level's identification information that the first identification information of the 3rd identification information is corresponding is corresponding for In Grade;
3rd computing unit 606 recalculates lower than the data record that higher level's identification information that the second identification information of the 3rd identification information is corresponding is corresponding for In Grade.
Will be understood that, in the device 60 of data summarization, the function of modules may correspond to the embodiment with reference to Fig. 3 embodiment in said method embodiment, repeats no more here.
Further, the structural representation of the device of the data summarization of another embodiment provided by the invention as shown in Figure 8, the device 60 of data summarization is except comprising the first acquiring unit 601, first collection unit 602, first computing unit 603 and second acquisition unit 604, can also comprise: the second computing unit 605, the 3rd computing unit 606, the 5th computing unit 607, the 6th computing unit 608 and the 7th computing unit 609, wherein
The data that second computing unit 605 obtains for the first data in data record corresponding for upper level identification information corresponding for the first identification information being deducted the first data in data record corresponding to the first identification information, cover the first data in data record corresponding to upper level identification information corresponding to the first identification information;
3rd computing unit 606, for the first data in data record corresponding for upper level identification information corresponding for the second identification information being added the data that the first data in the data record that the second identification information is corresponding obtain, covers the first data in data record corresponding to upper level identification information corresponding to the second identification information;
5th computing unit 607 is for the 3rd data in data record corresponding to the data cover upper level identification information that the first data in data record corresponding for upper level identification information deducted the second data in data record corresponding to upper level identification information and obtain.
6th computing unit 608 is for being multiplied by-1 by the second data in data record corresponding for the first identification information, and the data assignment obtained being multiplied gives the 4th data in the data record that upper level identification information corresponding to the first identification information is corresponding;
7th computing unit 609 is for giving the 4th data in the data record that upper level identification information corresponding to the second identification information is corresponding by the second data assignment in data record corresponding for the second identification information.
Will be understood that, in the device 60 of data summarization, the function of modules may correspond to the embodiment with reference to Fig. 3 embodiment in said method embodiment, repeats no more here.
Further, the structural representation of the device of the data summarization of another embodiment provided by the invention as shown in Figure 9, the device 60 of data summarization is except comprising the first acquiring unit 601, first collection unit 602, first computing unit 603, second acquisition unit 604, second computing unit 605, the 3rd computing unit 606, the 5th computing unit 607, the 6th computing unit 608 and the 7th computing unit 609, can also comprise: the 3rd acquiring unit 610 and display unit 611, wherein
3rd acquiring unit 610 is for according to identification information himself upper level identification information corresponding, and obtaining take the 4th identification information as each article of identification information of common upper level identification information;
Display unit 611 take the 4th identification information as each self-corresponding data record of each article of identification information of common upper level identification information for what show that the 3rd acquiring unit obtains.
Will be understood that, in the device 60 of data summarization, the function of modules may correspond to the embodiment with reference to Fig. 4 embodiment in said method embodiment, repeats no more here.
By implementing the embodiment of the present invention, when to obtain a certain gather target gather value time, directly sum up to obtain to these next stage data gathering target and gather value, and do not need to obtain huge data from bottom and sum up, substantially reduce the calculating pressure gathering instrument, to solve in prior art when the hierarchical structure of summarized results is complicated, gather the problem that instrument can bear huge calculating pressure; After identification information structure changes, only the data corresponding to local identification information adjust instead of adjust all data, and the step recalculated greatly simplified, reduces the calculating pressure gathering instrument to a certain extent; In addition, can also review the source of combined data as required, particularly when identification information changes and causes partial data to recalculate, can by reviewing the data of searching identification information and the correspondence thereof changed.
One of ordinary skill in the art will appreciate that all or part of flow process realized in above-described embodiment method, that the hardware that can carry out instruction relevant by computer program has come, described program can be stored in a computer read/write memory medium, this program, when performing, can comprise the flow process of the embodiment as above-mentioned each side method.Wherein, described storage medium can be magnetic disc, CD, read-only store-memory body (Read-Only Memory, ROM) or random access memory (Random Access Memory is called for short RAM) etc.
A kind of service code disposal route provided the embodiment of the present invention above and device are described in detail, apply specific case herein to set forth principle of the present invention and embodiment, the explanation of above embodiment just understands method of the present invention and core concept thereof for helping; Meanwhile, for one of ordinary skill in the art, according to thought of the present invention, all will change in specific embodiments and applications, in sum, this description should not be construed as limitation of the present invention.
Claims (20)
1. a method for data summarization, is characterized in that, comprising:
Obtain each identification information in tables of data with identical upper level identification information, described tables of data stores the identification information of each grade and the data record of correspondence thereof;
The data record corresponding to each identification information described in acquisition gathers, and obtains combined data record;
Data record corresponding to described upper level identification information is obtained according to described combined data record.
2. method according to claim 1, is characterized in that, described data record comprises the first data, and the described data record corresponding to each identification information described in acquisition gathers, and obtains combined data record and comprises:
The first data in data record corresponding for each identification information described in described acquisition are added up, obtains combined data record;
The described data record obtaining described upper level identification information corresponding according to described combined data record comprises:
By the data assignment in the described combined data record that obtains after cumulative to the first data in data record corresponding to described upper level identification information.
3. method according to claim 2, is characterized in that, described identification information himself upper level identification information corresponding, and described identification information comprises the first identification information, when described first identification information changes over the second identification information, also comprises:
According to described identification information himself upper level identification information corresponding, obtain the 3rd identification information in described first identification information common higher level's identification information corresponding with described second identification information, described 3rd identification information is first degree identification information in common higher level's identification information that described first identification information is corresponding with described second identification information;
In Grade recalculates lower than the data record that higher level's identification information that described first identification information of described 3rd identification information is corresponding is corresponding;
In Grade recalculates lower than the data record that higher level's identification information that described second identification information of described 3rd identification information is corresponding is corresponding.
4. method according to claim 3, is characterized in that,
Described In Grade recalculates lower than the data record that higher level's identification information that described first identification information of described 3rd identification information is corresponding is corresponding and comprises:
The first data in data record corresponding for upper level identification information corresponding for described first identification information are deducted the data that the first data in data record corresponding to described first identification information obtain, cover the first data in data record corresponding to upper level identification information corresponding to described first identification information;
Described In Grade recalculates lower than the data record that higher level's identification information that described second identification information of described 3rd identification information is corresponding is corresponding and comprises:
The first data in data record corresponding for upper level identification information corresponding for described second identification information are added the data that the first data in the data record that described second identification information is corresponding obtain, cover the first data in data record corresponding to upper level identification information corresponding to described second identification information.
5. method according to claim 2, it is characterized in that, described data record also comprises the second data and the 3rd data, described by the step of the first data in data record corresponding to described upper level identification information for the data assignment in the described combined data record that obtains after cumulative after, also comprise:
The first data in data record corresponding for described upper level identification information are deducted the 3rd data in the data record that described in data cover that the second data in data record corresponding to described upper level identification information obtain, upper level identification information is corresponding.
6. method according to claim 4, it is characterized in that, described data record also comprises the second data and the 3rd data, described, the first data in data record corresponding for upper level identification information corresponding for described second identification information are added the data that the first data in the data record that described second identification information is corresponding obtain, after covering the step of the first data in data record corresponding to upper level identification information corresponding to described second identification information, also comprise:
The first data in data record corresponding for described upper level identification information are deducted the 3rd data in the data record that described in data cover that the second data in data record corresponding to described upper level identification information obtain, upper level identification information is corresponding.
7. method according to claim 6, it is characterized in that, the data record that the upper level identification information that described first identification information is corresponding is corresponding and data record corresponding to upper level identification information corresponding to described second identification information all comprise the 4th data, also comprise:
The second data in data record corresponding for described first identification information are multiplied by-1, and the data assignment obtained being multiplied gives the 4th data in the data record that upper level identification information corresponding to described first identification information is corresponding;
The 4th data in the data record that upper level identification information corresponding to described second identification information is corresponding are given by the second data assignment in data record corresponding for described second identification information.
8. the method according to claim 5 or 6 or 7, is characterized in that, described obtain data record corresponding to described upper level identification information according to described combined data after, also comprise:
According to described identification information himself upper level identification information corresponding, obtaining take the 4th identification information as each article of identification information of common upper level identification information;
Be each self-corresponding data record of each article of identification information of common upper level identification information with the 4th identification information described in showing.
9. method according to claim 8, is characterized in that, each self-corresponding data record of each article of identification information being common upper level identification information with the 4th identification information described in described displaying comprises:
With the 3rd data that the 4th identification information is in each self-corresponding data record of each article of identification information of common upper level identification information described in showing.
10. method according to claim 9, it is characterized in that, when the data record that described 4th identification information is corresponding comprises described 4th data, while described in described displaying with the 4th identification information being the 3rd data in each self-corresponding data record of each article of identification information of common upper level identification information, show the 4th data that the data record that described 4th identification information is corresponding comprises.
The device of 11. 1 kinds of data summarization, is characterized in that, comprising:
First acquiring unit, for obtaining in tables of data each identification information with identical upper level identification information, described tables of data stores the identification information of each grade and the data record of correspondence thereof;
First collection unit, gathers for the data record corresponding to each identification information described in described first acquiring unit acquisition, obtains combined data record;
First computing unit, the described combined data record for obtaining according to described first collection unit obtains data record corresponding to described upper level identification information.
12. devices according to claim 11, it is characterized in that, described data record comprises the first data, described first collection unit adds up specifically for the first data in data record corresponding to each identification information described in obtaining described first acquiring unit, obtains combined data record;
Described first computing unit specifically for the data assignment in the described combined data record that obtains after described first collection unit is added up to the first data in data record corresponding to described upper level identification information.
13. devices according to claim 12, is characterized in that, described identification information himself upper level identification information corresponding; Described identification information comprises the first identification information, when described first identification information changes over the second identification information, also comprises:
Second acquisition unit, for according to described identification information himself upper level identification information corresponding, obtain the 3rd identification information in described first identification information common higher level's identification information corresponding with described second identification information, described 3rd identification information is first degree identification information in common higher level's identification information that described first identification information is corresponding with described second identification information;
Second computing unit, recalculates lower than the data record that higher level's identification information that described first identification information of described 3rd identification information is corresponding is corresponding for In Grade;
3rd computing unit, recalculates lower than the data record that higher level's identification information that described second identification information of described 3rd identification information is corresponding is corresponding for In Grade.
14. want the device described in 13 according to right, it is characterized in that,
The data that described second computing unit obtains specifically for the first data in data record corresponding for upper level identification information corresponding for described first identification information being deducted the first data in data record corresponding to described first identification information, cover the first data in data record corresponding to upper level identification information corresponding to described first identification information;
Described 3rd computing unit, specifically for the first data in data record corresponding for upper level identification information corresponding for described second identification information being added the data that the first data in the data record that described second identification information is corresponding obtain, covers the first data in data record corresponding to upper level identification information corresponding to described second identification information.
15. devices according to claim 12, is characterized in that, also comprise:
4th computing unit, for deducting the 3rd data in data record that described in data cover that the second data in data record corresponding to described upper level identification information obtain, upper level identification information is corresponding by the first data in data record corresponding for described upper level identification information.
16. devices according to claim 14, is characterized in that, also comprise:
5th computing unit, for when the first identification information becomes the second identification information, the first data in data record corresponding for described upper level identification information are deducted the 3rd data in the data record that described in data cover that the second data in data record corresponding to described upper level identification information obtain, upper level identification information is corresponding.
17. devices according to claim 16, it is characterized in that, the data record that the upper level identification information that described first identification information is corresponding is corresponding and data record corresponding to upper level identification information corresponding to described second identification information all comprise the 4th data, also comprise:
6th computing unit, for the second data in data record corresponding for described first identification information are multiplied by-1, and the data assignment obtained being multiplied gives the 4th data in the data record that upper level identification information corresponding to described first identification information is corresponding;
7th computing unit, for giving the 4th data in the data record that upper level identification information corresponding to described second identification information is corresponding by the second data assignment in data record corresponding for described second identification information.
18. devices according to claim 15 or 16 or 17, is characterized in that, also comprise:
3rd acquiring unit, for according to described identification information himself upper level identification information corresponding, obtaining take the 4th identification information as each article of identification information of common upper level identification information;
Display unit take described 4th identification information as each self-corresponding data record of each article of identification information of common upper level identification information for what show that described 3rd acquiring unit obtains.
19. devices according to claim 18, is characterized in that,
Described display unit is the 3rd data in each self-corresponding data record of each article of identification information of common upper level identification information specifically for what show that described 3rd acquiring unit obtains with described 4th identification information.
20. devices according to claim 19, is characterized in that, when the data record that described 4th identification information is corresponding comprises described 4th data,
While what described display unit showed that described 3rd acquiring unit obtains be the 3rd data in each self-corresponding data record of each article of identification information of common upper level identification information with described 4th identification information, show the 4th data that the data record that described 4th identification information is corresponding comprises.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201410593735.XA CN104408057B (en) | 2014-10-29 | 2014-10-29 | A kind of method and device of data summarization |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201410593735.XA CN104408057B (en) | 2014-10-29 | 2014-10-29 | A kind of method and device of data summarization |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN104408057A true CN104408057A (en) | 2015-03-11 |
| CN104408057B CN104408057B (en) | 2019-01-29 |
Family
ID=52645689
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201410593735.XA Active CN104408057B (en) | 2014-10-29 | 2014-10-29 | A kind of method and device of data summarization |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN104408057B (en) |
Cited By (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN104917837A (en) * | 2015-06-11 | 2015-09-16 | 百度在线网络技术（北京）有限公司 | Message processing method and system |
| CN109886658A (en) * | 2019-03-13 | 2019-06-14 | 北京睿勤永尚建设顾问有限公司 | A kind of Area summing method general for architectural design ditch and corresponding communication method |
| CN112364090A (en) * | 2020-11-03 | 2021-02-12 | 杭州数梦工场科技有限公司 | Data attribute display method and device and electronic equipment |
| CN113628053A (en) * | 2021-09-03 | 2021-11-09 | 中电金信软件有限公司 | Transaction balance calculation method and device |
Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102270226A (en) * | 2011-06-28 | 2011-12-07 | 用友软件股份有限公司 | Budget data summarization system |
| CN102436475A (en) * | 2011-09-29 | 2012-05-02 | 用友软件股份有限公司 | Data table summarizing device and data table summarizing method |
| CN102867065A (en) * | 2012-09-28 | 2013-01-09 | 用友软件股份有限公司 | Data summarization device and method based on relational database |
| CN104021156A (en) * | 2014-05-22 | 2014-09-03 | 武汉天量数据技术有限公司 | Method for rapidly collecting multi-layer fact data based on SQL statements |
-
2014
- 2014-10-29 CN CN201410593735.XA patent/CN104408057B/en active Active
Patent Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102270226A (en) * | 2011-06-28 | 2011-12-07 | 用友软件股份有限公司 | Budget data summarization system |
| CN102436475A (en) * | 2011-09-29 | 2012-05-02 | 用友软件股份有限公司 | Data table summarizing device and data table summarizing method |
| CN102867065A (en) * | 2012-09-28 | 2013-01-09 | 用友软件股份有限公司 | Data summarization device and method based on relational database |
| CN104021156A (en) * | 2014-05-22 | 2014-09-03 | 武汉天量数据技术有限公司 | Method for rapidly collecting multi-layer fact data based on SQL statements |
Non-Patent Citations (1)
| Title |
|---|
| 孙翀 等: ""基于层次空间聚类的表语义汇总算法"", 《计算机科学》 * |
Cited By (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN104917837A (en) * | 2015-06-11 | 2015-09-16 | 百度在线网络技术（北京）有限公司 | Message processing method and system |
| CN104917837B (en) * | 2015-06-11 | 2018-05-04 | 百度在线网络技术（北京）有限公司 | A kind of method and system for Message Processing |
| CN109886658A (en) * | 2019-03-13 | 2019-06-14 | 北京睿勤永尚建设顾问有限公司 | A kind of Area summing method general for architectural design ditch and corresponding communication method |
| CN112364090A (en) * | 2020-11-03 | 2021-02-12 | 杭州数梦工场科技有限公司 | Data attribute display method and device and electronic equipment |
| CN113628053A (en) * | 2021-09-03 | 2021-11-09 | 中电金信软件有限公司 | Transaction balance calculation method and device |
Also Published As
| Publication number | Publication date |
|---|---|
| CN104408057B (en) | 2019-01-29 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| Maron et al. | The many meanings of no net loss in environmental policy | |
| US20180330328A1 (en) | Interactive Organization Visualization Tools For Use in Analyzing Multivariate Human-Resource Data of Organizations | |
| CN110377667A (en) | It is associated with map methods of exhibiting, device, computer equipment and storage medium | |
| US20120023449A1 (en) | System and method for an interactive filter | |
| US20060200372A1 (en) | Method and system for generating a timeline associated with a project schedule | |
| CN104503957B (en) | A kind of formula graphic automatic generation method and device | |
| CN104408057A (en) | Data summarization method and device | |
| EP2266056A1 (en) | Dynamic formulas for spreadsheet cells | |
| CN106445931A (en) | Database node association relationship display method and apparatus | |
| Strange et al. | Tracking underreported financial flows (TUFF) methodology, Version 1.3 | |
| CN108805422A (en) | A kind of data assessment model training systems, data assessment platform and method | |
| US9026466B2 (en) | Financial audit scoping workbench | |
| CN107784035A (en) | Assessment system, the method and apparatus of the node of funnel model | |
| CN105528447A (en) | Method for rejecting and summarizing specific data layer by layer simultaneously | |
| CN115840567A (en) | Application editing method and related equipment | |
| CN108089858B (en) | Method and device for creating visual interface | |
| US20150269281A1 (en) | Inferred operations for data analysis | |
| CN105335886A (en) | Method and device for processing financial data | |
| US20140192082A1 (en) | Methods and systems for generating an aggregated data visualization | |
| CN104050206A (en) | Material bill rapid exporting method and system thereof | |
| US7512556B2 (en) | System and method for evaluation of simulated hedging relationship assignments | |
| CN105608151A (en) | Financial statement analysis device and method | |
| US9064245B2 (en) | Generating a calendar graphical visualization including pixels representing data records containing user feedback | |
| CN102779171B (en) | Evaluating and presenting method and device of report data | |
| CN108279962A (en) | A kind of method and device creating visualization data display interface |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |