Application system migration correctness verification method and device, equipment and storage medium
A verification method and application system technology, which is applied in the field of storage media, equipment, verification methods and devices for correctness of application system migration, can solve problems that cannot be given, cannot be applied, and provide more useful information, inconsistency transition history, etc. question
Pending Publication Date: 2021-05-11
CHINA CITIC BANK +1
View PDF0 Cites 0 Cited by
- Summary
- Abstract
- Description
- Claims
- Application Information
AI Technical Summary
Problems solved by technology
[0005] 1. It can only prove the data consistency at the moment of the aspect, but not whether the data at any time between the two aspects is consistent
[0006] 2. If the data verification is inconsistent, the inconsistent change history cannot be given
This is especially important for app migrations and means it doesn't provide much useful information for app troubleshooting
Method used
the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
View moreImage
Smart Image Click on the blue labels to locate them in the text.
Smart ImageViewing Examples
Examples
Experimental program
Comparison scheme
Effect test
Embodiment Construction
[0047] In the solution of the present invention, since the log of the database records all the changes of the data. Among them, log entries are logically divided into insert, update, and delete. Then, by parsing the database log, you can get every change of every record. By comparing the data changes by record, you can get the difference of the same record in the two databases.
[0048] figure 1 is a block diagram of steps used in the verification method of the present invention. Such as figure 1 A method for verifying the correctness of application system migration according to the present invention includes:
[0049] S1. Use the simulated standby machine to connect to the new system and the old system, and obtain the new physical logs in the new system and the old physical logs in the old system respectively;
[0050] S2. Determine the comparison interval between the new physical log and the old physical log;
[0051] S3. Analyze the new physical log and the old physic...
the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More PUM
Login to View More Abstract
The invention provides an application system migration correctness verification method and device, equipment and a storage medium, and the verification method comprises: S1, employing a simulation standby machine to access a new system and an old system, and respectively obtaining a new physical log in the new system and an old physical log in the old system; S2, determining a comparison interval between the new physical log and the old physical log; S3, respectively analyzing the new physical log and the old physical log according to the comparison interval, and obtaining an SQL statement; and S4, summarizing the SQL statements, carrying out data comparison on the new physical log and the old physical log in the comparison interval according to a time sequence, and outputting a difference rate.
Description
technical field [0001] The present invention relates to the technical field of data verification, in particular to a verification method, device, device, and storage medium for correctness of application system migration. Background technique [0002] After years of accumulation of informatization construction, each business unit has accumulated a considerable number of business systems. With the large-scale commercial use of open source databases in the Internet industry, open source databases represented by MySQL have attracted more and more attention from the banking industry. On the one hand, the regulatory authorities have put forward higher requirements for the "safety, independence and controllability" of the banking industry. On the other hand, the licensing fees for commercial databases and the high-end hardware environment required for their operation are expensive. Banks under the marketization of interest rates The industry is facing increasingly severe cost pre...
Claims
the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More Application Information
Patent Timeline
Login to View More Patent Type & Authority Applications(China)
IPC IPC(8): G06F16/21G06F16/242
CPCG06F16/214G06F16/219G06F16/2433
Inventor 陈建锋陈蓓全荣炫马世超李从兵买建华
Owner CHINA CITIC BANK