欢迎访问《中国农学通报》,

中国农学通报 ›› 2009, Vol. 25 ›› Issue (23): 464-472.

• 工程 机械 水利 装备 • 上一篇    下一篇

无公害农产品数据库的设计——以种植业为例

高添   

  • 收稿日期:2009-04-09 修回日期:2009-09-03 出版日期:2009-12-05 发布日期:2009-12-05
  • 基金资助:
    农产品认证数字化管理平台

Design and Realization of Database for Nuisanceless Agro-Food Information in China-A Case Study in Planting

  • Received:2009-04-09 Revised:2009-09-03 Online:2009-12-05 Published:2009-12-05

摘要: 通过数据库技术对无公害农产品认证的产地、产品及相关信息进行管理是提高认证效率的一个重要手段。本文从我国无公害农产品认证的现状出发,针对认证过程中信息的多源性、时效性、连续性、关联性和多类性的数据特征,采用实体-联系的建模方法,分析认证过程中的产品、产地、标准等实体的属性及其关系,确立农产品认证分类信息、产地信息、产品信息等六类信息,并建立字段和表,构建了基于关系模型的无公害农产品信息数据库,旨在为我国无公害农产品信息的管理提供高效支持。

关键词: 花生, 花生, 灰色关联度, 综合评判, 育种

Abstract: It is very helpful to establish database managing producing area, production quality, environment standard and other relative information of nuisanceless agro-food, for the improvement of nuisanceless agro-food certificating. In this paper, the method of ER was utilized to analyze the properties and interrelations of entities such as agro-food, agro-food area and standard, etc. based on status and data characteristics as multi-sources, time effectiveness, continuity, relationship and multi-category of nuisanceless agro-food certification. The relational database of nuisanceless agro-food was accomplished by the classification of the information of nuisanceless agro-food and establishment of tables and the fields, and the objective was to provide an efficient support for the management of nuisanceless agro-food information.