The Design And Implementation Of Database Monitoring System Based On Trigger

With the advent of the Data Era,human produce more and more data.These data are mostly stored by database.Therefore,monitoring the operation condition of these databases and controlling the usage and performance of SQL became important issues that most companies have to solve.Therefore,the company decided to develop a database monitoring system.The system,on one hand,includes the basic information of the management database.On the other hand,it is able to monitor the service condition and status of database.Based on B/S mode,the system is designed to be a standard three-tier framework according to the J2EE system architecture and MVC idea.And it embodies the combination of the Spring framework and Hibernate framework,which is very popular currently.To implement the most important function-monitoring the database,the method of Trigger,as well as Database Tasks Regularly Query System Tables are adopted.Compared with existing ones,this method firstly solves the problems of different monitoring database.Secondly,the method reliazes the monitoring on various degrees,especially monitoring SQL in detail.Thirdly,it realizes the monitoring at all levels,meeting the business characters of the company.Lastly,it provides a unified user interface,reducing the difficulty of using the system.The main research contents of the thesis:(1)Analysing the Bootstrap,AngularJS,Spring,Hibernate,Oracle,MVC technology,Database Trigger and summarizing the usage reasons according to the system demand.(2)Analysing the general demand of the system;dividing the system into System Management,Monitoring Management and Stored Procedure Analysing,and labouring the demand of these three modules with legends in detail.(3)Expounding the global structure design of the system,including the overall architecture and layered structure design;expounding the database design,including the detailed design of each table and the relationship among these tables;expounding the detailed design of each module and describing the design of the monitoring database and stored procedure analysis.(4)Accounting for the implementation details of each module with code and pseudocode on the basis of design and focusing on the main points implemented;giving the front end implementation design sketch for the visual parts.