Design And Development Of Application Management System Of Hydrological And Sediment Database In The Yellow River Basin

The Yellow River is known as "the cradle of the Chinese nation".However,since the 1990 s,the river course of the Yellow River has been cut off,the ecological environment has deteriorated,the water pollution has aggravated,and the river channel has shrunk rapidly,causing widespread concern in society.Faced with the increasingly deteriorating environment in which people get along with the river,people realized that measures must be taken to change the situation so as to achieve harmony between people and rivers."Less water and more sand,imbalance of water and sand" was the root cause of the siltation of the Yellow River.According to this,people put forward measures such as "store clear water and remove muddy water,block coarse particles and release fine,regulate the water and sand timely,silt in floodplain and scour in main channels" and other measures.With the rapid development of computer technology and the comprehensive development of hydrology and water conservancy information,all these measures are inseparable from the rational management of hydrological information.Through the establishment of a hydrology and sediment platform for the Yellow River basin,the complex water and sediment information of the Yellow River can be reasonably stored and effectively utilized,and the flood process and sediment transport rate of the watercourse can be predicted in advance,which will be conducive to the implementation of artificial control of water and sediment,and the coordination of the relationship between the water and sediment of Yellow River,so as to achieve the purpose of harmonious coexistence between human and the Yellow River.This article takes the Yellow River Basin as the research object and develops the application management system of the water and sediment database.The main tasks completed include the following aspects:(1)The front-end programming languages Java Script and HTML5 were introduced.Taking advantage of the front-end and back-end separation and decoupling development of code,Vue technology,Spring Boot technology and Mybatis technology were selected to build water and sediment database application management system of The Yellow River Basin.The characteristics and working process of these three technologies were introduced in detail,and briefly introduced the Axios technology and database technology.(2)Based on Oracle 11 g database platform,through the analysis of the characteristics of hydrology and sediment in the Yellow River Basin and the needs of users,convert the analyzed water and sediment data of the Yellow River Basin into a database model that can be created by the Yellow River Basin water and sediment database application management system,completed the conceptual design,logical design and physical design of the Yellow River Basin water and sediment database,including the division of logical sub-libraries such as basic geographic sub-library,hydrological special sub-library,mud sand library sub-library,reservoir data sub-library,precipitation data sub-library,runoff data sub-library,and established a complete water and sediment database in the Yellow River Basin that is conducive to organization and management of data and easy to query.That achieved structured management of water and sediment data in the Yellow River Basin.(3)According to the basic function requirements of the development system,the requirements analysis and functional module design were carried out.Five functional modules were finally determined,including:user management,map service,data statistics and input,rain-water-sand query,and flood forecasting scheme.(4)Build a project development environment and develop common components,and at the same time,develop functional modules for system demand analysis and product design,and carry out complex water and sediment data in the Yellow River Basin on the system in the form of tables,landing histograms,and water and sediment process lines,and through the model program selection,forecast time,long delay time,warm-up time,correction time and other conditions settings to carry out water and sediment program simulation and forecast.The Huayuankou-Lijin river section is selected on the system to verify the water level,flow,and sand content.Through the comparison of the calculated and measured values on the system,it is found that the flood peak change process and the calculated value of the flood propagation time are basically consistent with the measured value.The calculated value of the amount of sand and the peak occurrence time of sand is basically the same as the measured value,which verifies the feasibility of the Yellow River Basin water and sediment database application management system.On the basis of verification,the sections from Qingtongxia to Bayangaole and Bayangaole to Toudaoguai hydrological stations are selected for simulation calculation of water and sediment schemes to provide ideas for subsequent Yellow River governance.