Datacenter migration data arrangement strategy

Datacenter migration data collation is to collate the data of the original system into data recognized by the system conversion program. The data collation is divided into two stages: the first stage is to make the data collection and backup of different types of sources to the unified database; the second stage is to arrange the original data, and to classify the different intermediate databases according to the different requirements, and to provide the intermediate data for the data conversion. The following methods are used in the process of data consolidation:

L ensures the integrity of the original data
In data consolidation, we need to backup the raw data first. There are two purposes for backup: one is to unify the database, to facilitate data conversion, and the other is to provide reference for tracing the source of future data. In this system, we will use DB2 as backup unified database.
L data hierarchical filtering strategy
Data classification filtering means sorting data into different intermediate databases according to different data levels. In this system, we divide data into three levels: discarded data, data to be adjusted, and transferable data. Waste data is the existence of some data, which wastes data on system resources, and will affect the operation of future systems. The data to be adjusted is that part of the data seriously affect the operation of the new system. The conversion data is that this part of the data does not need to do any processing, basically meets the requirements of data conversion or the proposed adjustment of the new system of data, but does not affect the operation of the system, and can be adjusted after the operation of the new system, which can save a lot of time for the data conversion work.
L collects related tools with the help of data
Data collation is very arduous, the amount of data involved is very large, it is impossible to complete by manual inspection, so it is necessary to write the relevant data sorting tool to complete the data sorting. It includes data consolidation tools and data error correction tools. The data sorting tool is responsible for classifying the data in the original backup database into different intermediate databases; the data error correction tool is responsible for providing a friendly and convenient tool interface for the users to improve and correct the wrong data.
L uses the Middle Library as a bridge
Because the database structure of the original system and the new system may be different, it is very important to use the intermediate library as an important bridge to connect the data of the old and new systems, and to establish the control relationship of the old and new systems. Once a business operator has doubts about a certain conversion data in the new system, the raw data can be successfully identified through the correlation between the intermediate libraries.