Design And Implementation Of Zhengzhou Meteorological Observation Data Management System

Observation data is the basis of the meteorological research work, in the national geological disaster prevention project of mountain torrents, meteorological disaster monitoring and early warning of the project, supported by henan province gradually form a rational layout of observation network system.Automatic meteorological station has not only changed the original way of observation, but also because of observation time, more data density is big, make the observation data to soar, in the face of mountains of data, especially as a forecaster at the grass-roots level, the need for a new system, solve the observation data management, data query application problems.In this thesis, based on the actual demand of the weather forecaster at the grass-roots level as a starting point, uses Python as a design language, MySQL as the database, design based on conventional meteorological elements as the theme of the data warehouse, the design of zhengzhou meteorological observation data management system.This system is established with the temperature, precipitation, soil moisture as the theme of meteorological data warehouse, and use the stored procedure, trigger two technologies program, improve the operation efficiency of the system.In data warehouse design, using the technology of ETL, for a variety of heterogeneous meteorological data are analyzed, and the meteorological data in the initial loading, data conversion, purification, quality control in the process of loading, to realize the integration of the meteorological data management.In the visual display, and expounds the system function module, real-time meteorological observation data and historical meteorological data read the query.From the time series and spatial distribution, through the secondary development of Surfer software, provide a variety of display of meteorological elements.Realize the automation of service material, solved the forecast, decision service demand for information timeliness, improve the credibility of the results.Abnormal data automatic alarm to remind function, to improve the practicability of the system.Through the software test, verify the practicability of the software.The design of this system, to convenient for the observation data of the target for the grassroots forecasters, to perfect the refined meteorological disaster forecast warning construction of zhengzhou city, it is of great significance.