Design And Implementation Of Oracle Database Security Inspection System

With the continuous development of database technology, Oracle database as the leader of this field in parallel high-speed processing, system high availability, seamless sharing of data, data processing and other fields has also been a rapid development. At the same time, however, due to the enormous complexity of the logic of the system, function rich security or configuration of the database itself follow security has increasingly become major risks. Because of the complexity of the Oracle database system, the configuration logic relations variability, deployment implementation environments inconsistencies and other characteristics, the current state of Oracle database security check system there has been all kinds of technical difficulties, therefore construct a set of Oracle database and adapt to any case of safety inspection system to meet the definition of the DAB/CIO/CSO management of their database security status has become the most important task.The goal of this study is to build a set of Oracle database security check system, more comprehensive research in the field of database security for Oracle, include the positioning of the system function, the versatility of the various types of environment, check the knowledge base, and loophole-level definitions, and so. The system is a common set of Oracle database security inspection system administrator can set convenient, quick and standardized safety inspection platform for the Oracle database.This document first analyzes the current safety status of the Oracle database system, clear Oracle Database Security check system function positioning, core functionality, and system processes. Then based on the JDBC common open connection engine using Swing hierarchical design model through the MVC framework with encryption and decryption, parallel technology resource pool to achieve the overall Oracle Database Security check system. Which focuses on the function of the cross-Oracle database environment, and analysis of the loopholes in the security check, the role of decentralization, and reporting capabilities. And on this basis, the detailed breakdown of the various functional modules require sub-function analysis of the module construction and implementation. UML modeling for each system or subsystem design, including those related to the MVC presentation layer, service control layer, data analysis, access layer. Accordance with relevant design at the same time, through the Swing framework further to achieve a specific code and interface with the JDK development environment package. Finally, summarize the strengths and weaknesses of the system. Overall demand analysis, technical analysis, system design code、build links elaborate on the Design and Implementation of Oracle Database Security check system.