林艷燕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