PESTICIDE RESIDUE DETECTION DATA PLATFORM BASED ON HIGH RESOLUTION MASS SPECTRUM, INTERNET AND DATA SCIENCE, AND METHOD FOR AUTOMATICALLY GENERATING DETECTION REPORT

Abstract
Disclosed is a pesticide residue detection data platform based on high resolution mass spectrum, the Internet and data science, and a method for automatically generating a detection report. The platform includes allied laboratories, a detection result database of the allied laboratories, four basic sub-databases, a data collection system and an intelligent data analysis system. The intelligent analysis system reads data according to conditions set by a user, performs various statistical analyses according to a statistical analysis model, generates charts, obtains a comprehensive conclusion, and returns an analysis result to the client ends of the allied laboratories.
Description
TECHNICAL FIELD

This invention presents a method for online tracing and warning of pesticide residues in agricultural products, particularly refers to the building method of pesticide residue detection data platform and automatic generation method of detection report based on the ternary integration technique which consists of high-resolution mass spectrometry, Internet, and data science, which belongs to interdisciplinary technique.


BACKGROUND ART

At present, in the pesticide residue detection reports published by quality supervision departments, the detection data is mainly represented by data tables and only a few statistical charts. Generation of these reports need long time and have poor timeliness. Moreover, these statistical data and charts are difficult to understand for the public, and lack of timely management and early warning functions. In addition, as non-target pesticide residue detection techniques are implemented in a high degree of digitization, informatization and automation, massive analytical data have been generated, which is also a challenge to traditional data statistics and analysis methods. Therefore, it is urgent to develop a system which can provide the innovative big data acquisition, transmission, statistics and intelligent analysis. In recent years, with the development of electronic information and Internet, new approach and method are provided for multi-dimensional expression, sharing and analysis of big data of pesticide residue detection.


It is necessary to construct a pesticide residue detection data platform based on interdisciplinary integration of Internet, advanced high-resolution mass spectrometry, and data science to realize timely acquisition, management and intelligent analysis of pesticide residues data, generate pesticide residue detection reports automatically in a short time, provide real-time online service for the traceability and risk assessment of pesticide residue, realize scientific management and use of pesticides. However, until now, there is no report on such method and system.


CONTENTS OF THE INVENTION

The invention presents a ternary interdisciplinary integration technique, which consists of high-resolution mass spectrometry, Internet, and data science, constructs a pesticide residue detection data platform and presents an automatic detection report generation method. In laboratory union based on Internet and distributed in China, more than 1,200 pesticides commonly used are screening continuously in different fruits and vegetables according seasons. Databases are established through pesticide residue detection data acquisition to achieve intelligent management and analysis of data, automatic report generation.


The present invention “pesticide residue detection data platform construction and automatic detection report generation method based on the ternary integration technique of a high-resolution mass spectrometry, Internet, data science” proposes four major parts: {circle around (1)} establishing laboratory union and pesticide residue detection standard methods; {circle around (2)} establishing a laboratory union detection result database and four basic sub-databases; {circle around (3)} establishing a pesticide residue data acquisition system; and {circle around (4)} establishing an intelligent analysis system of pesticide residue data.


The first part of this invention is to establish laboratory union and standard pesticide residue detection method. The establishment of laboratory union refers to establishing laboratory union across the country, which are operated under five unified criteria (unified sampling, unified sample preparation, unified detection method, unified format data uploading, and unified format statistical analysis report) in a closed system and detect pesticide residues in fruits and vegetables on the market throughout the country all year. The pesticide residue data detection methods by Liquid Chromatography-Quadrupole-Time of Flight/Mass Spectrometry (LC-Q-TOF/MS) and Gas Chromatography-Quadrupole-Time of Flight/Mass Spectrometry (GC-Q-TOF/MS) techniques detect pesticide residues in fruits and vegetables to obtain relevant raw data of pesticide residues.


The second part of this invention is to establish a laboratory union detection result database and four basic sub-databases. Wherein, the union laboratory detection result database includes names of pesticides, names of agricultural products, sampling time, sampling locations, detection methods, and detection organizations, etc. The four basic sub-databases include a multi-country MRLs database, an agricultural product category database, a pesticide information database, and a geographic information database. The multi-country MRLs database contains 241,527 items of relevant MRLs, criteria from different counties or regions, such as China, Hong Kong of China, United States, European Union, Japan and CAC. It includes the pesticides, agricultural products, maximum residue limits (MRLs), and the criteria-setting countries or organizations. The agricultural product category database mainly contains the category criteria in China, Hong Kong of China, US, EU, Japan, and CAC. It mainly comprises name of agricultural products, primary category, secondary category, and tertiary category, etc. The pesticide information database includes their basic information such as toxicity, function, chemical composition, prohibition, and derivatives. It specifically comprises name, CAS registry number, toxicity intensities of the pesticides, Whether the pesticides are metabolic compounds and their metabolic precursors or not, and whether the pesticides are prohibited in the criteria or not. The geographic information database covers required geographical scopes, and comprises detailed address of all sampling locations in provincial, regional, and county-level administrative division, etc.


The third part of this invention is to establish a data acquisition system. Three-layer architecture based on “browser/Web server/database server” comprises a data acquisition module, a data preprocessing module, a contamination level judgment module, and a data storage module. The browser layer is in the clients of the laboratory union and is an interface for the users to access the system. The Web server layer is located in a data center and is responsible for accessing the databases and executing preprocessing logics. The database server is located in a data center and is responsible for storing and managing various kinds of data. The functions of all modules in the acquisition system are as follows: (1) the data acquisition module is responsible for acquiring pesticide residue detection results reported by the laboratory union; (2) the data preprocessing module is responsible for processing the reported detection data, including judgment of reported data, and supplementation, categorization and merging for the information of pesticide, region, and agricultural product category, etc.; (3) the contamination level judgment module is responsible for judging contamination levels according to the MRLs in different countries (or regions, or organizations); (4) the data storage module is responsible for storing records of final results into the databases.


The fourth part of this inventions is to create an intelligent data analysis system, which mainly establish the link and communication among the detection result database and the four sorts-databases, and realizes multi-dimensional cross analysis of sampling locations, pesticides, agricultural products, and contamination levels according to statistical analysis models. The system is also based on the three-layer architecture of “browser/Web server/database server”, and comprises a parameter setting module, a single item analysis module, a comprehensive analysis module, a report generation module, a table generation module, and a prewarning reporting module. The browser layer is in the clients of the laboratory union and is an interface for the users to access the system, set statistical parameters, and download statistical results. The Web server layer is also located in the data center and is responsible for accessing the databases and executing various statistical analysis logics. The database server is located in the data center and is responsible for storing and managing various pesticide residue data. The functions of all modules in the intelligent data analysis system are as follows: (1) the parameter setting module is responsible for providing interface and channel to set parameter for the users; (2.) the single item analysis module is responsible for accomplishing 18 individual statistics functions; (3) the comprehensive analysis module is responsible for accomplishing 5 comprehensive analysis tasks based on individual analysis result; (4) the report generation module is responsible for generating detection reports that contain text and charts from the analytical results; (5) the table generation module is responsible for generating various statistical tables; (6) the warning reporting module provides warning prompts according to the analytical results.


BENEFICIAL EFFECTS OF THIS INVENTION

The platform construction and automatic detection report generation method presented in this invention provides an efficient and accurate data analysis platform for pesticide residue data analysis and pre-warning in China. Wherein, the laboratory union and the united pesticide residue detection methods could guarantee uniformity, integrality, accuracy, security, and reliability of data. The establishment of union laboratory detection result database and four basic sub-databases provides basis for pesticide residue detection data analysis and contamination level judgment. The presented pesticide residue data acquisition system realizes automatic uploading of detection results, data preprocessing, and contamination level judgment. Based on the above, we established a national pesticide residue detection result database. The presented intelligent pesticide residue data analysis system establishes the link and communication among the raw detection data and the four basic sub-databases, realizes individual and comprehensive statistics and analysis of multi-dimensional pesticide residue data, and automatically generates detection result reports that contain text and charts. By “one-button download”, the detection result report could be generated within 30 minutes, which can't be realized with traditional statistical methods.


Compared with the existing manual reports, the detection reports generated method in this invention not only has high accuracy, high speed, and diverse judgment criteria, but also has flexible statistical range and various analysis methods. The platform and method in this invention realize the automation of online data acquisition, result judgment, statistical analysis, and report generation. They greatly improve the depth, accuracy and efficiency of data analysis, and are of great practical significance and commercial application value.





DESCRIPTION OF DRAWINGS


FIG. 1 shows the Internet pesticide residue detection data analysis platform across China;



FIG. 2 shows the pesticide residue detection data acquisition system;



FIG. 3 shows the intelligent pesticide residue detection data analysis system;



FIG. 4 shows an automatically generated pesticide residue detection report;



FIG. 5 shows a parameter selection interface for automatic export of pesticide residue detection report;



FIG. 6 shows the five-level tree structure of administrative divisions for pesticide residue detection reports;



FIG. 7 shows the content of a pesticide residue detection report;



FIG. 8 shows the detection rates of pesticide residues in fruits and vegetables from 31 provincial capitals/municipalities markets in 2012-2015;



FIG. 9 shows measurement of sample safety level according to the MRL standards of several countries, regions, or international organizations;



FIG. 10 shows the toxicity categories and percentages of detected pesticides;



FIG. 11 shows the species and frequencies of pesticides exceeding CAC-MRLs.





EMBODIMENTS

This invention will be presented in detail with reference to the accompanying drawings and embodiments.


The Internet-based national big data technical platform of pesticide residue detection is shown in FIG. 1. It comprises four main parts: {circle around (1)} more than 30 Internet-based laboratories across the country; {circle around (2)} a union laboratory- detection result database and four basic sub-databases (a multi-country MRLs database, an agricultural product category database, a basic information of pesticide database, and a geographic information database); {circle around (3)} a pesticide residue data acquisition system; {circle around (4)} an intelligent pesticide residue analysis system. The last two parts constitute a data processing center. The working principle of the platform is shown below. The raw pesticide residue detection results are reported from clients in the union laboratory distributed in the country to the acquisition system via Internet, as shown in FIG. 2. The acquisition system carries out the judgment of the contamination levels by data acquisition, information supplementation, derivative information merging, toxicity analysis, and according to the MRL standards in different countries, records the result, and stores the records into the detection result database. The intelligent analysis system sets and reads the data according to the criteria set by the users, performs statistical data analyses one by one according to statistical analysis models, generates charts, draws general conclusions and creates detection reports. Finally, it returns the analytical results to the clients in the union laboratory for viewing and downloading, as shown in FIG. 1.


Table 1 shows the raw detection result database and four basic sub-databases (multi-country MRLs database, agricultural product category database, basic information of pesticide database, and geographic information database) established in more than 30 laboratories across the country. An associated data storage and query model established based on “MRL standards in several countries-categories of agricultural products-properties of more than one thousand pesticides” is proposed. Thus, linked basic pesticide residue data access and invocation is realized, and a standard basis for judgment of the pesticide residue detection results is provided.


A pesticide residue data acquisition system is designed as shows in FIG. 2, and a national pesticide residue detection result database is established. A data integration and processing model consisting of “data acquisition-information supplementation-derivative consolidation-prohibited pesticide handling-contamination level judgment” is presented, which realizes quick online acquisition and merging of pesticide residue detection result data, accurate judgment of the data according to MRLs from several countries and dynamic addition and real-time update of the pesticide residue detection result database is realized, and provides scientific data for decision-making of food safety in the country. As shown in FIG. 2, the pesticide residue detection data acquisition system employs three-layer architecture based on browser/server. The laboratory union are operated under five unified specifications (unified sampling, unified sample preparation, unified detection, unified format data uploading, and unified format statistical analysis report) in a closed system, utilizes Liquid Chromatography-Quadrupole-Time of Flight/Mass Spectrometry (LC-Q-TOF/MS) and Gas Chromatography-Quadrupole-Time of Flight/Mass Spectrometry (GC-Q-TOF/MS) techniques to report pesticide residue detection data that is detected in fruits and vegetables, which can fully guarantee the uniformity, integrality, accuracy, security, and reliability of data. The raw detection result data is acquired with ASP.NET technique to supply the information on pesticides, regions, and agricultural product categories merge derivatives and manage pesticide toxicity categorization. The result is judged contamination level according to the MRL criterion of the countries or regions or organizations and stored the generated records of results in the detection result database.


An intelligent pesticide residue detection data analysis system is established as shown in FIG. 3. The intelligent analysis system comprises a presentation layer, a business layer, an access layer, and a data layer. The data layer consists of the detection result database, the four basic sub-databases, and relevant files and is configured to provide database and file services. The access layer accesses the data in the databases via a database access component and provides the data to the business layer. The business layer realizes multi-dimensional statistical analysis of sampling locations, pesticides, and contamination levels according to the statistical analysis models. The presentation layer provides various intelligent analysis reports that contain text and charts according to the criterion set by a client. An online custom mode is established in the present invention to support the users to select and filter the statistical data autonomously, to highlight the data of interest or key data. Meanwhile it supports the user to customize the report type and range, to improve data presentation and big data analysis capability. It is realized that multi-dimensional automatic statistics of 20 pesticide residue indices including agricultural products, pesticides, regions, and MRLs in different countries, as shown in Table 2. Wherein, 31 different tables and 38 different figures can be generated automatically, and comprehensive assessment and warning information can be generated automatically according to the statistical results. Finally, a pesticide residue detection report that contains text and charts can be generated automatically within 30 minutes by “one-button download”, as shown in FIG. 4.



FIG. 4 shows the result of multi-discipline multi-element pesticide residue big data integration technique based on ternary interdisciplinary integration technique of high-resolution mass spectrometry, Internet, and data science. “One-button download” is realized, and a detection report that contains texts and charts can be generated within 30 minutes. The pesticide residue detection report reflects 20 regular characteristics of pesticide residues in more than 150 species of fruits and vegetables in 18 categories in 31 provincial capitals/municipalities in the country, as shown in Table 2.









TABLE 2





20 regular characteristics of pesticide residues


discovered through big data statistical analysis















(1) It is found that pesticide residues exist almost in most fruits


and vegetables from 31 provincial capitals/municipalities. The


pesticide residue detection rate is 39%-88% (LC-Q-TOFMS)


or 54%-97% (GC-Q-TOFMS).


(2) Altogether 517 pesticides are detected in more than 150


species of fruits and vegetables in 18 categories (wherein,


93 pesticides are detected with both techniques) in China;


(3) It is found that the pass rate of pesticide residues in fruits


and vegetables from 31 provincial capitals/municipalities is


96.3%-98.7%, which means that the safety level is assured


essentially;


(4) The regular characteristics of pesticide residue detection


levels (1-5, 5-10, 10-100, 100-1,000, greater than 1,000 μg/kg)


in our country are discovered (by comparison with


MRLs in China, EU, and Japan, etc.);


(5) The regular characteristics of detected pesticide species in


individual samples (not found, 1 species, 2-5 species, 6-10


species, more than 10 species) in our country are


discovered;


(6) The regular characteristics of detected pesticide species


in the same category of samples (not detected, 1 species,


2-5 species, 6-10 species, more than 10 species) in our


country are discovered;


(7) The regular characteristics of pesticide functions


(insecticides, bactericides, herbicides, plant growth regulators,


synergistic agents, and other species, and their proportions) in


our country are discovered;


(8) The regular characteristics of toxicity of pesticides in our


country (species of pesticides of slightly toxic, low toxic,


slightly low toxic, moderately toxic, highly toxic, vitally toxic,


and prohibited, and their proportions) are discovered;


(9) The order of pesticide species detected throughout the


country and in the provincial capitals and the order of


frequencies of detection are discovered, revealing the


differences in pesticide application in fruits and vegetables


among different regions throughout the country;


(10) The order of safety (“exceeding”, “detected but not


exceeding”, “not detected”) of the detected pesticides


throughout the country and in the provincial capitals is


discovered (by comparison with MRL standards in China,


EU, and Japan);


(11) It is found that the MRLs in China is confronted with a


challenge of lower level and less quantity when compared


with MRLs in developed countries such as USA, EU, and


Japan;


(12) It is found that only 40% of the massive residue data


in the general investigation is used according to the China


MRLs, while the application ratio of the data is as


high as 95% or above in EU and Japan; consequently.


(13) Top 10 species of fruits and vegetables in which the


quantities of pesticide species are the largest and


the order of follow-tap fruits and vegetables are


discovered; it is found that the common fruits and vegetables


are contaminated severely.


(14) Top ten species of fruits and vegetables in which the


average detected frequency of pesticides is the highest


and the order of thef ollow-up fruits and vegetables are


discovered;


(15) The species of highly toxic, vitally toxic, and prohibited


pesticides and the detection frequencies are discovered;


(16) Top ten fruits and vegetables in which the quantities of


highly toxic, vitally toxic, and prohibited pesticides are the


largest and the order of follow-up fruits and vegetables are


discovered;


(17) Top ten fruits and vegetables in which the detected


frequency of highly toxic, vitally toxic, and prohibited


pesticides is the highest and the order of follow-up fruits and


vegetables are discovered;


(18) The general characteristics of and the differences in the


existence of pesticides in the commercial fruits and


vegetables in 31 provincial capitals/municipalities are


discovered;


(19) The characteristics of and the differences in the pesticides


detected at the sampling locations in 31 provincial capitals/


municipalities are discovered;


(20) The characteristics of and the differences in the use of


pesticides in 31 provincial capitals/municipalities are


discovered.









The download parameters of pesticide residue detection result report are shown in FIG. 5. The sampling period and type can be selected freely. One or more administrative divisions can be selected at will (a five-level architecture of “national-regional-provincial-city-county” can be realized) as shown in FIG. 6. User can select the type of the testing instrument and export the body part or the annexed tables of the report as required. The content of the body part of a local report consists of 5 chapters, as shown in FIG. 7. The report of detection result includes various charts to help user visually understand statistic result. For example, reflecting the detection rates of pesticide residues in fruits and vegetables from 31 provincial capitals/municipalities (see FIG. 8). Pie charts that reflect the safety levels of the detected samples, as shown in FIG. 9. Toxicity categories of detected pesticides and their proportions, as shown in FIG. 10. And bar charts that are used for out-of-specification analysis of specific samples (sec FIG. 11), etc. There are 20 annexed tables which could be selected in the report. They record the raw detection results and detail statistics of concentration distribution, contamination levels, and out-of-specification (MRLs) of detected pesticide residues.


A report may contain words ranging from tens of thousands of words to hundreds of thousands of words depending on the data size, and the body part and the annexed tables may contain text and charts. Such a report may be generated and downloaded by “one-button download” within 30 minutes. Thus, the analysis and reporting ability to the massive pesticide residue data is greatly improved. Besides, the automatic reporting system further supports customization and extension of report structure and content.


Example of analysis report: the pesticide residue detection result database now contains 13.74 million detection data items of 22,368 batches samples of more than 140 specifies of fruits and vegetables from 638 sampling spots in 31 provincial capitals/municipalities (including 284 counties) in the country, which is stored in 10 laboratories in the country, 145 million high-resolution mass spectra are collected, and pesticide residue detection reports containing 25 million words in total are formed.


The basic information of pesticide residues in fruits and vegetables from 31 provincial capitals/municipalities in the country has been investigated preliminarily, as shown in FIG. 8, Tables 3 and 4. The further general investigation of the basic situation of pesticide residues in fruits and vegetables from Beijing, Tianjin, and Hebei in 2016 is similar to that of pesticide residues in fruits and vegetables in 31 provincial capitals/municipalities in 2012-2015.









TABLE 3





Basic information of pesticide residues in fruits and vegetables


from 31 provincial capitals/municipalities (2012-2015)

















Item
LC-Q-TOF/MS
GC-Q-TOF/MS





Detected pesticide
174/25448
343/20418


species/frequency




Range of pesticide residue
39.3%-88.0%
28.6%-100%


detection rate













Total number
424
Total number of
93 species


of pesticide
species/
pesticide species



species/frequencies
45,866
detected by both



detected
times
techniques



by both techniques
















TABLE 4





Basic information of pesticide residues in fruits and vegetables


from Beijing, Tianjin, and Hebei (2016)

















Item
LC-Q-TOF/MS
GC-Q-TOF/MS





Detected pesticide
161/9724
197/9834


species/frequency




Range of pesticide residue
20.0%-100.0%
50.0%-100.0%


detection rate













Total number
279
Total number of
56 species


of pesticide
species/
pesticide species



species/frequencies
19,558
detected by both



detected
times
techniques



by both techniques









It is shown in Table 3 that in the 22,368 samples from 31 provincial capitals/municipalities in 2012-2015, totally 517 pesticides were detected (wherein, 93 pesticides were detected by both techniques), and the detected frequency was 45,866 times. It is listed in Table 4 that in the 10,190 samples from Beijing, Tianjin, and Hebei in 2016, totally 227 pesticides were detected, and the detected frequency was 19,558 times. It is found in the big data analysis for the general investigation from 31 provincial capitals/municipalities in 2012-2015 and the general investigation from Beijing, Tianjin, and Hebei in 2016 that the safety level of commercial fruits and vegetables in China was essentially assured, at 97% or above pass rate according to the China MRL standards. However, the pesticide residue problem was still severe. It is found in the big data statistical analysis: {circle around (1)} highly toxic or vitally toxic pesticides (e.g., Carbofuran, Isocarbophos, and Methidathion) and prohibited pesticides (e.g., Thimet, Ethoprophos) were still detected frequently, and the detection frequency is 5.5% of the total detection frequency; {circle around (2)} there are about 19% samples in which the pesticide residues were exceeding MRLs ; {circle around (3)} there are about 0.7%; individual samples in which more than 10 pesticide residues were found {circle around (4)} the quantity of pesticide residue species detected in single specie of fruits and vegetables was 30 or more, and was even about 100 pesticides at the most; {circle around (5)} The detection rates of pesticide residues in common fruits (grape, apple, pear and peach) and vegetables (celery, tomato, cucumber and sweet pepper) were high, and the phenomena of exceeding MRLs were severe, shown in Tables 5 and 6; {circle around (6)} comparing with the MRL standards in advanced countries, the pesticide residue MRLs in China are confronted with a challenge of lower quantity and lower threshold. For example, in the 9,834 detected times of pesticide residues in the general investigation (GC-Q-TOF/MS) from Beijing, Tianjin, and Hebei in 2016, there are only 2,233 corresponding MRL items in the China MRL standards, which is 22.7%. China MRL standards are the lowest among all of the 6 MRL standards, which are much lower than the MRL standards in EU and Japan.









TABLE 5







Detection results of pesticide residues in 4 types of fruits (grape, apple,


pear and peach) and 4 types of vegetables (celery, tomato, cucumber, and sweet


pepper)








LC-Q-TOF/MS
GC-Q-TOF/MS























Number

Number of






Number of


of

pesticide




Number of

pesticide


samples

species in



Total
samples in

species in

Total
in which

which



number
which
Pesticide
which

number
pesticides
Pesticide
pesticides



of
pesticides
detection
pesticides

of
are
detection
are


Sample
samples
are detected
rate, %
are detected
Sample
samples
detected
rate, %
detected



















Grape
411
367
89.3
75
Grape
389
316
85.6
81


Apple
628
579
92.2
61
Peach
279
234
83.9
83


Pear
574
397
69.2
52
Pear
437
349
79.9
91


Celery
537
479
89.2
87
Celery
353
341
96.6
132


Tomato
621
547
88.1
81
Cucumber
343
381
87.8
112


Cucumber
591
548
92.7
76
Sweet
369
292
79.1
104







pepper




















TABLE 6







MRL analysis of three categories of pesticide residues in 4 types of fruits


(grape, apple, pear and peach) and 4 types of vegetables (celery, tomato,


cucumber, and sweet pepper)








LC-Q-TOF/MS
GC-Q-TOF/MS















Number of









out-of-speci-
Number of
Number of

Number of
Number of
Number of



fication
out-of-speci-
out-of-speci-

out-of-speci-
out-of-speci-
out-of-speci-



pesticides
fication
fication

fication
fication
fication



according
pesticides
pesticides

pesticides
pesticides
pesticides



to China
according to
according to

according to
according to
according to



MRL
EU MRL
Japan MRL

China MRL
EU MRL
Japan MRL


Sample
standards
standards
standards
Sample
standards
standards
standards

















Grape
9
24
25
Grape
3
24
33


Apple
3
17
11
Peach
3
23
30


Pear
4
11
9
Pear
2
24
33


Celery
7
45
36
Celery
8
69
88


Tomato
5
21
21
Cucumber
5
32
37


Cucumber
8
22
22
Sweet
2
19
37






pepper












The above detailed description is provided only to describe some feasible embodiments of the present invention rather than to limit the protection scope of the present invention. Any equivalent embodiment or modification implemented without departing from the spirit of the present invention shall be deemed as falling in the protection scope of the present invention.

Claims
  • 1. A pesticide residue detection data platform based on high-resolution mass spectrometry, Internet, and data science includes laboratory union, a union laboratory detection result database and four basic sub-databases, a data acquisition system, and an intelligent data analysis system, wherein, the laboratory union refers to several standard laboratories established across the country, which are operated under five unified specifications in a closed system and detect pesticide residues in fruits and vegetables on the market throughout the country all year;the union laboratory detection result database contains names of pesticides, names of agricultural products, sampling times, sampling locations, detection methods, and detection organizations; the four basic sub-databases are a multi-country MRL(maximum residue limit) database, an agricultural product category database, a pesticide information database, and a geographic information database;the data acquisition system realizes automatic uploading of detection result, data preprocessing, and contamination level judgment, to establish a national pesticide residue detection result database;the data acquisition system comprises a data acquisition module, a data preprocessing module, a contamination level judgment module, and a data storage module; the data acquisition module is responsible for acquiring pesticide residue detection results reported by the union laboratories; the data preprocessing module is responsible for processing the reported detection data, including judgment of reported data, and supplementation, categorization, and merging of information of pesticide, region, and agricultural product category; the contamination level judgment module is responsible for judging contamination levels according to the MRLs of different countries or regional organizations; the data storage module is responsible for storing records of final results into the databases;the intelligent data analysis system realizes link and communication among the detection result database and the four basic sub-databases, accomplishes multi-dimensional cross analysis of sampling locations, pesticides, agricultural products, and contamination levels according to statistical analysis models, sets and reads data and then carries out statistical analyses according to the statistical analysis models on the criteria set by the users, generates charts, draws comprehensive conclusions, provides detection reports, and returns the analytical results to clients in the union laboratories for viewing and downloading;the intelligent data analysis system comprises a parameter setting module, an single item analysis module, a comprehensive analysis module, a report generation module, an annexed table generation module, and a warning reporting module; the parameter setting module is responsible for providing interface and channel of parameter set by the users; the single item analysis module is responsible for accomplishing itemized statistics of several items; the comprehensive analysis module is responsible for accomplishing comprehensive analysis of several items on the results of single item analysis; the report generation module is responsible for generating detection reports that contain text and charts from the analytical results; the annexed table generation module is responsible for generating various statistical tables; the warning reporting module provides warning prompts according to the analytical results;the intelligent data analysis system is specifically implemented as including a presentation layer, a business layer, an access layer, and a data layer; the data layer consists of the detection result database, the four basic sub-databases, and relevant files, and is configured to provide database and file services; the access layer accesses the data in the databases via a database access component and provides the data to the business layer; the business layer realizes multi-dimensional statistical analysis of sampling locations, pesticides, and contamination levels according to the statistical analysis models; the presentation layer provides various intelligent analysis reports that contain text and charts according to several criteria set by the client.
  • 2. The pesticide residue detection data platform based on high-resolution mass spectrometry, Internet, and data science according to claim 1, wherein, the multi-country MRLs database includes 241,527 items of MRL standard items from China MRL, Hong Kong of China MRL, US MRL, EU MRL, Japan MRL, and CAC MRL standards, targeted pesticides, agricultural products, permitted MRLs, and the standard establishment countries/regions/organizations.
  • 3. The pesticide residue detection data platform based on high-resolution mass spectrometry, Internet, and data science according to claim 1, wherein, the agricultural product category database comprises standards of China categorization, Hong Kong of China categorization, US categorization, EU categorization, Japan categorization, and CAC categorization.
  • 4. The pesticide residue detection data platform based on high-resolution mass spectrometry, Internet, and data science according to claim 3, wherein, the agricultural product category database specifically comprises names of agricultural products, primary category information, secondary category information, and tertiary category information.
  • 5. The pesticide residue detection data platform based on high-resolution mass spectrometry, Internet, and data science according to claim 1, wherein, the pesticide information database contains basic information, toxicity information, function information, chemical composition, prohibition information, and derivative information.
  • 6. The pesticide residue detection data platform based on high-resolution mass spectrometry, Internet, and data science according to claim 5, wherein, the pesticide information database specifically comprises names of all detected pesticides, CAS registry number of the pesticides, toxicity intensities of the pesticides, whether the pesticides are metabolic products and their metabolic precursors or not, and whether the pesticides are prohibited in the standards or not.
  • 7. The pesticide residue detection data platform based on high-resolution mass spectrometry, Internet, and data science according to claim 1, wherein, the geographic information database covers required geographical scopes, and comprises detailed address of all sampling locations in provincial administrative division, regional administrative division, and county-level administrative division.
  • 8. The pesticide residue detection data platform based on high-resolution mass spectrometry, Internet, and data science according to claim 1, wherein, the data acquisition system is implemented on the basis of three-layer architecture consisting of browsers, a Web server, and a database server, wherein the browsers are located in the clients in the union laboratories and are interfaces for the users to access the system; the Web server is located in a data center and is responsible for accessing the databases and executing preprocessing logics; the database server is located in the data center and is responsible for storing and managing various pesticide residue data.
  • 9. The pesticide residue detection data platform based on high-resolution mass spectrometry, Internet, and data science according to claim 1, wherein, the intelligent data analysis system is implemented on the basis of three-layer architecture consisting of browsers, a Web server, and a database server; the browsers are located in the clients in the union laboratories throughout the country, and are interfaces for the users to access the system, set statistical parameters, and download statistical results; the Web server is also located in the data center and is responsible for accessing the databases and executing various statistical analysis logics; the database server is located in the data center and is responsible for storing and managing various pesticide residue data.
  • 10. The pesticide residue detection data platform based on high-resolution mass spectrometry, Internet, and data science according to claim 1, wherein, the five unified specifications include unified sampling, unified sample preparation, unified detection method, unified format data uploading, and unified format statistical analysis report.
  • 11. An automatic pesticide residue detection report generation method using the pesticide residue detection data platform based on high-resolution mass spectrometry, Internet, and data science according to claim 1, comprising: reporting raw pesticide residue detection results to the data acquisition system from the clients in the union laboratories distributed in the country over Internet; the data acquisition system carries out the judgment of contamination levels by data acquisition, information supplementation, derivative information merging, and toxicity analysis, and according to the MRL standards in different countries, records the results, and stores the records of results into the detection result database; the intelligent analysis system sets and reads the data according to the criteria set by the users, then performs statistical analyses of the data one by one according to statistical analysis models, generates charts, draws comprehensive conclusions, generates detection reports, and returns the analytical results to the clients in the union laboratories.
  • 12. The automatic pesticide residue detection report generation method according to claim 11, wherein, the union laboratories detect pesticide residues by Liquid Chromatography-Quadrupole-Time of Flight/Mass Spectrometry (LC-Q-TOF/MS) and Gas Chromatography-Quadrupole-Time of Flight/Mass Spectrometry (GC-Q-TOF/MS) and report pesticide residue detection data that is detected all year.
  • 13. The automatic pesticide residue detection report generation method according to claim 11, further comprising: setting up an online custom mode in the intelligent analysis system to support the users to select and filter the statistical data autonomously, to highlight the data of interest or key data, and to support the users to customize the type and range of report.
Priority Claims (1)
Number Date Country Kind
201710249874.4 Apr 2017 CN national
PCT Information
Filing Document Filing Date Country Kind
PCT/CN2018/082954 4/13/2018 WO 00