晏 濤，夏向學

　　(華北科技學院，河北 三河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