| 基于SQL的智能灌溉专家系统优化设计 |
| |
| 引用本文： | 刘小杰.基于SQL的智能灌溉专家系统优化设计[J].农机化研究,2022,44(4):235-238,243. |
| |
| 作者姓名： | 刘小杰 |
| |
| 作者单位： | 赤峰工业职业技术学院, 内蒙古 赤峰 024000 |
| |
| 基金项目： | 内蒙古自治区自然科学基金项目(2012MS0522)。 |
| |
| 摘 要： | 随着全球水资源的不断匮乏,节水形势越来越严峻。传统的灌溉技术缺乏对水资源的合理分配,导致水资源利用率十分低下,浪费现象较为严重,且不合理的灌溉模式对农作物生长也产生了一定的影响。为提高水资源利用率,保证农作物时刻具有所需的水分,基于SQL数据库技术,完成了智能灌溉专家系统的优化设计。通过分析专家系统的基本结构,建立了SQL数据库的E-R模型,并对智能灌溉专家系统的典型数据表(用户信息表、机具信息表、灌溉标准信息表和水泵信息表)进行优化设计。最后,对灌溉系统的实际灌溉情况进行试验,结果表明:基于SQL的智能灌溉专家系统可以根据农作物的生长所需合理分配水资源,使农作物具有适宜的水分环境,对大幅提高农作物产量和质量具有一定的实践意义。
|
| 关 键 词： | 智能灌溉 专家系统 水资源利用率 SQL E-R模型 |
Optimal Design of Intelligent Irrigation Expert System Based on SQL |
| |
| Liu Xiaojie.Optimal Design of Intelligent Irrigation Expert System Based on SQL[J].Journal of Agricultural Mechanization Research,2022,44(4):235-238,243. |
| |
| Authors: | Liu Xiaojie |
| |
| Institution: | (Chifeng Vocational and Technical College of Industry, Chifeng 024000, China) |
| |
| Abstract: | With the scarcity of global water resources,the water-saving situation is becoming more and more severe.Traditional irrigation techniques lack a reasonable allocation of water resources,resulting in a very low utilization rate of water resources and serious waste.At the same time,unreasonable irrigation has also had a certain impact on crop growth.In order to improve the utilization rate of water resources and ensure that the crops have the necessary water at all times,this article and introduces SQL database technology to complete the optimization design of the SQL-based intelligent irrigation expert system.Through the research and analysis of the basic structure of the expert system,and the ER model of SQL database was established.The typical data tables(user information table,machine information table,irrigation standard information table and water pump information table)of the intelligent irrigation expert system were optimized and designed.Experiments on the actual irrigation conditions of the irrigation system show that:the SQL-based intelligent irrigation expert system can reasonably allocate water resources according to the growth of crops,so that crops have a suitable moisture environment,and have certain practices for greatly improving crop yield and quality. |
| |
| Keywords: | intelligent irrigation expert system water resource utilization SQL E-R model |
| 本文献已被 维普 万方数据 等数据库收录！ |
|
