养分平衡法配方施肥数据库建模

Data Modeling for Prescription Fertilization of Nutrient Balance and Fertilizer Recommendation

【研究目的】养分平衡法是一种重要的配方施肥方法,在进行施肥决策时,需要依赖大量的施肥参数进行计算,所以建立数据库对施肥参数进行有效地管理是一项非常重要的工作。【结果】笔者给出了养分平衡法简洁的计算公式,采用实体-关系建模的方法确定了8个实体对象和12个关系对象,并绘制了完整的实体-关系图。【结论】本文的分析对于其他配方施肥方法的参数管理同样具有参考意义。

[OBJECTIVE]Nutrient balance and fertilizer recommendation is a very important method of prescription fertilization. The calculation of fertilization decision depend on mass of data as inputting parameters. So the valid management of these data by database is a key technology. [RESULTS]The author analyzed the data model of the relative data in further. Firstly, the formulas of this method was presented in brief, then these data were analyzed by entity-relationship method of the data modeling and 8 entities and 12 relationship objects were proposed based on the formulas to expression them. Finally, the entire entity-relationship diagram was presented. [CONCLUSION]The analysis method is also propitious to the parameter management of other method of prescription fertilization.