晏 涛，夏向学

　　(华北科技学院，河北 三河065201)

　　摘 要：目前水利统计信息系统收录全国各省市、自治区的农业灌溉、供用水、水土保持、水利建设投资、农村水电、水文站网等行业数据，这些数据来源渠道广、涉及维度多、信息量级大，传统的数据分析手段已经很难满足水利业务分析的需要。为解决水利统计数据体量大、类型多、分析慢的问题，基于大数据技术提出包含从数据接入到业务应用的架构体系，设计综合展示、空间分析、智能分析及多维分析等功能模块，建立基于大数据技术的水利统计查询分析系统。结果表明：大数据水利统计查询分析系统不仅能够满足水利统计业务分析的需要，而且可以统筹分析不同类别、频率的数据，为水利统计查询分析业务提供平台支撑，同时也为大数据技术应用于其他行业提供参考。

　　关键词：大数据;水利统计分析;Hadoop;数据仓库;查询分析

　　中图分类号：TP39 文献标识码：A 文章编号：

　　Application of big data technology in query and analysis system of water statistics

　　YAN Tao，XIA Xiangxue

　　(North China Institute of Science and Technology, Sanhe 065201, China)

　　Abstract：At present, the water statistics information system stores industry data of agricultural irrigation, water supply and consumption, water and soil conservation, water conservancy construction investment, rural hydropower, hydrological station network etc. from all provinces, cities and autonomous regions. These data are collected from multi-sources and multi-dimensions with enormous information, which means the traditional data analysis methods are difficult to meet the demands of water business analysis. In order to solve the data problems, such as big volume, various types and slow analysis, a query and analysis system of water statistics is proposed, with a systematic framework from data access to business application based on big data technology. Functional modules are designed into this system, including integrated display, spatial analysis, intelligent analysis and multi-dimensional analysis. The results show that the big data query and analysis system of water statistics can not only meet the demands of water business analysis, but also comprehensively analyze data of different types and frequencies. It provides platform support for query and analysis business of water statistics, and also provides references for the application of big data technology in other industries.

　　Key words: big data;water statistics analysis;Hadoop;data warehouse;query and analysis