智慧水利工程异构数据整合方法研究  

Research on heterogeneous data integration in smart water conservancy project

作　　者：余启成 YU Qicheng(Fujian Jiulongjiang Basin Center,Zhangzhou 363100,China)

机构地区：[1]福建省九龙江流域中心,福建漳州363100

出　　处：《水利水电快报》2024年第8期113-117,共5页Express Water Resources & Hydropower Information

摘　　要：水利工程建设由于日益增长的海量异构数据导致信息孤岛和资源孤岛问题,阻碍了智慧水利建设的推进工作。以福建省九龙江北溪水闸工程信息管理系统为例,分析了水利工程信息管理中的数据整合要求,从数据规范、数据集成和数据中心等3个方面,提出了北溪水闸信息管理数据整合整体框架,制定了异构数据规范和接口规范,基于ETL技术,采用Kettle工具集成各个子系统的数据,实现了水利工程异构数据资源共享访问、系统之间互联互通。研究成果显示,该方法对智慧水利工程异构数据的整合具有较好的可行性、先进性及示范性。The construction of water conservancy projects is hindered by the problem of information and resource silos caused by the increasing amount of heterogeneous data,and thereby hinders the promotion of smart water conservancy construction.We took the information management system of Jiulong River North River Sluice Project in Fujian Province as an example to analyze the data integration requirements in water conservancy engineering information management.Starting from data specifications,data integration,and data center three aspects,the overall framework for data integration in North River Sluice information management was proposed,and heterogeneous data specifications and interface specifications were developed.Based on ETL technology,Kettle tool was used to integrate data from various subsystems,realized the sharing and access of heterogeneous data resources in water conservancy engineering,as well as the interconnection and interoperability between systems.The research results on the integration of heterogeneous data of smart water conservancy projects are feasible,progressiveness and exemplary.

关 键 词：智慧水利 异构数据 信息管理 数据整合 

分 类 号：TP399[自动化与计算机技术—计算机应用技术]