CN108280142B - Method for butt-jointing transaction data of new and old systems - Google Patents
Method for butt-jointing transaction data of new and old systems Download PDFInfo
- Publication number
- CN108280142B CN108280142B CN201711474932.XA CN201711474932A CN108280142B CN 108280142 B CN108280142 B CN 108280142B CN 201711474932 A CN201711474932 A CN 201711474932A CN 108280142 B CN108280142 B CN 108280142B
- Authority
- CN
- China
- Prior art keywords
- transaction
- data
- old system
- old
- new
- 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
Images
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/23—Updating
- G06F16/2358—Change logging, detection, and notification
-
- 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
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Databases & Information Systems (AREA)
- Data Mining & Analysis (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Computing Systems (AREA)
- Debugging And Monitoring (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention relates to the technical field of data docking, and provides a method for docking transaction data of a new system and an old system, which comprises the following steps: s1, in the old system, the data item of the old system transaction is positioned by testing and modifying the human-computer interface and comparing the change of the relevant field of the database, and the data item of the old system transaction can be effectively positioned in the old system without the document or the source code; s2, when the confirmed data item generates transaction, the trigger triggers and records the specific transaction state event of the old system; s3, recording the transaction data of the data item, and recording the acquired system time of the current transaction as a current timestamp; s4, sequentially outputting the collected transaction data according to a certain format; and S5, in the new system, importing the output data in the old system into the new system according to the time sequence, and enabling the transaction data output at the back of the new system to cover the previous transaction data so as to achieve the effect of continuously synchronizing the latest transaction data.
Description
Technical Field
The invention relates to the technical field of data docking, in particular to a method for data docking of a new system and an old system in a different mode.
Background
In most application systems on the current market, there are various legacy systems. With the change of the external environment of the application, a specific application scenario that the old system provides a specific data interface to the new system to achieve the purpose that the new system manages the data of the old system appears. Therefore, the problem of how to solve the problem of monitoring the data abnormality of the old system by the new system under the condition that the source code of the old system is not available and the data document is not complete is caused. The problems of how to locate specific transaction data, how to trigger recording of transaction states of specific data, how to provide transaction information generated in time sequence, and how to expose information to a new system in a reasonable manner are the problems faced at present.
Disclosure of Invention
The invention aims to provide a method for data docking of new and old system transactions, which can at least solve part of defects in the prior art.
In order to achieve the above purpose, the embodiments of the present invention provide the following technical solutions: a data docking method of new and old system transaction, S1, in the old system, through testing and modifying the human-computer interface and comparing the change of the relevant field of the database to position the data item of the old system transaction, can position the data item of the old system transaction effectively in the old system that lacks the file or source code;
s2, when the confirmed data item generates transaction, the trigger triggers and records the specific transaction state event of the old system;
s3, recording the transaction data of the data item, and recording the acquired system time of the current transaction as a current timestamp;
s4, sequentially outputting the collected transaction data according to a certain format;
and S5, in the new system, importing the output data in the old system into the new system according to the time sequence, and enabling the transaction data output at the back of the new system to cover the previous transaction data so as to achieve the effect of continuously synchronizing the latest transaction data.
Further, in the step S1, when locating the data item of the old system transaction, it is necessary to repeatedly verify and finally locate the data item of the transaction by estimating whether the data item matches the change of the final field.
Further, in the step S2, the recording of the transaction data specifically includes: the transaction data is recorded in another record table.
Further, in the step S2, the trigger is a programmable trigger, and the trigger program can be written according to a specific transaction state event.
Further, in the step S4, the certain format is xml, json, or webservice format.
Compared with the prior art, the invention has the beneficial effects that:
1. the method comprises the steps of positioning abnormal data items of an old system by testing and modifying a human-computer interface and comparing changes of relevant fields of a database, and can solve the problems that in the prior art, specific abnormal data of the old system are positioned, and the old system cannot effectively position required abnormal data according to conventional descriptions due to the loss of documents or source codes.
2. The trigger triggers and records the specific transaction state event of the system, so that the problem of how to record the specific transaction state of the old system in the prior art can be solved.
3. By formulating the time stamp, the problem of how to generate the transaction information of the old system in time sequence in the prior art can be solved.
4. By sequentially outputting according to a certain format, for example, outputting according to time stages by adopting xml, json, webservice and the like, the problem of how to expose the transaction information of the old system to the new system in a reasonable mode in the prior art can be solved.
Drawings
Fig. 1 is a flowchart illustrating steps of a method for data docking between new and old systems according to an embodiment of the present invention.
Detailed Description
The technical solutions in the embodiments of the present invention will be clearly and completely described below with reference to the drawings in the embodiments of the present invention, and it is obvious that the described embodiments are only a part of the embodiments of the present invention, and not all of the embodiments. All other embodiments, which can be derived by a person skilled in the art from the embodiments given herein without making any creative effort, shall fall within the protection scope of the present invention.
Referring to fig. 1, an embodiment of the present invention provides a method for data docking between a new system and an old system, including the following steps: s1, in the old system, the data item of the old system transaction is positioned by testing and modifying the human-computer interface and comparing the change of the relevant field of the database, and the data item of the old system transaction can be effectively positioned in the old system without the document or the source code; s2, when the confirmed data item generates transaction, the trigger triggers and records the specific transaction state event of the old system; s3, recording the transaction data of the data item, and recording the acquired system time of the current transaction as a current timestamp; s4, sequentially outputting the collected transaction data according to a certain format; and S5, in the new system, importing the output data in the old system into the new system according to the time sequence, and enabling the transaction data output at the back of the new system to cover the previous transaction data so as to achieve the effect of continuously synchronizing the latest transaction data. The method can solve the problem that the data docking can not be provided according to a normal method due to various historical problems in the existing old system. For example, the old system cannot provide docking by adding a program interface on the old system due to the loss of source codes, the old system cannot provide docking by providing an interface through a data layer due to the loss of data description documents, and the later system cannot reserve enough external interfaces due to the technical limitation of the current development of the old system. The method provides a feasible operation method for the new system when the specific transaction data of the old system needs to be monitored.
Specifically, in this embodiment, the data items of the old system transaction are located by testing and modifying the human-computer interface and comparing the changes of the relevant fields of the database, so as to solve the problem in the prior art that how to locate the specific transaction data of the old system and the old system cannot effectively locate the required transaction data according to the conventional description due to the absence of the document or the source code. The trigger triggers and records the specific transaction state event of the system, so that the problem of how to record the specific transaction state of the old system in the prior art can be solved. By formulating the time stamp, the problem of how to generate the transaction information of the old system in time sequence in the prior art can be solved. By sequentially outputting according to a certain format, for example, outputting according to time stages by adopting xml, json, webservice and the like, the problem of how to expose the transaction information of the old system to the new system in a reasonable mode in the prior art can be solved.
As an optimization scheme of the embodiment of the present invention, in the step S1, when locating a data item of an old system transaction, it is necessary to repeatedly verify and finally locate the data item of the transaction by predicting whether the data item matches the change of the final field. In this embodiment, the worker needs to repeatedly verify the previously evaluated field and the finally generated field until the confirmation is ensured.
As an optimization scheme of the embodiment of the present invention, in the step S2, the recording of the transaction data specifically includes: the transaction data is recorded in another record table. The purpose of adopting this mode is to be able to not modify the table structure of the original data, but also play the role of extracting the transaction information.
As an optimization scheme of the embodiment of the present invention, in step S2, the trigger is a programmable trigger, and a trigger program can be written according to a specific transaction state event. By adopting the programmable trigger, the trigger program can be adjusted according to the actual situation so as to meet the requirement of a specific transaction state event.
As an optimization scheme of the embodiment of the invention, a certain format is an xml, json or webservice format. These several formats are mass formats so that the method can be applied to other systems.
As an optimization scheme of the embodiment of the present invention, in step S5, the format of the output data is xml, json, or webservice format. The format corresponds to the format in step S4, and the purpose of using these formats is to facilitate the method to be applied to other systems.
Although embodiments of the present invention have been shown and described, it will be appreciated by those skilled in the art that changes, modifications, substitutions and alterations can be made in these embodiments without departing from the principles and spirit of the invention, the scope of which is defined in the appended claims and their equivalents.
Claims (4)
1. A method for data docking between new and old systems is characterized by comprising the following steps:
s1, in the old system, the data item of the old system transaction is positioned by testing and modifying the human-computer interface and comparing the change of the relevant field of the database, and the data item of the old system transaction can be effectively positioned in the old system without the document or the source code;
s2, when the confirmed data item generates transaction, the trigger triggers and records the specific transaction state event of the old system;
s3, recording the transaction data of the data item, and recording the acquired system time of the current transaction as a current timestamp;
s4, sequentially outputting the collected transaction data according to a certain format;
s5, in the new system, importing the output data in the old system into the new system according to the time sequence, and the transaction data output at the back of the new system covers the transaction data at the front so as to achieve the effect of continuously synchronizing the latest transaction data;
in the step S1, when locating the data item of the old system transaction, it is necessary to repeatedly verify and finally locate the data item of the transaction by estimating whether the data item matches the change of the final field.
2. The method according to claim 1, wherein in the step S3, the recording of the transaction data specifically includes: the transaction data is recorded in another record table.
3. The method according to claim 1, wherein the data interfacing between the old system and the new system is performed by: in the step S2, the trigger is a programmable trigger, and the trigger program can be written according to a specific transaction state event.
4. The method according to claim 1, wherein the data interfacing between the old system and the new system is performed by: in the step S4, the certain format is xml, json, or webservice format.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201711474932.XA CN108280142B (en) | 2017-12-29 | 2017-12-29 | Method for butt-jointing transaction data of new and old systems |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201711474932.XA CN108280142B (en) | 2017-12-29 | 2017-12-29 | Method for butt-jointing transaction data of new and old systems |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN108280142A CN108280142A (en) | 2018-07-13 |
| CN108280142B true CN108280142B (en) | 2022-01-04 |
Family
ID=62802603
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201711474932.XA Active CN108280142B (en) | 2017-12-29 | 2017-12-29 | Method for butt-jointing transaction data of new and old systems |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN108280142B (en) |
Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101344894A (en) * | 2008-08-21 | 2009-01-14 | 峰峰集团邯郸鼎峰物流有限公司 | Method and device for synchronizing data between application systems |
| CN102082772A (en) * | 2009-11-30 | 2011-06-01 | 中国移动通信集团北京有限公司 | Method and system for realizing resource information access |
| JP2013105435A (en) * | 2011-11-16 | 2013-05-30 | Hitachi Ltd | Data shift method and program |
| CN104317601A (en) * | 2014-10-31 | 2015-01-28 | 北京思特奇信息技术股份有限公司 | Method and system for developing file interfaces |
| CN105426419A (en) * | 2015-11-03 | 2016-03-23 | 用友网络科技股份有限公司 | System and method for data promotion among heterogeneous systems |
-
2017
- 2017-12-29 CN CN201711474932.XA patent/CN108280142B/en active Active
Patent Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101344894A (en) * | 2008-08-21 | 2009-01-14 | 峰峰集团邯郸鼎峰物流有限公司 | Method and device for synchronizing data between application systems |
| CN102082772A (en) * | 2009-11-30 | 2011-06-01 | 中国移动通信集团北京有限公司 | Method and system for realizing resource information access |
| JP2013105435A (en) * | 2011-11-16 | 2013-05-30 | Hitachi Ltd | Data shift method and program |
| CN104317601A (en) * | 2014-10-31 | 2015-01-28 | 北京思特奇信息技术股份有限公司 | Method and system for developing file interfaces |
| CN105426419A (en) * | 2015-11-03 | 2016-03-23 | 用友网络科技股份有限公司 | System and method for data promotion among heterogeneous systems |
Also Published As
| Publication number | Publication date |
|---|---|
| CN108280142A (en) | 2018-07-13 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN102831052B (en) | Test exemple automation generating apparatus and method | |
| CN101719149B (en) | Data synchronization method and device | |
| US7509539B1 (en) | Method for determining correlation of synchronized event logs corresponding to abnormal program termination | |
| US20200092180A1 (en) | Methods and systems for microservices observability automation | |
| CN109445842A (en) | Rule generating method, device, computer equipment and storage medium | |
| CN109408105A (en) | Acquisition method, device, computing device and the storage medium of user behavior data | |
| CN104866619A (en) | Data monitoring method and system for data warehouse | |
| CN102231161A (en) | Method for synchronously verifying and monitoring databases | |
| CN104572781B (en) | A kind of transaction log production method and device | |
| CN109284331B (en) | Certificate making information acquisition method based on service data resources, terminal equipment and medium | |
| US20180365128A1 (en) | Creating trace data from recent software output and activity | |
| CN112561370A (en) | Software version management method and device, computer equipment and storage medium | |
| CN113987393A (en) | Web page operation recorder, system, device and method | |
| CN108280142B (en) | Method for butt-jointing transaction data of new and old systems | |
| CN104123104B (en) | Daily record control system and method | |
| CN109684321A (en) | Data quality management method, device, electronic equipment, storage medium | |
| CN109597706B (en) | Detection method, device and system for checking difference data | |
| CN111222928A (en) | Method and system for monitoring enterprise standard invoicing | |
| CN114493159B (en) | Node position verification method and device based on MES system | |
| CN110309032A (en) | Data managing method, device and electronic equipment | |
| CN115794486A (en) | Robot information acquisition method, system, device and readable medium | |
| CN112448840B (en) | Communication data quality monitoring method, device, server and storage medium | |
| US20220365841A1 (en) | Repair support system and repair support method | |
| EP3440565A1 (en) | Method and system for persisting data | |
| US10922301B1 (en) | Apparatus, computer program, and method for trigger-based tracking of database modifications |
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 |