Research And Application Of Data Migration Technology In Multiple Database Environment

With the development of application and the lapse of time, the amount of data in the database system and the location of physical storage will change. These changes may affect the application of the database system.Data migration is one of the ways to solve the poor operation of database systems, so data migration is one of the important studies in the academic field.Multi database environment is to use multiple database servers, together to form a complete, global large databases in order to provide transparent data services to clients. Each local database server can be deployed in a high-speed LAN, you can also be deployed in cross-sectoral, cross-unit off-site remote network.Data migration in multi database environment is actually the migration of data between multiple database systems. It is necessary to monitor the database system and analyze the operating efficiency of the database system.When it is discovered that the decline of operating efficiency of a database system, the partial table space on the database system is migrated to the good performance or the new database system needs to be the demand.The traditional data transfer mode is usually through artificial migration. Artificial operation is prone to error.Especially in the multi-database environment, data transfer is including not only the migration of data, but also modifing the route, deleting the source database data, changing the link and other information.If These complex operations can be replaced by machines,it will reduce the complexity of human operation and increase the success rate of migration.This paper mainly includes two aspects:first, multi database system monitoring; second,data migration.Firstly, the monitoring of multi database system. Each database system pushes the data to the general database system regularly. It analyze the three kinds of monitoring indexes of the database system, and give the monitoring history line chart, and design and integrate into a formula. Through the formula, it may reach the threshold of monitoring, than the data migration will execute. Secondly, data migration. The data migration of this thesis is the migration of the table space in database system.It include manual migration and automatic migration database table space. Through the monitoring of the database system, we can judge the operation of the database system and the database table space.Than filter out the database table space and target database system which needs to migrate, and carry out data migration.Combined with Oracle Data Pump toolset provided by the database metadata and the actual data underlying network connection using a synchronous loading migrate to the destination database server. This paper analyzes various data migration schemes, combines the features of this topic, realizes data migration through application software calling batch file.Focuses on the migration of the difficulties and problems needing attention.Finally, it designes and implemente of the program, and introduces the technology used in the program.At the same time, in order to maintain the consistency of the multi database table structure, a scheme is designed to modify the database table structure and modify the corresponding table structure in the table space simultaneously.