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

doi:10.3969/j.issn.1008-0864.2010.02.16

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

Previous Articles Next Articles

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.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

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

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

(1.湖南大学环境科学与工程学院, 环境生物与控制教育部重点实验室, 长沙 410082|
2.中南大学信息物理工程学院, 长沙 410083)

通讯作者: 李忠武,教授,主要从事农业环境信息系统研究。 E-mail:lizhongwu@yahoo.com.cn
作者简介:黄金权,硕士研究生,研究方向为环境信息系统在农业生态环境管理中的应用。E-mail:hnu_hjq@yahoo.cn。
基金资助:
国家863计划项目(2007AA10Z222)资助。

Abstract

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

摘要：

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

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

CLC Number:

HUANG Jin-quan1, LI Zhong-wu1, ZENG Guang-ming1, WANG Zhen-xing2, LUO Xiao1, RE. Studies on Optimization of Constructing an Integrated Agro-environmental Database Mechanism Based on SQL Server+ SDE[J]. , 2010, 12(2): 86-92.

黄金权1,李忠武1,曾光明1,王振兴2,罗霄1,任平1. 基于SQL Server+ SDE的综合农业环境数据库建设机制优化研究[J]. , 2010, 12(2): 86-92.

[1]	Xiang DAI, Haichao SONG, Chuan SU. Design and Experiment of Self-propelled Garlic Vertically-planting and Fertilizing Integrated Machine [J]. Journal of Agricultural Science and Technology, 2025, 27(9): 131-144.
[2]	Hang CAO, Xinbing YANG, Yanlin LIU, Na HUO, Xiaokuan LIU, Xinyue LI. Physicochemical Properties and Enzyme Activities of Reconstituted Soils from Limestone Mines [J]. Journal of Agricultural Science and Technology, 2025, 27(8): 168-178.
[3]	Yaxin WANG, Yangcheng LYU, Wenqi WANG, Qi LIU, Jie YANG, Guihong REN, Wuping ZHANG, Fuzhong LI. Nondestructive Segmentation and Extraction of Stem and Leaf Phenotypes During Tomato Plant Growth [J]. Journal of Agricultural Science and Technology, 2025, 27(7): 90-100.
[4]	Zhongzhong DOU, Yiqi LIU. Simulation Analysis of Arc-jaw Type Potato Precision Seed Discharger [J]. Journal of Agricultural Science and Technology, 2025, 27(4): 110-119.
[5]	Huapeng HU, Xukun ZHANG, Jiajun CHEN, Yangyang PAN, Peilin YANG, Zhi LU. Structural Optimization and Moisture Content Simulation of Tea Residue Dual Axis Stirring Dryer [J]. Journal of Agricultural Science and Technology, 2025, 27(4): 120-132.
[6]	Mingjie ZHU, Wei LIAO, Zhen XU, Yilin TIAN. Study on Fish Body Length Measurement Method Based on Segmentation Mask and Binocular Vision [J]. Journal of Agricultural Science and Technology, 2025, 27(2): 116-124.
[7]	Xue WANG, Xing ZHENG, Jiamiao REN, Yazhou ZHAO, Wenjun PENG. Optimization of Extraction Conditions for Volatile Components in Jujube Honey Based on Plackett-Burman Design and Response Surface Method [J]. Journal of Agricultural Science and Technology, 2025, 27(1): 181-192.
[8]	Jingyi XI, Shuangqing WANG, Yitong BAI, Xiuli YAO, Bixuan HUANG, Qingyi LI, Liqing FAN, Shichen HUANG, Mingguo SUN. Study on Optimization of Processing Parameters Using Hermetia illucens Larva to Treat Food Waste by Response Surface Methodology [J]. Journal of Agricultural Science and Technology, 2025, 27(1): 241-249.
[9]	Yongjun XIE, Xiaozhuo PAN, Fuhui CHEN, Kaibo YIN, Jiayue JIN, Yibing WANG. Screening， Identification and Biocontrol of Bacteria Degrading Ginseng Phenolic Acid Autotoxic Substances [J]. Journal of Agricultural Science and Technology, 2024, 26(7): 147-155.
[10]	Xialing LIU, Zhaoyan CUI, Hang YE, Xiaoqiang WANG, Li ZHENG. High Standard Farmland Construction Based on Multi-source Spatio-temporal Point Cloud Fusion Technology [J]. Journal of Agricultural Science and Technology, 2024, 26(7): 80-92.
[11]	Sirou GUO, Xiaolei WEN, Jianing LI, Jianhua WANG, Weiming SUN, Lina FENG, Huixia QI. Optimization of Chinese Chestnut Yellow Crinkle Detection Method and Resistance Identification of 10 Chestnut Varieties [J]. Journal of Agricultural Science and Technology, 2024, 26(6): 226-233.
[12]	Linbo SHI, Qing PENG, Xiaoqing XU, Yuwei ZHANG, Shuo YANG, Dandan TIAN, Mengxin HE, Bo SHI, Yu QIAO. Effects of Co-culture of Lactobacillus casei NA-2 and Lactobacillus rhamnosus LGG on Antibacterial Activity [J]. Journal of Agricultural Science and Technology, 2024, 26(6): 63-71.
[13]	Zimin CHEN, Jiangting MO, Guangsheng CHEN, Xiaoxuan GUO, Xianwen ZHU. Analysis and Optimization of the Airflow Field in a Head-air Heat Pump Dryer Based on Fluent [J]. Journal of Agricultural Science and Technology, 2024, 26(10): 135-144.
[14]	Daigui GUO, Yulan LIAO, Xihui ZHANG, Chengyu YUAN, Zhongye WU. Parameter Optimization and Experiment of Cassava Planter [J]. Journal of Agricultural Science and Technology, 2023, 25(9): 122-130.
[15]	Fenfang XIAO, Conghe ZHANG, Hui WANG, Yafeng YE, Daolin ZHANG, Heting WANG, Bo LI, Yuejin WU, Binmei LIU. Simulation and Optimization of Pneumatic Conveying System for Hybrid Rice Pollen Collection Device [J]. Journal of Agricultural Science and Technology, 2023, 25(4): 110-122.

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

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

PDF

Knowledge

Abstract

Cite this article

share this article

References

Related Articles 15

Recommended Articles

Metrics