CN107341253A - A kind of method being updated according to data level to master data - Google Patents
A kind of method being updated according to data level to master data Download PDFInfo
- Publication number
- CN107341253A CN107341253A CN201710559044.1A CN201710559044A CN107341253A CN 107341253 A CN107341253 A CN 107341253A CN 201710559044 A CN201710559044 A CN 201710559044A CN 107341253 A CN107341253 A CN 107341253A
- Authority
- CN
- China
- Prior art keywords
- renewal
- data
- priority level
- field
- 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
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/28—Databases characterised by their database models, e.g. relational or object models
- G06F16/283—Multi-dimensional databases or data warehouses, e.g. MOLAP or ROLAP
-
- 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/23—Updating
- G06F16/235—Update request formulation
Abstract
The present invention relates to a kind of method being updated according to data level to master data, it is several master data latitude units first by the data setting in data warehouse, derived data is classified as some source data units, renewal priority level is then set, master data is updated according to renewal priority level, solves the problems, such as to update in master data processing procedure and integrates, simultaneously, with the characteristics of selective updating, renewal speed is fast.
Description
Technical field
The present invention relates to a kind of data-updating method, particularly relate to a kind of be updated master data according to data level
Method.
Background technology
In enterprise-level application, the basis of the master data of enterprise as all Information applications, is whole IT application in enterprises
Core, it is therefore, particularly important to the optimization processing of master data.
In the processing of traditional master data, the renewal processing to master data dimension data is always the problem of master data processing,
Particularly under data source environment complicated and changeable, to master data renewal processing be difficult to it is quick, accurate.With industry
Business, the explosive growth of data volume, under current mass data environment, further increase the solution difficulty of the problem.Specific real
If using being not added with its renewal speed right and wrong if screening carries out the methods that all renewal is replaced to the master data of enterprise when trampling
It is often slow, and it also requires the very high server of configuration rates can be realized, in the epoch this renewal side that big data is arrived
Formula is obvious not to be applicable, in addition if to master data and update method without innovation will necessarily occur bull data,
Data update not in time, data corruption phenomena such as, so as to influence the normal operation of enterprise, and this is lacked for the main of conventional art
Point.
The content of the invention
The present invention provides a kind of method being updated according to data level to master data, and the present invention is carried out to derived data
Conclude and be classified and master data is selectively updated according to data level, solve to update in master data processing procedure and integrate
The problem of, meanwhile, there is selective updating, the characteristics of renewal speed is fast, and this is for the main object of the present invention.
The technical solution adopted in the present invention is：A kind of method being updated according to data level to master data, it is wrapped
Include following steps.
The first step, it is several master data latitude units by the data setting in data warehouse, each master data latitude
Degree unit all includes some field informations.
Second step, derived data is classified as some source data units, each source data units includes some sources
Data field, the source data field in the source data units and one in the master data latitude unit
More new relation is established between the field information, to form several more new relations.
3rd step, to several more new relations in second step simultaneously renewal priority level is set, the more new relation with
The renewal priority level corresponds, and some renewal priority levels have different Update Levels respectively.
4th step, when checking any one in any one source data units source data field and having renewal
Wait, first, read this renewal priority level of more new relation corresponding to this source data field, the more new relation points to
One field information of one master data latitude unit, while source data field is read in other source data units of last time to the word
The last time renewal priority level of segment information, this renewal priority level is compared with last time renewal priority level, if,
This renewal priority level is less than last time renewal priority level and then abandons this renewal operation, if this renewal priority scheduling
Level is more than last time renewal priority level and then covers this source data field in the corresponding field information to main number
It is updated according to latitude unit.
In second step, the source data field in the source data units simultaneously with multiple master data latitudes
More new relation is established between the field information in unit.In 3rd step, the Update Level root of each renewal priority level
Set according to factors such as the renewal time of the source data units, data source department grades, the source that renewal is more timely, accuracy is higher
Data cell, it is higher that it updates priority setting.
It is if this renewal priority level is equal to last time renewal priority level that this renewal is preferential in 4th step
The renewal time of grade and the renewal time of last time renewal priority level are contrasted, during the renewal of this renewal priority level
Between be later than renewal time of last time renewal priority level and then abandon this renewal operation, during the renewal of this renewal priority level
Between this source data field then covered into the corresponding field believed earlier than renewal time of last time renewal priority level
Master data latitude unit is updated in breath.The master data latitude of record renewal when the renewal operation of the 4th step is carried out
The field information of unit, the source data field of renewal, the more new relation of renewal, the renewal priority level of renewal, renewal
Temporal information.
Beneficial effects of the present invention are：The present invention carries out concluding classification and according to data level to master data to derived data
It is selectively updated, solves the problems, such as to update in master data processing procedure and integrate, meanwhile, there is selective updating, more
New fireballing feature.
Brief description of the drawings
Fig. 1 is the principle block diagram of the present invention.
Principle block diagram when Fig. 2 is present invention specific implementation.
Fig. 3 is the schematic diagram of the renewal allocation list of the present invention.
Embodiment
As Figure 1-3, a kind of method being updated according to data level to master data, it comprises the following steps：
The first step, by the data setting in data warehouse it is several master data latitude units 10.
Each master data latitude unit 10 includes some field informations 11.
Such as by the data setting in data warehouse be master data latitude unit Z1, master data latitude unit Z2, master data
Latitude unit Z3, wherein, master data latitude unit Z1 is personal information, and master data latitude unit Z2 is information of vehicles, master data
Latitude unit Z3 is house property information.
Master data latitude unit Z1 includes some field informations 11, and some field informations 11 can be name field information
A1, age field information A2 and dead field information A3 etc..
Master data latitude unit Z2 includes some field informations 11, and some field informations 11 can be that time buying field is believed
Cease B1, field information B2 violating the regulations and transfer time field information B3.
Second step, derived data is classified as some source data units 20, if each source data units 20 includes
Dry source data field 21.
In the source data field 21 and the master data latitude unit 10 in the source data units 20
The field information 11 between establish more new relation 30, to form several more new relations 30.
, can also be in one in the source data units 20 source data field 21 simultaneously when specific implementation
More new relation 30 is established between the field information 11 in multiple master data latitude units 10.
3rd step, several more new relations 30 in second step are set with renewal priority level 40 simultaneously, the renewal is closed
It is 30 to be corresponded with the renewal priority level 40, some renewal priority levels 40 have different Update Levels respectively.
When specific implementation, the Update Level of each renewal priority level 40 is according to the source data units 20
The factors such as renewal time, data source department grade are set, the source data units that renewal is more timely, accuracy is higher, and it updates
Priority sets higher.
For example some renewal priority levels 40 are arranged to Update Level S1-S9 levels, source data in source data units C
More new relation 30 in field C1 and master data latitude unit Z1 between dead field information A3 is S1 levels.
Renewal in source data units C in source data field C2 and master data latitude unit Z2 between field information B2 violating the regulations
Relation 30 is S4 levels etc..
4th step, there is renewal when checking any one source data field 21 in any one source data units 20
When.
First, this renewal priority level 40 of more new relation 30 corresponding to this source data field 21 is read, should
More new relation 30 points to a field information 11 of a master data latitude unit 10.
It is excellent that last time renewal of the source data field 21 to the field information 11 in other source data units 20 of last time is read simultaneously
First class 40.
This renewal priority level 40 is compared with last time renewal priority level 40, if this renewal is excellent
First class 40 is less than last time renewal priority level 40 and then abandons this renewal operation.
By this source data field 21 if this renewal priority level 40 is more than last time renewal priority level 40
Cover in the corresponding field information 11 and master data latitude unit 10 is updated.
By this renewal priority level if this renewal priority level 40 is equal to last time renewal priority level 40
40 renewal time and the renewal time of last time renewal priority level 40 are contrasted.
The renewal time that the renewal time of this renewal priority level 40 is later than last time renewal priority level 40 then abandons
This renewal operation.
The renewal time of this renewal priority level 40 then incite somebody to action this earlier than the renewal time of last time renewal priority level 40
The secondary source data field 21 covers in the corresponding field information 11 and master data latitude unit 10 is updated.
The field information 11, more of the master data latitude unit 10 of record renewal when the renewal operation of the 4th step is carried out
The new source data field 21, the more new relation 30 of renewal, the information such as renewal priority level 40, the renewal time of renewal.
When specific implementation, renewal allocation list 100 can be set, i.e., by master data dimension word in method of the invention
Section more new relation corresponding with source data field and Update Level are configured in allocation list is updated.
Claims (5)
- A kind of 1. method being updated according to data level to master data, it is characterised in that：Comprise the following steps,The first step, it is several master data latitude units by the data setting in data warehouse, each master data latitude list Member all includes some field informations,Second step, derived data is classified as some source data units, each source data units includes some source datas Field, the source data field in the source data units and word in the master data latitude unit More new relation is established between segment information, to form several more new relations,3rd step, to several more new relations in second step simultaneously renewal priority level is set, the more new relation with this more New priority level corresponds, and some renewal priority levels have different Update Levels respectively,4th step, when checking any one in any one source data units source data field and having renewal, it is first First, this renewal priority level of more new relation corresponding to this source data field is read, the more new relation points to one One field information of master data latitude unit, while read source data field in other source data units of last time and the field is believed The last time renewal priority level of breath, this renewal priority level is compared with last time renewal priority level, if, this The renewal priority level is less than last time renewal priority level and then abandons this renewal operation, if this renewal priority level is big Then this source data field is covered in the corresponding field information to master data latitude in last time renewal priority level Degree unit is updated.
- A kind of 2. method being updated according to data level to master data as claimed in claim 1, it is characterised in that：Second In step, the source data field in the source data units simultaneously with the word in multiple master data latitude units More new relation is established between segment information.
- A kind of 3. method being updated according to data level to master data as claimed in claim 1, it is characterised in that：3rd In step, the Update Level of each renewal priority level is according to renewal times of the source data units, data source department etc. The setting of the factors such as level, the source data units that renewal is more timely, accuracy is higher, it is higher that it updates priority setting.
- A kind of 4. method being updated according to data level to master data as claimed in claim 1, it is characterised in that：4th In step, when if this renewal priority level being equal to last time renewal priority level by the renewal of this renewal priority level Between with last time renewal priority level renewal time contrasted,The renewal time that the renewal time of this renewal priority level is later than last time renewal priority level then abandons this renewal Operation,The renewal time of this renewal priority level updated the renewal time of priority level then by this source number earlier than last time Covered according to field in the corresponding field information and master data latitude unit is updated.
- A kind of 5. method being updated according to data level to master data as claimed in claim 1, it is characterised in that：Entering Field information, source data word of renewal of the master data latitude unit of record renewal when the renewal operation of the step of row the 4th Section, the more new relation of renewal, the renewal priority level of renewal, renewal time information.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201710559044.1A CN107341253B (en) | 2017-07-11 | 2017-07-11 | Method for updating main data according to data grade |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201710559044.1A CN107341253B (en) | 2017-07-11 | 2017-07-11 | Method for updating main data according to data grade |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN107341253A true CN107341253A (en) | 2017-11-10 |
| CN107341253B CN107341253B (en) | 2020-07-07 |
Family
ID=60217934
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201710559044.1A Active CN107341253B (en) | 2017-07-11 | 2017-07-11 | Method for updating main data according to data grade |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN107341253B (en) |
Citations (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN1889501A (en) * | 2006-07-25 | 2007-01-03 | 杭州华为三康技术有限公司 | Method and system for deciding bridge role |
| CN102289519A (en) * | 2011-09-14 | 2011-12-21 | 成都软智科技有限公司 | Application server and method for coordinating data of same and database |
| CN103530311A (en) * | 2012-07-05 | 2014-01-22 | 汤姆逊许可公司 | Method and apparatus for prioritizing metadata |
| CN103544323A (en) * | 2013-11-08 | 2014-01-29 | 中国农业银行股份有限公司 | Data updating method and device |
| CN106790549A (en) * | 2016-12-23 | 2017-05-31 | 北京奇虎科技有限公司 | A kind of data-updating method and device |
| US20170270210A1 (en) * | 2016-03-16 | 2017-09-21 | Sysomos L.P. | Data Infrastructure and Method for Ingesting and Updating A Continuously Evolving Social Network |
| US9779129B1 (en) * | 2013-09-11 | 2017-10-03 | Express Scripts, Inc. | Systems and methods for integrating data |
-
2017
- 2017-07-11 CN CN201710559044.1A patent/CN107341253B/en active Active
Patent Citations (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN1889501A (en) * | 2006-07-25 | 2007-01-03 | 杭州华为三康技术有限公司 | Method and system for deciding bridge role |
| CN102289519A (en) * | 2011-09-14 | 2011-12-21 | 成都软智科技有限公司 | Application server and method for coordinating data of same and database |
| CN103530311A (en) * | 2012-07-05 | 2014-01-22 | 汤姆逊许可公司 | Method and apparatus for prioritizing metadata |
| US9779129B1 (en) * | 2013-09-11 | 2017-10-03 | Express Scripts, Inc. | Systems and methods for integrating data |
| CN103544323A (en) * | 2013-11-08 | 2014-01-29 | 中国农业银行股份有限公司 | Data updating method and device |
| US20170270210A1 (en) * | 2016-03-16 | 2017-09-21 | Sysomos L.P. | Data Infrastructure and Method for Ingesting and Updating A Continuously Evolving Social Network |
| CN106790549A (en) * | 2016-12-23 | 2017-05-31 | 北京奇虎科技有限公司 | A kind of data-updating method and device |
Also Published As
| Publication number | Publication date |
|---|---|
| CN107341253B (en) | 2020-07-07 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| Zipkin et al. | Addressing data integration challenges to link ecological processes across scales | |
| Dobrovolski et al. | Climatic history and dispersal ability explain the relative importance of turnover and nestedness components of beta diversity | |
| Klenow et al. | Economic growth: A review essay | |
| Verde Arregoitia | Biases, gaps, and opportunities in mammalian extinction risk research | |
| Peterson et al. | Extrapolating inventory results into biodiversity estimates and the importance of stopping rules | |
| CN111159157B (en) | Index processing method and device for enterprise report data | |
| EP2965492B1 (en) | Selection of data storage settings for an application | |
| CN104036029A (en) | Big data consistency comparison method and system | |
| US10552399B2 (en) | Predicting index fragmentation caused by database statements | |
| Andone et al. | Using open education tools for a higher education virtual campus | |
| CN114169401A (en) | Data processing and prediction model training method and device | |
| Feldmeier et al. | Climate versus weather extremes: Temporal predictor resolution matters for future rather than current regional species distribution models | |
| Dambly et al. | Observer retention, site selection and population dynamics interact to bias abundance trends in bats | |
| CN109033173A (en) | It is a kind of for generating the data processing method and device of multidimensional index data | |
| CN103345527B (en) | Intelligent data statistical system | |
| Lee et al. | A big data management system for energy consumption prediction models | |
| Russell et al. | Estimating the spatial distribution of wintering little brown bat populations in the eastern United States | |
| Özden et al. | On the economic geography of international migration | |
| CN107341253A (en) | A kind of method being updated according to data level to master data | |
| Vanhille Campos et al. | A coupled food security and refugee movement model for the South Sudan conflict | |
| CN109388711A (en) | The method and apparatus of log stream cluster | |
| Shabashev et al. | The problems of developing the ecological market of the region | |
| Vesk | How traits determine species responses to environmental gradients | |
| Hartley et al. | What can new technology tell us about the reviewing process for journal submissions in BJET? | |
| CN109032580A (en) | A kind of production method that general data is reported to a higher authorities for approval and analyzes software |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant | ||
| CP01 | Change in the name or title of a patent holder |
Address after: 518000 zone a, 4th floor, building r1-a, 021 Gaoxin industrial village, South 4th Road, Gaoxin, Nanshan District, Shenzhen City, Guangdong Province Patentee after: Shenzhen Radio & TV Xinyi Technology Co.,Ltd. Address before: 518000 zone a, 4th floor, building r1-a, 021 Gaoxin industrial village, South 4th Road, Gaoxin, Nanshan District, Shenzhen City, Guangdong Province Patentee before: SHENZHEN XINYI TECHNOLOGY Co.,Ltd. |
|
| CP01 | Change in the name or title of a patent holder |