吳 巍1,2，王高旭1,2，吳永祥1,2，張 軒1,2，許 怡1,2

(1. 南京水利科學研究院，江蘇 南京210029;2. 水文水資源與水利工程科學國家重點實驗室，江蘇 南京210098)

　　摘 要：農業灌溉用水量約占全國總用水量的60%，客觀測算農田灌溉用水量是落實最嚴格水資源制度的重要抓手，綜合運用數據庫管理手段實現農業用水復核工作的流程化和規范性成為迫切需求。深入剖析農田灌溉用水量客觀測算的原理與方法，梳理測算業務的數據流程，基于合理的數據分類提出測算模型數據需求。分析各類數據特性及數據間的關聯特性，明確數據時間尺度與存儲格式，建立氣象站點、種植結構與測算區域的對應關系。運用面向對象的設計思路，以冗余度小、可擴展性好為原則推求農田灌溉用水量測算模型數據庫設計方案，并在漢江上游構建農田灌溉用水量測算模型數據庫實例，測算結果表明：模型數據庫建設可高效支撐農田灌溉用水量測算，提升測算結果匯總分析能力。

　　關鍵詞：農業用水;農田灌溉用水;客觀測算;測算模型;數據庫設計;漢江上游

　　Research on objective calculating model database of farmland irrigation water consumption

　　WU Wei1,2 ，WANG Gaoxu1,2 ，WU Yongxiang1,2，ZHANG Xuan1,2，XU Yi1,2

　　(1. Nanjing Hydraulic Research Institute, Nanjing 210029, China;

　　2. State Key Laboratory of Hydrology-Water Resources and Hydraulic Engineering, Nanjing 210098, China)

　　Abstract：Farmland irrigation water consumption accounts for about 60% of the total water consumption in China. The objective calculation of irrigation water consumption is a key point to implement the Strictest Water Resources System. It is urgent to realize the standardization of agricultural water accounting by comprehensive use of database. This paper deeply analyzes the principle and method of objective calculating of farmland irrigation water consumption, combs the data flow of accounting model, and puts forward calculating model data demand based on reasonable data classification. This paper analyzes various data characteristics and correlation between data, to make clear the data time scale and storage format, and establish corresponding relationship between meteorological stations, planting structure and accounting area. Based on the principle of small redundancy and good expansibility, this paper deduces the design scheme of farmland irrigation water consumption calculation model database using the object-oriented design idea, and then constructs the farmland irrigation water consumption calculating model database upstream of Hanjing River. Calculation results show that the construction of model database can effectively support the objective calculation of farmland irrigation water consumption and improve the ability of summary and analysis of calculation results.

　　Key words：agricultural water; farmland irrigation water; objective calculation; calculating model; database design; upstream of Hanjiang River