Ecological environment laboratory experimental data record management method and system

By entering and comparing experimental data in the ecological environment laboratory using multiple input methods and establishing a correction model, the problem of insufficient monitoring of the data acquisition process in experimental data management is solved, the accuracy of data and experimental efficiency are improved, and the accuracy of data is simplified. Data management and communication.

CN118940057APending Publication Date: 2024-11-12JIANGSU SHUOSHENG SCIENTIFIC EQUIPMENT CO LTD +1
View PDF 5 Cites 0 Cited by

Patent Information

Application Number
CN202411430216.1
Authority / Receiving Office
CN · China
Patent Type
Applications(China)
Current Assignee / Owner
Filing Date
2024-10-14
Publication Date
2024-11-12

AI Technical Summary

Technical Problem

The existing experimental data management methods have insufficient monitoring and comparison of the data collection process in ecological environment experiments, resulting in insufficient accuracy of experimental data. Traditional recording methods are prone to loss or identification errors, and difficulty in retrieval and sharing.

Method used

Adopt an ecological environment laboratory experimental data record management system, including data acquisition module, data processing module, model establishment module and experimental data correction module, enter data through text and image input methods, perform data classification and comparison, and establish a correction model Improve the accuracy of data recording by completing and correcting missing and abnormal records.

Benefits of technology

It improves the accuracy and efficiency of experimental data recording, reduces manual workload, enhances the reliability and repeatability of experimental results, and simplifies data management and communication.

✦ Generated by Eureka AI based on patent content.

Smart Images

  • Figure CN118940057A_ABST
    Figure CN118940057A_ABST
Patent Text Reader

Abstract

The invention provides an ecological environment laboratory experimental data record management method and system, and relates to the technical field of experimental data management, the system comprises a data acquisition module, a data processing module, a model establishment module and an experimental data correction module; the data acquisition module is used for recording experimental data in an experimental process, the data processing module is used for analyzing and processing the experimental data, and the model establishment module is used for establishing an experimental data correction model; the experimental data correction module complements and corrects missing experimental records and abnormal experimental records; according to the method, the experimental data are acquired in different modes, the acquired experimental data are compared and analyzed, and finally the experimental data are complemented and corrected according to the analysis result, so that the accuracy of experimental data result recording is improved, and the problems that an existing experimental data management method is not accurate enough and the working efficiency is high are solved. And the accuracy of the acquired experimental data cannot be ensured.
Need to check novelty before this filing date? Find Prior Art

Description

Technical Field

[0001] The present invention relates to the technical field of experimental data management, and in particular to an ecological environment laboratory experimental data record management method and system. Background Art

[0002] In the research of ecological and environmental experiments, the recording and management of experimental data plays a vital role in the promotion of scientific research activities. Through the systematic recording and management of experimental data, the accuracy, reliability and repeatability of experimental results can be effectively ensured, thereby promoting the in-depth development of scientific research.

[0003] Traditional paper-based experimental records are prone to loss or damage of experimental data, and handwritten records are prone to recognition errors or omissions, which affect the accuracy of the data. In addition, it is difficult to retrieve and share traditional experimental notebooks, which is not conducive to the management and communication of experimental data. In the existing technology, electronic laboratory recording methods are used, and the collected experimental data are usually classified and stored. For example, a Chinese patent with publication number CN116796932A discloses a testing laboratory equipment data collection and electronic original record management system. The system can remotely collect test data files of instrument equipment for various types of testing laboratories, automatically parse and store data files, generate original record sheets, and associate matching original data files with spectral data, but does not monitor and compare the experimental data collection process, and is insufficient in obtaining the accuracy of experimental data. Summary of the invention

[0004] In view of the shortcomings of the prior art, the purpose of the present invention is to provide an ecological environment laboratory experimental data recording management method and system, by collecting experimental data in different ways, comparing and analyzing the collected experimental data, and finally completing and correcting the experimental data according to the analysis results, so as to improve the accuracy of the experimental data result recording, so as to solve the problem that the existing experimental data management method is not accurate enough and cannot ensure the accuracy of the collected experimental data.

[0005] In order to achieve the above object, the present invention is implemented through the following technical solutions: In the first aspect, an ecological environment laboratory experimental data record management system includes a data acquisition module, a data processing module, a model building module and an experimental data correction module; The data acquisition module is used to record the experimental data during the experiment, store the collected experimental data in an electronic database, and establish data indexes and classifications; The data processing module is used to analyze and process the experimental data collected by the data collection module to obtain missing experimental records and abnormal experimental records; The model building module is used to build an experimental data correction model based on the experimental data in the electronic database; The experimental data correction module completes and corrects missing experimental records and abnormal experimental records according to the experimental data correction model to obtain calibrated experimental data.

[0006] Furthermore, the data acquisition module is configured with a data entry unit and a data classification unit, and the data entry unit is configured with a data entry strategy. The data entry strategy includes entering the experimental data into the experimental record table by simultaneously using text input and image input during the experiment to obtain image experimental records and electronic text experimental records. The experimental data includes experimental parameters, observation data and experimental results.

[0007] Furthermore, the text input includes establishing a text experiment record table for the experimental project, and inputting the experimental data into the text experiment record table in real time; The image input includes recording the experimental data in paper and pen during the experiment, and retaining the image through an electronic device, and setting the paper and pen records retained by the electronic device as image experiment records.

[0008] Furthermore, the data classification unit is configured with a data classification strategy, which includes establishing an experimental index based on the experimental time, arranging the experimental record sheets of the experimental items in the electronic database in the order of the experimental time, and obtaining experimental record sheets 1 to experimental record sheets n; Add keyword tags to the experimental record table based on the experimental method of the experimental project corresponding to each experimental record table, and record them as experimental category 1 to experimental category m; Number each experimental record sheet based on the experimental time and experimental classification, and get the experimental number T n J m .

[0009] Furthermore, the data processing module includes an image text matching unit, the image text matching unit is configured with an image text matching strategy, the image text matching strategy includes obtaining any image experiment record, classifying and locating all image texts in the image experiment record, and modifying the record-like text in the image text into a red-bottom image, the record-like text includes the content written by humans in the image text; Modify the printed text in the image into a blue background image, wherein the printed text includes a wireframe and a header in the image text; Get a blank text experiment record sheet, position and align the blank text experiment record sheet with the image text according to the blue background text, extract the text in the red background image, fill the text in the red background image into the corresponding position in the blank experiment record sheet, and set the filled-in table as the image text experiment record.

[0010] Furthermore, the data processing module further comprises an image proofreading unit, wherein the image proofreading unit is configured with an image proofreading strategy, wherein the image proofreading strategy comprises retrieving any experimental record table T from the electronic database. n J m , for the experimental record table T n J m Perform image text matching on the image experiment records in the image experiment record table T n J m Image text experiment record; The experimental record table T n J m The image text experiment records and the electronic text experiment records are proofread one by one, and the text records that appear in both the image text experiment records and the electronic text experiment records but are different are set as abnormal records, the text records that appear in the image text experiment records but do not appear in the electronic text experiment records are set as electronic missing records, and the text records that do not appear in the image text experiment records but appear in the electronic text experiment records are set as image missing records.

[0011] Further, the model building module includes a model building unit, the model building unit is configured with a model building strategy, the model building strategy includes setting the keywords of the experimental project as features, extracting all experimental projects with the same features, and setting them as experimental projects with the same features; The project numbers of the experimental projects with the same characteristics are sorted from small to large according to the experimental record sheet numbers, and the experimental projects whose experimental record sheet number differences are less than or equal to the first number interval are set as the experimental projects of the same period; Obtain electronic text experimental records of all concurrent experimental projects of the experimental project corresponding to the missing record or abnormal record, and set them as the first complementary reference text experimental record, wherein the missing record includes an image missing record and an electronic missing record, locate the record position corresponding to the missing record or abnormal record in the first complementary reference text experimental record, and obtain the first missing homonymous record or the first abnormal homonymous record; obtain the average value of the ratio of the first missing homonymous record or the first abnormal homonymous record to the left and right records in all the first complementary reference text experimental records, and set it as the first calibration ratio; calibrate the missing record or abnormal record according to the first calibration ratio to obtain the first calibration result; Obtain electronic text experimental records of all experimental items with the same characteristics as the experimental items corresponding to the missing record or abnormal record, set them as the second complementary reference text experimental records, locate the record position corresponding to the missing record or abnormal record in the second complementary reference text experimental records, and obtain the second missing homonymous record or the second abnormal homonymous record; obtain the average value of the ratio of the second missing homonymous record or the second abnormal homonymous record to the left and right records in all second complementary reference text experimental records, and set it as the second calibration ratio; calibrate the missing record or abnormal record according to the second calibration ratio to obtain the second calibration result.

[0012] Furthermore, the model building module is also configured with a model training unit, and the model training unit is configured with a model training strategy. The model training strategy includes using known data in an electronic database to train an experimental data correction model, obtaining a large number of first calibration results and second calibration results, comparing the accuracy of the first calibration results and the second calibration results, and using the results with higher accuracy as model parameters.

[0013] Furthermore, the model building module also includes a model calibration unit, the model calibration unit is configured with a model calibration strategy, the model calibration strategy includes using a simulation experiment to correct the trained experimental data model, the simulation experiment includes erasing or modifying any experimental data in any experimental project, setting the experimental data as a test abnormality record, correcting the test abnormality record using the experimental data correction model, and judging whether the corrected data is consistent with the data before erasure or modification, and if consistent, judging that the simulation is passed; A first number of simulation experiments are performed on the experimental data correction model to obtain a percentage of simulation passes. When the percentage of simulation passes is greater than or equal to the first percentage, the experimental data correction model is judged to have passed. When the percentage of simulation passes is less than the first percentage, the experimental data correction model is judged to have failed. After increasing the first number interval by two intervals, model training and model calibration are performed again until the experimental data correction model is judged to have passed.

[0014] Furthermore, the experimental data correction module includes a data completion unit, which is used to substitute the missing records into the experimental data correction model, output the calibration results, and complete the calibration results into the text experimental records to obtain the filled experimental records.

[0015] Furthermore, the experimental data correction module further includes a data correction unit, which is used to substitute the abnormal record into the experimental data correction model, output a calibration result, and correct the abnormal record in the text experimental record according to the calibration result to obtain a corrected experimental record; The calibrated experimental data are obtained by integrating the filled-in experimental records and the corrected experimental records.

[0016] In a second aspect, a method for recording and managing experimental data in an ecological environment laboratory comprises the following steps: Step S1: Establishing an electronic database; Step S2: record the experimental data during the experiment, store the collected experimental data in an electronic database, and establish data index and classification; Step S3: Analyze and process the experimental data to obtain missing experimental records and abnormal experimental records; Step S4: using the data in the electronic database to establish an experimental data correction model; Step S5: Complete and correct missing experimental records and abnormal experimental records according to the experimental data correction model to obtain calibrated experimental data.

[0017] Beneficial effects of the present invention: The present invention first records the experimental data in the experimental process through the data entry unit of the data acquisition module, and simultaneously uses text input and image input to enter the experimental data into the experimental record table to obtain image experimental records and electronic text experimental records, and records the experimental data in multiple ways, providing a comparison reference for subsequent analysis; The image experiment records and electronic text experiment records are classified through the data classification unit, and the experiment index is established, which improves the efficiency of subsequent call of experiment results; The present invention also compares and analyzes the image experiment record and the electronic text experiment record through the image text matching unit and the image proofreading unit to obtain abnormal records and missing records. Through two different experimental data records, it can be timely judged whether there are loopholes in the record of the experimental results, thereby reducing the error caused by a single record; The present invention also completes and corrects abnormal records and missing records by establishing an experimental data correction model, thereby reducing the workload of manual experiments and improving the experimental recording efficiency of the ecological environment laboratory.

[0018] Advantages of additional aspects of the present invention will be given in part in the description of the following specific embodiments, and in part will become apparent from the following description, or will be learned through the practice of the present invention. BRIEF DESCRIPTION OF THE DRAWINGS

[0019] Other features, objects and advantages of the present invention will become more apparent from the detailed description of non-limiting embodiments made with reference to the following drawings: Figure 1 is a functional block diagram of the system of the present invention; Figure 2 This is a schematic diagram for obtaining model parameters of the present invention; Figure 3 is a flow chart of the steps of the method of the present invention; Figure 4 It is a connection block diagram of the electronic device of the present invention. DETAILED DESCRIPTION

[0020] It should be noted that the following detailed descriptions are exemplary and are intended to provide further explanation of the present invention. Unless otherwise specified, all technical and scientific terms used herein have the same meanings as those commonly understood by those skilled in the art to which the present invention belongs.

[0021] It should be noted that the terms used herein are for describing specific embodiments only and are not intended to be limiting of exemplary embodiments according to the present invention.

[0022] In the absence of conflict, the embodiments of the present invention and the features of the embodiments may be combined with each other.

[0023] Example 1, please refer to Figure 1 As shown, an ecological environment laboratory experimental data record management system includes a data acquisition module, a data processing module, a model building module and an experimental data correction module; The data acquisition module is used to record the experimental data during the experiment, store the collected experimental data in the electronic database, and establish data index and classification; The data acquisition module is configured with a data entry unit and a data classification unit. The data entry unit is configured with a data entry strategy. The data entry strategy includes using text input and image input to enter the experimental data into the experimental record table during the experiment to obtain image experimental records and electronic text experimental records. The experimental data includes experimental parameters, observation data and experimental results. In the specific implementation process, when the recorder records the experimental results, there are problems such as the loss or damage of the single paper handwritten record, which leads to the loss of experimental data and the easy recognition error or omission of the handwritten record, which affects the accuracy of the data. Therefore, the experimental data is entered into the experimental record table by using text input and image input at the same time, which greatly improves the accuracy of the experimental data record. The text input includes establishing a text experiment record table for the experimental project, and inputting the experimental data into the text experiment record table in real time. In the specific implementation process, the text input is provided with text verification rules; the text verification rules include checking the input character length, character type and character format; Image input includes recording experimental data in paper and pen during the experiment, and retaining the image through electronic devices, setting the paper and pen records retained by electronic devices as image experimental records. In the specific implementation process, the paper and pen records are set with handwriting verification rules. The handwriting verification rules include setting the experimental data filling position and filling specifications to prevent the problem of unrecognizable records due to confusion in the order of paper and pen records; The data classification unit is configured with a data classification strategy, which includes establishing an experimental index based on the experimental time, arranging the experimental record sheets of the experimental items in the electronic database in the order of the experimental time, and obtaining experimental record sheets 1 to experimental record sheets n; in the specific implementation process, the experimental items conducted at the same time have similar recording times and the same state of experimental equipment, and the result trends shown are also similar to a certain extent. Therefore, the experimental items are arranged in the order of the experimental time to obtain the experiments at the same time, which is convenient for subsequent comparison of the experiments at the same time; Based on the experimental method of the experimental project corresponding to each experimental record table, keyword tags are added to the experimental record table, which are recorded as experimental category 1 to experimental category m; in the specific implementation process, the experimental methods of different experimental projects have a direct impact on the experimental results, so setting the experimental method as a keyword tag can accurately classify the experimental project, which is convenient for subsequent comparison of similar experiments; Number each experimental record sheet based on the experimental time and experimental classification, and get the experimental number T n J m .

[0024] The data processing module includes an image text matching unit, which is configured with an image text matching strategy. The image text matching strategy includes obtaining any image experiment record, classifying and locating all image texts in the image experiment record, and modifying the record-like text in the image text into a red-bottom image. The record-like text includes the content written by humans in the image text. The printed text in the image is modified into a blue-background image, and the printed text includes the wireframe and header in the image text; in the specific implementation process, the image content becomes easy to identify by adding a red background and a blue background to the records in the image text according to the content, so as to facilitate the subsequent accurate and efficient extraction of the image content; Obtain a blank text experiment record sheet, align the blank text experiment record sheet with the image text according to the blue background text, extract the text in the red background image, fill the text in the red background image into the corresponding position in the blank experiment record sheet, and set the filled-in table as the image text experiment record; The data processing module is used to analyze and process the experimental data collected by the data acquisition module to obtain missing experimental records and abnormal experimental records; The data processing module also includes an image proofreading unit, which is equipped with an image proofreading strategy. The image proofreading strategy includes retrieving any experimental record table T from the electronic database. n J m , for the experimental record table T n J m Perform image text matching on the image experiment records in the image experiment record table T nJ m Image text experiment record; The experimental record table T n J m The image text experiment record and the electronic text experiment record are proofread one by one, and the text records that appear in both the image text experiment record and the electronic text experiment record but are different are set as abnormal records; in the specific implementation process, when the text appears in both the image text experiment record and the electronic text experiment record but is different, it may be due to handwriting errors that cause the records to be inconsistent; Set the text records that appear in the image text experiment record but do not appear in the electronic text experiment record as electronic missing records; Set the text records that do not appear in the image text experiment record but appear in the electronic text experiment record as image missing records; The model building module is used to build an experimental data correction model based on the experimental data in the electronic database; The model building module includes a model building unit, and the model building unit is configured with a model building strategy. The model building strategy includes setting the keywords of the experimental project as features, extracting all experimental projects with the same features, and setting them as experimental projects with the same features; in the specific implementation process, for example, if the keyword of a certain experimental project is experimental category 5, and the keyword of another experimental project is also experimental category 5, then the two experimental projects are experimental projects with the same features; The project numbers of the experimental projects with the same characteristics are sorted from small to large according to the experimental record table numbers, and the experimental projects whose experimental record table number differences are less than or equal to the first number interval are set as experimental projects of the same period. In the specific implementation process, the first number interval is 3. For example, in the experimental record table T 11 J 22 , Experimental Record Sheet T 12 J 24 , Experimental Record Sheet T 15 J 22 Experimental record table T 11 J 22 Experimental Record Sheet T 15 J 22 For the same experimental project, but the experimental record table T 11 J 22 Experimental Record Sheet T 15 J 22 Not for the same period of experimental project; in the experimental record table T 18 J 22 , Experimental Record Sheet T 19 J 24 And the experimental record sheet T 21 J 22 Experimental Record Form T 18 J 22Experimental Record Sheet T 21 J 22 For experimental projects with the same characteristics, and the experimental record table T 18 J 22 Experimental Record Sheet T 21 J 22 It is a concurrent experimental project; See also Figure 2 As shown, the electronic text experimental records of all experimental projects of the same period corresponding to the experimental project of the missing record or abnormal record are obtained, and set as the first complementary reference text experimental record, the missing record includes the image missing record and the electronic missing record, and the record position corresponding to the missing record or the abnormal record in the first complementary reference text experimental record is located to obtain the first missing isotope record or the first abnormal isotope record; the average value of the ratio of the first missing isotope record or the first abnormal isotope record to the left and right records in all the first complementary reference text experimental records is obtained, and set as the first calibration ratio; the missing record or the abnormal record is calibrated according to the first calibration ratio to obtain the first calibration result; in the specific implementation process, since the experimental project often needs to be repeated for many times to reduce the experimental error, when recording the experimental results of the experimental project, the adjacent experimental records are the experimental results of different groups of the same experiment, which are similar, so the adjacent experimental records are used to calibrate the missing record or the abnormal record; Obtain electronic text experimental records of all experimental items with the same characteristics of the experimental items corresponding to the missing record or abnormal record, set them as the second completion reference text experimental record, locate the record position corresponding to the missing record or abnormal record in the second completion reference text experimental record, and obtain the second missing homonymous record or the second abnormal homonymous record; obtain the average value of the ratio of the second missing homonymous record or the second abnormal homonymous record to the left and right records in all second completion reference text experimental records, and set it as the second calibration ratio; calibrate the missing record or abnormal record according to the second calibration ratio to obtain a second calibration result; in the specific implementation process, the first completion reference text experimental record and the second completion reference text experimental record respectively use two different parameters to complete the missing text and the abnormal text, and the first calibration result and the second calibration result can be obtained. If only any one of the calibration results is used to calibrate the missing record or the abnormal record, the calibration error may occur due to parameter error; The model building module is also configured with a model training unit, and the model training unit is configured with a model training strategy. The model training strategy includes using known data in an electronic database to train an experimental data correction model, obtaining a large number of first calibration results and second calibration results, comparing the accuracy of the first calibration results and the second calibration results, and using the results with high accuracy as model parameters.

[0025] The model building module also includes a model calibration unit, which is configured with a model calibration strategy. The model calibration strategy includes using a simulation experiment to calibrate the trained experimental data model. The simulation experiment includes erasing or modifying any experimental data in any experimental project, setting the experimental data as a test abnormality record, and correcting the test abnormality record using the experimental data correction model, and judging whether the corrected data is consistent with the data before erasure or modification. If they are consistent, it is judged that the simulation is passed; A first number of simulation experiments are performed on the experimental data correction model to obtain a percentage of simulations that pass. When the percentage of simulations that pass is greater than or equal to the first percentage, the experimental data correction model is judged to pass. When the percentage of simulations that pass is less than the first percentage, the experimental data correction model is judged to fail. After the first number interval is increased by two intervals, model training and model calibration are performed again until the experimental data correction model is judged to pass. In the specific implementation process, the first number is 100 times, and the first percentage is 95%. The ecological environment experimental data has a greater impact on the experimental results, so the accuracy of the experimental data correction model is required to be higher. The experimental data correction module completes and corrects the missing experimental records and abnormal experimental records according to the experimental data correction model to obtain calibrated experimental data; The experimental data correction module includes a data completion unit, which is used to substitute missing records into the experimental data correction model, output calibration results, and complete the calibration results into the text experimental records to obtain filled experimental records; The experimental data correction module also includes a data correction unit, which is used to substitute the abnormal record into the experimental data correction model, output the calibration result, and correct the abnormal record in the text experimental record according to the calibration result to obtain the corrected experimental record; The calibrated experimental data are obtained by integrating the filled-in experimental records and the corrected experimental records.

[0026] Example 2, please refer to Figure 3 As shown, the present invention also provides an ecological environment laboratory experimental data record management method, the method comprising the following steps: Step S1: Establishing an electronic database; Step S2: record the experimental data during the experiment, store the collected experimental data in an electronic database, and establish data index and classification; Step S201: During the experiment, the experimental data is input into the experimental record table by using both text input and image input to obtain an image experimental record and an electronic text experimental record. The experimental data includes experimental parameters, observation data and experimental results. Text input includes establishing a text experiment record sheet for the experimental project and inputting the experimental data into the text experiment record sheet in real time; Image input includes recording experimental data in paper and pencil during the experiment, and retaining the image through electronic devices, and setting the paper and pencil records retained through electronic devices as image experimental records; Step S202: establishing an experimental index based on the experimental time, arranging the experimental record sheets of the experimental items in the electronic database in the order of the experimental time, and obtaining experimental record sheets 1 to experimental record sheets n; Step S203: adding keyword tags to the experiment record table based on the experimental method of the experimental project corresponding to each experiment record table, and recording them as experiment category 1 to experiment category m; Number each experimental record sheet based on the experimental time and experimental classification, and get the experimental number T n J m ; Step S3: Analyze and process the experimental data to obtain missing experimental records and abnormal experimental records; Step S301: obtaining any image experiment record, classifying and locating all image texts in the image experiment record, and modifying the record-type text in the image text into a red-bottom image, wherein the record-type text includes the manually written content in the image text; Change the printed text in the image to a blue background image. The printed text includes the wireframe and header in the image text. Step S302: Obtain a blank text experiment record sheet, align the blank text experiment record sheet with the image text according to the blue background text, extract the text in the red background image, fill the text in the red background image into the corresponding position in the blank experiment record sheet, and set the filled form as the image text experiment record; Step S303: retrieve any experimental record table T from the electronic database n J m , for the experimental record table T n J m Perform image text matching on the image experiment records in the image experiment record table T n J m Image text experiment record; Step S304: record the experiment n J m The image text experiment record and the electronic text experiment record are proofread one by one, and the text records that appear in both the image text experiment record and the electronic text experiment record but are different are set as abnormal records, the text records that appear in the image text experiment record but do not appear in the electronic text experiment record are set as electronic missing records, and the text records that do not appear in the image text experiment record but appear in the electronic text experiment record are set as image missing records; Step S4: using the data in the electronic database to establish an experimental data correction model; Step S401: setting the keywords of the experimental items as features, extracting all experimental items with the same features, and setting them as experimental items with the same features; Step S402: sorting the project numbers of the experimental projects with the same characteristics from small to large according to the experimental record table numbers, and setting the experimental projects whose experimental record table number differences are less than or equal to the first number interval as the experimental projects of the same period; Step S403: Acquire electronic text experimental records of all concurrent experimental projects of the experimental project corresponding to the missing record or abnormal record, and set them as the first complementary reference text experimental record. The missing record includes the image missing record and the electronic missing record. Locate the record position corresponding to the missing record or abnormal record in the first complementary reference text experimental record to obtain the first missing co-location record or the first abnormal co-location record. Step S404: obtaining an average value of the ratio of the first missing homonymous record or the first abnormal homonymous record to the left and right records in all first completion reference text experiment records, and setting it as a first calibration ratio; calibrating the missing record or the abnormal record according to the first calibration ratio to obtain a first calibration result; Step S405: Obtain electronic text experimental records of all experimental items with the same characteristics as the experimental items corresponding to the missing record or abnormal record, set them as the second complementary reference text experimental records, locate the record position corresponding to the missing record or abnormal record in the second complementary reference text experimental records, and obtain the second missing homonymous record or the second abnormal homonymous record; obtain the average value of the ratio of the second missing homonymous record or the second abnormal homonymous record to the left and right records in all the second complementary reference text experimental records, and set it as the second calibration ratio; calibrate the missing record or abnormal record according to the second calibration ratio to obtain the second calibration result; Step S406: training the experimental data correction model, wherein the model training includes training the experimental data correction model using known data in the electronic database, obtaining a large number of first calibration results and second calibration results, comparing the accuracy of the first calibration results and the second calibration results, and using the result with higher accuracy as a model parameter; Step S407: using a simulation experiment on the trained experimental data correction model, the simulation experiment includes erasing or modifying any experimental data in any experimental project, setting the experimental data as a test abnormality record, correcting the test abnormality record using the experimental data correction model, and judging whether the corrected data is consistent with the data before erasure or modification. If they are consistent, it is judged that the simulation has passed; A first number of simulation experiments are performed on the experimental data correction model to obtain a percentage of simulations that pass. When the percentage of simulations that pass is greater than or equal to the first percentage, the experimental data correction model is judged to pass. When the percentage of simulations that pass is less than the first percentage, the experimental data correction model is judged to fail. After the first number interval is increased by two intervals, model training and model calibration are performed again until the experimental data correction model is judged to pass. Step S5: supplement and correct missing experimental records and abnormal experimental records according to the experimental data correction model to obtain calibrated experimental data; Step S501: Substitute the missing records into the experimental data correction model, output the calibration results, and complete the calibration results into the text experimental records to obtain the filled experimental records; Step S502: Substitute the abnormal record into the experimental data correction model, output the calibration result, and correct the abnormal record in the text experimental record according to the calibration result to obtain the corrected experimental record; Step S503: Integrate the filled-in experimental record and the corrected experimental record to obtain calibration experimental data.

[0027] Example 3, please refer to Figure 4 As shown, Figure 4 The schematic diagram of the structure of an electronic device is illustrated, and the electronic device may include: a processor, a communication interface, a memory and a communication bus, wherein the processor, the communication interface and the memory communicate with each other through the communication bus. The memory stores computer-readable instructions, and the processor can call the instructions in the memory. When the computer-readable instructions are executed by the processor, the steps in the method for managing experimental data records in an ecological environment laboratory are executed to achieve the following functions: establish an electronic database; record experimental data during the experiment, store the collected experimental data in the electronic database, and establish data indexes and classifications; analyze and process the experimental data to obtain missing experimental records and abnormal experimental records; use the data in the electronic database to establish an experimental data correction model; supplement and correct the missing experimental records and abnormal experimental records according to the experimental data correction model to obtain calibrated experimental data.

[0028] In addition, the logic instructions in the above-mentioned memory can be implemented in the form of software functional units and can be stored in a computer-readable storage medium when sold or used as an independent product. Based on this understanding, the technical solution of the present application can be essentially or partly embodied in the form of a software product that contributes to the prior art. The computer software product is stored in a storage medium, including several instructions to enable a computer device (which can be a personal computer, server, or network device, etc.) to execute all or part of the steps of the method described in each embodiment of the present application. The aforementioned storage medium includes: U disk, mobile hard disk, read-only memory (ROM, Read-Only Memory), random access memory (RAM, Random Access Memory), disk or optical disk, etc. Various media that can store program codes.

[0029] Example 4. The present application also provides a computer-readable storage medium. The present application provides a storage medium on which a computer program is stored. When the computer program is executed by a processor, the steps in the above ecological environment laboratory experimental data record management method are executed to achieve the following functions: establish an electronic database; record the experimental data during the experiment, store the collected experimental data in the electronic database, and establish data indexes and classifications; analyze and process the experimental data to obtain missing experimental records and abnormal experimental records; use the data in the electronic database to establish an experimental data correction model; supplement and correct the missing experimental records and abnormal experimental records according to the experimental data correction model to obtain calibrated experimental data.

[0030] Through the description of the above implementation methods, the embodiments of the present invention can be provided as methods, systems or computer program products. Based on such an understanding, the above technical solutions can be essentially or partly contributed to the prior art in the form of software products, which can be stored in a computer-readable storage medium, such as ROM / RAM, a magnetic disk, an optical disk, etc., and include several instructions for enabling a computer device (which can be a personal computer, a server, or a network device, etc.) to execute the methods described in each embodiment or some parts of the embodiments.

[0031] In the embodiments provided in the present application, it should be understood that the disclosed system or method can be implemented in other ways. The embodiments described above are merely schematic. For example, the division of modules or units is only a logical function division. There may be other division methods in actual implementation. For example, multiple modules or units can be combined or integrated into another system, or some features can be ignored or not executed. Another point is that the mutual coupling or direct coupling or communication connection shown or discussed can be through some communication interfaces, and the indirect coupling or communication connection of systems, modules and units can be electrical, mechanical or other forms.

[0032] Finally, it should be noted that the above embodiments are only used to illustrate the technical solutions of the present application, rather than to limit it. Although the present application has been described in detail with reference to the aforementioned embodiments, those skilled in the art should understand that they can still modify the technical solutions described in the aforementioned embodiments, or make equivalent replacements for some of the technical features therein. However, these modifications or replacements do not deviate the essence of the corresponding technical solutions from the spirit and scope of the technical solutions of the embodiments of the present application.

Claims

1. An ecological environment laboratory experimental data record management system, characterized in that: It includes data acquisition module, data processing module, model building module and experimental data correction module; The data acquisition module is used to record the experimental data during the experiment, store the collected experimental data in an electronic database, and establish data indexes and classifications; The data processing module is used to analyze and process the experimental data collected by the data collection module to obtain missing experimental records and abnormal experimental records; The model building module is used to build an experimental data correction model based on the experimental data in the electronic database; The experimental data correction module completes and corrects missing experimental records and abnormal experimental records according to the experimental data correction model to obtain calibrated experimental data.

2. The ecological environment laboratory experimental data record management system according to claim 1 is characterized in that: The data acquisition module is configured with a data entry unit and a data classification unit. The data entry unit is configured with a data entry strategy. The data entry strategy includes entering the experimental data into the experimental record table by using text input and image input at the same time during the experiment to obtain image experimental records and electronic text experimental records. The experimental data includes experimental parameters, observation data and experimental results.

3. The ecological environment laboratory experimental data record management system according to claim 2 is characterized in that: The text input includes establishing a text experiment record table for the experimental project, and inputting the experimental data into the text experiment record table in real time; The image input includes recording the experimental data in paper and pen during the experiment, and retaining the image through an electronic device, and setting the paper and pen records retained by the electronic device as image experiment records.

4. The ecological environment laboratory experimental data record management system according to claim 3 is characterized in that: The data classification unit is configured with a data classification strategy, which includes establishing an experimental index based on the experimental time, arranging the experimental record sheets of the experimental items in the electronic database in the order of the experimental time, and obtaining experimental record sheets 1 to experimental record sheets n; Add keyword tags to the experimental record table based on the experimental method of the experimental project corresponding to each experimental record table, and record them as experimental category 1 to experimental category m; Number each experimental record sheet based on the experimental time and experimental classification, and get the experimental number T n J m .

5. The ecological environment laboratory experimental data record management system according to claim 4 is characterized in that: The data processing module includes an image text matching unit, and the image text matching unit is configured with an image text matching strategy, and the image text matching strategy includes obtaining any image experiment record, classifying and locating all image texts in the image experiment record, and modifying the record-like text in the image text into a red-bottom image, and the record-like text includes the content written by humans in the image text; Modify the printed text in the image into a blue background image, wherein the printed text includes a wireframe and a header in the image text; Get a blank text experiment record sheet, position and align the blank text experiment record sheet with the image text according to the blue background text, extract the text in the red background image, fill the text in the red background image into the corresponding position in the blank experiment record sheet, and set the filled-in table as the image text experiment record.

6. The ecological environment laboratory experimental data record management system according to claim 5, characterized in that: The data processing module also includes an image proofreading unit, which is configured with an image proofreading strategy, which includes retrieving any experimental record table T from the electronic database. n J m , for the experimental record table T n J m Perform image text matching on the image experiment records in the image experiment record table T n J m Image text experiment record; The experimental record table T n J m The image text experiment records and the electronic text experiment records are proofread one by one, and the text records that appear in both the image text experiment records and the electronic text experiment records but are different are set as abnormal records, the text records that appear in the image text experiment records but do not appear in the electronic text experiment records are set as electronic missing records, and the text records that do not appear in the image text experiment records but appear in the electronic text experiment records are set as image missing records.

7. The ecological environment laboratory experimental data record management system according to claim 6 is characterized in that: The model building module includes a model building unit, the model building unit is configured with a model building strategy, the model building strategy includes setting the keywords of the experimental items as features, extracting all experimental items with the same features, and setting them as experimental items with the same features; The project numbers of the experimental projects with the same characteristics are sorted from small to large according to the experimental record sheet numbers, and the experimental projects whose experimental record sheet number differences are less than or equal to the first number interval are set as the experimental projects of the same period; Obtain electronic text experimental records of all concurrent experimental projects of the experimental project corresponding to the missing record or abnormal record, and set them as the first complementary reference text experimental record, wherein the missing record includes an image missing record and an electronic missing record, locate the record position corresponding to the missing record or abnormal record in the first complementary reference text experimental record, and obtain the first missing homonymous record or the first abnormal homonymous record; obtain the average value of the ratio of the first missing homonymous record or the first abnormal homonymous record to the left and right records in all the first complementary reference text experimental records, and set it as the first calibration ratio; calibrate the missing record or abnormal record according to the first calibration ratio to obtain the first calibration result; Obtain electronic text experimental records of all experimental items with the same characteristics as the experimental items corresponding to the missing record or abnormal record, set them as the second complementary reference text experimental records, locate the record position corresponding to the missing record or abnormal record in the second complementary reference text experimental records, and obtain the second missing homonymous record or the second abnormal homonymous record; obtain the average value of the ratio of the second missing homonymous record or the second abnormal homonymous record to the left and right records in all second complementary reference text experimental records, and set it as the second calibration ratio; calibrate the missing record or abnormal record according to the second calibration ratio to obtain the second calibration result.

8. The ecological environment laboratory experimental data record management system according to claim 7 is characterized in that: The model building module is also configured with a model training unit, and the model training unit is configured with a model training strategy. The model training strategy includes using known data in an electronic database to train an experimental data correction model, obtaining a large number of first calibration results and second calibration results, comparing the accuracy of the first calibration results and the second calibration results, and using the results with higher accuracy as model parameters.

9. The ecological environment laboratory experimental data record management system according to claim 8, characterized in that: The model building module also includes a model calibration unit, which is configured with a model calibration strategy. The model calibration strategy includes using a simulation experiment to correct the trained experimental data model. The simulation experiment includes erasing or modifying any experimental data in any experimental project, setting the experimental data as a test abnormality record, correcting the test abnormality record using the experimental data correction model, and judging whether the corrected data is consistent with the data before erasure or modification. If they are consistent, it is judged that the simulation is passed; A first number of simulation experiments are performed on the experimental data correction model to obtain a percentage of simulation passes. When the percentage of simulation passes is greater than or equal to the first percentage, the experimental data correction model is judged to have passed. When the percentage of simulation passes is less than the first percentage, the experimental data correction model is judged to have failed. After increasing the first number interval by two intervals, model training and model calibration are performed again until the experimental data correction model is judged to have passed.

10. The ecological environment laboratory experimental data record management system according to claim 9, characterized in that: The experimental data correction module includes a data completion unit, which is used to substitute missing records into the experimental data correction model, output calibration results, and complete the calibration results into the text experimental record to obtain a filled experimental record.

11. The ecological environment laboratory experimental data record management system according to claim 10, characterized in that: The experimental data correction module also includes a data correction unit, which is used to substitute the abnormal record into the experimental data correction model, output the calibration result, and correct the abnormal record in the text experimental record according to the calibration result to obtain a corrected experimental record; The calibrated experimental data are obtained by integrating the filled-in experimental records and the corrected experimental records.

12. A method for managing experimental data records in an ecological environment laboratory, implemented based on an ecological environment laboratory experimental data record management system according to any one of claims 1 to 11, characterized in that: The steps include: Step S1: Establishing an electronic database; Step S2: record the experimental data during the experiment, store the collected experimental data in an electronic database, and establish data index and classification; Step S3: Analyze and process the experimental data to obtain missing experimental records and abnormal experimental records; Step S4: using the data in the electronic database to establish an experimental data correction model; Step S5: Complete and correct missing experimental records and abnormal experimental records according to the experimental data correction model to obtain calibrated experimental data.

Citation Information

Patent Citations

  • Monitoring and early warning method and system based on drainage pipe network GIS

    CN115345568A

  • Laboratory virtual simulation system and method

    CN117709081A

  • Data verification management system and method for agricultural information digital management platform

    CN118152633A

  • Method and apparatus for populating electronic forms from scanned documents

    CN1673995A

  • Imputing missing values in machine learning models

    US10733515B1