CN102867065B - Based on Data Transform Device and the method for relevant database - Google Patents
Based on Data Transform Device and the method for relevant database Download PDFInfo
- Publication number
- CN102867065B CN102867065B CN201210369871.1A CN201210369871A CN102867065B CN 102867065 B CN102867065 B CN 102867065B CN 201210369871 A CN201210369871 A CN 201210369871A CN 102867065 B CN102867065 B CN 102867065B
- Authority
- CN
- China
- Prior art keywords
- priority
- data
- path
- higher level
- dimension
- 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
Abstract
The invention provides a kind of Data Transform Device based on relevant database, comprising: definition unit, the priority of each dimension of definition business datum; Receiving element, receives the changing unit that user submits to; Search unit, in the higher level's data cell in multiple dimensions of changing unit, find out the higher level's data cell in the dimension that priority is the highest; Collection unit, carries out data summarization to the higher level's data cell in the highest dimension of priority from changing unit.According to technical scheme of the present invention, data typing in non-final stage dimension can be allowed, can the priority gathering path be judged, ensure that the combined data of higher level does not have ambiguity.Present invention also offers a kind of data summarization method based on relevant 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 summarization method based on relevant database.
Background technology
In the operation system of complexity, a lot of business datum all having levels property, the data of higher level's level need automatically to gather the business datum of subordinate's level in real time.
Automatically gather and require successively to be aggregated into higher level member in the data of final stage dimension member, the data of all higher level members are all calculated out through gathering by subordinate.
But under some business scenario, user may not directly in 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, user still wishes that the data of typing can be continued superior gather.That is, according to the hierarchical relationship of dimension, we cannot judge whether the data of user's typing are final stage data.
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 in organization dimensionality is: [department d] → [company a] → [group g];
Hierarchical relationship in subject dimension is: [travel expenses] → [managerial cost].
User fill in two data:
[3 July in season in 2011] [managerial cost] [department d]=3000;
[3 seasons in 2011] [travel expenses] [department d]=2000;
Should be so combined data as higher level [3 seasons in 2011] [managerial cost] [department d], its data be how many? 2000,3000,5000? or other?
Figure 1A illustrates the combined data under data inputting to final stage.Figure 1B illustrates data inputting to the combined data under non-final stage.
The reason of this puzzlement is not determine which is 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.When data only in final stage typing, no matter along any paths upwards gather, and result should be all the same, but when allow data in non-final stage dimension typing, do not judge the priority in path, data just have problem.
Therefore, need a kind of new summarized manner, allow data typing in non-final stage dimension, suitable path can be selected to gather, can ensure that the combined data of higher level does not have ambiguity.
Summary of the invention
The present invention, just based on the problems referred to above, proposes a kind of data summarization technology, allows data typing in non-final stage dimension, suitable path can be selected to gather, can ensure that the combined data of higher level 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, comprising: definition unit, the priority of each dimension of definition business datum; Receiving element, receives the changing unit that user submits to; Search unit, in the higher level's data cell in multiple dimensions of described changing unit, find out the higher level's data cell in the dimension that priority is the highest; Collection unit, carries out data summarization to the higher level's data cell in the highest dimension of described priority from described changing unit.
In this technical scheme, the priority of each dimension of predetermined definition, if data are in non-final stage typing, then select the dimension that priority is the highest, then upwards gathers from this dimension direction, so just can avoid the inconsistent of combined data.
In technique scheme, preferably, described collection unit comprises record subelement, and be recorded in described higher level's data cell for the dimension precedence information this gathered as the priority that this gathers path, described collection unit carries out data summarization according to the priority gathering path.
Each precedence information gathering path is recorded, in aggregation process afterwards, judges specifically how to gather according to this priority gathering path.
In technique scheme, preferably, described in search unit and comprise and compare subelement, recorded former when gathering path in described higher level's data cell, more described former gather path priority and described this gather the height of the priority in path; Described collection unit also comprises: replace subelement, the described priority that this gathers path higher than described former gather the priority in path time, when gathering, replace the combined data in the higher level's data cell in the highest dimension of described priority by the data of described changing unit.
This situation illustrates that the priority that gathers of Ben Weidu gathers priority higher than the original data of higher level, and that is just by combined data original for the combined data of Ben Weidu covering higher level.
In technique scheme, preferably, described collection unit can also comprise: extract subelement, the described priority that this gathers path equal described former gather the priority in path time, when gathering, the dimensional information according to described changing unit extracts metadata element from described relevant database; Computation subunit, calculates the difference between described changing unit and described metadata element; Cumulative subelement, from described changing unit, recurrence upwards gathers step by step, described difference is added in all described higher level's data cell of described changing unit.
This situation illustrate the original data of higher level gather priority and this to gather be same dimension, therefore only need to calculate this incremental data changed, and this incremental data is added to the former combined data of higher level gets on.
In technique scheme, preferably, described collection unit also for be less than in the described priority that this gathers path described former gather the priority in path time, abandon this and gather.
This situation illustrates that the original data of higher level are gathered up by the dimension of higher priority, abandons gathering of Ben Weidu.
According to a further aspect in the invention, additionally provide a kind of data summarization method based on relevant database, comprise the following steps: step 402, the priority of each dimension of definition business datum;
Step 404, receives the changing unit that user submits to; Step 406, in the higher level's data cell in multiple dimensions of described changing unit, finds out the higher level's data cell in the dimension that priority is the highest; Step 408, carries out data summarization to the higher level's data cell in the highest dimension of described priority from described changing unit.
In this technical scheme, the priority of each dimension of predetermined definition, if data are in non-final stage typing, then select the dimension that priority is the highest, then upwards gathers from this dimension direction, so just can avoid the inconsistent of combined data.
In technique scheme, preferably, described step 408 can also comprise: the dimension precedence information this gathered is recorded in described higher level's data cell as the priority that this gathers path, and the priority according to gathering path carries out data summarization.
Each precedence information gathering path is recorded, in aggregation process afterwards, judges specifically how to gather according to this priority gathering path.
In technique scheme, preferably, described step 406 can also comprise: recorded former when gathering path in described higher level's data cell, more described former gather path priority and described this gather the height of the priority in path; Described step 408 also comprises: the described priority that this gathers path higher than described former gather the priority in path time, when gathering, replace the data in the higher level's data cell in the highest dimension of described priority by the data of described changing unit.
This situation illustrates that the priority that gathers of Ben Weidu gathers priority higher than the original data of higher level, and that is just by combined data original for the combined data of Ben Weidu covering higher level.
In technique scheme, preferably, described step 408 can also comprise: the described priority that this gathers path equal described former gather the priority in path time, when gathering, dimensional information according to described changing unit extracts metadata element from described relevant database, and calculates the difference between described changing unit and described metadata element; From described changing unit, recurrence upwards gathers step by step, described difference is added in all described higher level's data cell of described changing unit.
This situation illustrate the original data of higher level gather priority and this to gather be same dimension, therefore only need to calculate this incremental data changed, and this incremental data is added to the former combined data of higher level gets on.
In technique scheme, preferably, the described priority that this gathers path be less than described former gather the priority in path time, abandon this and gather.
This situation illustrates that the original data of higher level are gathered up by the dimension of higher priority, abandons gathering of Ben Weidu.
Under the present invention proposes a kind of business scenario allowing non-final stage data inputting, by definition dimension on gather priority, exist multiple when gathering path in systems in which, by selecting a preferred path, realize data the end of from gather, the problem under similar business scenario can be solved.
Accompanying drawing explanation
Figure 1A shows and gathers schematic diagram from final stage logging data;
Figure 1B shows and gathers schematic diagram from non-final stage logging data;
Fig. 2 A to Fig. 2 C shows dimensional structure figure according to an embodiment of the invention;
Fig. 3 shows according to an embodiment of the invention based on the block diagram of the Data Transform Device of relevant database;
Fig. 4 shows the process flow diagram of the data summarization method based on relevant database according to an embodiment of the invention;
Fig. 5 shows the process flow diagram of the data summarization method based on relevant database according to still another embodiment of the invention.
Embodiment
In order to more clearly 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 a lot of detail in the following description so that fully understand the present invention, but 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.
First composition graphs 2A to Fig. 2 C illustrates expression and the storage of multidimensional data in an embodiment of the present invention.
For business datum, need the dimension (Dimension) of preliminary setting data.
Dimension (Dimension): the special angle being people's observed data, be generic attribute when considering a problem, community set forms dimension, such as a time dimension, organization dimensionality, product dimension etc.
The level (Level) of dimension: be the further segmentation to dimension, as time dimension can be subdivided into, year level, season level, the moon level.
The member (Member) of dimension: the concrete value of dimension is the description of data position in certain dimension, if " in March, 2012 " is the description of the position of data on time dimension.
By defining multiple different dimension, can observation and analysis data more neatly, the hierarchical relationship of each dimension stores with tree structure, is convenient to gathering of data like this.
Cube (Cube): the data carrier be made up of multiple dimension, Cube is just as a coordinate system, and each dimension (Dimension) wherein represents a coordinate axis.
For the ease of understanding the present invention more clearly, in an embodiment of the present invention for three-dimensional, give dimensional structure figure, as shown in Fig. 2 A to Fig. 2 C.
In the following embodiments, use RDBMS(relationaldatabasemanagementsystem, 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 | Department d | Travel expenses | 5000 |
2011.3.~.O1.CL | 2011 | 3 | ~ | Department d | Travel expenses | 8000 |
2011.~.~.O1.CL | 2011 | ~ | ~ | Department d | Travel expenses | 32000 |
As can be seen from data above, combined data (last column data) and final stage data (the first row data) exist inside same database table.Wherein these row of coordinate are the major key fields each dimension, after compressing mapping, combine and a character string of formation, and coordinate fields is that full table is unique, and two row data can not be had to have the coordinate figure of repetition.According to coordinate figure, the value of multidimensional data easily and accurately can be inquired.The object of compressing mapping is to reduce storage space, improves performance and the efficiency of inquiry simultaneously.
Fig. 3 shows according to an embodiment of the invention based on the block diagram of the Data Transform Device of relevant database.
As shown in Figure 3, according to an embodiment of the invention based on the Data Transform Device 300 of relevant database, comprising: definition unit 302, the priority of each dimension of definition business datum; Receiving element 304, receives the changing unit that user submits to; Search unit 306, in the higher level's data cell in multiple dimensions of described changing unit, find out the higher level's data cell in the dimension that priority is the highest; Collection unit 308, carries out data summarization to the higher level's data cell in the highest dimension of described priority from described changing unit.
In this technical scheme, the priority of each dimension of predetermined definition, if data are in non-final stage typing, then select the dimension that priority is the highest, then upwards gathers from this dimension direction, so just can avoid the inconsistent of combined data.
In technique scheme, preferably, described collection unit 308 comprises record subelement 3082, dimension precedence information for this being gathered is recorded in described higher level's data cell as the priority that this gathers path, and described collection unit 308 carries out data summarization according to the priority gathering path.
Each precedence information gathering path is recorded, in aggregation process afterwards, judges specifically how to gather according to this priority gathering path.
In technique scheme, preferably, described in search unit 306 and comprise and compare subelement 3062, recorded former when gathering path in described higher level's data cell, more described former gather path priority and described this gather the height of the priority in path; Described collection unit 308 also comprises: replace subelement 3084, the described priority that this gathers path higher than described former gather the priority in path time, when gathering, replace the combined data in the higher level's data cell in the highest dimension of described priority by the data of described changing unit.
This situation illustrates that the priority that gathers of Ben Weidu gathers priority higher than the original data of higher level, and that is just by combined data original for the combined data of Ben Weidu covering higher level.
In technique scheme, preferably, described collection unit 308 can also comprise: extract subelement 3086, the described priority that this gathers path equal described former gather the priority in path time, when gathering, the dimensional information according to described changing unit extracts metadata element from described relevant database; Computation subunit 3088, calculates the difference between described changing unit and described metadata element; Cumulative subelement 30810, from described changing unit, recurrence upwards gathers step by step, described difference is added in all described higher level's data cell of described changing unit.
This situation illustrate the original data of higher level gather priority and this to gather be same dimension, therefore only need to calculate this incremental data changed, and this incremental data is added to the former combined data of higher level gets on.
In technique scheme, preferably, described collection unit 308 also for be less than in the described priority that this gathers path described former gather the priority in path time, abandon this and gather.
This situation illustrates that the original data of higher level are gathered up by the dimension of higher priority, abandons gathering of Ben Weidu.
Allow data typing in non-final stage dimension according to Data Transform Device of the present invention, suitable path can be selected to gather, can ensure that the combined data of higher level does not have ambiguity
Fig. 4 shows according to an embodiment of the invention based on the process flow diagram of the data summarization method of relevant database.
As shown in Figure 4, according to an embodiment of the invention based on the data summarization method of relevant database, comprise the following steps: step 402, the priority of each dimension of definition business datum; Step 404, receives the changing unit that user submits to; Step 406, in the higher level's data cell in multiple dimensions of changing unit, finds out the higher level's data cell in the dimension that priority is the highest; Step 408, carries out data summarization to the higher level's data cell in the highest dimension of priority from changing unit.
In this technical scheme, the priority of each dimension of predetermined definition, if data are in non-final stage typing, then select the dimension that priority is the highest, then upwards gathers from this dimension direction, so just can avoid the inconsistent of combined data.
In technique scheme, preferably, step 408 can also comprise: the dimension precedence information this gathered is recorded in described higher level's data cell as the priority that this gathers path, and the priority according to gathering path carries out data summarization.
Each precedence information gathering path is recorded, in aggregation process afterwards, judges specifically how to gather according to this priority gathering path.
In technique scheme, preferably, described step 406 can also comprise: recorded former when gathering path in described higher level's data cell, more described former gather path priority and described this gather the height of the priority in path; Described step 408 can also comprise: the described priority that this gathers path higher than described former gather the priority in path time, when gathering, replace the data in the higher level's data cell in the highest dimension of described priority by the data of described changing unit.
This situation illustrates that the priority that gathers of Ben Weidu gathers priority higher than the original data of higher level, and that is just by combined data original for the combined data of Ben Weidu covering higher level.
In technique scheme, preferably, described step 408 can also comprise: the described priority that this gathers path equal described former gather the priority in path time, when gathering, dimensional information according to described changing unit extracts metadata element from described relevant database, and calculates the difference between described changing unit and described metadata element; From described changing unit, recurrence upwards gathers step by step, described difference is added in all described higher level's data cell of described changing unit.
This situation illustrate the original data of higher level gather priority and this to gather be same dimension, therefore only need to calculate this incremental data changed, and this incremental data is added to the former combined data of higher level gets on.
In technique scheme, preferably, the described priority that this gathers path be less than described former gather the priority in path time, abandon this and gather.
This situation illustrates that the original data of higher level are gathered up by the dimension of higher priority, abandons 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 the path of high priority be automatically selected to gather when gathering, such as, the priority of definition time dimension is 9 in the example in fig. 1b, and the priority of subject dimension is 8, the priority of organization dimensionality is 7, and that is dimension priority orders is: time > subject > organizes.
When gathering, if certain higher level has multiple bottom-ranked unit, system can dimension residing for the different dimension of bottom-ranked unit and superordinate elements different, and the high bottom-ranked unit of prioritizing selection priority gathers.
In the above example, the priority due to time dimension is greater than subject dimension, therefore system meeting prioritizing selection: [3 July in season in 2011] [managerial cost] [department d]=3000.Gather based on this data superior, the combined data of last [3 seasons in 2011] [managerial cost] [department d] is 3000.
Two. gather the description of algorithm
Use in the present embodiment recursive algorithm the end of from carry out the calculating that increment gathers, from the data cell in the changing unit set C of user's typing, recurrence upwards gathers.
In step 502, judge whether there is remaining data cell (cell) in changing unit set C, data cell (cell) can be understood as the data line in changing unit set C, such as, the first row data in upper table.If judged remaining data cell, then carry out data summarization based on this data cell.
In step 504, the difference between the new data of this user's typing and the data of a upper version, calculates data increment diff.
In step 506, when certain dimension upwards gathers, preferentially inquire priority the most high-dimensional on father's cell, what calculate that this time gather gathers priority v simultaneously, and this numerical priority value is recorded in father's cell as gathering path.
In step 508, judge whether the coordinate of father's cell is empty, if it is empty, entering step 516, judging whether the higher level's data cell that there is next dimension.If not empty, then step 510 is entered.
In step 510, find out the data of higher level's data cell.
In step 512, if find when gathering that father's unit has existed to gather path v0, and when the secondary priority v that gathers gathered compares, namely judge whether current path equals original route, if so, then enters step 514, if not, then enter step 518.
In step 514, if v0=v, the original data of higher level gather priority and this to gather be same dimension, need to calculate this incremental data changed, and this incremental data is added to the former combined data of higher level gets on.Then based on father's unit, recursive call is proceeded, until aggregation process terminates.
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, illustrate that the priority that gathers of Ben Weidu gathers priority higher than the original data of higher level, then enter step 520, by combined data original for the data cover higher level of user's typing.Then based on father's unit, recursive call is proceeded, until aggregation process terminates.If v0>v, illustrate that the original data of higher level are gathered up by the dimension of higher priority, abandon gathering of Ben Weidu.
Here is that the Java gathering algorithm key component illustrates that code is as follows:
/ * * increment gather main-inlet method */
Complete after gathering calculating, in database, write the data of change, affairs complete.
In sum, under the present invention proposes a kind of business scenario allowing non-final stage data inputting, by definition dimension on gather priority, exist multiple when gathering path in systems in which, by selecting a preferred path, realize data the end of from gather, the problem under similar business scenario can be solved, therefore, the present invention can be applicable to the business scope needing multi-dimensional data to be carried out to System, and the business scenario in the inconsistent situation of multiple paths combined data of multidimensional data.
The foregoing is only the preferred embodiments of the present invention, be not limited to the present invention, 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 amendment done, equivalent replacement, improvement etc., all should be included within protection scope of the present invention.
Claims (6)
1. based on a Data Transform Device for relevant database, it is characterized in that, comprising:
Definition unit, the priority of each dimension of definition business datum;
Receiving element, receives the changing unit that user submits to;
Search unit, in the higher level's data cell in multiple dimensions of described changing unit, find out the higher level's data cell in the dimension that priority is the highest;
Collection unit, carries out data summarization to the higher level's data cell in the highest dimension of described priority from described changing unit;
Described collection unit comprises record subelement, and be recorded in described higher level's data cell for the dimension precedence information this gathered as the priority that this gathers path, described collection unit carries out data summarization according to the priority gathering path;
Described unit of searching comprises and compares subelement, has recorded former when gathering path in described higher level's data cell, more described former gather path priority and described this gather the height of the priority in path;
Described collection unit also comprises: replace subelement, the described priority that this gathers path higher than described former gather the priority in path time, when gathering, replace the combined data in the higher level's data cell in the highest dimension of described priority by the data of described changing unit.
2. the Data Transform Device based on relevant database according to claim 1, it is characterized in that, described collection unit also comprises: extract subelement, the described priority that this gathers path equal described former gather the priority in path time, when gathering, the dimensional information according to described changing unit extracts metadata element from described relevant database;
Computation subunit, calculates the difference between described changing unit and described metadata element;
Cumulative subelement, from described changing unit, recurrence upwards gathers step by step, described difference is added in all described higher level's data cell of described changing unit.
3. the Data Transform Device based on relevant database according to claim 1, is characterized in that, described collection unit also for be less than in the described priority that this gathers path described former gather the priority in path time, abandon this and gather.
4. based on a data summarization method for relevant database, it is characterized in that, comprise the following steps:
Step 402, the priority of each dimension of definition business datum;
Step 404, receives the changing unit that user submits to;
Step 406, in the higher level's data cell in multiple dimensions of described changing unit, finds out the higher level's data cell in the dimension that priority is the highest;
Step 408, carries out data summarization to the higher level's data cell in the highest dimension of described priority from described changing unit;
Described step 408 also comprises: the dimension precedence information this gathered is recorded in described higher level's data cell as the priority that this gathers path, and the priority according to gathering path carries out data summarization;
Described step 406 also comprises: recorded former when gathering path in described higher level's data cell, more described former gather path priority and described this gather the height of the priority in path;
Described step 408 also comprises: the described priority that this gathers path higher than described former gather the priority in path time, when gathering, replace the data in the higher level's data cell in the highest dimension of described priority by the data of described changing unit.
5. the data summarization method based on relevant database according to claim 4, it is characterized in that, described step 408 also comprises: the described priority that this gathers path equal described former gather the priority in path time, when gathering, dimensional information according to described changing unit extracts metadata element from described relevant database, and calculates the difference between described changing unit and described metadata element;
From described changing unit, recurrence upwards gathers step by step, described difference is added in all described higher level's data cell of described changing unit.
6. the data summarization method based on relevant database according to claim 4, is characterized in that, the described priority that this gathers path be less than described former gather the priority in path time, abandon this and gather.
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 CN102867065A (en) | 2013-01-09 |
CN102867065B true 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) |
Families Citing this family (7)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
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 |
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 |
Citations (4)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
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 |
Family Cites Families (1)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US7418438B2 (en) * | 2004-11-30 | 2008-08-26 | International Business Machines Corporation | Automated default dimension selection within a multidimensional enterprise software system |
-
2012
- 2012-09-28 CN CN201210369871.1A patent/CN102867065B/en active Active
Patent Citations (4)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
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 |
Also Published As
Publication number | Publication date |
---|---|
CN102867065A (en) | 2013-01-09 |
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 | |
CN104123374B (en) | The method and device of aggregate query in distributed data base | |
Rao et al. | Spatial hierarchy and OLAP-favored search in spatial data warehouse | |
CN105493085B (en) | Create method, system and the computer readable storage medium of the sample of database table | |
CA2815815C (en) | Anonymizer device | |
JP2004518226A (en) | Database system and query optimizer | |
CN101957852A (en) | Method and system for producing correlation information of table data | |
WO2014066052A2 (en) | Systems and methods for interest-driven data sharing in interest-driven business intelligence systems | |
CN103914456A (en) | Data storage method and system | |
CN102063466B (en) | Database forced access control method and system based on policy | |
CN107491476A (en) | A kind of data model translation and query analysis method suitable for a variety of big data management systems | |
CN116775661A (en) | Big space data storage and management method based on Beidou grid technology | |
CN103678682B (en) | Magnanimity raster data processing and management method based on abstraction templates | |
Ravada et al. | Oracle8i spatial: Experiences with extensible databases | |
CN102214216B (en) | Aggregation summarization method for keyword search result of hierarchical relation data | |
CN108197187A (en) | Optimization method, device, storage medium and the computer equipment of query statement | |
CN100573511C (en) | Produce the system and method for the self-defined hierarchical system of analyzing data structure | |
CN103631839A (en) | Page region weight model implementation method | |
CN104537047A (en) | Garment basic sample plate retrieval system based on Lucene | |
CN109919225A (en) | A kind of user interest point knowledge method for distinguishing based on space-time data | |
JP2001216307A (en) | Relational database management system and storage medium stored with same | |
Vespa et al. | Efficient bulk-loading on dynamic metric access methods | |
Viswanathan et al. | User-centric spatial data warehousing: a survey of requirements and approaches |
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 |