CN104298761A - Implementation method for master data matching between heterogeneous software systems - Google Patents
Implementation method for master data matching between heterogeneous software systems Download PDFInfo
- Publication number
- CN104298761A CN104298761A CN201410569062.4A CN201410569062A CN104298761A CN 104298761 A CN104298761 A CN 104298761A CN 201410569062 A CN201410569062 A CN 201410569062A CN 104298761 A CN104298761 A CN 104298761A
- Authority
- CN
- China
- Prior art keywords
- data
- chronization
- syn
- basic
- database
- 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/27—Replication, distribution or synchronisation of data between databases or within a distributed database system; Distributed database system architectures therefor
- G06F16/275—Synchronous replication
-
- 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/2365—Ensuring data consistency and integrity
-
- 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/2379—Updates performed during online database operations; commit processing
-
- 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/27—Replication, distribution or synchronisation of data between databases or within a distributed database system; Distributed database system architectures therefor
Abstract
The invention discloses an implementation method for master data matching between heterogeneous software systems and belongs to the technical field of data processing. The method includes the steps: A) creating an intermediate contrast relation table and a basic data dictionary table in a database; B) synchronously loading data in a data update party system into the intermediate contrast relation table and the basic data dictionary table; C) completing historical data contrast through the intermediate relation contrast table; D) simultaneously synchronizing operations on the data to the intermediate contrast relation table and the basic data dictionary table; E) when a data synchronizing party system loads the data or initializing is performed on the data synchronizing party system, independently accessing to a control database, and directly reading the intermediate relation table and the basic data dictionary table to complete matching of master data. Compared with the prior art, the method has the advantages that the problem of slow data synchronization caused by the fact that the data synchronizing party system loads the data for users is solved, influence caused by data synchronization on large data volume is reduced, and data maintenance cost is lowered.
Description
Technical field
The present invention relates to technical field of data processing, the implementation method that specifically between a kind of heterogeneous software system, master data is mated.
Background technology
In order to meet client and the ever-increasing needs to real-time information of business parnter, enterprise often needs the exchange carrying out data between different systems to improve the reliability of data user rate and data.Exchanges data is the important component part of the various applications of computer network, is that the function exchanging interchange information between application system supports level.Contact between enterprises, enterprise is increasingly tight, often needs in the exchange of the enterprising row data of network and exchanging visit.How making different geographical, different enterprise, dissimilar data exchange visits easily, is one of important research problem in current IT technology.
Traditional method realizing master data coupling between heterogeneous system is that the existing data of Data Update method, system one side are directly imported in system one side needing to carry out data syn-chronization, utilize basic data contrast function, carry out data contrast, set up corresponding relation in order to realize the data syn-chronization between heterogeneous system; Or set up contrast relationship middle table, the basic data of two systems is carried out artificial manual contrast, then the data of middle table and basic data dictionary table is needed to realize the synchronous of data in synchrodata system one side importing.But there are a large amount of data in the system of the user of some industry or enterprise, because huge data volume needs a large amount of maintenances in the process of synchrodata, not only need to carry out data maintenance to Data Update method, system one side, also to carry out a large amount of data maintenance work to synchrodata system one side, also may to relate to the maintenance of contrast relationship middle table, data volume is large, difficult in maintenance.
Summary of the invention
Technical assignment of the present invention is for above-mentioned the deficiencies in the prior art, provides the implementation method of master data coupling between a kind of heterogeneous software system.
Technical assignment of the present invention realizes in the following manner: the implementation method of master data coupling between a kind of heterogeneous software system, is characterized in that comprising the steps:
A) Intermediate control relation table and basic data dictionary table is created in a database;
B) data syn-chronization in Data Update method, system is loaded in Intermediate control relation table and basic data dictionary table for data syn-chronization method, system read data information;
C) complete historical data contrast by the intermediate interactions table of comparisons, and data are preserved in the table of comparisons;
D), when Data Update method, system increases data manipulation newly, by being synchronized to Intermediate control relation table and basic data dictionary table to the operation of data simultaneously, to carry out synchronous operation synchronous with what realize data;
E) independently access control database when data syn-chronization method, system loads data or when data syn-chronization method, system carries out initialization, directly reads the coupling that Intermediate control relation table and basic data dictionary table complete master data between heterogeneous software system.
Described database can be any Sybase in prior art.Database can carry out administrator's password encryption, to ensure that other users cannot directly enter database to conduct interviews, ensures the safety of local data.
In order to further facilitate Data Update, after Intermediate control relation table and basic data dictionary table have been set up, Data Update method, system and data syn-chronization method, system all can carry out the acquisition of related content to required data.
The intermediate interactions table of comparisons and basic data dictionary table retain historical data and do not empty.
As preferably, comprise the following steps in step e:
E1) when data syn-chronization method, system loads data, or need initialization at data syn-chronization method, system, create access control database;
When E2) creating access control database, require input keeper numbering, password, using the login user of this user as database, and using this user as access control wide area information server owner.
Compared with prior art, between heterogeneous software system of the present invention, the implementation method of master data coupling passes through the historical data of Intermediate control table and basic data dictionary table between reservation two systems, after a predetermined time puts, the newly-increased Data Update of Data Update method, system in Intermediate control table and basic data dictionary table, data syn-chronization method, system directly can realize the acquisition of data and synchronous by reading Intermediate control table and basic data dictionary table, the maintenance work of data can be reduced simultaneously, substantially increase the work efficiency of staff.User can realize the synchronous acquisition of data between different system convenient, fast, reduces the complexity of software operation, enhances interest and convenience that user uses software, provides platform to the good application of software in enterprise.Have, the method has following outstanding beneficial effect:
(1) greatly accelerate data synchronization efficiency, the data maintenance workload of staff is greatly reduced;
(2) can connect effective time uploading data, this just can improve throughput rate and the work efficiency of user, and improves the availability of application program;
(3) Data Update method, system is more after new data, and data syn-chronization can reach the renewal coupling that real-time synchronization data complete master data, flexibly and easily;
(4) user of service can easily by the tight binding of interface and authority, when providing maximum convenience to user of service, and still can the synchronized update of guarantee information;
(5) data syn-chronization method, system determines whether synchronized update data after loading;
(6) data syn-chronization method, system directly can open a concrete form after logging in, and reads Intermediate control relation table and basic data dictionary table, completes the coupling of master data between heterogeneous software system;
(7) data syn-chronization method, system loading data complete the data synchronization updating between Data Update method, system after completing.
Accompanying drawing explanation
Accompanying drawing 1 is the Data Update process flow diagram of the inventive method;
Accompanying drawing 2 is graphs of a relation of each table in the embodiment of the present invention.
Embodiment
The implementation method of master data coupling between heterogeneous software system of the present invention is described in detail below with specific embodiment with reference to Figure of description.
Embodiment:
Between heterogeneous software system of the present invention, the implementation method of master data coupling, comprises the steps:
As shown in Figure 1, in the inventive method, data are stored into Intermediate control relation table and basic data dictionary table by Data Update method, system, and when Data Update method, system carries out Data Update, Intermediate control relation table and basic data dictionary table also carry out synchronous operation.Finally, data syn-chronization side directly reads Intermediate control relation table and basic data dictionary table, completes the synchronized update realizing master data between heterogeneous software system.
Just concrete embodiment does a detailed description below.
1, Intermediate control relation table and basic data dictionary table is set up in a database
Wherein at least should there is field main in several list structure below and each table in a database:
System banner table (FIBSZD): for identifying each operation system
The data field table of comparisons (FIFDMAPPING), for storing source data and target data field corresponding relation, FIFM _ id field generates automatically
The storage that the value table of comparisons (FIDMAPPING) contrasts with target data values for source data
As shown in Figure 2, " source data system banner ID " in figure in the data field table of comparisons and target data system mark ID takes from id field in system banner table to the table relation of above-mentioned each table, for distinguishing source data and target data to be derived from which system.The value table of comparisons is used for the storage of data contrast, the FIFM_ID field in this Table I D field corresponding data field table of comparisons, can take out the contrast of data value according to field contrast.
2, data are stored in Intermediate control relation table and basic data dictionary table by Data Update method, system;
3, Data Update method, system and data syn-chronization method, system can carry out the acquisition of related data according to Intermediate control relation table and basic data dictionary table to required data;
4, when Data Update method, system carries out Data Update, Intermediate control relation table and basic data dictionary table carry out synchronous operation to complete data syn-chronization;
In the process of 5, data syn-chronization, Intermediate control relation table retains historical data, and carries out synchronous operation to upgrade Intermediate control relation table to newly-increased data simultaneously;
6, completed the comparison mapping of data by Intermediate control relation table, complete the synchronous preservation of data;
7, data syn-chronization method, system select needed for data and loading synchronous data;
8, data syn-chronization method, system directly reads Intermediate control relation table and basic data dictionary table acquisition data, completes the synchronized update realizing master data between heterogeneous software system.
In said method, when data syn-chronization method, system loads data, or need initialization at data syn-chronization method, system, created access control database; When creating access control database, require input keeper numbering, password, using the login user of this user as database, and using this user as access control wide area information server owner.
Claims (4)
1. the implementation method that between heterogeneous software system, master data is mated, is characterized in that comprising the steps:
A) Intermediate control relation table and basic data dictionary table is created in a database;
B) data syn-chronization in Data Update method, system is loaded in Intermediate control relation table and basic data dictionary table for data syn-chronization method, system read data information;
C) data syn-chronization method, system load after determine whether more new data and can according to data sheet select need upgrade data, to complete the data syn-chronization between Data Update method, system;
D) complete historical data contrast by the intermediate interactions table of comparisons, and data are preserved in the table of comparisons;
E) data syn-chronization method, system determines whether synchronized update data, when Data Update method, system increases data manipulation newly, obtain the data manipulation authority of user, data syn-chronization operation is carried out according to operating right, carry out the synchronous operation of relevant Intermediate control relation table and basic data dictionary table, what finally realize data is synchronous;
F), during data syn-chronization method, system loading data or when data syn-chronization method, system carries out initialization, independently access control database, directly reads Intermediate control relation table and basic data dictionary table, completes the coupling of master data between heterogeneous software system;
G) data syn-chronization method, system loading data complete the data synchronization updating between Data Update method, system after completing.
2. the implementation method that between heterogeneous software system according to claim 1, master data is mated, it is characterized in that: after Intermediate control relation table and basic data dictionary table have been set up, Data Update method, system and data syn-chronization method, system all can carry out the acquisition of related content to required data.
3. the implementation method that between heterogeneous software system according to claim 1, master data is mated, is characterized in that: the intermediate interactions table of comparisons and basic data dictionary table retain historical data and do not empty.
4. the implementation method that between heterogeneous software system according to claim 1, master data is mated, is characterized in that: comprise the following steps in step e:
F1) when data syn-chronization method, system loads data, or need initialization at data syn-chronization method, system, create access control database;
When F2) creating access control database, require input keeper numbering, password, using the login user of this user as database, and using this user as access control wide area information server owner.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201410569062.4A CN104298761B (en) | 2014-10-23 | 2014-10-23 | The implementation method that master data is matched between a kind of heterogeneous software system |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201410569062.4A CN104298761B (en) | 2014-10-23 | 2014-10-23 | The implementation method that master data is matched between a kind of heterogeneous software system |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN104298761A true CN104298761A (en) | 2015-01-21 |
| CN104298761B CN104298761B (en) | 2017-08-25 |
Family
ID=52318486
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201410569062.4A Active CN104298761B (en) | 2014-10-23 | 2014-10-23 | The implementation method that master data is matched between a kind of heterogeneous software system |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN104298761B (en) |
Cited By (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN104899312A (en) * | 2015-06-15 | 2015-09-09 | 国家电网公司 | Data updating method for multi-layer classification data system |
| CN105760498A (en) * | 2016-02-22 | 2016-07-13 | 浪潮通用软件有限公司 | Achievement method of XML data and relational database matching |
| CN106202445A (en) * | 2016-07-14 | 2016-12-07 | 上海超橙科技有限公司 | A kind of information displaying method and equipment |
| CN107273485A (en) * | 2017-06-13 | 2017-10-20 | 苏州弘铭检测科技有限公司 | A kind of data store organisation and database remapping method based on configurable data storehouse |
| CN107451259A (en) * | 2017-07-31 | 2017-12-08 | 北京微影时代科技有限公司 | A kind of data dictionary dynamic updating method and device |
| CN109885690A (en) * | 2018-12-14 | 2019-06-14 | 中国平安人寿保险股份有限公司 | A kind of method for detecting of data variation, device, electronic equipment and storage medium |
Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102495910A (en) * | 2011-12-28 | 2012-06-13 | 畅捷通信息技术股份有限公司 | Device and method for data timing synchronization of heterogeneous system |
| US20130138616A1 (en) * | 2011-11-29 | 2013-05-30 | International Business Machines Corporation | Synchronizing updates across cluster filesystems |
| CN103685543A (en) * | 2013-12-23 | 2014-03-26 | 中国电子科技集团公司第三十研究所 | Method and system for data synchronism between heterogeneous databases |
| CN203775251U (en) * | 2014-03-19 | 2014-08-13 | 中国人民解放军装甲兵工程学院 | Isomerous data communication device based on communication agent |
-
2014
- 2014-10-23 CN CN201410569062.4A patent/CN104298761B/en active Active
Patent Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20130138616A1 (en) * | 2011-11-29 | 2013-05-30 | International Business Machines Corporation | Synchronizing updates across cluster filesystems |
| CN102495910A (en) * | 2011-12-28 | 2012-06-13 | 畅捷通信息技术股份有限公司 | Device and method for data timing synchronization of heterogeneous system |
| CN103685543A (en) * | 2013-12-23 | 2014-03-26 | 中国电子科技集团公司第三十研究所 | Method and system for data synchronism between heterogeneous databases |
| CN203775251U (en) * | 2014-03-19 | 2014-08-13 | 中国人民解放军装甲兵工程学院 | Isomerous data communication device based on communication agent |
Cited By (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN104899312A (en) * | 2015-06-15 | 2015-09-09 | 国家电网公司 | Data updating method for multi-layer classification data system |
| CN104899312B (en) * | 2015-06-15 | 2018-07-31 | 国家电网公司 | A kind of data-updating method of multistratum classification data system |
| CN105760498A (en) * | 2016-02-22 | 2016-07-13 | 浪潮通用软件有限公司 | Achievement method of XML data and relational database matching |
| CN106202445A (en) * | 2016-07-14 | 2016-12-07 | 上海超橙科技有限公司 | A kind of information displaying method and equipment |
| CN107273485A (en) * | 2017-06-13 | 2017-10-20 | 苏州弘铭检测科技有限公司 | A kind of data store organisation and database remapping method based on configurable data storehouse |
| CN107451259A (en) * | 2017-07-31 | 2017-12-08 | 北京微影时代科技有限公司 | A kind of data dictionary dynamic updating method and device |
| CN109885690A (en) * | 2018-12-14 | 2019-06-14 | 中国平安人寿保险股份有限公司 | A kind of method for detecting of data variation, device, electronic equipment and storage medium |
Also Published As
| Publication number | Publication date |
|---|---|
| CN104298761B (en) | 2017-08-25 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN104298761A (en) | Implementation method for master data matching between heterogeneous software systems | |
| US20120304262A1 (en) | Automating cloud service reconnections | |
| US20160378842A1 (en) | Enhanced mechanisms for managing multidimensional data | |
| CN107003906A (en) | The type of cloud computing technology part is to type analysis | |
| CN104572122A (en) | Software application data generating device and method | |
| CN103020026A (en) | Synergistic file processing system and method | |
| US11531645B2 (en) | Method, apparatus and computer program product for improving data indexing in a group-based communication platform | |
| CN105184144A (en) | Multi-system privilege management method | |
| CN104615710A (en) | Electronic map frame data updating method | |
| CN105635311A (en) | Method for synchronizing resource pool information in cloud management platform | |
| CN112217656A (en) | Method and device for synchronizing configuration information of network equipment in SD-WAN (secure digital-to-Wide area network) system | |
| CN103780686A (en) | Method and system for customizing application approval procedure in cloud organization | |
| CN105608126A (en) | Method and apparatus for establishing secondary indexes for massive databases | |
| CN108897876A (en) | A kind of data cut-in method and device | |
| CN107071036A (en) | A kind of method, the webserver and system for downloading driving file | |
| CN106021566A (en) | Method, device and system for improving concurrent processing capacity of single database | |
| CN107798120B (en) | Data conversion method and device | |
| CN102097015A (en) | Operation instruction processing system and method | |
| CN111177698B (en) | Processing method and device of portal system and computer equipment | |
| US20170177687A1 (en) | Synchronization of offline instances | |
| CN108563697A (en) | A kind of data processing method, device and storage medium | |
| CN111800460A (en) | Data synchronization method, device and equipment of LDAP (lightweight directory Access protocol) service node and storage medium | |
| CN105373631A (en) | SQLSever-based automatic upgrading method for database structure | |
| CN109063265B (en) | Cross-domain allopatric collaborative design method and device in mass data environment | |
| CN109033444A (en) | The method and device across organizational boundary's data sharing is realized based on object storage technology |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |