林艳燕1,2,3 ，陈 季1,2 ，金有杰1,2

　　(1.水利部南京水利水文自动化研究所，江苏 南京 210012;

　　2.南京水利科学研究院，江苏 南京 210029;

　　3.水利部水文水资源监控工程技术研究中心，江苏 南京 210012)

　　摘 要：通过对大中型水库水利信息化系统应用现状的分析，针对数据分散、交互能力差、可视化能力低、权限管理缺乏等系统研发及应用难题，开展水库综合信息管理平台相关技术研究。管理平台关键技术包括：利用ETL工具对库区多专业整合形成平台专业业务数据库，实现基于海量数据的监测资料分析;灵活配置数据源向访问层提供屏蔽数据库厂商差异性的统一数据接口，实现基于JWT鉴权和RBAC模型的用户权限与接口访问控制;利用工程CAD制图转换成SHP格式，提高水库综合信息可视化表达能力。基于关键技术开发的水库综合信息管理平台在多个水库得以应用，可有效提高水库运行效率，减轻运行管理人员的工作量，为其他大中型水库信息化建设提供参考。

　　关键词：信息管理平台;综合信息;软件;关键技术;水库管理;ETL工具;信息融合;RBAC模型

　　Research and application of key technologies of reservoir integrated information management platform

　　LIN Yanyan 1,2,3, CHEN Ji 1,2, JIN Youjie 1,2

　　(1.Nanjing Research Institute of Hydrology and Water Conservation Automation, Ministry of Water Resources, Nanjing 210012, China;

　　2.Nanjing Hydraulic Research Institute, Nanjing 210029,China;

　　3. Hydrology and Water Resources Monitoring Engineering Research Center, Ministry of Water Resources, Nanjing 210012, China)

　　Abstract: By analyzing the application status of the existing information systems of big and medium-sized reservoirs, related technology research of reservoir integrated information management platform is carried out in view of the problems of system research and application such as data dispersion, poor interaction ability, low visualization ability and lack of authority management. Key technologies of the platform include: using ETL tools to integrate multiple specialties in the reservoir area to form a professional business database of the platform, and realize monitoring data analysis based on massive data; flexible configuration of the data source and providing unified data interface to access layers of database vendor differences by shielding, and realize user authority and interface access control based on JWT authentication and RBAC model; using CAD to convert into SHP format to improve the visualization expression ability of reservoir comprehensive information. Based on key technologies, the comprehensive reservoir information management software is developed and applied in several reservoirs, which can effectively improve the operation efficiency of those reservoirs, reduce the workload of operation management personnel, and provide references for other large and medium-sized reservoir information construction.

　　Key words: information management platform; integrated information; software; key technologies; reservoir management; ETL tools; information fusion; RBAC mode