การพัฒนากระบวนการดึง-เปลี่ยนรูป-บรรจุข้อมูล และระบบมโนภาพความสม่ำเสมอของข้อมูลในระบบวัดดัสต์บอย

Abstract

In this independent study, the extract-transform-load (ETL) system is designed and implemented to extract and transform large scale data from heterogeneous DustBoy data sources and load into DustBoy data warehouse efficiently, for ease of further usage. DustBoy measuring system was developed and is maintained by Climate Change Data Center of Chiang Mai University to collect and analyze data such as PM2.5 and PM10 from DustBoy stations. In addition, the visualization system conceptualizes the consistency of the data transmission in the DustBoy measuring system in order to demonstrate researchers or users who in the need of conveniently analyzed information for analyzing purposes and debugging problems. Furthermore, the system will assist in decision-making reference for the maintenance of each sensor device with a highly efficient approach. A measure of the efficiency of the system developed in this research indicated by measuring the transmission rate in the developed ETL system. Another indicator is visually concept and consistency of the data in the DustBoy measuring system to help in visualization aspect of the frequency of each sensor's data transmission. It can be said that this research is legitimate because it can be compatibly integrated to the existing system flawlessly.