摘要
通过数据库技术对无公害农产品认证的产地、产品及相关信息进行管理是提高认证效率的一个重要手段。从中国无公害农产品认证的现状出发,针对认证过程中信息的多源性、时效性、连续性、关联性和多类性的数据特征,采用实体-联系的建模方法,分析认证过程中的产品、产地、标准等实体的属性及其关系,确立农产品认证分类信息、产地信息、产品信息等六类信息,并建立字段和表,构建了基于关系模型的无公害农产品信息数据库,旨在为中国无公害农产品信息的管理提供高效支持。
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 ago-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.
出处
《中国农学通报》
CSCD
北大核心
2009年第23期464-472,共9页
Chinese Agricultural Science Bulletin
基金
国家863计划"农产品数字化认证平台"(2006AA10Z270)
国家科技支撑计划"西南地区地力耗竭型种植系统耕地保育综合技术研究与示范"(2006BAD05B06-03)
关键词
无公害农产品
关系型数据库
数据特征
nuisanceless agro-food, relational database, characteristic of data
