Dissertation > Excellent graduate degree dissertation topics show

Research on Multi-database Control and Supervisory System on Oracle9i

Author: ZhengMinHong
Tutor: LiuFaGui；LiuGang
School: South China University of Technology
Course: Computer technology
Keywords: tax-related systems Oracle9i multi-databases maintenance and monitoring
CLC: TP311.13
Type: Master's thesis
Year: 2011
Downloads: 84
Quote: 1
Read: Download Dissertation

Abstract


More comprehensive and stable daily operation and maintenance management are required since the China Taxation Administration Information System (CTAIS) and more other tax information systems were deployed and applied at the provincial level in 2006. In practice, a database administrator may need to manage and maintain multiple databases in the same time. Routine manual inspection to detect and troubleshoot can’t meet the security requirements of business systems no longer. To make business systems run more efficiently and stably, it’s necessary to use monitoring tools to automate the collection, status monitoring and performance analysis of databases.To achieve customized monitoring requirements, this paper studied on 18 tax-related business systems of Guangdong province and focused on main problems and daily duties in monitoring and management of 12 Oracle9i databases and correlative backup and replication software. It did system analysis and case studies and captured monitoring control and management needs through environment and contents analysis. The paper proposed an overall system architecture frame and completed the module design and studied the core technology in the design. It designed and implemented a multi-database control and supervisory system based on Oracle9i. The work finished in the paper is as follows.Firstly, it designed a multi-database control and supervisory system based on three-tier B/S structure and the research of the characteristic and monitoring demand of existing tax-related business databases and hierarchical monitoring and management model. It proposed an overall system architecture frame and described the system functions and modules design.Secondly, it implemented a multi-database supervisory system on the basis of the above studies and J2EE technology, which could perform the functions of configuration management, user authority management, event detection, real-time supervision, alarm management, statistical analysis and charts. Function and performance test had been taken to prove that the system was feasible and was a good solution for main problems in the process of monitoring and management of the tax-related databases with very low impact on the normal business.The research of multi-database control and supervisory system can solve the problems in the database monitoring for Guangdong province. It can establish the mechanism of maintenance and management for the stabilization and high efficiency of database. This study aims to establish unified, standardized and business-oriented monitoring indicators and achieve centralized management of monitoring data through data integration tools. It research on a system that can satisfy the monitoring demand of all tax-related databases for provincial administration of taxation and integrate multi-database monitoring. We can establish an effective and user-friendly monitoring system to facilitate the database administrators in daily work and to release them from the complex and repetitive daily monitoring work through this research.

Related Dissertations

  1. Online database service system of ancient ceramics,TP311.13
  2. The Research of Distributed Space Databases Used in Forestry WebGIS System,S757
  3. Research and Development on Air Compressor On-line Monitoring and Diagnosis System,TH17
  4. Research and Development of a DSP Based Monitoring System,TV738
  5. Plant Management Theory and Method Based on Internet and Condition-monitoring,TH17
  6. The Research on Technology and Methods for Aviation Engine Health Management,V263.6
  7. Sparse Coding Based Machine Condition Recognition and Its Application in the Condition Monitoring of a Heavy Roller Grinder,TG580.6
  8. Data Transferring among Different Structure Database Based on Java,TP311.13
  9. Power generation equipment condition monitoring and fault diagnosis system,TM76
  10. The Design and Implementation of GIS in the LBS Platform,P208
  11. Air traffic management information database system,V355
  12. Application Technology Research on the Information Integration System of Equipment Maintenance and Process Supervisory and Control,TP277
  13. Java Based Stored Procedure in Oracle,TP311.11
  14. The Study of Data Management System Based on Standard IEC61970,TM769
  15. Scheme Design and Performance Optimization of Data Migration on Oracle9i,TP311.13
  16. The Research and Implementation of Oracle Performance Tuning Techniques Based on the Kylin Platform with TPC-C Benchmark,TP316.8
  17. The Research which Transforms the Traditional E-R Model to the Object-oriented Data Model,TP311.13
  18. Maintenance Oriented Real-Time Condition Monitoring for Hydro-electric Generator Unit,TV738
  19. The Condition Monitor and Maintenance System of Fan of Power Plant,TM621
  20. VRML-XML - based three-dimensional model of distributed virtual environment,TP391.9
  21. Research on Civil Aeroengine Condition Based Maintenance Management,V263.6

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