Scheme Design And Performance Optimization Of Data Migration On Oracle9i

In a company's new systematic design exploitation process, we are confronted with some problems: The collected and stored data in old system must be migrated to new system, which is called"Data migration". For instance, bank company, insurance company, and telecommunication company. According to the statistics, the management system of one company will be renewed every 10 years. So it is significant to study the data migration technology.There are many technologies about Data migration. This essay studies mainly the following three aspects: firstly, the overall solving scheme of data migration; secondly, ETL(Extract Transform Load)instrument of data migration, that is the choice of selection instrument, shift instrument and loading instrument; thirdly, the method to improve ETL procedure implementation efficiency. The overall solving scheme of data migration in this essay is to transfer the customer-supplied migrated data in SAM document to the Input Data Base, which is a temporary and transference data base. Then ETL process the data in Input Data Base and load the data into the data base of new system. The selection of ETL instrument is by means of combination of the special implement and the development of ETL program through our own efforts: shift the simple part by using ETL implement produced by the special field firm; and shift the complex part by using the ETL program through our own efforts to transfer data. The data migration in using ETL procedure and a high speed to deal with the data can not be avoided to carry out the data migration. In the background of Oracle data base and PL/SQL language, this essay explains the efficiency methods to improve the ETL program processing efficiency in three aspects: Index and SQL sentence optimization,Shared Pool adjustment and Database Buffer Cache adjustment.During the one-year data migration project, the loaded data of the new system can ensure that the new system regular work through the original data validation,the selection of migration scheme and the procedure of editing and testing the migration program at last.