Design And Implementation Of Safe Produce Attestation And Supervision Information System

In recent years,with the improvement of people's living standards,safety of agricultural products has caused more and more attention.After China joins WTO, "Green Barriers" a new term has attracted more and more people's attention.All of these problem made many new demands to agricultural production sector and regulatory departments of agricultural products.Beijing 2008 Olympic Games contractors also accelerated the safety of agricultural products and early-warning mechanism for the establishment of retrospective,has increased efforts to monitor the safety of agricultural products.In this context,this article will GIS technology into agricultural products quality safety supervision system and geographic information into the product barcode,and the agricultural product production and sales of geographic information regulatory process for agricultural information management,construction and initial based on the realization of WebGIS monitoring the safety of agricultural products certified information systems.Concrete contents is as follows:1.The establishment of the safety agricultural products attestation and supervision database.Database using a standardized database design,through needs analysis,the concept of structural design,logic design structure,the physical design of the design process,in the relational database management system to establish complete database model.The establishment of the main table(user information table),then the establishment of information associated with users from the table(table registration information,download information form,evaluation of information,etc.),from the main table must crawl through access to detailed information on the user's To minimize the occurrence of redundant data to ensure that monitoring the integrity of the database.2.The base authentication and the authentication product code integration research. This study finds that the use of certified products base and the integration of 32(metric) encoding,or geographical location coding enterprises Code+code+certification class certification time coding certification category code + type certification coding +coding farmers block coding The way,which is used in coding location countries zip code,this can enhance system scalability,in order to promote the use of the system;enterprises through computer programming code is randomly generated,may be unique.3.The establishment of the safety agricultural product habitat environmental evaluation model.Environmental assessment of the product origin of theory,method of presentation and to determine system for the evaluation of methods and specific technical processes.Based on the information related to national standards and the agricultural sector on the basis of criteria,set to air,soil,water quality indicators as the origin of the environmental assessment component of the construction of a pollution-free food production,green food production,organic food production environment evaluation model.Made environmental assessment process,including the technical preparation phase,the unit of evaluation,selection of evaluation to determine the weight of evaluation to determine evaluation criteria,the single factor or factors evaluation comprehensive evaluation,classification,gradation,and several other steps.Including water,soil comprehensive evaluation by sub-index average and maximum combined Nemerow index, the air quality assessment to consider using both air average,also an appropriate balance between the maximum value of the air quality index.4.The applications of barcode technology.Through monitoring the distribution of bar code,print,use and recognition that the establishment of identity recognition technology,corporate identity monitoring mechanism,to complete certification supervision work.This study was designed to establish techniques,which integrated the visual management and the model of producing area environmental assessment about the cognizance of bases and the certification of products for monitoring agricultural products,and a comprehensive database of the information about bases,productions and authentication.This system of quality control achieves the authentication and the security management of agricultural products for the government departments.