Dissertation > Excellent graduate degree dissertation topics show

Storage Architecture Design and Performance Analysis of the ORACLE 11G RAC OLTP Massive Databases

Author: HuangSuYa
Tutor: YaoTian；WuXiaoJin
School: Shanghai Jiaotong University
Course: Software Engineering
Keywords: Oracle 11g RAC Massive Database Storage Subsystem SAN NAS Performance Tunning TPC-C
CLC: TP311.13
Type: Master's thesis
Year: 2011
Downloads: 256
Quote: 0
Read: Download Dissertation

Abstract


With the continuous informationization development of enterprises, the data volume stored in database as the core component of the information system is growing in a geometrical progression. The efficiency of transaction principles of the transactional OLTP (Online Transaction Processing) database is very slow in the face of mass data, and it is hard to meet the business requirement of the continuous increasing concurrent users. With the trend of global informationization, mass OLTP database performance problems have also become one important concern within the enterprises. For enterprises, maintaining the system stability under high concurrent users and guaranteeing the system response time for single user not exceeding the SLA (Service Level Agreement) signed with business departments become an urgent problem that needs immediate solution. For IT companies which provide services to customers, huge economical loss will be made if cannot satisfy the indicators specified in the SLA.The key points of this study are the detailed storage architecture design and performance analysis of the Oracle 11g RAC OLTP massive database. Focusing on the two popular storage subsystem architecture SAN (Storage Area Network) and NAS (Network Attached Server), this study discusses the database performance relevant factors in two aspects, design and implementation. This study also performs the performance testing and optimization on the whole database system.This thesis firstly introduces existing theory of storage system and database, labors the different disk technology, advantages and disadvantages of different RAID techniques and various factors affecting the performance of the storage subsystem, mainly focuses on the key technologies and architecture of Oracle RAC database. On this basis, this thesis makes the overall architecture design of the Oracle RAC database, including the physical system architecture design, storage subsystem design, network architecture design, and database file system design. Furthermore, this thesis makes a detailed performance analysis for storage subsystem on existing experiment environment.This thesis then performs optimization combining with specific examples on the implementation of the database system in physical experiment environment, including the storage subsystem, server, database, network, etc. It detailed introduces and discusses the specific tuning techniques. This optimization solution is general to all Oracle database system performance optimization.The last part of this thesis performs repeated TPC-C benchmark testing on the massive databases built with different storage subsystem architecture, analyzes the overall database performance by utilizing the Oracle AWR (Automatic Workload Repository) report, finds the system bottleneck and optimizes corresponding resources. The system’s overall architecture has been verified under multiple test runs, and the system remains stable and maintains good response time under high concurrent users. Finally, this thesis compares and analyses the best test results and performance statisticses obtained from the databases built with the two kinds of storage architecture, thus to provide the reliable design reference to enterprises who need building massive databases.

Related Dissertations

  1. Cough Powder treatment of chronic cough Compatibility Law,R256.11
  2. Study on Antioxidant Components of Tibetan Medicine Sanguo Tang San,R29
  3. Life History and Culture,B26
  4. A Study on the Time-adverb of San Yan,H141
  5. Based on the RADIUS protocol analysis and application of the extended attribute,TN915.04
  6. Based power control MAC protocol for mobile Ad Hoc network research,TN929.5
  7. A NAS&STB Based Home Multimedia System,TP393.02
  8. Research on Security Scheme for the Integration of SAN and NAS,TP393.08
  9. Design and Applications of a Network Storage Management Software Based on Nas,TP311.52
  10. Based on high-end fault-tolerant server OLTP TPC-E benchmark performance evaluation research and design,TP368.5
  11. Design and Implementation of Fault-Tolerant Parallel Algorithm for On-board Computer,TP302.8
  12. Study on the Electron Transmission Efficiency of Gating-GEM Foil in TPC,TL812.3
  13. The nonparametric qualified support domain blind image restoration algorithm,TP391.41
  14. Research on the Blind Restoration Algorithms for the Adaptive Opto-Electronic Images,TP391.41
  15. The Design and Implementation of TPC-W for OpenBASE,TP311.13
  16. SAN NAS fusion technology research,TP333
  17. The Research of "Xi Hu Er Ji",I207.41
  18. \,H141
  19. Research and Implementation of the NAS application software automated testing program,TP311.52
  20. Electricity enterprise network disaster recovery storage system design and application,TP333

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