Analysis, Test And Optimization Of Security For Load Spectrum Information System Based On SQL Server

With the rapid development of computer technology, the application of database has been widely used in every field. Security problem of database occurs correspondly. Database managers have always felt confused about security problem of database. The lost and the illegal incursion of database make the database manager exhausted. The information system is on the base of database. And the leaks of the operation system have been well disposed in most information system. However, the security of database and script based on database are ignored usually. A great deal of confidential data has been saved in the SQL Server., So knowing and analyzing the insecurity factor and the measures to deal with it is very important. With the rapid development of the Internet, database under the environment of network has been the target of many vicious persons. The attackers use the leaks in the database system. If unknowning that what is the weakness in one data system, it's unable to say the system is safe. And only learning the potential threaten and using the right measure to protect, can it be possible to write safe program ,which ensure the data safety and not be leaked.First, the environment and website frame of the plane load spectrum database system, test tools and the choice of error-following system are illustrated, and the analysis of the effect on the whole information system is involved. Second, the running load spectrum database system is analyzed and the leaks of the ASP code are found. Finally the measure of the optimizating of SQL Server system is emphasized. The right to visit the database is based on controling of the roles. The encrypted method on database is the data element. And the memory process takes the place of the script of the information system in the SQL sentence directly. Considering of the security of SQL Server, the captive test and dynamic test are used to evaluate the security of the server, analyze the measure of the load spectrum database system and the way to ensure the security, and find the leaks in the SQL Server, finally provide the test report and describe test means, and the scheme to dispose and optimize.The security mechanism involved in the paper are not independent but interrelated. The absolute safe database system does not exist yet.,the security technology of the database system is in the process of researching and development. The security measure and mechanisms adopted in this paper can be reference for the development of similar information systems.The load spectrum database information system can be sorted in three kinds, which contains the introduction of the technology on plane load spectrum, technology report, the result and the paper, the calling criterion and related information. They provide the data-disposed experts on load chart with friendly interface to the data document on the related plane types. The efficiency on visiting the load chart data document will be improved greatly. And this database server is served for the managing and researching department.