Improvement Of Strategy For Data Migration

With the development of technology, the powerful systems will take place of the former systems which deposited lot's of information. So, it is necessary to do the data migration. The paper studied the problems in the process of the data migration and resolved the problems which include the dispersed depositing of bulks of data, the multiplicity of data and the low speed of selecting data from database.First, about the problem of the dispersed depositing, the paper analyzes the characteristic of data, and researches the deposited structure of the object data and the method of using the nested of table in PL/SQL. Then, we put forward the way of depositing data as to use one table to deposit data taking place of many tables, found the type of object data , realize the inserting and extracting object data.Second, it is necessary to adopt the different of method to put the different type of data into database and extract the data from database. So, we research the way of using on LOAD, IMP and EXP in ORACLE, realize that puting the different type of data into database and extracting the data.Last, about the data migration in PL/SQL language, formerly we adopted the method of many cursors, which can not satisfy the demand of the client. So, we research the link in SQL language and put forward and implement the design of cursor which merges many cursors into one.