Construction method of Yellow River water and sand change data warehouse and public service platform

Abstract

The invention relates to a construction method of a Yellow River water and sand change data warehouse and a public service platform. The construction method of the Yellow River water and sand change data warehouse comprises the following steps: step 1, carrying out decision topic demand analysis; 2, determining a decision topic information model or a concept model; 3, determining a data source related to the decision topic information model, and screening and analyzing the data source, wherein the data source comprises data from an operational database, files and other formats, spatial data, professional attribute data and management data; 4, designing a decision topic data model or a logic model; 5, determining metadata of the data warehouse, technical standards of data collection, fusionand integration and ETL implementation of the data; and step 6, carrying out physical model design including index design, storage architecture, data loading and interface design. By constructing a Yellow River water and sediment change data warehouse, the Yellow River water and sediment change trend is scientifically predicted and analyzed, and then the purpose of scientifically governing YellowRiver is achieved.

Description

technical field [0001] The invention belongs to the technical field of data warehouse construction, and in particular relates to a construction method and a public service platform of a Yellow River water and sediment change data warehouse. Background technique [0002] The in-depth application of water conservancy information technology and the continuous innovation of river basin water resources management, such as the research on the change of water and sediment in the Yellow River, have promoted the rapid development of digital river basin construction in my country, improved the modernization level of integrated management of river basin water resources, and responded to various The problem of wading has provided strong support for the sustainable development of the economy, and achieved obvious social and economic benefits. At the same time, the rapid economic and social development has brought a huge impact on water resources and water ecosystems in river basins. The v...

AI Technical Summary

Problems solved by technology

However, at present, the ability to conduct high-level, flexible and diverse analysis, mining and processing of massive data of water resource management in river basins is weak. In addition, in the prior art, the prediction of the change trend of the Yellow River's water and sediment is often judged by calculating the proportion of sediment in the river channel and each section of water flow. The factors considered in this way are relatively single and cannot be integrated. Factors are comprehensively predicted, which ultimately leads to decision-making lag and low scientific decision-making

Images