CN104484429A - Data contrast analysis method and data contrast analysis system - Google Patents
Data contrast analysis method and data contrast analysis system Download PDFInfo
- Publication number
- CN104484429A CN104484429A CN201410796564.0A CN201410796564A CN104484429A CN 104484429 A CN104484429 A CN 104484429A CN 201410796564 A CN201410796564 A CN 201410796564A CN 104484429 A CN104484429 A CN 104484429A
- Authority
- CN
- China
- Prior art keywords
- data
- field
- corresponding relation
- new
- check analysis
- 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.)
- Pending
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/21—Design, administration or maintenance of databases
- G06F16/219—Managing data history or versioning
-
- 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/21—Design, administration or maintenance of databases
- G06F16/214—Database migration support
Landscapes
- Engineering & Computer Science (AREA)
- Databases & Information Systems (AREA)
- Theoretical Computer Science (AREA)
- Data Mining & Analysis (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention discloses a data contrast analysis method and a data contrast analysis system. The method comprises the following steps: determining whether corresponding relation between target field data in new and old systems exists, and performing corresponding relation marking and corresponding information remarking, thereby establishing the corresponding relationship between field data of the new and old systems. According to the method and the device, the subsequent data migration from the old system to the new system is convenient, and the problem that data migration is difficult to realize due to different data acquisition modes and different data formats of the new and old systems can be solved.
Description
Technical field
The present invention relates to field of data migration, particularly relate to a kind of data check analysis method and system.
Background technology
In the new systematic procedure of construction, need to carry out the work such as database design, data migration.Data correspondence in old system is moved in new system and goes.
New-old system because the not equal reason of the length of the difference of data acquisition modes or data item is difficult to the migration work directly carrying out data, may carry out the corresponding relation analysis of new-old system data, may have problems after Direct Transfer.
Summary of the invention
In view of this, fundamental purpose of the present invention is to provide a kind of data check analysis method and system, can analyze the corresponding relation setting up new-old system data.
For achieving the above object, the invention provides a kind of data check analysis method, comprising:
Determine aiming field data;
Judge whether described aiming field data exist corresponding relation in described the first system and described second system;
Arrange about the mark of corresponding relation and remark information according to the result judged;
The described result according to judging arranges and comprises about the mark of corresponding relation and remark information:
When described field data directly can set up corresponding relation in described the first system and described second system, corresponding relation is labeled as and is, when described field data does not exist in described second system, described corresponding relation is labeled as no, when described field data exists in described the first system, and need the described field data in described second system to carry out being labeled as conversion to corresponding relation time corresponding with the field data in described the first system by calculating conversion, and remarks calculate transformation rule, when described field data does not exist the default value needing to retain field data described in described second system in described the first system, corresponding relation is labeled as acquiescence, and remarks default value.
Preferably, arrange according to the result judged and also comprise about after the mark of corresponding relation and remark information:
The new field increased in described second system.
Preferably, also comprise after the new field increased in described second system:
Quote for described new field select target dictionary.
Preferably, also comprise after quoting for described new field select target dictionary:
Determining the data source dictionary of the field data needing amendment, quoting all field datas of described data source dictionary by revising described data source dictionary updating.
Present invention also offers a kind of data check analysis system, comprising:
First determination module, for determining aiming field data;
Judge module, for judging whether described aiming field data can set up corresponding relation in described the first system and described second system;
Mark remarks module, for arranging mark about corresponding relation and remark information according to the result judged.
Preferably, described data check analysis system also comprises:
Newly-built field module, for the new field increased in described second system.
Preferably, described data check analysis system also comprises:
Quote module, for quoting for described new field select target dictionary.
Preferably, described data check analysis system also comprises:
Second determination module, for determining the data source dictionary of the field data needing amendment;
Modified module, for quoting all field datas of described data source dictionary by the described data source dictionary updating of amendment.
Apply a kind of data check analysis method and system provided by the invention, whether the aiming field data according to the new-old system judged exist corresponding relation, carry out the mark of corresponding relation and the remarks of corresponding informance, thus set up the corresponding relation of field data between new-old system, facilitate and follow-uply carry out the Data Migration of old system data to new system, can solve that new-old system data acquisition modes is different and data layout is different and be difficult to carry out the problem of Data Migration.
Accompanying drawing explanation
In order to be illustrated more clearly in the embodiment of the present invention or technical scheme of the prior art, be briefly described to the accompanying drawing used required in embodiment or description of the prior art below, apparently, accompanying drawing in the following describes is only embodiments of the invention, for those of ordinary skill in the art, under the prerequisite not paying creative work, other accompanying drawing can also be obtained according to the accompanying drawing provided.
Fig. 1 is the process flow diagram of a kind of data check analysis of the present invention method;
Fig. 2 is the surface chart of data check analysis method specific embodiment of the present invention;
Fig. 3 is the another process flow diagram of a kind of data of the present invention check analysis method;
Fig. 4 is the specific embodiment surface chart of data check analysis method of the present invention;
Fig. 5 is the another process flow diagram of a kind of data of the present invention check analysis method;
Fig. 6 is the structural representation of a kind of data check analysis of the present invention system;
Fig. 7 is the another structural representation of a kind of data of the present invention check analysis system;
Fig. 8 is the another structural representation of a kind of data of the present invention check analysis system.
Embodiment
Below in conjunction with the accompanying drawing in the embodiment of the present invention, be clearly and completely described the technical scheme in the embodiment of the present invention, obviously, described embodiment is only the present invention's part embodiment, instead of whole embodiments.Based on the embodiment in the present invention, those of ordinary skill in the art, not making the every other embodiment obtained under creative work prerequisite, belong to the scope of protection of the invention.
The invention provides a kind of data check analysis method, as shown in Figure 1, be the process flow diagram of data check analysis method specific embodiment of the present invention, comprise:
Step S101: determining will from aiming field data;
Step S102: judge whether described aiming field data exist corresponding relation in described the first system and described second system;
Step S103: arrange about the mark of corresponding relation and remark information according to the result judged.
The above-mentioned result according to judging arranges and specifically can comprise about the mark of corresponding relation and remark information:
When described field data directly can set up corresponding relation in described the first system and described second system, corresponding relation is labeled as and is, when described field data does not exist in described second system, described corresponding relation is labeled as no, when described field data exists in described the first system, and need the described field data in described second system to carry out being labeled as conversion to corresponding relation time corresponding with the field data in described the first system by calculating conversion, and remarks calculate transformation rule, when described field data does not exist the default value needing to retain field data described in described second system in described the first system, corresponding relation is labeled as acquiescence, and remarks default value.
The first system is old system, second system is new system, the different situations that whether there is corresponding relation according to the field data of new-old system arrange corresponding mark and remark information, be illustrated in figure 2 specific embodiment interface when setting up corresponding relation, the kind of mark has, no, conversion and default value, when being labeled as conversion, remarks calculate transformation rule, remarks default value information when being labeled as acquiescence, data items length can be solved inconsistent, the problem that Data Source is inconsistent, if legacy system field data is typing, the data of new system corresponding field are that calculating converts.
Apply a kind of data check analysis method provided by the invention, whether the aiming field data according to the new-old system judged exist corresponding relation, carry out the mark of corresponding relation and the remarks of corresponding informance, thus set up the corresponding relation of field data between new-old system, facilitate and follow-uply carry out the Data Migration of old system data to new system, can solve that new-old system data acquisition modes is different and data layout is different and be difficult to carry out the problem of Data Migration.
As shown in Figure 3, be the another embodiment process flow diagram of data check analysis method of the present invention, corresponding to Fig. 1, also comprise:
Step S104: the new field increased in described second system;
Step S105: quote for described new field select target dictionary.
The present embodiment can increase new field and REFER object dictionary for new system.As shown in Figure 4, for the specific embodiment interface of newly-built field, in figure, sequence number 36 data line is newly-built field, and the data of this field are dictionary items, concrete dictionary codomain is the content of data dictionary [sx221] item, and therefore this field quotes dictionary [sx221].The detailed content selecting [quoting] namely to eject this dictionary is quoted, or reselects new dictionary.
As shown in Figure 5, be the another embodiment process flow diagram of data check analysis method of the present invention, corresponding to Fig. 3, also comprise:
Step S106: the data source dictionary determining the field data needing amendment, quotes all field datas of described data source dictionary by revising described data source dictionary updating.
Because the foundation of field all refer to data source dictionary, based on the feature quoted, the present embodiment can carry out the amendment of the data to this dictionary of all references by the dictionary in Update Table source, without the need to searching amendment one by one, time large for system data amount, effect is especially obvious.
Present invention also offers a kind of data check analysis system, as shown in Figure 6, be the example structure schematic diagram of data check analysis system of the present invention, comprise:
First determination module 101, for determining aiming field data;
Judge module 102, for judging whether described aiming field data can set up corresponding relation in described the first system and described second system;
Mark remarks module 103, for arranging mark about corresponding relation and remark information according to the result judged.
The data check analysis system that application the present embodiment provides, by judging whether the field data of new-old system exists corresponding relation by before the Data Migration of old system to new system, arrange about the mark of corresponding relation and remarks by judged result, according to described mark and remarks, old system data is migrated in new system, new-old system data acquisition modes difference and data layout not parity problem can be solved.
As shown in Figure 7, be the another example structure schematic diagram of data check analysis system of the present invention, corresponding to Fig. 6, also comprise:
Newly-built field module 104, for the new field increased in described second system.
Quote module 105, for quoting for described new field select target dictionary.
As shown in Figure 8, be the another example structure schematic diagram of data check analysis system of the present invention, corresponding to Fig. 7, also comprise:
Second determination module 106, for determining the data source dictionary of the field data needing amendment;
Modified module 107, for quoting all field datas of described data source dictionary by the described data source dictionary updating of amendment.
The system of the present embodiment can be used as information acquisition system, for the working method of alternative paper trail.Because all data are quoted all mutually, compare and use the required maintenance of paper trail more convenient, more clear, greatly reduce the workload of maintenance, only need Update Table source the overall situation to upgrade.
The content gathered comprises: new-old system data list structure, new-old system data dictionary item, and new-old system data sheet field contrasts and processes and new-old system data dictionary contrasts and process.
The information of all collections of system is the development for follow-up Data Migration software function, needs to collect result contrast relationship with reference to these during exploitation, can be got information about data corresponding relation and the data dictionary relation of new legacy system by system most.
It should be noted that, each embodiment in this instructions all adopts the mode of going forward one by one to describe, and what each embodiment stressed is the difference with other embodiments, between each embodiment identical similar part mutually see.
Finally, also it should be noted that, in this article, the such as relational terms of first and second grades and so on is only used for an entity or operation to separate with another entity or operational zone, and not necessarily requires or imply the relation that there is any this reality between these entities or operation or sequentially.And, term " comprises ", " comprising " or its any other variant are intended to contain comprising of nonexcludability, thus make to comprise the process of a series of key element, method, article or equipment and not only comprise those key elements, but also comprise other key elements clearly do not listed, or also comprise by the intrinsic key element of this process, method, article or equipment.When not more restrictions, the key element limited by statement " comprising ... ", and be not precluded within process, method, article or the equipment comprising described key element and also there is other identical element.
Be described in detail method and system provided by the present invention above, apply specific case herein and set forth principle of the present invention and embodiment, the explanation of above embodiment just understands method of the present invention and core concept thereof for helping; Meanwhile, for one of ordinary skill in the art, according to thought of the present invention, all will change in specific embodiments and applications, in sum, this description should not be construed as limitation of the present invention.
Claims (8)
1. a data check analysis method, is characterized in that, comprising:
Determine aiming field data;
Judge whether described aiming field data exist corresponding relation in described the first system and described second system;
Arrange about the mark of corresponding relation and remark information according to the result judged;
Described setting according to judged result comprises about the mark of corresponding relation and remark information:
When described field data directly can set up corresponding relation in described the first system and described second system, corresponding relation is labeled as and is, when described field data does not exist in described second system, described corresponding relation is labeled as no, when described field data exists in described the first system, and need the described field data in described second system to carry out being labeled as conversion to corresponding relation time corresponding with the field data in described the first system by calculating conversion, and remarks calculate transformation rule, when described field data does not exist the default value needing to retain field data described in described second system in described the first system, corresponding relation is labeled as acquiescence, and remarks default value.
2. data check analysis method according to claim 1, is characterized in that, arranges also comprise about after the mark of corresponding relation and remark information according to the result judged:
The new field increased in described second system.
3. data check analysis method according to claim 2, is characterized in that, also comprises after the new field increased in described second system:
Quote for described new field select target dictionary.
4. data check analysis method according to claim 3, is characterized in that, also comprises for described new field select target dictionary after quoting:
Determining the data source dictionary of the field data needing amendment, quoting all field datas of described data source dictionary by revising described data source dictionary updating.
5. a data check analysis system, is characterized in that, comprising:
First determination module, for determining aiming field data;
Judge module, for judging whether described aiming field data can set up corresponding relation in described the first system and described second system;
Mark remarks module, for arranging mark about corresponding relation and remark information according to the result judged.
6. data check analysis system according to claim 5, is characterized in that, also comprise:
Newly-built field module, for the new field increased in described second system.
7. data check analysis system according to claim 6, is characterized in that, also comprise:
Quote module, for quoting for described new field select target dictionary.
8. data check analysis system according to claim 7, is characterized in that, also comprise:
Second determination module, for determining the data source dictionary of the field data needing amendment;
Modified module, for quoting all field datas of described data source dictionary by the described data source dictionary updating of amendment.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201410796564.0A CN104484429A (en) | 2014-12-18 | 2014-12-18 | Data contrast analysis method and data contrast analysis system |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201410796564.0A CN104484429A (en) | 2014-12-18 | 2014-12-18 | Data contrast analysis method and data contrast analysis system |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN104484429A true CN104484429A (en) | 2015-04-01 |
Family
ID=52758970
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201410796564.0A Pending CN104484429A (en) | 2014-12-18 | 2014-12-18 | Data contrast analysis method and data contrast analysis system |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN104484429A (en) |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN107122476A (en) * | 2017-05-02 | 2017-09-01 | 山东浪潮通软信息科技有限公司 | The treating method and apparatus of publicly-owned data under a kind of network isolation mode |
Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US5021992A (en) * | 1986-08-28 | 1991-06-04 | Hitachi, Ltd. | Method of translating data from knowledge base to data base |
| CN101706803A (en) * | 2009-11-27 | 2010-05-12 | 天津工业大学 | Method for migrating production data of weaving workshop |
| CN103176989A (en) * | 2011-12-21 | 2013-06-26 | 中国银联股份有限公司 | Method and system used for comparing database table levels and based on data dictionary and variable rules |
-
2014
- 2014-12-18 CN CN201410796564.0A patent/CN104484429A/en active Pending
Patent Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US5021992A (en) * | 1986-08-28 | 1991-06-04 | Hitachi, Ltd. | Method of translating data from knowledge base to data base |
| CN101706803A (en) * | 2009-11-27 | 2010-05-12 | 天津工业大学 | Method for migrating production data of weaving workshop |
| CN103176989A (en) * | 2011-12-21 | 2013-06-26 | 中国银联股份有限公司 | Method and system used for comparing database table levels and based on data dictionary and variable rules |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN107122476A (en) * | 2017-05-02 | 2017-09-01 | 山东浪潮通软信息科技有限公司 | The treating method and apparatus of publicly-owned data under a kind of network isolation mode |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN101770479B (en) | Association relationship query method and device | |
| CN102646103B (en) | The clustering method of term and device | |
| CN106204285A (en) | Insurance rules process method based on cloud computing and system | |
| CN103412868A (en) | Method and device for generating document | |
| CN103593456A (en) | Form user-defined design method and device | |
| CN104519072A (en) | Authority control method and device | |
| CN103645905B (en) | A kind of incremental data acquisition method and device | |
| CN104268247A (en) | Master data imputation method based on fuzzy analytic hierarchy process | |
| CN104133870A (en) | Web page similarity calculation method and web page similarity calculation device | |
| CN103309801A (en) | Method and device for determining regression testing range | |
| CN108073688A (en) | A kind of method and device of Data Migration | |
| CN104361025A (en) | Method for fusing and integrating multi-source spatial data | |
| KR102526147B1 (en) | Monitoring apparatus in elctric power system | |
| CN107147726A (en) | Content pushing method, terminal equipment and computer readable storage medium | |
| CN104376073A (en) | Database recovery method and device | |
| CN102880500B (en) | The optimization method of a kind of task tree and device | |
| CN115617773A (en) | Data migration method, device and system | |
| CN104700187A (en) | Bill generation method | |
| CN104461570A (en) | BOM automatic analysis method | |
| CN103870540A (en) | Database based on structural design and analysis integration | |
| CN106951593A (en) | A kind of method and apparatus for the configuration file for generating protection supervisory equipment | |
| CN105930354A (en) | Storage model conversion method and device | |
| CN105373636A (en) | Enterprise Windchill system based ProE standard part library construction method | |
| CN104484429A (en) | Data contrast analysis method and data contrast analysis system | |
| CN103810310A (en) | Parameterization determination method for pitch foaming module equipment oriented to bituminous mixing plant |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| RJ01 | Rejection of invention patent application after publication | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20150401 |