การพัฒนาระบบแสดงผลข้อมูลสำหรับสุขภาพฐานข้อมูลเชิงสัมพันธ์

Abstract

The objective of this independent study was to develop a system to summarize health status of multiple relational databases using ETL (Extract Transforms Load) techniques which extract data from various sources transform and load into a master database. Then, the health status data is analyzed and presented by using business intelligent tool. This system provides a convenience and timesaving platform for observing the availability and identifying anomalies of each database. Furthermore, this system allows the administrators to detect problems that can occur, such as disk space full which can cause the system to stop and consequently, damage the reliability of the system. The proposed system is evaluated in two aspects. First, the time spent for make a summary of the health of the database to check abnormal from these databases is compared between existing system and proposed system. Second, the accuracy and completeness of the information provided by the proposed system is compared with that of existing system. From the evaluation, It was found that proposed system can meets the expected time saving, contains complete information as expected, and has verified that the data is correct with the fact data in each the database source.