Project Title : | Database Monitoring and Analysis System |
By : | Sahawass Janthawong, Watcharaphong Athikitchote, Miss.Janya Yamcharoen |
Advisor : | Miss.Janya Yamcharoen |
Degree : | Bachelor of Science |
Major : | Computer Science |
Faculty : | Science |
Semester / Academic year : | 2 / 2017 |
Abstract
The objective of this project is to develop a system for monitoring and analyzing database system. Data administrator have to repeatedly look at report files from different server platforms such as Microsoft SQL Server, Oracle, and IBM DB2. This program can reduce the workload of data administrator. The system process consists of platform detection, data transformation and data analyzes. The system detects errors, and analyzes by using historical data in a database. Then the system will notify the errors to database administrator. The system has been developed by SQL language to create stored procedure, and trigger for performance. Also, the system has web application for database administrator to monitor the server’s performance with graphs.
Keywords: Database system, Database administrator, Data analysis.
Database Monitoring and Analysis System
Faculty of Science, Siam University, Thailand