›› 2010, Vol. 12 ›› Issue (2): 86-92.DOI: 10.3969/j.issn.1008-0864.2010.02.16

• 863课题进展 • 上一篇    下一篇

基于SQL Server+ SDE的综合农业环境数据库建设机制优化研究

黄金权1,李忠武1,曾光明1,王振兴2,罗霄1,任平1   

  1. (1.湖南大学环境科学与工程学院, 环境生物与控制教育部重点实验室, 长沙 410082|
    2.中南大学信息物理工程学院, 长沙 410083)
  • 收稿日期:2009-10-23 修回日期:2010-01-11 出版日期:2010-04-15 发布日期:2010-03-30
  • 通讯作者: 李忠武,教授,主要从事农业环境信息系统研究。 E-mail:lizhongwu@yahoo.com.cn
  • 作者简介:黄金权,硕士研究生,研究方向为环境信息系统在农业生态环境管理中的应用。E-mail:hnu_hjq@yahoo.cn。
  • 基金资助:

    国家863计划项目(2007AA10Z222)资助。

Studies on Optimization of Constructing an Integrated Agro-environmental Database Mechanism Based on SQL Server+ SDE

HUANG Jin-quan1, LI Zhong-wu1, ZENG Guang-ming1, |WANG Zhen-xing2, LUO Xiao1, REN Ping1   

  1. (1.Key Laboratory of Environmental Biology and Pollution Control, Ministry of Education|College of Environmental Science and Engineering, Hunan University, Changsha 410082|2.School of Info-Physics and Geomatics Engineering, Central South University, Changsha 410083, China)
  • Received:2009-10-23 Revised:2010-01-11 Online:2010-04-15 Published:2010-03-30

摘要:

针对现阶段我国精准农业和数字农业发展的需求,整合当前较为先进的空间数据库引擎技术、数据库技术和3S技术等技术手段,研究提出建设区域性综合农业环境数据库的优化技术组合理论,并在此基础上进一步提出区域性综合农业环境数据库的性能优化策略,同时给出了数据库部分实例功能与整体效果评析。研究结果表明:基于Ice混合层次空间数据库引擎+SQL Server 2000农业环境数据库建设技术理论,在针对农业环境数据信息自身特点的基础上,优化了基于关系型数据库管理系统的农业数据统一存储机制,提高了结构化与非结构化农业环境信息数据间的协调性能与互操作性能;基于Ice混合层次空间数据库引擎、优化空间数据模型的运用,也为区域农业环境信息的深度挖掘与高效管理提供了理论与技术支持。

关键词: 综合农业环境数据库;建设;SDE;SQL Server;优化

Abstract:

In accordance with the requirements of Chinas precision and digital agriculture development at present stage; and with the spatial database engine technology, database technology, and 3S technology, etc., this paper puts forward a portfolio theory of optimized techniques for building regional integrated agro-environmental database. It also provides instance feature of the database and analysis of its overall effect. The results show that on the basis of its own characteristics of aiming at agro-environmental information data, this theory established on Ice mixed-level spatial database engine + SQL Server 2000 for agricultural databases has optimized the unified storage mechanism based on management system of relational database; and improved the coordination and inter-operation between structural and nonstructural agro-environmental information data. It also provides theoretical and technical support for further excavation and efficient management of regional agro-environmental information.

Key words: integrated agro-environmental database, construction, SDE, SQL Server, optimization

中图分类号: