The Methods Of Data Transfed In ORACLE Database Used In The Insurance Information System Impelement

Pacific Insurance Company is a top 3 national insurance company in China. The original vehicle Insurance system is distributed and the databases were distributed into 40 branchs. With the growth of business and the fierce competition in the market, the distributed layout of original vehicle insurance can not meet the management needs, so the new Pacific vehicle insurance project will turn from the distributed pattern into a unified model, that is all of the branch's data will be stored in a same database and all branchs will use a same operation system. So to facilitate the analysis of national data and statistics, but also more conducive to the senior decision-making. The amount of data is the sum of the amount of data across branchs and will be 2TB size of DB at online early stage and will be 10 to 20 percent of the increase rate after each year, In-depth study in all aspects of database design, program development, the initial data transmission is necessary to make sure the program will have good performance and to ensure the smooth implementation of the project. In the project for a large amount of data, how to optimize in aspects of database designing, application development, data transmission is the issues in this document will to discuss.This document will discuss how to choose a right method to import huge data into database in the different environments and will do research for the importing methods then find a right importing method for each environment in Oracle10g.In this document, first introduce the basic knowledge of Oracle database including the objects in database and the theory for database running, then this document introduce the database import methods in Oracle database and do search for the few methods (IMP, IMPDP, SQL LOADER, SQL PLUS). After research the key technology and functions, realize the few functions that mentioned in this document. Finally, do the testing for the several commonly used to import method (IMP, IMPDP, SQL LOADER, SQL PLUS), obtained test data and analyzed the test results. To choose the appropriate import method through the analysis of test results under different environments and the special requirements of the database. For the testing environment and development environment, eliminating the need for database archive log generated, so the faster import methods should be use, such as IMPDP, SQL LOADER. For the production environment, as required to generate the archive log database, so must use the import method that generate log, and in these methods using SQL PLUS DATABASE LINK import the data into the database is the fastest.The table partition is used in database designing in the vehicle insurance system, transfer the data from development server to production server using DATABASE LINK in the implemention process and through the stored procedure make the process of data transferring too simple to improve the speed. These successful finished the work to get the all forty branch companies online and not only match the request that generate archive log file but also match the request that transfer data in high speed.