节水农业决策支持系统的数据库建设

在对内陆干旱半干旱地区灌溉用水的来源、节水灌溉技术的类型、节水环节分析的基础上,将节水农业决策支持系统的数据库分为基础数据、常规节水技术、高新节水技术、非常规水源灌溉技术4个一级子库;基础数据在SuperMap环境下以矢量格式分层组织;常规节水技术、高新节水技术、非常规水源灌溉技术等节水技术数据以关系型数据结构在SQLServer环境下生成,数据编码以灌溉用水的节水环节为主线,以作物类型的节水试验为副线;各节水灌溉技术数据库下分试验设计、试验结果、节水效果3个子库,数据子库以试验水平为数据项,以试验处理为记录进行数据组织。

Database construction of decision support system on water-ecolomic agriculture

Based on the analysis on sources of irrigation water, types of water-economic irrigation technologies and links of water-economic irrigation in arid and semiarid region inland, the database of the decision support system on water-economic agriculture could be divided into four first subdatabases: element database, routine water-economic irrigation technology database, advanced water-economic irrigation technology database and non-routine water sources irrigation technology database. Element database is constructed under SuperMap in ways of vector and layer;while database of water-economic irrigation technologies such as routine water-economic irrigation technology database, advanced water-economic irrigation technology database, non-routine water sources irrigation technology database are constructed under SQL Server in ways of relationship data structure; data are coded based on main links of water-economic irrigation, and subsidiary on water-economic irrigation experiments with different crops. Every first subdatabase of water-economic irrigation technology includes three secondary subdatabase: experiment design, experiment results and water-economic effects;the secondary subdatabase is constructed in ways of experiment level as data item and experiment treatment as record.