Remote Monitoring Information Management System for Preventing Performance Degradation of Database

Abstract

In order to guarantee the stability and reliability of database performance, database monitoring system and program are necessary. The previous commercial database monitoring servers and programs make database overhead and degrade performance of database management system. And there were no alert message or warning message for database administrators in the previous commercial database monitoring system.

We propose the remote database monitoring information management system without degrading performance of database. In the proposed system, remote monitoring information database is constructed by collecting monitoring information from each database server and the remote database monitoring information server deliver monitoring information and each database state to administrators. Thus additional overhead of database monitoring does not occur in the proposed system. The proposed system uses a smart phone as administrator terminal and send alert or warning message to administrators. It provides monitoring service without limitation of time and place of administrators.