CN103530808A - Whole-process tracing system for quality safety of fruit logistics - Google Patents

Abstract

The invention discloses a whole-process quality and safety traceability system for fruit logistics, including a product traceability system and a product traceability system, the product traceability system and the product traceability system are respectively connected to a database of a traceability platform; The quality prediction subsystem and the audit supervision subsystem, the audit supervision subsystem are respectively connected to the registration application subsystem and the information collection subsystem; the product traceability system includes a traceability coding subsystem, a traceability query subsystem and an information Release management subsystem; this system uses Internet, RFID (radio frequency), two-dimensional code and other technologies to implement effective supervision on fruit planting, processing, circulation, sales and other links. The system can realize multi-platform traceability, and consumers can trace the quality of fruits through websites, mobile phones, telephones, and touch screen scanning terminals.

Description

A whole-process quality and safety traceability system for fruit logistics

technical field

The invention belongs to the technical field of intelligent logistics and food safety, and relates to a system and method for traceability of the whole process of fruit logistics quality and safety.

Background technique

With the continuous improvement of people's quality of life, the requirements for fruit safety are also more refined. As far as fruits are concerned, how to buy real green and pollution-free fruits has always been a concern of consumers. At present, no matter whether it is a fruit market, a supermarket or a retailer, it is impossible to know exactly the specific conditions of the fruit in various links such as planting, processing, transportation, and sales, and it is impossible to satisfy consumers' right to know and right to choose.

J2EE is a set of technical architecture completely different from traditional application development, including many components, mainly to simplify and standardize the development and deployment of application systems, thereby improving portability, security and reuse value.

The core of J2EE is a set of technical specifications and guidelines. The various components, service architectures, and technical levels contained in it all have common standards and specifications, so that there is good compatibility between various platforms that follow the J2EE architecture. Solve the dilemma that the information products used by the backend of the enterprise in the past are not compatible with each other, which makes it difficult to communicate with each other inside or outside the enterprise.

J2EE provides a good mechanism for building scalable, flexible, and easy-to-maintain business systems:

1. Preserve existing IT assets: As enterprises must adapt to new business needs, it becomes important to leverage existing investments in enterprise information systems rather than redesigning the overall solution. Such a server-side platform mechanism that builds on existing systems in an incremental manner is what the company needs.

2. Efficient development: J2EE allows companies to hand over some common and tedious server-side tasks to middleware suppliers. In this way, developers can concentrate on how to create business logic, which shortens the development time accordingly.

3. Support heterogeneous environment: J2EE can develop portable programs deployed in heterogeneous environments. J2EE-based applications do not depend on any specific operating system, middleware, or hardware.

4. Scalability: Enterprises must choose a server-side platform that can provide excellent scalability to meet a large number of new customers who conduct business operations on their systems. Applications based on the J2EE platform can be deployed to various operating systems.

5. Stable availability: A server-side platform must be able to operate around the clock to meet the needs of the company's customers and partners.

RFID (radio frequency identification: radio frequency identification) is a non-contact automatic identification technology. It automatically identifies the target object and obtains relevant data through radio frequency signals. The identification work does not require manual intervention. It does not have the advantages of waterproof, antimagnetic, high temperature resistance, long service life, large reading distance, data on the label can be encrypted, storage data capacity is larger, and storage information can be changed freely. Its application will bring revolution to retail, logistics and other industries. Sexual changes.

The basic working principle of RFID (radio frequency identification) technology is not complicated: after the tag enters the magnetic field, it receives the radio frequency signal sent by the reader, and sends out the product information stored in the chip by virtue of the energy obtained by the induced current (Passive Tag, passive tag) tag or passive tag), or actively send a signal of a certain frequency (Active Tag, active tag or active tag); after the reader reads and decodes the information, it sends it to the central information system for relevant data processing. A complete RFID system is composed of three parts: the reader (Reader), the electronic tag (TAG), the so-called transponder (transponder) and the application software system. Its working principle is that the Reader emits a specific frequency The radio wave energy is given to the Transponder to drive the Transponder circuit to send out the internal data. At this time, the Reader receives and interprets the data in sequence and sends them to the application program for corresponding processing.

Two-dimensional codes record data symbol information with black and white graphics that are distributed on a plane (two-dimensional direction) according to a certain pattern with a specific geometric figure. ", "1" The concept of bit stream uses a number of geometric shapes corresponding to binary to represent text and numerical information, and automatically reads through image input equipment or photoelectric scanning equipment to realize automatic processing of information. It has some common features of barcode technology: each code system has its specific character set; each character occupies a certain width; it has certain verification functions, etc. At the same time, it also has the characteristics of automatic identification of information in different rows, and processing of graphic rotation changes.

The electronic tag is an electronic tag that combines an RFID electronic chip and a two-dimensional code with both a chip and a two-dimensional code. The combination of RFID electronic chip and QR code becomes the only electronic label in the world that cannot be copied, making it not only truly anti-counterfeiting, but also traceable to the source.

Data Mining (Data Mining, DM), also known as Knowledge Discovery Database (KDD), is a hot topic in the field of artificial intelligence and database research. non-trivial process of previously unknown and potentially valuable information. Data mining is a decision support process, which is mainly based on artificial intelligence, machine learning, pattern recognition, statistics, database, visualization technology, etc., to analyze enterprise data highly automatically, make inductive reasoning, and dig out potential The model helps decision makers adjust market strategies, reduce risks, and make correct decisions.

Data mining is a technology that finds its laws from a large amount of data by analyzing each data. It mainly includes three steps: data preparation, law finding and law expression. Data preparation is to select the required data from relevant data sources and integrate them into a data set for data mining; regularity finding is to use a certain method to find out the regularity contained in the data set; regular expression is to use user-friendly data as much as possible. The way of understanding (such as visualization) expresses the found laws.

Contents of the invention

The purpose of the present invention is to provide a system and method for traceability of the whole process of fruit logistics quality and safety. Using database technology, network technology and barcode technology, by constructing a unified traceability platform, a perfect agricultural product quality traceability system is established to realize the traceability of fresh fruit production enterprises. Safe production management, and provide consumers with traceability information, and at the same time play a role model for other enterprises, and promote the development of fruit quality and safety work.

Due to the long production cycle of most fruits and the high water content of fresh fruits, they are prone to damage during storage and transportation. The establishment of its traceability system should be very special. The system uses advanced technologies such as the Internet, RFID (radio frequency), electronic tags, and two-dimensional codes to implement effective supervision on fruit breeding, processing, circulation, and sales; and through Data mining technology analyzes the factors affecting fruit quality to predict the quality of fruit, thereby reducing losses and improving benefits.

In order to solve the problems of the technologies described above, the technical solution of the present invention is:

A whole-process quality and safety traceability system for fruit logistics, including a product traceability system and a product traceability system, the product traceability system and the product traceability system are respectively connected to the traceability platform database;

The product tracking system includes an audit supervision subsystem connected to the traceability platform database, a product quality prediction subsystem and an information collection subsystem, and the audit supervision subsystem is connected to the registration application subsystem and the information collection subsystem respectively;

The product traceability system includes a traceability coding subsystem, a traceability query subsystem and an information release management subsystem respectively connected to the traceability platform database;

The review and supervision subsystem respectively reviews and supervises the basic information of the terminal basic information collected by the registration application subsystem and the information collection subsystem, and saves the information that has passed the review and supervision to the database of the traceability platform;

In the product quality prediction subsystem, the prediction module and the model building module interact with the predictor selection module to complete the prediction of product quality, and the prediction information is displayed on the client;

The information release management subsystem completes the system update and maintenance, and saves the information to the traceability platform database;

The traceability coding subsystem completes the extraction of the data required by the traceability query subsystem in the traceability platform database, and encrypts these data to form a traceability code, and saves the information to the traceability platform database;

The traceability query subsystem completes information query to the system according to the URL and traceability code provided on the label, and transmits the query information to the traceability platform database.

Further, the review and supervision subsystem completes the review of the submitted basic information, and at the same time supervises the information collected by the information collection subsystem, and gives an early warning if the collected information exceeds the standard.

Further, the information collection subsystem obtains the RFID unit of the product identification through the RFID reading device, and uploads the production information, transportation information, inventory information, processing information, finished product information and sales information of the fruit to the traceability platform database.

Further, the product quality prediction subsystem extracts the training data source from the database to form a training data set through data preprocessing, and then predicts the product quality based on different algorithmic predictors, and the predicted results are divided into safe and unsafe Two categories.

Further, the data preprocessing described “cleans” the data by filling in missing values, smoothing noise data, identifying or deleting outliers and resolving inconsistencies, to achieve format standardization, abnormal data removal, error correction and duplicate data removal Objective; at the same time, data preprocessing also includes the discretization of continuous data. For example, if the date is continuous, it can be discretized by dividing different thresholds.

Further, the predictor includes a single-algorithm predictor and a multi-algorithm combined predictor, wherein the single-algorithm predictor includes a predictor based on a neural network algorithm, a predictor based on a random tree algorithm, and a predictor based on an addiction regression algorithm ; The multi-algorithm combination predictor combines the above three algorithms through the composite mode to make predictions.

Further, the traceability query subsystem obtains the product identification by scanning the two-dimensional code with the two-dimensional code scanner.

Further, the traceability encoding subsystem performs encryption processing to form a traceability code, and the data encryption processing includes encryption processing of origin code, production date code encryption processing and verification code encryption processing.

The information release management subsystem completes the synchronous update of the content displayed on the front desk through a unified operation interface, and adds the information content to the database without modifying the entire home page or adding a new page, and it is also convenient for users to inquire. Using a unified information release management subsystem, use, maintenance, and management are all based on the Web interface, without professional technology, making system maintenance as simple as text entry, linking pictures, and uploading files (including PDF, PPT, EXCEL, WORD, RAR) , FLASH and other format files), and supports HTML code entry, visual editing methods, etc., and realizes the powerful visual editing functions of desktop editing software (such as Word) on the web page.

Through various terminals such as computers or mobile phones, scan the QR code to log in to the traceability query subsystem, query the production information, transportation information, inventory information, processing information, finished product information and sales information of the fruit, and realize the full quality traceability of the fruit.

Compared with the prior art, the present invention is characterized in that:

(1) The present invention is a traceability system based on oracle relational database and J2EE development and programming technology, which has high usability and scalability.

(2) The present invention can realize multi-platform traceability, and consumers can trace fruit through websites, mobile phones, telephones, and touch screen scanning terminals.

(3) The present invention adopts data mining technology, which can be used by enterprises to predict the quality and safety of fruits, adjust production, transportation and other links to reduce losses and improve benefits.

(4) The present invention has high portability, is easy to be extended to various enterprises, can improve the safety level of fruit products, and follows the overall deployment of the Ministry of Agriculture and the General Administration of Quality Supervision, Inspection and Quarantine of the People's Republic of China on accelerating the construction of a traceability system for agricultural product quality and safety.

Description of drawings

Figure 1 is a structural diagram of the whole-process quality and safety traceability system of fruit logistics.

Detailed ways

Specific embodiments of the present invention will be described in detail below in conjunction with the accompanying drawings.

As shown in Figure 1, the entire quality and safety traceability system of fruit logistics includes a product tracking system and a product traceability system, which are respectively connected to the database of the traceability platform; among them,

The product tracking system includes an audit supervision subsystem connected to the traceability platform database, a product quality prediction subsystem and an information collection subsystem, and the audit supervision subsystem is connected to the registration application subsystem and the information collection subsystem respectively;

The product traceability system includes a traceability coding subsystem, a traceability query subsystem and an information release management subsystem respectively connected to the traceability platform database.

Among them, in the product tracking system:

The review and supervision subsystem respectively reviews and supervises the terminal basic information collected by the registration application subsystem and the information collection subsystem, and saves the information that has passed the review and supervision to the database of the traceability platform.

The review and supervision subsystem completes the review of the submitted basic information, and at the same time supervises the information collected by the information collection subsystem. If the collected information exceeds the standard, an early warning will be issued.

The information collection subsystem obtains the RFID unit of the product identification through the RFID reading device, and uploads the production information, transportation information, inventory information, processing information, finished product information and sales information of the fruit to the traceability platform database.

The product quality prediction subsystem establishes a prediction model based on the basic data of the traceability platform database, and extracts the training data source from the traceability platform database to form a training data set after data preprocessing. The quality is predicted, and the predicted results are divided into two categories: safe and unsafe, and the predicted information is displayed on the client.

Data preprocessing, cleaning data by filling in missing values, smoothing noisy data, identifying or removing outliers, and resolving inconsistencies, performing format standardization, abnormal data removal, error correction, and duplicate data removal; data preprocessing also includes Discretization of continuous data, discretization of continuous data by dividing different thresholds.

Predictors include single-algorithm predictors and multi-algorithm combination predictors, where single-algorithm predictors include neural network algorithm-based predictors, random tree algorithm-based predictors, and addictive regression algorithm-based predictors; multi-algorithm combination forecasters The forecaster combines the above three algorithms through the composite mode to make predictions.

In the product traceability system:

The information release management subsystem completes the system update and maintenance, saves the information and transmits it to the traceability platform database; the traceability coding subsystem completes the extraction of the data required by the traceability query subsystem in the traceability platform database, and encrypts these data to form traceability Code, the information is saved to the database of the traceability platform; the traceability query subsystem scans the QR code through the QR code scanner to obtain the product identification, completes the information query to the system according to the URL and traceability code provided on the label, and transmits the query information To the traceability platform database. The traceability coding subsystem performs encryption processing to form a traceability code, and the data encryption processing includes the encryption processing of the origin code, the encryption processing of the production date code, and the encryption processing of the verification code.

The development of the whole quality and safety traceability system of fruit logistics chooses the J2EE technology system, adopts the MVC (model-window-control) mode of development, and builds the J2EE technology on the JAVA technology as a whole, in order to better control the changes in the Web project and improve the product quality. Professional level, introduces the Struts technical framework, and introduces the data access object technology (DAO) in the data persistence layer.

The specific implementation steps are as follows:

The first step is to trace the platform database design: the database of this system adopts Oracle database, and according to the actual investigation results of fruit production and circulation and through the analysis of demand, it is determined to create the basic information table of the enterprise, the label generation record table, the information release record table, and the traceability record Table, fruit certification table, enterprise product information table, product complaint table and other database tables, these information tables record the origin information, producer information, product quality information, circulation link information, etc. The unified management constitutes the basic database of traceability management, and is the foundation and core of the product traceability system.

The second step is the overall system design: choose the J2EE technology system, adopt the MVC model to develop, in order to better control the changes in the Web project, introduce the Struts technology framework, and introduce the data access object technology (DAO) in the data persistence layer.

The specific design of each subsystem is as follows:

1. Product tracking system:

(1) The registration information application subsystem is mainly used for the registration application of production bases. The subsystem needs to fill in the registration information by displaying on the human-computer interaction interface page. These registration information include the name of the production unit, unit identification code, organization code, corporate legal person, farmer and main crops planted, etc. After filling in the information, click Submit button to complete the registration and then display waiting for review, otherwise you can click the reset button to fill in again.

(2) The review and supervision subsystem is mainly used by government departments (such as county-level agricultural departments, quality supervision departments, and industry and commerce departments, etc.) to review and supervise the production base information applied for registration in the basic information application subsystem. Specifically, it includes production base login account management, base basic information review, base production qualification review, and crop production status management. If the verification of the production base information is completed and the submitted basic information is reviewed, enter the account management page of the human-computer interaction interface, and you can perform password modification and other operations; otherwise, return to the production base application subsystem and display that the verification has failed.

(3) The information collection subsystem mainly uploads the production information, transportation information, inventory information, processing information, finished product information and sales information of the fruit to the server database.

The specific operation steps of each link of the information collection subsystem are as follows:

The first step is the production link: use RFID electronic tags to store fruit information in the fruit safety production database as the original data for future fruit safety traceability.

The second step is the transportation link: issue vehicle labels to the vehicles, record the vehicle number information and cargo information, and dispatch the vehicle to transport the goods to the enterprise warehouse after matching.

The third step is the inventory link: the production enterprise identifies and records the incoming goods, and stores them according to the storage requirements. Associate goods with storage label information and record them in the background database.

The fourth step is the processing link: find out the raw material information of the fruit to be processed from the database, and after successfully reading the information on the storage label, it is directly out of the warehouse to the production workshop. Through the identification of electronic tags at key points in the production process, the real-time processing information of this batch of fruits is recorded.

The fifth step, the finished product link: pack the processed products, print the barcode on the small package, and install the electronic label on the large box, and associate the packaging information with the fruit raw material information.

The sixth step is the sales link: by identifying the electronic label on the finished product packaging box delivered by the processing enterprise or the barcode information on the finished product, the terminal retailer updates its own inventory information, and when necessary, can trace back to the production through the information in the label Corporate Information.

(4) The product quality prediction subsystem mainly establishes a prediction model based on historical data, and performs prediction on the basis of this model. The specific implementation steps are as follows:

The first step is to read the training data from the data, which includes fruit production information, transportation information, inventory information, processing information, finished product information and sales information;

The second step is training data preprocessing, which discretizes and cleans the read training data;

In the third step, the preprocessed data forms a training data set;

The fourth step is to click on the predictor to select a single-algorithm predictor and a multi-algorithm combined predictor;

The fifth step is to click on the model to generate a prediction model based on the selected predictor;

The sixth step is to enter the data to be predicted in the prediction interface. These data include the amount of pesticides and fertilizers used, the processing environment, storage time, transportation time and temperature, etc., and click on the prediction to predict the quality of this batch of fruits;

In the seventh step, if a large amount of data is imported into the database, the model needs to be rebuilt, click the model refresh, and repeat the sixth step to make predictions based on the new model.

2. Product traceability system:

(1) The retrospective coding subsystem mainly extracts the manufacturer code, product code, picking time, batch code, origin code, etc. of the agricultural products of the base from the database, and generates a random code composed of 25 Arabic numerals through a proprietary encryption algorithm , that is, the fruit traceability code.

(2) The traceability query subsystem is mainly used for consumers to search the system according to the URL and traceability code provided on the label when purchasing agricultural products marked with the URL and traceability code of the traceability system. The query results include base registration information, base production qualification information, production status information, pesticide usage information, fertilizer usage information, preservative usage information, testing status information, etc., enabling consumers to trace the quality of the purchased fruit.

(3) The information release management subsystem is mainly used to update and maintain the parts of the system that need to be updated frequently, such as the latest information and pesticide residue information. Complete the synchronous update of the front display content through a unified operation interface, and add the information content to the database, without modifying the entire home page or adding a new page, and it is also convenient for users to query. Using a unified information release management subsystem, use, maintenance, and management are all based on the Web interface, without professional technology, making system maintenance as simple as text entry, linking pictures, and uploading files (including PDF, PPT, EXCEL, WORD, RAR) , FLASH and other format files), and supports HTML code entry, visual editing methods, etc., and realizes the powerful visual editing functions of desktop editing software (such as Word) on the web page.

Claims (8)

1. A whole-process quality and safety traceability system for fruit logistics, characterized in that it includes a product traceability system and a product traceability system, and the product traceability system and the product traceability system are respectively connected to the traceability platform database; The product tracking system includes an audit supervision subsystem connected to the traceability platform database, a product quality prediction subsystem and an information collection subsystem, and the audit supervision subsystem is connected to the registration application subsystem and the information collection subsystem respectively; The product traceability system includes a traceability coding subsystem, a traceability query subsystem and an information release management subsystem respectively connected to the traceability platform database; The review and supervision subsystem respectively reviews and supervises the terminal basic information collected by the registration application subsystem and the information collection subsystem, and saves the information that has passed the review and supervision to the traceability platform database; In the product quality prediction subsystem, the prediction module and the model building module interact with the predictor selection module to complete the prediction of product quality, and the prediction information is displayed on the client; The information release management subsystem completes the system update and maintenance, and saves the information to the traceability platform database; The traceability coding subsystem completes the extraction of the data required by the traceability query subsystem in the traceability platform database, and encrypts these data to form a traceability code, and saves the information to the traceability platform database; The traceability query subsystem completes information query to the system according to the URL and traceability code provided on the label, and transmits the query information to the traceability platform database. 2. The whole-process quality and safety traceability system of fruit logistics according to claim 1, characterized in that, the audit and supervision subsystem completes the audit of the submitted basic information, and at the same time supervises the information collected by the information collection subsystem. If the information exceeds the standard, an early warning will be issued. 3. The whole process quality and safety traceability system of fruit logistics according to claim 1, characterized in that, the information collection subsystem obtains the RFID unit of the product identification through the RFID read-write device, and records the production information, transportation information, and inventory information of the fruit. , processing information, finished product information and sales information are uploaded to the traceability platform database. 4. The whole process quality and safety traceability system of fruit logistics according to claim 1, wherein the product quality prediction subsystem extracts the training data source from the traceability platform database and forms the training data set through data preprocessing, and then based on different The predictor of the algorithm predicts the product quality, and the predicted results are divided into two categories: safe and unsafe. 5. The whole-process quality and safety traceability system of fruit logistics according to claim 4, characterized in that, the data preprocessing cleans up data by filling in missing values, smoothing noise data, identifying or deleting outliers and solving inconsistencies , carry out format standardization, abnormal data removal, error correction and duplicate data removal; at the same time, data preprocessing also includes the discretization of continuous data, and the discretization of continuous data is carried out by dividing different thresholds. 6. The whole-process quality and safety traceability system of fruit logistics according to claim 5, wherein the predictor includes a single-algorithm predictor and a multi-algorithm combined predictor, wherein the single-algorithm predictor includes prediction based on a neural network algorithm The predictor based on the random tree algorithm and the predictor based on the addiction regression algorithm; the multi-algorithm combination predictor combines the above three algorithms through the composite mode for prediction. 7. The whole process quality and safety traceability system of fruit logistics according to claim 1, characterized in that, the traceability query subsystem scans the QR code with a QR code scanner to obtain the product identification. 8. The whole process quality and safety traceability system of fruit logistics according to claim 1, characterized in that, the traceability coding subsystem performs encryption processing to form a traceability code, and the data encryption processing includes encryption processing of place of origin code, encryption processing of production date code and encryption and Check code encryption processing.

Images