黄河水沙变化数据仓库构建关键技术研究  

Study on Key Technologies of Data Warehouse Construction of Water and Sediment Change in the Yellow River

作　　者：吴丹 夏润亮[1,2] 李涛 刘启兴[1,2] WU Dan;XIA Runliang;LI Tao;LIU Qixing(Yellow River Institute of Hydraulic Research,YRCC,Zhengzhou 450003,China;Henan Engineering Research Center of Smart Water Conservancy,Zhengzhou 450003,China)

机构地区：[1]黄河水利委员会黄河水利科学研究院,河南郑州450003 [2]河南省智慧水利工程技术研究中心,河南郑州450003

出　　处：《人民黄河》2022年第10期159-162,共4页Yellow River

基　　金：国家重点研发计划项目(2017YFC0405505,2018YFC0407905);国家自然科学基金资助项目(51779100);河南省优秀青年科学基金项目(212300410059);河南省杰出青年科学基金项目(202300410539);黄河水利科学研究院中央级公益性科研院所基本科研业务费专项资金项目(HKY-JBYW-2019-08,HKYJBYW-2020-21,HKY-JBYW-2020-07)。

摘　　要：针对黄河流域降雨、水文泥沙、土地利用等数据存在分散、多源、异构、语义不一等问题,采用数据仓库、面向对象思想、数据挖掘等关键技术将流域相关数据有机集成起来,构建黄河水沙变化数据仓库。该数据仓库主要分为数据采集层、数据存储与分析层、数据共享层、数据应用层4个层级,通过建立数据分析模型,可以支持决策信息的快速获取与综合集成;通过建立逻辑模型,可以分析水沙调度方案和数据信息的关系;通过ETL可以提供统一的数据接口,将多源、异构的水沙数据有效地抽取、转换、集成到数据仓库中。基于黄河水沙变化数据仓库,依据不同的业务场景为黄河水沙数据公共服务平台提供数据资源,从而实现多业务场景下的功能扩展与优化。Aiming at the issues of scattered,multi⁃source,heterogeneous and semantic in the data of rainfall,hydrological sediment and land use in the Yellow River Basin,the data warehouse,object⁃oriented methodology,data mining and other key technologies were used to organi⁃cally integrate the basin⁃related data and build the Yellow River water and sediment change data warehouse.The data warehouse was mainly divided into four layers of data collection layer,data storage and analysis layer,data sharing layer and data application layer.By establishing a data analysis model,it could support rapid access to decision information and comprehensive integration;by establishing a logical model,it could analyze the correlation between water and sediment scheduling program and data information;by ETL,it could provide a unified data interface to extract,convert,and analyze multi⁃source and heterogeneous water resources data effectively.Based on the Yellow River water and sediment change data warehouse,it provided data resources for the Yellow River water and sediment data public service platform based on different business scenarios,thus realizing functional expansion and optimization in multiple business scenarios.

关 键 词：数据仓库 水沙变化 关键技术 模型 黄河 

分 类 号：TP392[自动化与计算机技术—计算机应用技术] TV882.1[自动化与计算机技术—计算机科学与技术]