Dissertation > Excellent graduate degree dissertation topics show

The Methods of Data Transfed in ORACLE Database Used in the Insurance Information System Impelement

Author: LiuHongZuo
Tutor: YaoTian；ZhangWenYu
School: Shanghai Jiaotong University
Course: Software Engineering
Keywords: Oracle Database Relational database Table Partition Data transfer IMPORT EXPORT
CLC: TP311.13
Type: Master's thesis
Year: 2012
Downloads: 28
Quote: 0
Read: Download Dissertation

Abstract


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.

Related Dissertations

  1. The International Trade and the Upgrading of the Industrial Structure:based on the Empirical Study of Input-Output Model,F752
  2. RMB appreciation on China's Foreign Trade Research,F752;F224
  3. On Export Vat Refund Mechanism Over Sino-EU Trade,D922.22
  4. An Empirical Research on How Import Promotes China’s Economy Growth,F752.6;F124
  5. The Study about the Export-Oriented Talent Development in Guangxi Beibu Gulf Ecnomic Zone,C964.2
  6. The employment effects of foreign economic - theoretical and empirical research ( 1978-2009 ),F752;F224
  7. China 's exports to ASEAN Factors,F224
  8. Research Trade Effect of China’s FDI in Mauritania,F752.7;F224
  9. Low Carbon Economy and China Export Trade Relationship,F205;F224
  10. China 's export tax rebate rate and exchange rate policy impact on export Comparative Study,F832.6;F752.62
  11. Vietnam exported under the trend of free trade market structure adjustment,F753.33
  12. A Optimization Conceive of the Oracle Database Based on the Index,TP311.13
  13. Caché database based clinical laboratory information system design and implementation,TP311.13
  14. Research on Transfer Protocol and Penetration of ORACLE Database,TP311.13
  15. Research on Mapping Relational Database Schema to Ontology,TP311.13
  16. Chunk Chunk attention to the role of the output level of research and writing,H319
  17. Exports to China FDI technology spillover effects of structural change,F832.6;F224
  18. Export Competitiveness of Auto Spare Parts,F426.471
  19. Economic impact of imports on the Shanghai Empirical Analysis,F127;F752.6
  20. Wireless mesh network capacity optimization Control Method,TN929.5
  21. Driving test system design and implementation,TP311.52

CLC: > Industrial Technology > Automation technology,computer technology > Computing technology,computer technology > Computer software > Program design,software engineering > Programming > Database theory and systems
© 2012 www.DissertationTopic.Net  Mobile