CN102867065A - Data summarization device and method based on relational database - Google Patents
Data summarization device and method based on relational database Download PDFInfo
- Publication number
- CN102867065A CN102867065A CN2012103698711A CN201210369871A CN102867065A CN 102867065 A CN102867065 A CN 102867065A CN 2012103698711 A CN2012103698711 A CN 2012103698711A CN 201210369871 A CN201210369871 A CN 201210369871A CN 102867065 A CN102867065 A CN 102867065A
- Authority
- CN
- China
- Prior art keywords
- data
- gathers
- priority
- path
- higher 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.)
- Granted
Links
Images
Abstract
The invention provides a data summarization device based on a relational database. The device comprises a definition unit, a receiving unit, a finding unit and a summarizing unit, wherein the definition unit defines the priority level of each dimension of business data; the receiving unit receives an alteration unit submitted by a user; the finding unit finds a superior data unit in the dimension on the highest priority level among superior data units in a plurality of dimensions of the alteration unit; and the summarizing unit performs data summarization from the alteration unit to the superior data unit in the dimension on the highest priority level. According to the technical scheme of the invention, data can be permitted to enter dimensions not on the lowest level, and the priority level of a summarizing path can be judged, so as to ensure that summarized data on higher levels is unambiguous. The invention also provides a data summarization method based on the relational database.
Description
Technical field
The present invention relates to field of computer technology, in particular to a kind of Data Transform Device based on relevant database and a kind of data method of summary based on relevant database.
Background technology
In the operation system of complexity, a lot of business datums are having levels property all, and the data of higher level's level need real-time business datum to subordinate's level automatically to gather.
Automatically gather the data that require final stage dimension member and successively be aggregated into higher level member, all higher level members' data are all calculated out through gathering by subordinate.
But under some business scenario, the user may be directly in the final stage logging data, but in the logging data of higher level's dimension, the data of subordinate's dimension are empty, and in this case, the user wishes that still can continue superior to the data of typing gather.That is to say that the data that we can't judge user's typing according to the hierarchical relationship of dimension are the final stage data whether.
Be exemplified below: suppose that the hierarchical relationship on time dimension is:
[3 July in season in 2011] → [3 seasons in 2011] → [2011];
Hierarchical relationship on organization dimensionality is: [d of department] → [a of company] → [g of group];
Hierarchical relationship on the subject dimension is: [travel expenses] → [managerial cost].
The user has filled in two data:
[3 July in season in 2011] [managerial cost] [d of department]=3000;
[3 seasons in 2011] [travel expenses] [d of department]=2000;
Should be combined data as higher level [3 seasons in 2011] [managerial cost] [d of department] so, how many its data be? 2000,3000,5000? or other?
Figure 1A has showed that data are entered into the combined data under the final stage.Figure 1B has showed that data are entered into the combined data under the non-final stage.
The reason of this puzzlement is do not have to determine which is the final stage data, and which is non-final stage data, but in the business procedures such as enterprise's comprehensive budget, this business often occurs., no matter along any paths upwards gather only in the situation of final stage typing in data, and the result should be the same, but allowing data in the situation of non-final stage dimension typing, the priority in path not judged that data just have problem.
Therefore, need a kind of new mode that gathers, allow data typing on non-final stage dimension, can select suitable path to gather, can guarantee that higher level's combined data does not have ambiguity.
Summary of the invention
The present invention just is being based on the problems referred to above, has proposed a kind of data and has gathered technology, allows data typing on non-final stage dimension, can select suitable path to gather, and can guarantee that higher level's combined data does not have ambiguity.
In view of this, according to an aspect of the present invention, provide a kind of Data Transform Device based on relevant database, having comprised: definition unit, the priority of each dimension of definition business datum; Receiving element receives the change unit that the user submits to; Search the unit, in the higher level's data cell on a plurality of dimensions of described change unit, find out the higher level's data cell on the highest dimension of priority; Gather the unit, begin higher level's data cell on the highest dimension of described priority from described change unit and carry out data and gather.
In this technical scheme, the priority of predetermined each dimension of definition if data are then selected the highest dimension of priority in non-final stage typing, then upwards gathers from this dimension direction, so just can avoid the inconsistent of combined data.
In technique scheme, preferably, the described unit that gathers comprises the record subelement, is used for this dimension precedence information that gathers is recorded in described higher level's data cell as this priority that gathers the path, and the priority that the first basis of described cover sheet gathers the path is carried out data and gathered.
Each precedence information that gathers the path is recorded, in the aggregation process afterwards, judged specifically how to gather according to this priority that gathers the path.
In technique scheme, preferred, the described unit of searching comprises the comparison subelement, has recorded formerly when gathering the path in described higher level's data cell, and more described former priority and described this that gathers the path gathers the height of the priority in path; The described unit that gathers also comprises: replace subelement, when the described priority that this gathers the path is higher than the described former priority that gathers the path, when gathering, with the combined data in the higher level's data cell on the highest dimension of the described priority of data replacement of described change unit.
This situation illustrates the priority that gathers that priority is higher than the original data of higher level that gathers of Ben Weidu, and that just covers the original combined data of higher level with the combined data of Ben Weidu.
In technique scheme, preferably, the described unit further that gathers comprises: extract subelement, when the described priority that this gathers the path equals the described former priority that gathers the path, when gathering, from described relevant database, extract metadata element according to the dimensional information of described change unit; Computation subunit calculates the difference between described change unit and the described metadata element; Cumulative subelement begins step by step from described change unit that recurrence upwards gathers, and described difference is added in all described higher level's data cells of described change unit.
Gather priority and this of the original data of this situation explanation higher level gather and are same dimension therefore only need to calculate the incremental data of this change, and this incremental data is added to the former combined data of higher level gets on.
In technique scheme, preferred, the described unit that gathers also is used for, abandoning this and gathering during less than the described former priority that gathers the path in the described priority that this gathers the path.
The original data of this situation explanation higher level are that the dimension by higher priority gathers up, abandon gathering of Ben Weidu.
According to a further aspect in the invention, also provide a kind of data method of summary based on relevant database, may further comprise the steps: step 402, the priority of each dimension of definition business datum;
Step 404 receives the change unit that the user submits to; Step 406 in the higher level's data cell on a plurality of dimensions of described change unit, finds out the higher level's data cell on the highest dimension of priority; Step 408 begins higher level's data cell on the highest dimension of described priority and carries out data and gather from described change unit.
In this technical scheme, the priority of predetermined each dimension of definition if data are then selected the highest dimension of priority in non-final stage typing, then upwards gathers from this dimension direction, so just can avoid the inconsistent of combined data.
In technique scheme, preferred, described step 408 can also comprise: this dimension precedence information that gathers is recorded in described higher level's data cell as this priority that gathers the path, carries out data according to the priority that gathers the path and gather.
Each precedence information that gathers the path is recorded, in the aggregation process afterwards, judged specifically how to gather according to this priority that gathers the path.
In technique scheme, preferred, described step 406 can also comprise: recorded formerly when gathering the path in described higher level's data cell, more described former priority and described this that gathers the path gathers the height of the priority in path; Described step 408 also comprises: when the described priority that this gathers the path is higher than the described former priority that gathers the path, when gathering, with the data in the higher level's data cell on the highest dimension of the described priority of data replacement of described change unit.
This situation illustrates the priority that gathers that priority is higher than the original data of higher level that gathers of Ben Weidu, and that just covers the original combined data of higher level with the combined data of Ben Weidu.
In technique scheme, preferably, described step 408 can also comprise: when the described priority that this gathers the path equals the described former priority that gathers the path, when gathering, dimensional information according to described change unit extracts metadata element from described relevant database, and calculates the difference between described change unit and the described metadata element; Begin step by step from described change unit that recurrence upwards gathers, described difference is added in all described higher level's data cells of described change unit.
Gather priority and this of the original data of this situation explanation higher level gather and are same dimension therefore only need to calculate the incremental data of this change, and this incremental data is added to the former combined data of higher level gets on.
In technique scheme, preferred,, abandon this and gather during less than the described former priority that gathers the path in the described priority that this gathers the path.
The original data of this situation explanation higher level are that the dimension by higher priority gathers up, abandon gathering of Ben Weidu.
The present invention proposes under a kind of business scenario allowing the typing of non-final stage data, by the priority that gathers on the definition dimension, in system, exist in a plurality of situations that gather the path, by selecting a preferred path, realize data the end of from and on gather, can solve the problem under the similar business scenario.
Description of drawings
Figure 1A shows the synoptic diagram that gathers from the final stage logging data;
Figure 1B shows the synoptic diagram that gathers from non-final stage logging data;
Fig. 2 A to Fig. 2 C shows according to an embodiment of the invention dimensional structure figure;
Fig. 3 shows according to an embodiment of the invention the block diagram based on the Data Transform Device of relevant database;
Fig. 4 shows the process flow diagram of the data method of summary based on relevant database according to an embodiment of the invention;
Fig. 5 shows the process flow diagram based on the data method of summary of relevant database according to still another embodiment of the invention.
Embodiment
In order more clearly to understand above-mentioned purpose of the present invention, feature and advantage, below in conjunction with the drawings and specific embodiments the present invention is further described in detail.
Set forth in the following description a lot of details so that fully understand the present invention, still, the present invention can also adopt other to be different from other modes described here and implement, and therefore, the present invention is not limited to the restriction of following public specific embodiment.
Expression and the storage of multidimensional data in an embodiment of the present invention at first are described in conjunction with Fig. 2 A to Fig. 2 C.
For business datum, need the dimension (Dimension) of preliminary setting data.
Dimension (Dimension): being the special angle of people's observed data, is the generic attribute when considering a problem, and community set consists of a dimension, time dimension for example, organization dimensionality, product dimension etc.
The level of dimension (Level): be the further segmentation to dimension, can be subdivided into such as time dimension, year level, season level, month level.
The member of dimension (Member): the concrete value of dimension is the description of data position in certain dimension, is the description of the position of data on time dimension such as " in March, 2012 ".
By defining a plurality of different dimensions, observation and analysis data more neatly, the hierarchical relationship of each dimension is stored with tree structure, is convenient to like this gathering of data.
Cube (Cube): by the data carrier that a plurality of dimensions form, Cube is just as a coordinate system, and each dimension (Dimension) wherein represents a coordinate axis.
For the ease of understanding more clearly the present invention, in an embodiment of the present invention take three-dimensional as example, provided dimensional structure figure, shown in Fig. 2 A to Fig. 2 C.
In the following embodiments, use RDBMS(relational database management system, Relational DBMS) store cube, the data list structure of cube is as shown in the table:
| Coordinate | Year | Season | Month | Tissue | Subject | Data |
| 2011.3.7.O1.CL | 2011 | 3 | 7 | The d of department | Travel expenses | 5000 |
| 2011.3.~.O1.CL | 2011 | 3 | ～ | The d of department | Travel expenses | 8000 |
| 2011.~.~.O1.CL | 2011 | ～ | ～ | The d of department | Travel expenses | 32000 |
Can find out that from top data there be same database table the inside in combined data (last column data) and final stage data (the first row data).Wherein these row of coordinate are the major key fields each dimension, through after the compressing mapping, make up and a character string of formation, and coordinate fields is that full table is unique, can not have two row data that the coordinate figure of repetition is arranged.According to coordinate figure, can easily and accurately inquire the value of multidimensional data.The purpose of compressing mapping is in order to reduce storage space, to improve simultaneously performance and the efficient of inquiry.
Fig. 3 shows according to an embodiment of the invention the block diagram based on the Data Transform Device of relevant database.
As shown in Figure 3, based on the Data Transform Device 300 of relevant database, comprising according to an embodiment of the invention: definition unit 302, the priority of each dimension of definition business datum; Receiving element 304 receives the change unit that the user submits to; Search unit 306, in the higher level's data cell on a plurality of dimensions of described change unit, find out the higher level's data cell on the highest dimension of priority; Gather unit 308, begin higher level's data cell on the highest dimension of described priority from described change unit and carry out data and gather.
In this technical scheme, the priority of predetermined each dimension of definition if data are then selected the highest dimension of priority in non-final stage typing, then upwards gathers from this dimension direction, so just can avoid the inconsistent of combined data.
In technique scheme, preferably, the described unit 308 that gathers comprises record subelement 3082, be used for this dimension precedence information that gathers is recorded in described higher level's data cell as this priority that gathers the path, the described unit 308 that gathers carries out data according to the priority that gathers the path and gathers.
Each precedence information that gathers the path is recorded, in the aggregation process afterwards, judged specifically how to gather according to this priority that gathers the path.
In technique scheme, preferred, the described unit 306 of searching comprises comparison subelement 3062, has recorded formerly when gathering the path in described higher level's data cell, and more described former priority and described this that gathers the path gathers the height of the priority in path; The described unit 308 that gathers also comprises: replace subelement 3084, when the described priority that this gathers the path is higher than the described former priority that gathers the path, when gathering, with the combined data in the higher level's data cell on the highest dimension of the described priority of data replacement of described change unit.
This situation illustrates the priority that gathers that priority is higher than the original data of higher level that gathers of Ben Weidu, and that just covers the original combined data of higher level with the combined data of Ben Weidu.
In technique scheme, preferably, the described unit 308 that gathers can also comprise: extract subelement 3086, when the described priority that this gathers the path equals the described former priority that gathers the path, when gathering, from described relevant database, extract metadata element according to the dimensional information of described change unit; Computation subunit 3088 calculates the difference between described change unit and the described metadata element; Cumulative subelement 30810 begins step by step from described change unit that recurrence upwards gathers, and described difference is added in all described higher level's data cells of described change unit.
Gather priority and this of the original data of this situation explanation higher level gather and are same dimension therefore only need to calculate the incremental data of this change, and this incremental data is added to the former combined data of higher level gets on.
In technique scheme, preferred, the described unit 308 that gathers also is used for, abandoning this and gathering during less than the described former priority that gathers the path in the described priority that this gathers the path.
The original data of this situation explanation higher level are that the dimension by higher priority gathers up, abandon gathering of Ben Weidu.
Allow data typing on non-final stage dimension according to Data Transform Device of the present invention, can select suitable path to gather, can guarantee that higher level's combined data does not have ambiguity
Fig. 4 shows according to an embodiment of the invention the process flow diagram based on the data method of summary of relevant database.
As shown in Figure 4, based on the data method of summary of relevant database, may further comprise the steps according to an embodiment of the invention: step 402, the priority of each dimension of definition business datum; Step 404 receives the change unit that the user submits to; Step 406 in the higher level's data cell on a plurality of dimensions of change unit, finds out the higher level's data cell on the highest dimension of priority; Step 408 begins higher level's data cell on the highest dimension of priority and carries out data and gather from the change unit.
In this technical scheme, the priority of predetermined each dimension of definition if data are then selected the highest dimension of priority in non-final stage typing, then upwards gathers from this dimension direction, so just can avoid the inconsistent of combined data.
In technique scheme, preferred, step 408 can also comprise: this dimension precedence information that gathers is recorded in described higher level's data cell as this priority that gathers the path, carries out data according to the priority that gathers the path and gather.
Each precedence information that gathers the path is recorded, in the aggregation process afterwards, judged specifically how to gather according to this priority that gathers the path.
In technique scheme, preferred, described step 406 can also comprise: recorded formerly when gathering the path in described higher level's data cell, more described former priority and described this that gathers the path gathers the height of the priority in path; Described step 408 can also comprise: when the described priority that this gathers the path is higher than the described former priority that gathers the path, when gathering, with the data in the higher level's data cell on the highest dimension of the described priority of data replacement of described change unit.
This situation illustrates the priority that gathers that priority is higher than the original data of higher level that gathers of Ben Weidu, and that just covers the original combined data of higher level with the combined data of Ben Weidu.
In technique scheme, preferably, described step 408 can also comprise: when the described priority that this gathers the path equals the described former priority that gathers the path, when gathering, dimensional information according to described change unit extracts metadata element from described relevant database, and calculates the difference between described change unit and the described metadata element; Begin step by step from described change unit that recurrence upwards gathers, described difference is added in all described higher level's data cells of described change unit.
Gather priority and this of the original data of this situation explanation higher level gather and are same dimension therefore only need to calculate the incremental data of this change, and this incremental data is added to the former combined data of higher level gets on.
In technique scheme, preferred,, abandon this and gather during less than the described former priority that gathers the path in the described priority that this gathers the path.
The original data of this situation explanation higher level are that the dimension by higher priority gathers up, abandon gathering of Ben Weidu.
Describe in detail according to embodiments of the invention below in conjunction with Fig. 5.
One. dimension gathers the definition of priority
By defining a priority in dimension, can when gathering, automatically select the path of high priority to gather, for example, the priority of definition time dimension is 9 in the example of Figure 1B, and the priority of subject dimension is 8, the priority of organization dimensionality is 7, that is to say that the dimension priority orders is: the time〉subject〉tissue.
When gathering, if certain higher level has a plurality of subordinates unit, system can be different according to the residing dimension of the different dimension of subordinate unit and higher level unit, and preferentially select a high subordinate unit of priority to gather.
In the above example, because the priority of time dimension is greater than the subject dimension, so system can preferentially select: [3 July in season in 2011] [managerial cost] [d of department]=3000.Gather based on this data superior, the combined data of last [3 seasons in 2011] [managerial cost] [d of department] is 3000.
Two. gather the description of algorithm
Use in the present embodiment recursive algorithm the end of from and on carry out the calculating that increment gathers, the data cell from the change unit set C of user's typing begins recurrence and upwards gathers.
In step 502, judge among the change unit set C whether remaining data cell (cell) is arranged, data cell (cell) can be understood as the data line among the change unit set C, for example the first row data in the upper table.If judged remaining data cell, then carry out data based on this data cell and gather.
In step 504, the difference between the data of the new data of this user's typing and a upper version calculates data increment diff.
In step 506, when on certain dimension, upwards gathering, preferentially inquire the father cell of priority on the most high-dimensional, what calculate simultaneously that this time gather gathers priority v, and this numerical priority value is recorded in father's cell as gathering the path.
In step 508, judge whether the coordinate of father's cell is empty, if empty, entering step 516, judge whether to exist higher level's data cell of next dimension.If be not empty, then enter step 510.
In step 510, find out the data of higher level's data cell.
In step 512, if finding when gathering that the father unit has existed gathers path v0, and compare as the priority v that gathers that time gather, judge namely whether current path equals original route, if, then enter step 514, if not, then enter step 518.
In step 514, if v0=v, gather priority and this of the original data of higher level gather and are same dimension need to calculate the incremental data of this change, and this incremental data is added to the former combined data of higher level gets on.Then take the father unit as the basis, proceed recursive call, until aggregation process finishes.
In step 516, if there is next dimension, then enter step 506, if do not exist, then enter step 502.In step 518, if v0＜v illustrates the priority that gathers that priority is higher than the original data of higher level that gathers of Ben Weidu then to enter step 520, the combined data that the data cover higher level of user's typing is original.Then take the father unit as the basis, proceed recursive call, until aggregation process finishes.If v0〉v, illustrate that the original data of higher level are that dimension by higher priority gathers up, abandon gathering of Ben Weidu.
The below is that the Java that gathers the algorithm key component illustrates that code is as follows:
/ * * increment gather main-inlet method */
Finish gather calculating after, write the data of change in the database, affairs are finished.
In sum, the present invention proposes under a kind of business scenario allowing the typing of non-final stage data, by the priority that gathers on the definition dimension, in system, exist in a plurality of situations that gather the path, by selecting a preferred path, realize data the end of from and on gather, can solve the problem under the similar business scenario, therefore, the present invention can be applicable to carry out the various dimensions data business field of System, and the business scenario in the inconsistent situation of a plurality of paths combined data of multidimensional data.
The above is the preferred embodiments of the present invention only, is not limited to the present invention, and for a person skilled in the art, the present invention can have various modifications and variations.Within the spirit and principles in the present invention all, any modification of doing, be equal to replacement, improvement etc., all should be included within protection scope of the present invention.
Claims (10)
1. the Data Transform Device based on relevant database is characterized in that, comprising:
Definition unit, the priority of each dimension of definition business datum;
Receiving element receives the change unit that the user submits to;
Search the unit, in the higher level's data cell on a plurality of dimensions of described change unit, find out the higher level's data cell on the highest dimension of priority;
Gather the unit, begin higher level's data cell on the highest dimension of described priority from described change unit and carry out data and gather.
2. the Data Transform Device based on relevant database according to claim 1, it is characterized in that, the described unit that gathers comprises the record subelement, be used for this dimension precedence information that gathers is recorded in described higher level's data cell as this priority that gathers the path, the priority that the first basis of described cover sheet gathers the path is carried out data and is gathered.
3. the Data Transform Device based on relevant database according to claim 2, it is characterized in that, the described unit of searching comprises the comparison subelement, recorded formerly when gathering the path in described higher level's data cell, more described former priority and described this that gathers the path gathers the height of the priority in path;
The described unit that gathers also comprises: replace subelement, when the described priority that this gathers the path is higher than the described former priority that gathers the path, when gathering, with the combined data in the higher level's data cell on the highest dimension of the described priority of data replacement of described change unit.
4. the Data Transform Device based on relevant database according to claim 2, it is characterized in that, the described unit that gathers also comprises: extract subelement, when the described priority that this gathers the path equals the described former priority that gathers the path, when gathering, from described relevant database, extract metadata element according to the dimensional information of described change unit;
Computation subunit calculates the difference between described change unit and the described metadata element;
Cumulative subelement begins step by step from described change unit that recurrence upwards gathers, and described difference is added in all described higher level's data cells of described change unit.
5. the Data Transform Device based on relevant database according to claim 2 is characterized in that, the described unit that gathers also is used for, abandoning this and gathering during less than the described former priority that gathers the path in the described priority that this gathers the path.
6. the data method of summary based on relevant database is characterized in that, may further comprise the steps:
Step 402, the priority of each dimension of definition business datum;
Step 404 receives the change unit that the user submits to;
Step 406 in the higher level's data cell on a plurality of dimensions of described change unit, finds out the higher level's data cell on the highest dimension of priority;
Step 408 begins higher level's data cell on the highest dimension of described priority and carries out data and gather from described change unit.
7. the data method of summary based on relevant database according to claim 6, it is characterized in that, described step 408 also comprises: this dimension precedence information that gathers is recorded in described higher level's data cell as this priority that gathers the path, carries out data according to the priority that gathers the path and gather.
8. the data method of summary based on relevant database according to claim 7, it is characterized in that, described step 406 also comprises: recorded formerly when gathering the path in described higher level's data cell, more described former priority and described this that gathers the path gathers the height of the priority in path;
Described step 408 also comprises: when the described priority that this gathers the path is higher than the described former priority that gathers the path, when gathering, with the data in the higher level's data cell on the highest dimension of the described priority of data replacement of described change unit.
9. the data method of summary based on relevant database according to claim 7, it is characterized in that, described step 408 also comprises: when the described priority that this gathers the path equals the described former priority that gathers the path, when gathering, dimensional information according to described change unit extracts metadata element from described relevant database, and calculates the difference between described change unit and the described metadata element;
Begin step by step from described change unit that recurrence upwards gathers, described difference is added in all described higher level's data cells of described change unit.
10. the data method of summary based on relevant database according to claim 7 is characterized in that,, abandons this and gathers during less than the described former priority that gathers the path in the described priority that this gathers the path.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201210369871.1A CN102867065B (en) | 2012-09-28 | 2012-09-28 | Based on Data Transform Device and the method for relevant database |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201210369871.1A CN102867065B (en) | 2012-09-28 | 2012-09-28 | Based on Data Transform Device and the method for relevant database |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN102867065A true CN102867065A (en) | 2013-01-09 |
| CN102867065B CN102867065B (en) | 2016-01-20 |
Family
ID=47445934
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201210369871.1A Active CN102867065B (en) | 2012-09-28 | 2012-09-28 | Based on Data Transform Device and the method for relevant database |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN102867065B (en) |
Cited By (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN104281713A (en) * | 2014-10-28 | 2015-01-14 | 用友软件股份有限公司 | Data summarizing method and data summarizing device |
| CN104346449A (en) * | 2014-10-28 | 2015-02-11 | 用友软件股份有限公司 | Data merging method and data merging device |
| CN104408057A (en) * | 2014-10-29 | 2015-03-11 | 中国建设银行股份有限公司 | Data summarization method and device |
| CN109165377A (en) * | 2018-06-11 | 2019-01-08 | 玖富金科控股集团有限责任公司 | Generate the method and tabulating equipment of form data |
| CN109753545A (en) * | 2019-01-11 | 2019-05-14 | 浪潮通用软件有限公司 | A kind of flexible setting procurement demand reports the method and system of relationship |
| CN111078796A (en) * | 2019-12-23 | 2020-04-28 | 广东聚智诚科技有限公司 | Summarizing system and method for distributed intellectual property databases |
| CN111522819A (en) * | 2020-04-24 | 2020-08-11 | 上海用天网络科技有限公司 | Method and system for summarizing tree-structured data |
Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20060116975A1 (en) * | 2004-11-30 | 2006-06-01 | Michael Gould | Automated default dimension selection within a multidimensional enterprise software system |
| CN1949226A (en) * | 2006-11-23 | 2007-04-18 | 金蝶软件（中国）有限公司 | Multidimensional data reading and writing method and apparatus in on-line analytical processing system |
| CN101026647A (en) * | 2007-04-09 | 2007-08-29 | 中国网络通信集团公司 | Telecommunication income check dynamic hierarchical management system and method |
| CN101957852A (en) * | 2010-09-26 | 2011-01-26 | 用友软件股份有限公司 | Method and system for producing correlation information of table data |
| CN102413106A (en) * | 2010-09-26 | 2012-04-11 | 百度在线网络技术（北京）有限公司 | Method for processing advertising agent data safely and system thereof |
-
2012
- 2012-09-28 CN CN201210369871.1A patent/CN102867065B/en active Active
Patent Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20060116975A1 (en) * | 2004-11-30 | 2006-06-01 | Michael Gould | Automated default dimension selection within a multidimensional enterprise software system |
| CN1949226A (en) * | 2006-11-23 | 2007-04-18 | 金蝶软件（中国）有限公司 | Multidimensional data reading and writing method and apparatus in on-line analytical processing system |
| CN101026647A (en) * | 2007-04-09 | 2007-08-29 | 中国网络通信集团公司 | Telecommunication income check dynamic hierarchical management system and method |
| CN101957852A (en) * | 2010-09-26 | 2011-01-26 | 用友软件股份有限公司 | Method and system for producing correlation information of table data |
| CN102413106A (en) * | 2010-09-26 | 2012-04-11 | 百度在线网络技术（北京）有限公司 | Method for processing advertising agent data safely and system thereof |
Cited By (10)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN104281713A (en) * | 2014-10-28 | 2015-01-14 | 用友软件股份有限公司 | Data summarizing method and data summarizing device |
| CN104346449A (en) * | 2014-10-28 | 2015-02-11 | 用友软件股份有限公司 | Data merging method and data merging device |
| CN104346449B (en) * | 2014-10-28 | 2017-11-24 | 用友网络科技股份有限公司 | Data merging method and data merging device |
| CN104281713B (en) * | 2014-10-28 | 2018-10-19 | 用友网络科技股份有限公司 | Data summarization method and Data Transform Device |
| CN104408057A (en) * | 2014-10-29 | 2015-03-11 | 中国建设银行股份有限公司 | Data summarization method and device |
| CN104408057B (en) * | 2014-10-29 | 2019-01-29 | 中国建设银行股份有限公司 | A kind of method and device of data summarization |
| CN109165377A (en) * | 2018-06-11 | 2019-01-08 | 玖富金科控股集团有限责任公司 | Generate the method and tabulating equipment of form data |
| CN109753545A (en) * | 2019-01-11 | 2019-05-14 | 浪潮通用软件有限公司 | A kind of flexible setting procurement demand reports the method and system of relationship |
| CN111078796A (en) * | 2019-12-23 | 2020-04-28 | 广东聚智诚科技有限公司 | Summarizing system and method for distributed intellectual property databases |
| CN111522819A (en) * | 2020-04-24 | 2020-08-11 | 上海用天网络科技有限公司 | Method and system for summarizing tree-structured data |
Also Published As
| Publication number | Publication date |
|---|---|
| CN102867065B (en) | 2016-01-20 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN102867065B (en) | Based on Data Transform Device and the method for relevant database | |
| CN102867066B (en) | Data Transform Device and data summarization method | |
| CN106933833B (en) | Method for quickly querying position information based on spatial index technology | |
| CN101957852B (en) | Method and system for producing correlation information of table data | |
| US7219108B2 (en) | Query prunning using exterior tiles in an R-tree index | |
| US7571182B1 (en) | Emulation of a balanced hierarchy from a nonbalanced hierarchy | |
| CN102662974B (en) | A network graph index method based on adjacent node trees | |
| US9720986B2 (en) | Method and system for integrating data into a database | |
| US20110029507A1 (en) | Cardinality and selectivity estimation using a single table join index | |
| CN103577440A (en) | Data processing method and device in non-relational database | |
| CN101882163A (en) | Fuzzy Chinese address geographic evaluation method based on matching rule | |
| CN102135995A (en) | Extract transform and load (ETL) data cleaning design method | |
| CN103823823A (en) | Denormalization strategy selection method based on frequent item set mining algorithm | |
| WO2015180531A1 (en) | Indexing methods and systems for spatial data objects | |
| EP2909758A2 (en) | Systems and methods for interest-driven data sharing in interest-driven business intelligence systems | |
| CN103914456A (en) | Data storage method and system | |
| CN104699857A (en) | Big data storage method based on knowledge engineering | |
| CN104391908A (en) | Locality sensitive hashing based indexing method for multiple keywords on graphs | |
| CN101256579A (en) | Method for inquesting data organization in database | |
| CN102063466A (en) | Database forced access control method and system based on policy | |
| CN104102699A (en) | Subgraph searching method in cluster graph set | |
| Ravada et al. | Oracle8i spatial: Experiences with extensible databases | |
| CN100498793C (en) | Method for realizing two-dimensional predicate selectivity estimation by using wavelet-based compressed histogram | |
| CN103631839A (en) | Page region weight model implementation method | |
| CN103593409A (en) | Real-time database retrieval method and real-time database retrieval system |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| CB02 | Change of applicant information |
Address after: 100094 Haidian District North Road, Beijing, No. 68 Applicant after: Yonyou Network Technology Co., Ltd. Address before: 100094 Beijing city Haidian District North Road No. 68, UFIDA Software Park Applicant before: UFIDA Software Co., Ltd. |
|
| COR | Change of bibliographic data | ||
| C14 | Grant of patent or utility model | ||
| GR01 | Patent grant |