Design and implementation of CTD profile observation data accumulation system based on MySQL

Abstract

In order to realize the accumulation of sea temperature, conductivity, pressure, depth, salinity, density and sound profile observation data, a ocean observation data storage system based on database is designed. For efficiently realizing accumulation of ocean observation data, the system makes full use of the advantages of MYSQL database management platform, and orderly stores tens of thousands ofConductivity-Temperature-Depth(CTD) profile observation data. At the same time, the data quality control will be applied to the received hydrological observation data, which improves the quality of the data stored in the database and enhances the data usability. After the system was developed, a simulation environment was set up to test the system. The results show that the system hasrational function design and stable operation, which can well realize the accumulation of CTD profile observation data. The realization of ocean hydrologic profile observation data accumulation provides reliable data source for the subsequent in-depth data-mining and utilization of ocean hydrologic observation data.