CN104408057B - A kind of method and device of data summarization - Google Patents
A kind of method and device of data summarization Download PDFInfo
- Publication number
- CN104408057B CN104408057B CN201410593735.XA CN201410593735A CN104408057B CN 104408057 B CN104408057 B CN 104408057B CN 201410593735 A CN201410593735 A CN 201410593735A CN 104408057 B CN104408057 B CN 104408057B
- Authority
- CN
- China
- Prior art keywords
- data
- identification information
- information
- data record
- upper level
- 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.)
- Active
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)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
A kind of method and device of data summarization, this method comprises: obtain tables of data in identical upper level identification information each identification information, the tables of data be stored with each grade identification information and its corresponding data record；The corresponding data record of each identification information of acquisition is summarized, obtains summarizing data record；The corresponding data record of the upper level identification information is obtained according to the data record that summarizes.By implementing the embodiment of the present invention, when to obtain a certain aggregate value for summarizing target, directly the next stage data for summarizing target are summed up can be obtained and summarize data, summed up without obtaining huge data from bottom, substantially reduces the calculating pressure for summarizing tool.
Description
Technical field
The present invention relates to field of computer technology more particularly to a kind of method and devices of data summarization.
Background technique
Data summarization has application in all trades and professions, uses especially in banking more frequently, since bank relates to
And data volume it is huge, the hierarchical structure of summarized results is complicated, so requiring to compare to the Method and kit for of processing bank data
Height, the at present method of data summarization commonly used in the sector are as follows: predefine the hierarchical structure of summarized results, each layer
Summarize target comprising several in secondary, from huge bottom data, screening belongs to the bottom data that some summarizes target and carries out
Summarize, obtains the aggregate value for summarizing target.
The shortcomings of the prior art are that illustrating referring to Fig.1: A, B and C are to summarize target, and D, E, F, G, H and I are bottom
Data, B and C belong to junior's data of A, and D, E and F belong to junior's data of B, and G, H and I belong to junior's data of C, then into
When row summarizes, summarizes target B and obtained by D+E+F, summarize target C and obtained by G+H+I, summarize target A and obtained by D+E+F+G+H+I
It arrives, when the hierarchical structure complexity of summarized results, can make to summarize the huge calculating pressure of tool receiving using above-mentioned method of summary
Power even directly results in sometimes and summarizes tool 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 summarizing knot
When the hierarchical structure complexity of fruit, this problem of huge calculating pressure can be born by summarizing tool.
In a first aspect, the embodiment of the invention provides a kind of methods of data summarization, comprising:
Each identification information in tables of data with identical upper level identification information is obtained, the tables of data is stored with respectively
A grade of identification information and its corresponding data record；
The corresponding data record of each identification information of acquisition is summarized, obtains summarizing data record；
The corresponding data record of the upper level identification information is obtained according to the data record that summarizes.
Second aspect, the embodiment of the invention provides a kind of devices of data summarization, comprising:
First acquisition unit, for obtaining each identification information in tables of data with identical upper level identification information,
The tables of data be stored with each grade identification information and its corresponding data record；
First collection unit, the corresponding data of each identification information for being obtained to the first acquisition unit
Record is summarized, and obtains summarizing data record；
First computing unit, for according to first collection unit obtain described in summarize data record obtain it is described
The corresponding data record of level-one identification information.
Target directly is summarized to this when to obtain a certain aggregate value for summarizing target by implementing the embodiment of the present invention
Next stage data sum up and can be obtained aggregate value, summed up without obtaining huge data from bottom, significantly
The calculating pressure for summarizing tool is reduced, solves in the prior art when the hierarchical structure complexity of summarized results, summarizes tool
The problem of bearing huge calculating pressure；After identification information structure changes, only to the corresponding number of local identification information
All data are adjusted according to being adjusted, the step of recalculating is enormously simplified, reduces to a certain extent
Summarize the calculating pressure of tool；Furthermore it is also possible to be traced as needed to the source for summarizing data, especially identifying
When information changes and partial data is caused to recalculate, can be searched by tracing the identification information to change and its
Corresponding data.
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 the flow diagram of the method for the data summarization of the prior art；
Fig. 2 is the flow diagram of the method for data summarization provided in an embodiment of the present invention；
Fig. 3 is the flow diagram of the method for the data summarization of another embodiment provided by the invention；
Fig. 4 is the flow diagram 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 schematic diagram of the device of data summarization provided in an embodiment of the present invention；
Fig. 7 is the structural schematic diagram of the device of the data summarization of another embodiment provided by the invention；
Fig. 8 is the structural schematic diagram of the device of the data summarization of another embodiment provided by the invention；
Fig. 9 is the structural schematic diagram of the device of the data summarization of another embodiment provided by the invention.
Specific embodiment
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.
It should be noted that the term used in embodiments of the present invention is only merely for the mesh of description specific embodiment
, it is not intended to limit the invention." the one of the embodiment of the present invention and singular used in the attached claims
Kind ", " described " and "the" are also intended to including most forms, unless the context clearly indicates other meaning.It is also understood that this
Term "and/or" used herein refers to and includes one or more associated any or all possible group for listing project
It closes.
Referring to fig. 2, be data summarization provided in an embodiment of the present invention method flow diagram, this method comprises:
Step S201: each identification information in tables of data with identical upper level identification information, the data are obtained
Table be stored with each grade identification information and its corresponding data record；
Specifically, storage has an a plurality of identification information in tables of data, each identification information be all corresponding with fixed grade and
The superior and the subordinate's identification information, the also corresponding data record of each identification information, identification information is usually according to " mechanism ", " nature
The types such as subject ", " responsibility center " are named, for example, name three identification informations according to " mechanism ": Guangdong Province, Shenzhen,
Dongguan City names three identification informations according to " natural subject ": 10002,10225,10223, each identification information is corresponding
Grade and the superior and the subordinate all pre-set, for example, the grade of " Shenzhen " is the fourth stage, higher level is " Guangdong Province ", under
Grade has " Futian District ", " Nanshan District " etc., and specific grade and relationship are subject to and are preset, to the identification information in tables of data
When being handled, can be artificial or the operational order designation date handling implement by pre-setting, filter out tables of data
In using a certain identification information as each identification information of upper level identification information, it is " deep for example, in preset hierarchical relationship
The higher level of Zhen Shi " and " Dongguan City " is " Guangdong Province ", then being believed obtaining with the mark that " Guangdong Province " is upper level identification information
When breath, " Shenzhen " and " Dongguan City " can be filtered out by preset condition.
It will be appreciated that identification information can be named with a dimension merely, it can also be according to the combination of multiple dimensions
It names, in many complicated tables of data, it will usually which various dimensions count some data, for example, a data is remembered
Recording corresponding dimension includes: nature subject, responsibility, mechanism, client's major class, general ledger source and group's intrabranch etc., Ke Yigen
It selects corresponding dimension to be combined (one or more) according to the data category counted is needed, constitutes identification information；It is above-mentioned to mention
To dimension be only limitted to illustrate, be not used in limitation identification information range.
Further, data record may include a data, also may include a plurality of data, depending on presetting.
Step S202: the corresponding data record of each identification information of acquisition is summarized, total amount is obtained
According to record；
Specifically, after filtering out each identification information with identical upper level identification information, believed according to mark
Breath and the corresponding relationship of data record obtain the corresponding data record of each identification information, then by these data records into
Row summarizes, and obtains one and summarizes data record.
It will be appreciated that aggregation process is by each data record when in data record including a data
In a data add up, obtain one include a data data record；When in data record include multiple data
When, aggregation process can be by certain a kind of data in each data record it is corresponding be added obtain one comprising multiple data but
It is that wherein there are a data be cumulative data record, is also possible to tire out n class data in each data record are corresponding
Adding to obtain one comprising multiple data but wherein having n data is cumulative data record.
Further, " cumulative " that above-mentioned aggregation process is mentioned is one of operation mode, if changing work " multiplication " etc.
Other operation modes also belong to the range of this programme protection as long as can reach lumped effect.
Step S203: the corresponding data record of the upper level identification information is obtained according to the data that summarize.
Specifically, it is obtained by way of assignment, covering, operation or others by the obtained data record that summarizes of step S202
To the corresponding data record of upper level identification information.
It will be appreciated that the process for obtaining the corresponding data record of upper level identification information by summarizing data record can be with
It is that a corresponding number in corresponding data record is obtained in upper level identification information by the data summarized in data record
According to being also possible to be obtained by the multiple data summarized in data record in the corresponding data record of upper level identification information corresponding
Multiple data, specific method is by depending on the presetting 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, packet
It includes:
Step S301: each identification information in tables of data with identical upper level identification information, the data are obtained
Table be stored with each grade identification information and its corresponding data record；
Specifically, step S301 can be to should refer to step S201 in Fig. 2 embodiment；
Step S302: the first data in the corresponding data record of each identification information of the acquisition are carried out
It is cumulative, it obtains summarizing data record；
Specifically, after filtering out each identification information with identical upper level identification information, believed according to mark
The corresponding relationship of breath and data record obtains the first data in the corresponding data record of each identification information, then by institute
The first data having add up, and obtain a cumulative data, the data of the type of cumulative data and cumulative preceding each first data
Type is consistent, citing, and in bank data statistics, type of first data in tables of data in the embodiment of the present invention is the " phase
Last remaining sum ", then the data type obtained after summarizing is still " ending balance ", it should be apparent that, first data are unlimited
In " ending balance ", only one of citing here.
Step S303: summarize the data in data record described in obtaining after will be cumulative and be assigned to the upper level mark letter
Cease the first data in corresponding data record；
Specifically, by the corresponding data record of the cumulative data summarized by step S302 covering upper level identification information
In the first data.
It will be appreciated that can also be wrapped other than comprising the first data in the corresponding data record of upper level identification information
Containing other data, although these data are not obtained by cumulative data directly, may be obtained indirectly by cumulative data
One data are obtained by some operations.
Step S304: the upper level identification information of its own is corresponded to according to the identification information, obtains the first identifier
Third identification information in information common higher level's identification information corresponding with the second identifier information, the third identification information
For the identification information of lowermost level in the first identifier information common higher level's identification information corresponding with the second identifier information；
Specifically, each identification information has all corresponded to its upper level identification information (relationship can be preset),
That is, after an identification information determines, so that it may obtain its upper level identification information；A certain item in identification information identifies letter
When breath becomes second identifier information from first identifier information, its upper level mark letter is all corresponded to according to each identification information
Breath, can up parse, and then obtain the hierarchical organization of the corresponding all higher level's identification informations of first identifier information, similarly layer by layer
The hierarchical organization of the corresponding all higher level's identification informations of second identifier information is obtained, it can be with by the comparison of two hierarchical organizations of acquisition
It obtains the identification information for all including in two hierarchical organizations, then the minimum identification information of the identification information middle grade for all including is screened
Out, as third identification information.
It will be appreciated that after first identifier information becomes second identifier information, first identifier information in tables of data just not
In the presence of the corresponding data record of second identifier information is identical as the corresponding data record of first identifier information before variation.
Further, first identifier information, which becomes second identifier information, can occur in step 301, step 302 and step
In 303 before or after any one step, i.e., it can be obtained according to the variation regardless of when identification information has occurred variation
Obtain third identification information.
Preferably, in the present embodiment, first identifier information becomes the generation of second identifier information after step 303.
Still further, obtain third identification information method be also possible that it is minimum from two hierarchical organization middle grades
Identification information starts, and judges whether the flag information is that the common higher level of first identifier information and second identifier information identifies letter
Breath, if it is not, then judge again toward upper level, and so on, common higher level's identification information until finding out two identification informations, and
Using the identification information as third identification information, the acquisition methods of the above third identification information are only limitted to illustrate, however not excluded that also
Other methods.
Step S305: by first in the corresponding data record of the corresponding upper level identification information of the first identifier information
Data subtract the data that the first data in the corresponding data record of the first identifier information obtain, to cover first mark
Know the first data in the corresponding data record of the corresponding upper level identification information of information；
Specifically, for convenience of description, it is still illustrated, is enabled in the corresponding data record of first identifier information with bank data
Data are as follows: ending balance (the first data): 50, in first identifier information corresponding upper level identification information corresponding data record
Data are as follows: ending balance (the first data): 200,50 are subtracted by 200 and is equal to 150, at this point, first identifier information corresponding upper one
Data in the corresponding data record of grade identification information become 150 from 200.
Step S306: by first in the corresponding data record of the corresponding upper level identification information of the second identifier information
The data that data are obtained plus the first data in the corresponding data record of the second identifier information, to cover second mark
Know the first data in the corresponding data record of the corresponding upper level identification information of information；
Specifically, for convenience of description, it is still illustrated, is enabled in the corresponding data record of second identifier information with bank data
Data are as follows: ending balance (the first data): 50, in the corresponding data record of the corresponding upper level identification information of second identifier information
Data are as follows: ending balance (the first data): 220, by 220 plus 50 be equal to 270, at this point, on second identifier information is corresponding
Data in the corresponding data record of level-one identification information become 270 from 220.
Step S307: the first data in the corresponding data record of the upper level identification information are subtracted into the upper level
The corresponding data of upper level identification information described in the data cover that the second data in the corresponding data record of identification information obtain
Third data in record；
Specifically, after the first data are calculated, also third data are calculated by the first data, in data record
In, the second data are known quantity, and the second data will not change because of next stage identification information and be changed, and calculate third
The method of data are as follows: third data are equal to the first data and subtract the second data, and still by taking bank data as an example, the first data are
" ending balance ", the second data are " beginning balance " and third data are " amount incurred ", i.e., " amount incurred " can be by " more than the end of term
Volume " subtracts " beginning balance " and obtains, wherein " ending balance " is to recalculate after junior's identification information changes, " the phase
First remaining sum " is " beginning balance " before junior's identification information changes.
It should be noted that being led when identification information becomes second identifier information from first identifier information because of the change
The data record for causing the first data to change will recalculate, specifically, the first data and third data are carried out with weight
It is new to calculate.
Step S308: it by the second data in the corresponding data record of the first identifier information multiplied by -1, and will be multiplied
Obtained data are assigned to the 4th number in the corresponding data record of the corresponding upper level identification information of the first identifier information
According to；By the second data in the corresponding data record of the second identifier information be assigned to the second identifier information it is corresponding on
The 4th data in the corresponding data record of level-one identification information.
Specifically, the corresponding data record of the corresponding upper level identification information of the first identifier information and second mark
Knowing the corresponding data record of the corresponding upper level identification information of information all includes the 4th data.4th data are for distinguishing first
The data of the another seed type of data, the second data and third data, for example, the embodiment of the present invention can in the data of bank
4th data are classified as " adjustment amount incurred ", the 4th data are not that each data record all has, before only changing
The corresponding data record of the corresponding upper level identification information of identification information afterwards just has, it can be used for embodying higher level mark
Junior's identification information of information is adjusted.By the second data in the corresponding data record of first identifier information multiplied by -1,
And the obtained data of being multiplied are assigned in the corresponding data record of the corresponding upper level identification information of first identifier information the
Four data are illustrated according to above-mentioned bank data, " beginning balance (the second number in the corresponding data record of first identifier information
According to) " it is 100, " the adjustment amount incurred the (the 4th in the corresponding data record of the corresponding upper level identification information of first identifier information
Data) " it is that 100 × (- 1) is equal to -100；The second data in the corresponding data record of the second identifier information are assigned to
The 4th data in the corresponding data record of the corresponding upper level identification information of the second identifier information, according to above-mentioned bank's number
According to citing, " beginning balance (the second data) " in the corresponding data record of second identifier information are 100 (second identifier information pair
The data record answered data record corresponding with first identifier information is identical), the corresponding upper level mark of second identifier information
" adjustment amount incurred (the 4th data) " known in the corresponding data record of information 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, packet
It includes:
Step S401: each identification information in tables of data with identical upper level identification information, the data are obtained
Table be stored with each grade identification information and its corresponding data record；
Step S402: the first data in the corresponding data record of each identification information of the acquisition are carried out
It is cumulative, it obtains summarizing data record；
Step S403: summarize the data in data record described in obtaining after will be cumulative and be assigned to the upper level mark letter
Cease the first data in corresponding data record；
Step S404: the upper level identification information of its own is corresponded to according to the identification information, obtains the first identifier
Third identification information in information common higher level's identification information corresponding with the second identifier information, the third identification information
For the identification information of lowermost level in the first identifier information common higher level's identification information corresponding with the second identifier information；
Step S405: by first in the corresponding data record of the corresponding upper level identification information of the first identifier information
Data subtract the data that the first data in the corresponding data record of the first identifier information obtain, to cover first mark
Know the first data in the corresponding data record of the corresponding upper level identification information of information；
Step S406: by first in the corresponding data record of the corresponding upper level identification information of the second identifier information
The data that data are obtained plus the first data in the corresponding data record of the second identifier information, to cover second mark
Know the first data in the corresponding data record of the corresponding upper level identification information of information；
Step S407: the first data in the corresponding data record of the upper level identification information are subtracted into the upper level
The corresponding data of upper level identification information described in the data cover that the second data in the corresponding data record of identification information obtain
Third data in record；
Step S408: it by the second data in the corresponding data record of the first identifier information multiplied by -1, and will be multiplied
Obtained data are assigned to the 4th number in the corresponding data record of the corresponding upper level identification information of the first identifier information
According to；By the second data in the corresponding data record of the second identifier information be assigned to the second identifier information it is corresponding on
The 4th data in the corresponding data record of level-one identification information；
The specific implementation of step S401 to step S408 can correspond to the step S301 in reference implementation example to step
S308, which is not described herein again.
Step S409: corresponding to the upper level identification information of its own according to the identification information, obtains with the 4th mark letter
Breath is each identification information of common upper level identification information；
Specifically, the 4th identification information is any one article of determining identification information, corresponding to the 4th identification information when needing
Data record source or composition information when being traced, filtered out first with the 4th identification information as common upper level mark
Know each identification information of information.
It should be noted that the 4th identification information is any one article of identification information in tables of data, can by it is directly selected,
Search or other modes determine, then execute each mark filtered out with the 4th identification information for common upper level identification information
Know the operation of information.
Step S410: it shows described each for each identification information of common upper level identification information with the 4th identification information
Self-corresponding data record.
Specifically, by way of a table or image or pop-up window etc., displaying is with the 4th identification information
The corresponding data record of each identification information of common upper level identification information.
It should be noted that the displaying to data record, it can be a kind of data shown in the data record, it can also be with
Multi-class data in display data record only can show " amount incurred ", can also show displaying simultaneously by taking bank data as an example
" amount incurred ", " beginning balance " and " ending balance ", the data type specifically shown is by depending on the presetting of tables of data.
Further, it when having four data in the corresponding data record of the 4th identification information, is showing with the 4th
Identification information is the third data in the corresponding data record of each identification information of common upper level identification information
When, it is also an option that show the 4th data in the corresponding data record of the 4th identification information, equally by taking bank data as an example,
It is showing with " amount incurred (the third number in all corresponding data records of junior's identification information of the 4th identification information
According to) " when, " adjustment amount incurred (the 4th data) " that can be presented along in the corresponding data record of the 4th identification information, from exhibition
" adjustment amount incurred (the 4th data) " shown can get information about identification information structure and be changed very much；To sum up,
Depending on the mode that data record is shown is by presetting.
Still further, the data record shown can be done and further be traced, and then shown
The source of data record and composition situation, so analogize, can be traced down step by step, trace back to the data of lowermost level always, in addition,
Whether change regardless of identification information structure, data can be traced, only when identification information change again into
It when row retrospect, can trace back to " adjustment amount incurred ", and when identification information does not change, then cannot trace back to that " adjustment occurs
Volume ".
It is to enumerate a specific application example with bank data in order to facilitate understanding, process of the example comprising data summarization,
Identification information changes and part is caused to summarize process that target summarizes again and to the process for summarizing data and being traced；
As shown in figure 5, summarizing identification information (the second number in subject (beginning balance, amount incurred, ending balance) corresponding claims
According to third data, the first data), summarize subject (beginning balance, amount incurred, ending balance adjust amount incurred) respective rights and wants
Section is summarized in identification information (the second data, third data, the first data, the 4th data) in asking, the front and back that only changes
Purpose upper level, which summarizes subject, just has " adjustment amount incurred ".
Aggregation process: using summarizing step by step, that is, summarize subject D and summarized by summarizing subject G, H, I, specifically, summarized
" ending balance " in subject D by summarize " ending balance " in subject G, H and I it is cumulative come, summarize " the beginning in subject D
Remaining sum " is equal to " ending balance " for a upper accounting period summarizing subject D, and " amount incurred " is equal to " ending balance " and subtracts " the beginning
Remaining sum " summarizes subject B by summarizing from subject D and E summarize, and summarizing subject A is by summarizing from subject B and C summarize, with this
Analogize, up summarize step by step from the bottom, may finally obtain and all summarize section's purpose total amount evidence.
Structural adjustment process: changing when summarizing subject I, and causes to summarize subject I and be summarized by the junior for summarizing subject D
Subject becomes when summarizing the junior of subject F and summarizing subject I', and the common higher level for finding I and I' first summarizes subject middle grade most
Low summarizes subject, that is, summarizes subject A, then summarizes section between subject (B and D) and I' and A to summarizing between I and A
Mesh (C and F) is summarized again, wherein it is slightly special to summarizing again for subject D and F is summarized, when being summarized again to D, D
In " beginning balance " remain unchanged, the data that G is added with " ending balance " of H are as " ending balance " of D, by D
" ending balance " subtract " beginning balance " to new " amount incurred ", then add a data " adjustment hair to summarizing subject D
Raw volume ", " beginning balance " of " adjustment amount incurred " equal to I multiplied by -1, add by " amount incurred " for being somebody's turn to do " adjustment amount incurred " plus G
" amount incurred " of H is just equal to " amount incurred " of D, and " beginning balance " of I has been regarded one of " amount incurred " of D by whole process
Point, it ensure that " beginning balance " of D is constant, therefore changed even if summarizing subject structure, " the beginning of current accounting period
" ending balance " of the remaining sum " still with a upper accounting period maintains continuity；" phase when being summarized again to F, in F
First remaining sum " remains unchanged, and the data that M is added with " ending balance " of N are as " ending balance " of F, by " the end of term of F
Remaining sum " subtract " beginning balance " to new " amount incurred ", then add a data " adjustment amount incurred " to summarizing subject F,
" adjustment amount incurred " is equal to " beginning balance " of I', is somebody's turn to do " amount incurred " that " adjustment amount incurred " adds N plus " amount incurred " of M
Just it is equal to " amount incurred " of F, " beginning balance " of I' has been regarded a part of " amount incurred " of F, ensure that F by whole process
" beginning balance " it is constant, therefore changed even if summarizing subject structure, " beginning balance " of current accounting period is still
Continuity was maintained with " ending balance " of a upper accounting period.
It is then calculated according to normal computation rule for summarizing subject B and summarizing recalculating for subject C, i.e. subject B's
" beginning balance " remains unchanged, and " ending balance " summarizes subject D equal to junior and be added with " ending balance " of E, " amount incurred " etc.
" beginning balance " is subtracted in " ending balance "；" beginning balance " of subject C remains unchanged, and " ending balance " is equal to junior and summarizes section
" ending balance " of mesh F, " amount incurred " are equal to " ending balance " and subtract " beginning balance ".
Summarize data trace back process: double-clicking the data record of A, bullet to when summarizing in subject A " amount incurred " and tracing
A window shows " amount incurred " two data for summarizing subject B and C out, further traces to " amount incurred " of B, pop-up
One window shows " amount incurred " two data for summarizing subject D and E, further traces to " amount incurred " of D, pop-up
One window shows " adjustment amount incurred " three datas for " amount incurred " and D for summarizing subject G and E, and so on, it can be right
Any section's purpose " amount incurred " that summarizes is traced.
That mentions in citing can also be exchanged with retrospect to other data to the retrospect of " amount incurred ", and display mode is in addition to logical
Cross except " pop-up window " and can also be the other modes such as table, image, it is mentioned that " double-click " can also be direction, click
Etc. other modes, summarize before subject traces to a certain, can obtain this certain by the modes such as manually searching or searching for
One summarizes subject.
It should be noted that above-mentioned application scenarios are only limitted to illustrate, it is not used in and limits application range of the invention.
For the ease of better implementing the above scheme of the embodiment of the present invention, the present invention is also corresponding to be provided a kind of data and converges
Total device, the structural schematic diagram of the device of data summarization provided in an embodiment of the present invention as shown in Figure 6, the dress of data summarization
Setting 60 may include: first acquisition unit 601, the first collection unit 602 and the first computing unit 603, wherein
First acquisition unit 601 is used to obtain each mark letter in tables of data with identical upper level identification information
Breath, tables of data be stored with each grade identification information and its corresponding data record；
The corresponding data record of each identification information that first collection unit 602 is used to obtain first acquisition unit into
Row summarizes, and obtains summarizing data record；
Summarize data record of first computing unit 603 for being obtained according to the first collection unit obtains upper level mark letter
Cease corresponding data record.
It will be appreciated that the function of modules can be corresponded to reference in above method embodiment in the device 60 of data summarization
The specific embodiment of Fig. 2 embodiment, which is not described herein again.
Further, the structure of the device 60 of the data summarization of another embodiment provided by the invention as shown in Figure 7 is shown
It is intended to, the device 60 of data summarization is in addition to including first acquisition unit 601, the first collection unit 602 and the first computing unit 603
Except, it can also include: second acquisition unit 604, the second computing unit 605 and third computing unit 606, wherein
Second acquisition unit 604 is used to correspond to the upper level identification information of its own according to identification information, obtains the first mark
Know the third identification information in information common higher level's identification information corresponding with second identifier information, third identification information is first
The identification information of lowermost level in identification information common higher level's identification information corresponding with second identifier information；
Second computing unit 605 is for In Grade higher level's mark corresponding lower than the first identifier information of third identification information
The corresponding data record of information recalculates；
Third computing unit 606 is for In Grade higher level's mark corresponding lower than the second identifier information of third identification information
The corresponding data record of information recalculates.
It will be appreciated that the function of modules can be corresponded to reference in above method embodiment in the device 60 of data summarization
The specific embodiment of Fig. 3 embodiment, which is not described herein again.
Further, the structural representation of the device of the data summarization of another embodiment provided by the invention as shown in Figure 8
Figure, the device 60 of data summarization is in addition to including first acquisition unit 601, the first collection unit 602,603 and of the first computing unit
It can also include: the second computing unit 605, third computing unit 606, the 5th computing unit except second acquisition unit 604
607, the 6th computing unit 608 and the 7th computing unit 609, wherein
Second computing unit 605 is used for will be in the corresponding data record of the corresponding upper level identification information of first identifier information
The first data subtract the data that the first data in the corresponding data record of first identifier information obtain, to cover first identifier
The first data in the corresponding data record of the corresponding upper level identification information of information；
Third computing unit 606 is used for will be in the corresponding data record of the corresponding upper level identification information of second identifier information
The data that are obtained plus the first data in the corresponding data record of second identifier information of the first data, to cover second identifier
The first data in the corresponding data record of the corresponding upper level identification information of information；
5th computing unit 607 is used to the first data in the corresponding data record of upper level identification information subtracting upper one
The corresponding data note of the data cover upper level identification information that the second data in the corresponding data record of grade identification information obtain
Third data in record.
6th computing unit 608 is used for the second data in the corresponding data record of first identifier information multiplied by -1, and
The 4th that the obtained data that are multiplied are assigned in the corresponding data record of the corresponding upper level identification information of first identifier information
Data；
7th computing unit 609 is used to the second data in the corresponding data record of second identifier information being assigned to second
The 4th data in the corresponding data record of the corresponding upper level identification information of identification information.
It will be appreciated that the function of modules can be corresponded to reference in above method embodiment in the device 60 of data summarization
The specific embodiment of Fig. 3 embodiment, which is not described herein again.
Further, the structural representation of the device of the data summarization of another embodiment provided by the invention as shown in Figure 9
Figure, the device 60 of data summarization is in addition to including first acquisition unit 601, the first collection unit 602, the first computing unit 603, the
Two acquiring units 604, the second computing unit 605, third computing unit 606, the 5th computing unit 607, the 6th computing unit 608
It can also include: third acquiring unit 610 and display unit 611 except the 7th computing unit 609, wherein
Third acquiring unit 610 is used to correspond to the upper level identification information of its own according to identification information, obtains with the 4th
Identification information is each identification information of common upper level identification information；
It is common upper level mark letter with the 4th identification information that display unit 611, which is used to show that third acquiring unit to obtain,
The corresponding data record of each identification information of breath.
It will be appreciated that the function of modules can be corresponded to reference in above method embodiment in the device 60 of data summarization
The specific embodiment of Fig. 4 embodiment, which is not described herein again.
Target directly is summarized to this when to obtain a certain aggregate value for summarizing target by implementing the embodiment of the present invention
Next stage data sum up and can be obtained aggregate value, summed up without obtaining huge data from bottom, significantly
The calculating pressure for summarizing tool is reduced, solves in the prior art when the hierarchical structure complexity of summarized results, summarizes tool
The problem of bearing huge calculating pressure；After identification information structure changes, only to the corresponding number of local identification information
All data are adjusted according to being adjusted, greatly simplify the step of recalculating, reduce to a certain extent
Summarize the calculating pressure of tool；Furthermore it is also possible to be traced as needed to the source for summarizing data, especially identifying
When information changes and partial data is caused to recalculate, can be searched by tracing the identification information to change and its
Corresponding data.
Those of ordinary skill in the art will appreciate that realizing all or part of the process in above-described embodiment method, being can be with
Relevant hardware is instructed to complete by computer program, the program can be stored in a computer-readable storage medium
In, the program is when being executed, it may include such as the process of the embodiment of above-mentioned each method.Wherein, the storage medium can be magnetic
Dish, CD, read-only memory (Read-Only Memory, ROM) or random access memory (Random Access
Memory, abbreviation RAM) etc..
A kind of service code processing method and processing device is provided for the embodiments of the invention above to be described in detail, this
Apply that a specific example illustrates the principle and implementation of the invention in text, the explanation of above example is only intended to
It facilitates the understanding of the method and its core concept of the invention；At the same time, for those skilled in the art, think of according to the present invention
Think, there will be changes in the specific implementation manner and application range, in conclusion the content of the present specification should not be construed as pair
Limitation of the invention.
Claims (16)
1. a kind of method of data summarization characterized by comprising
Each identification information in tables of data with identical upper level identification information is obtained, the tables of data is stored with each grade
Identification information and its corresponding data record；The data record includes the first data；
The first data in the corresponding data record of each identification information of the acquisition are added up, are summarized
Data record；
Summarize the data in data record described in obtaining after will be cumulative and is assigned to the corresponding data of the upper level identification information
The first data in record；
Wherein, the identification information corresponds to the upper level identification information of its own, and the identification information includes first identifier information,
When the first identifier information is changed to second identifier information, the method also includes:
The upper level identification information that its own is corresponded to according to the identification information obtains the first identifier information and described second
Third identification information in the corresponding common higher level's identification information of identification information, the third identification information are the first identifier
The identification information of lowermost level in information common higher level's identification information corresponding with the second identifier information；The second identifier letter
Breath is the identification information after the first identifier information changes；
In Grade is lower than the corresponding data of the corresponding higher level's identification information of the first identifier information of the third identification information
Record recalculates；
In Grade is lower than the corresponding data of the corresponding higher level's identification information of the second identifier information of the third identification information
Record recalculates.
2. the method according to claim 1, wherein
The In Grade is corresponding lower than the corresponding higher level's identification information of the first identifier information of the third identification information
Data record, which recalculates, includes:
The first data in the corresponding data record of the corresponding upper level identification information of the first identifier information are subtracted described
The data that the first data in the corresponding data record of first identifier information obtain, it is corresponding to cover the first identifier information
The first data in the corresponding data record of upper level identification information；
The In Grade is corresponding lower than the corresponding higher level's identification information of the second identifier information of the third identification information
Data record, which recalculates, includes:
By the first data in the corresponding data record of the corresponding upper level identification information of the second identifier information plus described
The data that the first data in the corresponding data record of second identifier information obtain, it is corresponding to cover the second identifier information
The first data in the corresponding data record of upper level identification information.
3. the method according to claim 1, wherein the data record further includes the second data and third number
According to, it is described will it is cumulative after obtain described in summarize in data record data to be assigned to the upper level identification information corresponding
After the step of the first data in data record, further includes:
It is corresponding that the first data in the corresponding data record of the upper level identification information are subtracted into the upper level identification information
Data record in the obtained data cover of the second data described in third in the corresponding data record of upper level identification information
Data.
4. according to the method described in claim 2, it is characterized in that, the data record further includes the second data and third number
According to being added in first data by the corresponding data record of the corresponding upper level identification information of the second identifier information
The data that the first data in the corresponding data record of the second identifier information obtain, to cover the second identifier information pair
After the step of the first data in the corresponding data record of upper level identification information answered, further includes:
It is corresponding that the first data in the corresponding data record of the upper level identification information are subtracted into the upper level identification information
Data record in the obtained data cover of the second data described in third in the corresponding data record of upper level identification information
Data.
5. according to the method described in claim 4, it is characterized in that, the corresponding upper level identification information of the first identifier information
Corresponding data record and the corresponding data record of the corresponding upper level identification information of the second identifier information all include the 4th
Data, further includes:
By the second data in the corresponding data record of the first identifier information multiplied by -1, and the data assignment that multiplication is obtained
To the 4th data in the corresponding data record of the corresponding upper level identification information of the first identifier information；
It is corresponding that the second data in the corresponding data record of the second identifier information are assigned to the second identifier information
The 4th data in the corresponding data record of upper level identification information.
6. according to the method described in claim 5, it is characterized in that, obtaining the corresponding data record of the upper level identification information
In the first data after, further includes:
The upper level identification information that its own is corresponded to according to the identification information is obtained with the 4th identification information as common upper level
Each identification information of identification information；Wherein, the 4th identification information is any one article of identification information in the tables of data；
Show the corresponding data of each identification information with the 4th identification information for common upper level identification information
Record.
7. according to the method described in claim 6, it is characterized in that, with the 4th identification information being common upper one described in the displaying
Grade identification information the corresponding data record of each identification information include:
Show the corresponding data of each identification information with the 4th identification information for common upper level identification information
Third data in record.
8. the method according to the description of claim 7 is characterized in that when the corresponding data record of the 4th identification information includes
When four data, described in the displaying with the 4th identification information be common upper level identification information each identification information
While third data in corresponding data record, show that the corresponding data record of the 4th identification information includes
4th data.
9. a kind of device of data summarization characterized by comprising
First acquisition unit, it is described for obtaining each identification information in tables of data with identical upper level identification information
Tables of data be stored with each grade identification information and its corresponding data record；The data record includes the first data；
First collection unit, the corresponding data record of each identification information for being obtained to the first acquisition unit
In the first data add up, obtain summarizing data record；
First computing unit is assigned for summarizing the data in data record described in obtaining first collection unit after cumulative
It is worth to the first data in the corresponding data record of the upper level identification information；
Wherein, the identification information corresponds to the upper level identification information of its own；The identification information includes first identifier information,
When the first identifier information is changed to second identifier information, described device further include:
Second acquisition unit obtains described first for corresponding to its own upper level identification information according to the identification information
Third identification information in identification information common higher level's identification information corresponding with the second identifier information, the third mark
Information is the mark of lowermost level in the first identifier information common higher level's identification information corresponding with the second identifier information
Information；The second identifier information is the identification information after the first identifier information changes；
Second computing unit, for In Grade higher level's mark corresponding lower than the first identifier information of the third identification information
Know the corresponding data record of information to recalculate；
Third computing unit, for In Grade higher level's mark corresponding lower than the second identifier information of the third identification information
Know the corresponding data record of information to recalculate.
10. device according to claim 9, which is characterized in that
Second computing unit is specifically used for the corresponding data of the corresponding upper level identification information of the first identifier information
The first data in record subtract the data that the first data in the corresponding data record of the first identifier information obtain, to cover
Cover the first data in the corresponding data record of the corresponding upper level identification information of the first identifier information；
The third computing unit is specifically used for the corresponding data of the corresponding upper level identification information of the second identifier information
The data that the first data in record are obtained plus the first data in the corresponding data record of the second identifier information, to cover
Cover the first data in the corresponding data record of the corresponding upper level identification information of the second identifier information.
11. device according to claim 9, which is characterized in that further include:
4th computing unit, it is described for subtracting the first data in the corresponding data record of the upper level identification information
Upper level identification information described in the data cover that the second data in the corresponding data record of level-one identification information obtain is corresponding
Third data in data record.
12. device according to claim 10, which is characterized in that further include:
5th computing unit, for when first identifier information becomes second identifier information, by the upper level identification information pair
The second data that the first data in the data record answered subtract in the corresponding data record of the upper level identification information obtain
Data cover described in third data in the corresponding data record of upper level identification information.
13. device according to claim 12, which is characterized in that the corresponding upper level mark letter of the first identifier information
It ceases corresponding data record and the corresponding data record of the corresponding upper level identification information of the second identifier information all includes
Four data, further includes:
6th computing unit, for by the second data in the corresponding data record of the first identifier information multiplied by -1, and will
The obtained data of being multiplied are assigned to the in the corresponding data record of the corresponding upper level identification information of the first identifier information
Four data；
7th computing unit, for the second data in the corresponding data record of the second identifier information to be assigned to described
The 4th data in the corresponding data record of the corresponding upper level identification information of two identification informations.
14. device according to claim 13, which is characterized in that further include:
Third acquiring unit is obtained for corresponding to its own upper level identification information according to the identification information with the 4th mark
Know each identification information that information is common upper level identification information；4th identification information is any in the tables of data
One identification information；
Display unit, for showing that the third acquiring unit obtains with the 4th identification information as common upper level mark
The corresponding data record of each identification information of information.
15. device according to claim 14, which is characterized in that
It is on common with the 4th identification information that the display unit, which is specifically used for showing that the third acquiring unit obtains,
Third data in the corresponding data record of each identification information of level-one identification information.
16. device according to claim 15, which is characterized in that when the corresponding data record packet of the 4th identification information
When containing four data,
The display unit show that the third acquiring unit obtains with the 4th identification information for common upper level mark
While third data in the corresponding data record of each identification information of information, the 4th identification information is shown
The 4th data that corresponding data record includes.
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 CN104408057A (en) | 2015-03-11 |
| CN104408057B true 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) |
Families Citing this family (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| 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 |
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 |
|---|
| "基于层次空间聚类的表语义汇总算法";孙翀 等;《计算机科学》;20120331;全文 |
Also Published As
| Publication number | Publication date |
|---|---|
| CN104408057A (en) | 2015-03-11 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US10521771B2 (en) | Interactive organization visualization tools for use in analyzing multivariate human-resource data of organizations | |
| US9678652B2 (en) | Automatic data sharing between multiple graph elements | |
| CN104408057B (en) | A kind of method and device of data summarization | |
| CN110377667A (en) | It is associated with map methods of exhibiting, device, computer equipment and storage medium | |
| US11029806B1 (en) | Digital product navigation tool | |
| CN106951369A (en) | The management method and device of a kind of joint debugging test | |
| CN108595604A (en) | A kind of data visualisation system and method for intelligent report forms | |
| CN107748752A (en) | A kind of data processing method and device | |
| CN105868297A (en) | Online map based remote sensing interpretation sample calling method, apparatus and system | |
| CN104216922B (en) | The method and device of data screening | |
| CN107784035A (en) | Assessment system, the method and apparatus of the node of funnel model | |
| CN114511235A (en) | Process evaluation method and system | |
| CN108053323A (en) | Method, apparatus, computer equipment and the storage medium of service plan generation | |
| CN115840567A (en) | Application editing method and related equipment | |
| CN107678972A (en) | The appraisal procedure and relevant apparatus of a kind of test case | |
| CN105608151B (en) | A kind of financial statement analysis device and method | |
| CN107291616A (en) | A kind of online generating platform of project report | |
| CN110008277A (en) | The visible processing method and device of resource flow direction | |
| US7512556B2 (en) | System and method for evaluation of simulated hedging relationship assignments | |
| CN103793469A (en) | Data inquiry statistics method and data inquiry statistics system | |
| CN109213979B (en) | Method and device for screening electronic forms, electronic equipment and storage medium | |
| CN109582834A (en) | Data Risk Forecast Method and device | |
| CN107545009B (en) | Method and equipment for determining components in webpage | |
| US10552528B2 (en) | User interface technology for displaying table data | |
| CN110941608B (en) | Method, device and equipment for generating buried point analysis and funnel analysis report |
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 |