Design And Implementation Of Information Access System In SQL Server Database

Database system which serves as the main information part in modern society is paid extensive attention about its security by people. This paper analyzes the current security threat that database system faces, while the domestic and international database security products are analyzed. Through comparative analysis, we can see that the current products still have some shortcomings such as the oneness of accessing database information, as well as the application limited in the types of encryption network environment. In view of this, on basis of original database monitoring system, some modules function are improved, as well as some new function are applied in this paper.This paper mainly analyzes and introduces information access system. The main content are below: (1)By using existing database programming interfaces, integrate VC and C # programming technology integration for the first time, as well as through loading the DLL, realize Multi processes, real-time tracking and access various database operational information,database currently running status and the current host status information, also well resolve the problem of information source single, and because of its access is mainly based on the mainframe so there will be no question of encrypted network environment constrained;(2)By combining the traditional definition of the database tracking templates and command control, this system achieves the effective data extraction of various database operational information, avoiding redundant information transmission and reducing the load of the system;(3)The application of communications technology between process is overloading existing function on base of the pipeline technology and putting up cross-platform calls to ensure the stability of transmission of the database operation information that is captured;(4)By applying the self-launch of the guard process and monitoring technology, the problem that database monitoring system in unattended circumstances can not achieve automatic link after disconnected is well resolved and the continuity of the state of information access system is ensured;(5) The collectivity architecture design, software flow and the realization of the modules, including the code, flowcharts, as well as working principle in the information access system is presented;(6)Doing some functions testing and performance testing by carrying out testing program and the result is analyzed which further confirm the reliability in accessing information and transmission of this system.Finally, the works above are sum up, with the current system inadequate pointing out, as well as the direction for the next step that should be done.