基于改进动态扩展和位置服务的农产品追溯系统优化

    Optimization for agricultural product traceability system based on dynamic expansion improvement and location based service

    • 摘要: 农产品追溯系统是解决食品安全问题的重要手段,目前常见的追溯系统往往具有适用品种单一、精度不高、可应用性弱等特点,无法满足大规模推广应用的需要。该文以建立适用面广、性能高效的农产品追溯系统为目标,分析了常见追溯系统的软件框架与追溯信息数据结构,重点研究可支撑多品种追溯的动态扩展数据模型优化技术,同时以提升追溯精度、降低追溯成本为目标研究了基于位置服务(location based service,LBS)的追溯精度提升技术。针对追溯系统适用范围窄的问题,分析了追溯信息指标模型的数据结构特征,对比了常见的4种动态扩展数据模型,采用EAV与XML数据模型相结合的方法,通过可视化操作界面实现了不同品种追溯信息的动态扩展,通过性能分析发现该模型较其他两种模型时间缩短65%,查询效率提升了175%;针对追溯信息中的产地环境信息,分析了各类环境数据的可用来源和数据特征,制订了数据匹配的最小空间单元和实现方法,运用LBS技术实现了产地环境信息的自动获取,通过追溯系统之间的精度对比发现,该技术显著提高了追溯系统的宽度、深度、精确度,从而整体提升了系统追溯精度并降低了数据采集成本。该系统已在青海省应用,结果表明该系统较其他系统在适用范围、系统性能、追溯精度与追溯成本上具有明显优势。

       

      Abstract: Food safety has become a focus and the priority of people's livelihood. The issues of safety of agricultural products are frequent occurred around the world in recent years. For food safety incidents in the society, while agricultural products due to the presence of large uncertainties in producing area conditions, planting and processing, quality supervision of the entire journey quality traceability becomes extremely urgent for agricultural products. Through to the food safety supervision and research situation around the world, it can be found that in the construction of food safety supervision work in countries around the world,, government is gradually strengthening the construction of supervision mechanism and implementing mandatory measures to guarantee food safety. Different kinds of food safety traceability system are also gradually established and put into use. Agricultural products quality traceability system has become an important mean to solve the problem of food safety. But the current research is mainly on the single product traceability system. The public service platform has not yet been reported. The problems for lack of such system development mainly include the inability to support many kinds of traces, lower accuracy in the process of the trace, high cost of doing business application. In this paper, we developed a system applicable to quality traceability of a variety of commonly used agricultural products by analyzing the software framework of universal system and the traceability information data structure characteristics, focusing on the dynamic expansion of the data model optimization techniques and tracing precision lifting technique based on LBS. Aiming at the problem of narrow application range, we analyzed the data structure characteristics of traceability information index model, and compared four dynamic extended data models. By using the method of combining EAV with XML data model, the dynamic extension of different variety tracing information was realized through visual interface. It was found that the model compared to the other two models shortened time by 65% and query efficiency by 175% through performance analysis. For traceability information on producing environmental conditions, we analyzed the various types of available data sources and characteristics, formulated the smallest unit of space and realization method. We also used LBS technology to achieve the automatic acquisition of the origin of the environmental information. As such we found that the technique significantly improved the traceability system of width, depth, accuracy. Therefore it enhanced the overall system tracing precision and reduced the data collection cost. Through the database performance analysis, we found that the system query efficiency increased by 1.5 times, less CPU time. By traceability system general comparison, it indicated that the system can apply to many varieties of agricultural products with a good accuracy. We tested the system in livestock products quality and safety in Qinghai province. The results showed that the system had good performance and functional versatility, the system had obvious advantage in query efficiency and traceability accuracy, suitable for all kinds of agricultural products quality traceability.

       

    /

    返回文章
    返回