A method, system and storage medium for checking experimental data in electronic records

Abstract

This invention discloses a method, system, and storage medium for verifying experimental data in electronic records. According to verification instructions, the method acquires the data of each experimental instrument recorded within the verification area and the corresponding bound instrument screen image. Based on the instrument type in the experimental instrument data, it queries the corresponding screen recognition information in the instrument information database. Based on information such as the position of digital feature areas and non-digital feature areas on the screen, it identifies the instrument measurement parameters in the instrument screen image. Finally, it compares the identified information with the information already entered in the electronic experimental record to identify any errors in the record. This effectively ensures the accuracy of the entered data in the experimental record and eliminates the significant time and effort required for quality inspectors to manually compare the data in the input boxes of each record book with the instrument screen images.

Description

Technical Field

[0001] This invention relates to the field of data processing technology, and in particular to a method, system, and storage medium for verifying experimental data in electronic records. Background Technology

[0002] With the rapid development of science and technology, the use of instruments in social industry, social sciences and other fields is increasing. However, data collection from these instruments has become a rather troublesome task. In pharmaceutical research and development laboratories, researchers need to record a large number of process parameters related to instruments during drug development. Traditional laboratory data collection often involves researchers recording data with pen and paper or manually entering data into computers. Such methods are prone to data errors or loss, resulting in data mismatches.

[0003] To ensure accuracy, many pharmaceutical companies constantly verify the accuracy of their data entries against the instrument readings during the experimental process. This not only wastes significant labor costs but also fails to guarantee compliance. Furthermore, they often need to continuously photograph the instruments while completing the experimental records, then upload these photos to the lab manual. Quality control personnel then compare the data in the input boxes of each record with the images on the instrument screens. A single experimental record may involve the use of dozens of instruments, requiring the images to be meticulously processed and compared, resulting in enormous labor costs. Summary of the Invention

[0004] This invention addresses the shortcomings of existing technologies by providing a method for verifying experimental data in electronic records. This method is used to audit and verify experimental instrument data entered into electronic experimental records, and includes the following steps:

[0005] S1, Receive a data verification instruction, the data verification instruction including the audit and verification area in the electronic experimental record;

[0006] S2, sequentially retrieve the data of each experimental instrument recorded in the audit and verification area and the corresponding bound instrument screen image;

[0007] S3. Query the corresponding screen recognition information in the instrument information database according to the instrument type in the experimental instrument data. The screen recognition information includes the shape of the screen area, the position of the digital feature area on the screen, and the position of the non-digital feature area on the screen. The non-digital feature is a text feature or a letter feature. Identify the instrument measurement parameters in the instrument screen image according to the position of the digital feature area on the screen and the position of the non-digital feature area on the screen.

[0008] S4 compares the identified instrument measurement parameters with the data recorded in the experimental instrument data. If they are different, an experimental instrument data error response is issued.

[0009] Preferably, step S4 includes:

[0010] S41, compare and match each recorded data and the identified data in the experimental instrument data to obtain the first recorded parameter and the first identified parameter that cannot be matched;

[0011] S42, query whether there is a non-digital feature area in the instrument screen image. If it exists, obtain the first non-digital feature area corresponding to the first digital feature area where the first identification parameter is located, and identify the first unit of measurement in the first non-digital feature area.

[0012] S43, based on the first unit of measurement, query the instrument information database to see if there is a unit conversion relationship group containing the first unit of measurement;

[0013] S44, if a unit conversion relationship group containing the first unit of measurement exists, then the predetermined parameter unit of the first recorded parameter is obtained from the experimental instrument data; the first identified parameter is converted into a conversion parameter corresponding to the predetermined parameter unit according to the unit conversion relationship group; and compared with the first recorded parameter. If they are different, a data error action is triggered; or

[0014] If a unit conversion relationship group containing the first unit of measurement exists, the predetermined parameter unit of the first recorded parameter is obtained from the experimental instrument data. The first recorded parameter is converted into a conversion parameter corresponding to the first unit of measurement according to the unit conversion relationship group, and compared with the first identification parameter. If they are different, a data error action is triggered.

[0015] Preferably, step S42 further includes:

[0016] S421, If ​​there is no non-digital feature area in the instrument screen image, then obtain the predetermined parameter unit of the first recorded parameter from the experimental instrument data;

[0017] S422, Query the unit conversion relationship group containing the predetermined parameter unit in the instrument information database according to the predetermined parameter unit;

[0018] S423, obtain the conversion formula of the predetermined parameter unit and other convertible candidate units of measurement, convert the first recorded parameter in sequence and compare the converted parameter with the first identification parameter. If they are different, perform the conversion of the next candidate unit of measurement until they are the same or the conversion comparison of all candidate units of measurement is completed. If the comparisons are all different, trigger the data error action.

[0019] Preferably, step S4 includes:

[0020] The second unit of measurement in the identified non-digital feature area is compared with the predetermined parameter units of the experimental instrument data. If there is the same second predetermined parameter unit, the second record parameter corresponding to the second predetermined parameter unit in the experimental instrument data is obtained, and the second record parameter is compared with the second identification parameter in the second digital feature area corresponding to the second non-digital feature area of ​​the identified second unit of measurement. If they are different, a data error action is triggered.

[0021] If there is no identical second predetermined parameter unit, then determine whether there are any recorded parameters in the experimental instrument data that have not been matched and verified. If so, then query the instrument information database for the unit conversion relationship group containing the second unit of measurement.

[0022] The second record parameter is converted into the corresponding candidate unit of measurement based on the unit conversion relationship group. Each conversion parameter is then compared with the record parameter that has not completed the matching verification. If they are all different, a data error action is triggered.

[0023] Preferably, step S4 includes:

[0024] Each predetermined parameter unit of the experimental instrument data is compared with the unit of measurement in the identified non-digital feature area. If the same unit exists, the identification parameter in the digital feature area corresponding to the non-digital feature area where the unit of measurement is located is obtained and compared. If they are different, a data error action is triggered.

[0025] This invention also discloses a verification system for experimental data in electronic records, used to audit and verify experimental instrument data entered in electronic experimental records, including:

[0026] The instruction receiving module is used to receive data verification instructions, which include the audit and verification area in the electronic experimental record.

[0027] The data acquisition module is used to sequentially acquire the data of each experimental instrument recorded within the audit and verification area and the corresponding bound instrument screen image;

[0028] The identification module is used to query the corresponding screen identification information in the instrument information database according to the instrument type in the experimental instrument data. The screen identification information includes the shape of the screen area, the position of the digital feature area on the screen, and the position of the non-digital feature area on the screen. The non-digital features are text features or letter features. The instrument measurement parameters in the instrument screen image are identified according to the position of the digital feature area on the screen and the position of the non-digital feature area on the screen.

[0029] The comparison module is used to compare the identified instrument measurement parameters with the data recorded in the experimental instrument data. If they are different, an error response is issued for the experimental instrument data.

[0030] Preferably, the comparison module includes:

[0031] The matching module is used to compare and match each recorded data in the experimental instrument data with the identification data to obtain the first record parameter and the first identification parameter that cannot be matched.

[0032] The unit acquisition module is used to query whether there is a non-digital feature area in the instrument screen image. If it exists, it acquires the first non-digital feature area corresponding to the first digital feature area where the first identification parameter is located, and identifies the first unit of measurement in the first non-digital feature area.

[0033] The query module is used to query the instrument information database to see if there is a unit conversion relationship group containing the first unit of measurement.

[0034] The unit conversion module is used to obtain the predetermined parameter unit of the first recorded parameter from the experimental instrument data if there is a unit conversion relationship group containing the first unit of measurement, convert the first identified parameter into a conversion parameter corresponding to the predetermined parameter unit according to the unit conversion relationship group, and compare it with the first recorded parameter. If they are different, a data error action is triggered.

[0035] Preferably, the unit acquisition module includes:

[0036] The first parameter acquisition module is used to obtain the predetermined parameter unit of the first recorded parameter from the experimental instrument data when there is no non-digital feature area in the instrument screen image;

[0037] The conversion relationship query module is used to query the unit conversion relationship group containing the predetermined parameter unit in the instrument information database;

[0038] The comparison module is used to obtain the conversion formulas of the predetermined parameter unit and other convertible candidate units of measurement, convert the first recorded parameter in sequence, and compare the converted parameter with the first identification parameter. If they are different, the conversion of the next candidate unit of measurement is performed until they are the same or the conversion comparison of all candidate units of measurement is completed. If the comparisons are all different, a data error action is triggered.

[0039] The present invention also discloses a verification device for experimental data in electronic records, including a memory, a processor, and a computer program stored in the memory and executable on the processor, wherein the processor executes the computer program to implement the steps of any of the methods described above.

[0040] The present invention also discloses a computer-readable storage medium storing a computer program that, when executed by a processor, implements the steps of any of the methods described above.

[0041] The present invention discloses a method, system, and storage medium for verifying experimental data in electronic records. According to a verification instruction, it acquires the data of each experimental instrument recorded within the verification area and the corresponding bound instrument screen image. Based on the instrument type in the experimental instrument data, it queries the corresponding screen recognition information in the instrument information database. It identifies the instrument measurement parameters in the instrument screen image based on information such as the position of digital feature areas and the position of non-digital feature areas on the screen. Finally, it compares the identified information with the information already entered in the electronic experimental record to identify any errors in the record. This effectively ensures the accuracy of the entered experimental data and eliminates the significant time and effort required for quality inspectors to manually compare the data in the input boxes of each record book with the instrument screen images.

[0042] Additional aspects and advantages of the invention will be set forth in part in the description which follows, and in part will be obvious from the description, or may be learned by practice of the invention. Attached Figure Description

[0043] The accompanying drawings, which are included to provide a further understanding of the invention and form part of this application, illustrate exemplary embodiments of the invention and, together with their description, serve to explain the invention and do not constitute an undue limitation thereof. In the drawings:

[0044] Figure 1 This is a flowchart illustrating a method for verifying experimental data in electronic records, as disclosed in one embodiment.

[0045] Figure 2 This is a schematic diagram of the specific process of step S4 disclosed in one embodiment.

[0046] Figure 3 This is a schematic diagram of the specific process of step S42 disclosed in one embodiment.

[0047] Figure 4 This is another specific flowchart illustrating step S4 as disclosed in one embodiment. Detailed Implementation

[0048] To make the objectives, technical solutions, and advantages of the embodiments of the present invention clearer, the technical solutions of the embodiments of the present invention will be clearly and completely described below with reference to the accompanying drawings. Obviously, the described embodiments are only some, not all, of the embodiments of the present invention. All other embodiments obtained by those skilled in the art based on the described embodiments of the present invention without creative effort are within the scope of protection of the present invention.

[0049] In this invention, unless otherwise expressly specified and limited, the technical or scientific terms used herein shall have the ordinary meaning understood by one of ordinary skill in the art to which this invention pertains. The terms "first," "second," and similar terms used in the specification and claims of this patent application do not indicate any order, quantity, or importance, but are merely used to distinguish different components. Similarly, the terms "an" or "a," and similar terms, do not indicate a quantity limitation, but rather indicate the presence of at least one.

[0050] This embodiment discloses a method for verifying experimental data in electronic records, used to review and verify experimental instrument data entered in electronic experimental records, as shown in the attached figure. Figure 1 As shown, the verification method includes the following:

[0051] Step S1: Receive a data verification instruction, which includes the verification area in the electronic experimental record. When verification of the electronic experimental record is required, the area containing the data to be verified in the electronic experimental record can be selected to trigger the verification instruction.

[0052] Step S2: Sequentially acquire the data of each experimental instrument recorded within the verification area and the corresponding bound instrument screen image. Each experimental instrument data may include the instrument model, one or more entered measurement parameters, and the corresponding units of measurement for these parameters.

[0053] Step S3: Query the corresponding screen recognition information in the instrument information database according to the instrument type in the experimental instrument data. The screen recognition information includes the shape of the screen area, the position of the digital feature area on the screen, and the position of the non-digital feature area on the screen. The non-digital features are text features or letter features. Identify the instrument measurement parameters in the instrument screen image according to the position of the digital feature area on the screen and the position of the non-digital feature area on the screen.

[0054] In this embodiment, the method also includes the step of identifying and supplementing the screen data of various types of instruments that may be used in the experiment and entering them into the instrument information database in the early stage. The step of supplementing the screen layout information of the instrument models may include the following.

[0055] Step S31: Obtain the input instrument model information, capture an instrument image of the screen area containing the displayed data, perform image recognition on the instrument image, and identify the screen location area to be analyzed in the instrument image. It is necessary to take a picture of the corresponding instrument screen after the testing is completed, as only then will the test data be displayed on the instrument screen. If the instrument screen is taken in a powered-off or standby state, the captured screen image will not show the display features of measurement parameters or units of measurement, making it impossible to identify and analyze the information within the screen in subsequent steps.

[0056] Step S31 may specifically include the following:

[0057] Identify closed regions within the instrument image formed by pixels with color difference values ​​less than a threshold. Analyze the edge shape of these closed regions; if the edge shape meets preset graphic conditions, the closed region is identified as a screen area. In instrument images, the display screen is often a closed region; even if display data exists in the middle, its transitional edges remain closed. Therefore, screen areas in the image can be searched by identifying closed regions.

[0058] The system analyzes whether there are patterns with different color differences from the edge of the identified screen area. If no such patterns are found, the identification of that area is abandoned and supplementary image information is sent. Specifically, if the identified screen area does not contain patterns with different color differences, meaning that no other features are displayed on the screen, it indicates that the experimental instrument containing the screen has not been powered on, resulting in no displayed data, or that the identified area is not the actual screen area, meaning the image was captured incorrectly. In either case, supplementary image information needs to be sent to obtain a new image of the instrument containing the screen area with displayed data.

[0059] Step S32 involves identifying and classifying the numerical and non-numerical features in the image area marked as a screen location, recording the position of each type of content within the screen area, and binding the identified information to the corresponding instrument model before entering it into the instrument information database. The instrument information database stores one or more pieces of information, including the instrument model, the shape of the screen area bound to each instrument model, measurement data layout information, unit of measurement, or unit conversion relationship group. Non-numerical features are text or English letter features.

[0060] In this embodiment, the measurement data layout information includes one or more of the following: the position of the digital feature area on the screen, the position of the text feature area on the screen, or the position of the letter feature area on the screen. The digital feature area refers to the area occupied by the measurement result number displayed on the screen after the instrument completes the test. This area can be the largest rectangular area that can enclose the number. Its position on the screen can be the relative position of this rectangular area within the screen area, the relative coordinates of each vertex of the rectangular area with respect to a reference point on the screen, or other positional information. Of course, the screen reference point can be preset, such as selecting the lower right corner of the screen area, and the relative position of the feature area within the screen area can be obtained by calculating the relative coordinates of each vertex of the feature area with respect to the reference point. The text feature refers to the corresponding unit of measurement of the measurement parameter displayed on the screen after the test is completed, such as milligrams or grams on an electronic balance. Since the text feature area is the area occupied by the unit of measurement, this area can also be the largest rectangular area that can enclose the text, and its position on the screen can be the relative position of this rectangular area within the screen area. On other experimental instruments, the units of measurement are often displayed in letters, such as kg and g. Therefore, it is necessary to obtain these letter feature areas on the instrument screen and calculate the position of the letter feature areas on the screen.

[0061] Step S32 may also include the following:

[0062] Step S321: Divide the regions containing different display features in the image region identified as the screen location.

[0063] Step S322: Perform content recognition and classification on each display feature area to obtain the position information of the digital feature area and the position information of the text or letter feature area on the screen, and then bind them with the corresponding instrument model and enter them into the instrument information database.

[0064] When the instrument can measure multiple sets of parameters with different meanings, it will display multiple sets of measurement parameters and their units of measurement on its screen. Therefore, in the content recognition and classification of each display feature area, it is necessary to identify each measurement parameter and its corresponding unit of measurement and bind them together. The digital feature area representing the measurement parameter can be paired with the non-digital feature area representing the unit of measurement to form a measurement data group. Finally, multiple measurement data groups are formed by combining the identified measurement parameters and their corresponding units of measurement within the screen area. The non-digital feature areas and digital feature areas of each measurement data group are combined into a measurement data display block, and the shape and position of the measurement data display block on the screen are entered into the instrument information database. In other words, when multiple measurement parameters and their corresponding units of measurement are arranged horizontally on the instrument display screen, the areas containing the measurement parameters and their units of measurement are combined into a measurement data display block, and the shape and position of the measurement data display block on the screen are entered into the instrument information database for subsequent parameter recognition and comparison.

[0065] Step S322 may also include the following:

[0066] If the distance between multiple display feature areas is greater than the distance between other display features, the display feature areas that are closer together will be grouped together into a measurement data display block.

[0067] If the first display feature group contains both numerical and text / letter features, it is treated as a measurement data display block. The shape of the display block, its position on the screen, and the text / letter information it contains are bound to the instrument model and recorded as a set of measurement data layout information for that instrument model in the instrument information database.

[0068] If the first display feature group contains only multiple digital features and some of the digital features are arranged vertically, then the first display feature group is divided into multiple vertically arranged digital display blocks, and it is checked whether a second display feature group exists.

[0069] If there is no second display feature group, the shape of each display block and its position on the screen will be bound to the instrument model and then entered into the instrument information database as the layout information of multiple sets of measurement data for that instrument model.

[0070] If a second display feature group exists, determine whether the second display feature group only contains text / letter features. If so, the second display feature group is also vertically divided into multiple text / letter display blocks arranged vertically. The number display blocks are then merged with the corresponding text / letter display blocks from top to bottom to form a measurement data display block. The shape of each display block, its position on the screen, and the text / letter information it contains are bound to the instrument model and recorded as a set of measurement data layout information for that instrument model in the instrument information database.

[0071] The above steps can effectively identify and classify various layouts of multiple measurement parameters and units of measurement in the screen display area, such as horizontal and vertical arrangement. The area where the corresponding parameters and units of measurement are located can be treated as a whole measurement data display block, and the information on the shape and position on the screen can be obtained and entered to facilitate subsequent data identification and analysis.

[0072] Step S323: Identify the displayed information within the text or letter area, and then bind the identified text or letter information as a unit of measurement with the corresponding instrument model and enter it into the instrument information database.

[0073] In another embodiment, step S32 may also include the following.

[0074] The image area identified as the screen location is segmented into regions containing different display features. Content recognition and classification are performed on each display feature region. If the screen image area contains only numerical feature regions, it is divided into multiple measurement data display blocks based on the spacing and / or arrangement of these numerical feature regions, and measurement unit input commands are issued sequentially. Specifically, the distance between the identified digits can be used to determine whether they represent the same measurement parameter. When digits are arranged vertically, the two sets of digits are assigned to different measurement parameters.

[0075] Based on the entered measurement units, the corresponding measurement data display blocks are bound to them. The shape of the display block, its position on the screen, the bound measurement units, and the corresponding instrument model are entered into the instrument information database as a set of measurement data layout information for that instrument model.

[0076] In this embodiment, the unit conversion relationship group information of each instrument model can also be supplemented in the instrument information database according to the stored measurement units and other conversion units that may appear on the various display screens. This includes the conversion relationships between each convertible unit and the conversion relationships between units, which facilitates the identification and conversion of the measurement units on the screen in the future.

[0077] By performing image recognition on instrument images, the screen regions to be analyzed within the images are identified. The numbers, text, and / or letters within these identified screen regions are then categorized and their positions within the screen region are recorded. This identified information is then linked to the corresponding instrument model and entered into an instrument information database. This database contains various information, including the instrument model, the shape of the screen region associated with each instrument model, measurement data layout, units of measurement, and unit conversion relationships. This database supports subsequent steps in identifying and acquiring test data from the obtained screen images of various experimental instruments.

[0078] Step S4: Compare the identified instrument measurement parameters with the data recorded in the experimental instrument data. If they are different, issue an experimental instrument data error response. However, in some embodiments, the discrepancy between some identified instrument measurement parameters and recorded measurement parameters does not necessarily indicate a recording error, because the measurement parameters displayed on the instrument screen and the recorded measurement parameters may only differ in their units of measurement. After unit conversion, they may still be the same. Therefore, further unit conversion comparison is needed for the inconsistent measurement parameters, as shown in the attached figure. Figure 2 As shown, this step may specifically include the following:

[0079] Step S41: Compare and match each recorded data and the identified data in the experimental instrument data to obtain the first recorded parameter and the first identified parameter that cannot be matched.

[0080] Step S42: Query whether a non-digital feature area exists in the instrument screen image. If it exists, obtain the first non-digital feature area corresponding to the first digital feature area containing the first recognition parameter, and identify the first unit of measurement within the first non-digital feature area. If a non-digital feature area exists, match it by obtaining the unit of measurement information within the non-digital feature area, as shown in the attached figure. Figure 3 The step S42 may also include the following:

[0081] Step S421: If there is no non-digital feature area in the instrument screen image, then obtain the predetermined parameter unit of the first recorded parameter from the experimental instrument data.

[0082] Step S422: Query the instrument information database for unit conversion relationship groups containing the predetermined parameter units according to the predetermined parameter units.

[0083] Step S423: Obtain the conversion formula between the predetermined parameter unit and other convertible candidate units of measurement, convert the first recorded parameter sequentially, and compare the converted parameter with the first identification parameter. If they are different, proceed to the next candidate unit of measurement until they are the same or the conversion comparison of all candidate units of measurement is completed. If the comparisons are all different, trigger a data error action.

[0084] Step S43: Based on the first unit of measurement, query the instrument information database to see if there is a unit conversion relationship group containing the first unit of measurement.

[0085] Step S44: If a unit conversion relationship group containing the first unit of measurement exists, the predetermined parameter unit of the first recorded parameter is obtained from the experimental instrument data. The first identified parameter is converted to a conversion parameter corresponding to the predetermined parameter unit according to the unit conversion relationship group, and compared with the first recorded parameter. If they are different, a data error action is triggered. Alternatively, in another embodiment, if a first unit of measurement exists, the predetermined parameter unit of the first recorded parameter is obtained from the experimental instrument data. The first recorded parameter is converted to a conversion parameter corresponding to the first unit of measurement according to the unit conversion relationship group, and compared with the first identified parameter. If they are different, a data error action is triggered.

[0086] By matching the units of measurement of the remaining unmatched first record parameters with the units of measurement of the identified units of measurement according to the above steps, false alarms caused by unit conversion errors in the verification of input parameters can be prevented.

[0087] In another embodiment, step S4 may include the following: when the electronic experimental record contains a predetermined parameter unit, the identified unit of measurement is directly matched with the predetermined parameter unit, and the measurement parameters to which the matched unit belongs are compared and verified, thereby enabling faster data verification, as shown in the attached figure. Figure 4 As shown, it may specifically include the following contents.

[0088] Step S101: Compare the second unit of measurement in the identified non-digital feature area with each predetermined parameter unit of the experimental instrument data. If there is the same second predetermined parameter unit, obtain the second recorded parameter corresponding to the second predetermined parameter unit in the experimental instrument data, and compare the second recorded parameter with the second identified parameter in the second digital feature area corresponding to the second non-digital feature area where the identified second unit of measurement is located. If they are different, trigger a data error action.

[0089] Step S102: If there is no identical second predetermined parameter unit, determine whether there are any recorded parameters in the experimental instrument data that have not been matched and verified. If so, query the instrument information database for the unit conversion relationship group containing the second unit of measurement.

[0090] Step S103: Convert the second record parameter into the conversion parameter of each corresponding candidate unit of measurement according to the unit conversion relationship group. Compare each conversion parameter with the record parameter that has not completed the matching verification in turn. If they are all different, trigger the data error action.

[0091] In other embodiments, step S4 may further include the following: comparing each predetermined parameter unit of the experimental instrument data with the unit of measurement in the identified non-digital feature area; if the same unit exists, comparing the identified parameter in the digital feature area corresponding to the non-digital feature area where the unit of measurement is located; if they are different, triggering a data error action. Alternatively, directly obtaining each predetermined parameter unit of the experimental instrument data and then matching them one by one with the unit of measurement in the identified non-digital feature area; if a match is successful, comparing and verifying the identified parameter in the digital feature area corresponding to the non-digital feature area where the unit of measurement is located.

[0092] The above-described method for verifying experimental data in electronic records involves, according to a verification instruction, acquiring the data of each experimental instrument recorded within the verification area and the corresponding bound instrument screen image. Based on the instrument type in the experimental instrument data, the method queries the corresponding screen recognition information in the instrument information database. It then identifies the instrument measurement parameters in the instrument screen image based on information such as the position of the digital feature area and the position of the non-digital feature area on the screen. Finally, it compares the identified information with the information already entered in the electronic experimental record to identify any errors in the record. This effectively ensures the accuracy of the entered data in the experimental record and eliminates the significant time-consuming process of quality inspectors manually comparing the data in the input boxes of each record book with the instrument screen images.

[0093] In another embodiment, a verification system for experimental data in electronic records is also disclosed, used to review and verify experimental instrument data entered in electronic experimental records. The system includes: an instruction receiving module for receiving data verification instructions, the data verification instructions including a review and verification area in the electronic experimental record; a data acquisition module for sequentially acquiring each experimental instrument data recorded within the review and verification area and the corresponding bound instrument screen image; a recognition module for querying corresponding screen recognition information in the instrument information database based on the instrument type in the experimental instrument data, the screen recognition information including the shape of the screen area, the position of the numeric feature area within the screen, and the position of the non-numeric feature area within the screen, the non-numeric feature being text features or letter features, and identifying the instrument measurement parameters in the instrument screen image based on the position of the numeric feature area within the screen and the position of the non-numeric feature area within the screen; and a comparison module for comparing the identified instrument measurement parameters with the data recorded in the experimental instrument data, and issuing an error response for the experimental instrument data if they are different.

[0094] In this embodiment, the comparison module includes: a matching module, used to compare and match each recorded data in the experimental instrument data with the identification data to obtain a first recorded parameter and a first identification parameter that cannot be matched; a unit acquisition module, used to query whether there is a non-digital feature area in the instrument screen image, and if so, to obtain the first non-digital feature area corresponding to the first identification parameter in the first digital feature area, and to identify the first unit of measurement in the first non-digital feature area; a query module, used to query the instrument information database for whether there is a unit conversion relationship group containing the first unit of measurement; and a unit conversion module, used to obtain the predetermined parameter unit of the first recorded parameter from the experimental instrument data if there is a unit conversion relationship group containing the first unit of measurement, convert the first identification parameter into a conversion parameter of the corresponding predetermined parameter unit according to the unit conversion relationship group, and compare it with the first recorded parameter. If they are different, a data error action is triggered.

[0095] In this embodiment, the unit acquisition module includes: a first parameter acquisition module, used to acquire a predetermined parameter unit of the first recorded parameter from the experimental instrument data when there is no non-digital feature area in the instrument screen image; a conversion relationship query module, used to query the instrument information database for a unit conversion relationship group containing the predetermined parameter unit according to the predetermined parameter unit; and a comparison module, used to acquire the conversion formula of the predetermined parameter unit with other convertible candidate units of measurement, sequentially convert the first recorded parameter and compare the converted parameter with the first identification parameter. If they are different, the conversion of the next candidate unit of measurement is performed until they are the same or the conversion comparison of all candidate units of measurement is completed. If the comparisons are all different, a data error action is triggered.

[0096] The specific functions of the above-described verification system for experimental data in electronic records correspond one-to-one with the verification methods for experimental data in electronic records disclosed in the preceding embodiments. Therefore, they will not be described in detail here. For details, please refer to the embodiments of the verification methods for experimental data in electronic records disclosed in the preceding embodiments. It should be noted that the various embodiments in this specification are described in a progressive manner, with each embodiment focusing on the differences from other embodiments. The same or similar parts between the various embodiments can be referred to mutually.

[0097] In other embodiments, a verification device for experimental data in electronic records is also provided, including a memory, a processor, and a computer program stored in the memory and executable on the processor, wherein the processor executes the computer program to implement the steps of the verification method for experimental data in electronic records as described in the above embodiments.

[0098] The verification device for experimental data in the electronic record may include, but is not limited to, a processor and a memory. The server may include, but is not limited to, a processor and a memory. Those skilled in the art will understand that the schematic diagram is merely an example of a server and does not constitute a limitation on the server device. It may include more or fewer components than illustrated, or combine certain components, or different components. For example, the server device may also include input / output devices, network access devices, buses, etc.

[0099] The processor can be a Central Processing Unit (CPU), or other general-purpose processors, digital signal processors (DSPs), application-specific integrated circuits (ASICs), field-programmable gate arrays (FPGAs), or other programmable logic devices, discrete gate or transistor logic devices, discrete hardware components, etc. A general-purpose processor can be a microprocessor or any conventional processor. The processor is the control center of the server device, connecting various parts of the server device via various interfaces and lines.

[0100] The memory can be used to store the computer programs and / or modules. The processor implements various functions of the server device by running or executing the computer programs and / or modules stored in the memory and by calling data stored in the memory. The memory may mainly include a program storage area and a data storage area. The program storage area may store the operating system, at least one application program required for a function, etc. In addition, the memory may include high-speed random access memory and non-volatile memory, such as hard disk, RAM, plug-in hard disk, smart media card (SMC), secure digital (SD) card, flash card, at least one disk storage device, flash memory device, or other volatile solid-state storage device.

[0101] If the verification method for experimental data in the electronic record is implemented as a software functional unit and sold or used as an independent product, it can be stored in a computer-readable storage medium. Based on this understanding, all or part of the processes in the methods of the above embodiments of the present invention can also be implemented by a computer program instructing related hardware. The computer program can be stored in a computer-readable storage medium, and when executed by a processor, it can implement the steps of the various method embodiments described above. The computer program includes computer program code, which can be in the form of source code, object code, executable files, or certain intermediate forms. The computer-readable medium can include: any entity or device capable of carrying the computer program code, recording media, USB flash drives, portable hard drives, magnetic disks, optical disks, computer memory, read-only memory (ROM), random access memory (RAM), electrical carrier signals, telecommunication signals, and software distribution media, etc. It should be noted that the content included in the computer-readable medium can be appropriately added or removed according to the requirements of legislation and patent practice in the jurisdiction. For example, in some jurisdictions, according to legislation and patent practice, computer-readable media do not include electrical carrier signals and telecommunication signals.

[0102] Finally, it should be noted that the above embodiments are only used to illustrate the technical solutions of the present invention, and not to limit them; although the present invention has been described in detail with reference to the foregoing embodiments, those skilled in the art should understand that modifications can still be made to the technical solutions described in the foregoing embodiments, or equivalent substitutions can be made to some of the technical features; and these modifications or substitutions do not cause the essence of the corresponding technical solutions to deviate from the scope of the technical solutions of the embodiments of the present invention.

[0103] In summary, the above description is only a preferred embodiment of the present invention. All equivalent changes and modifications made within the scope of the claims of the present invention should be covered by the present invention.

Claims

1. A method for checking experimental data in an electronic record, for auditing and checking the experimental instrument data entered in an electronic experimental record, characterized in that, Includes the following steps: S1, Receive a data verification instruction, the data verification instruction including the audit and verification area in the electronic experimental record; S2, sequentially retrieve the data of each experimental instrument recorded in the audit and verification area and the corresponding bound instrument screen image; S3. Query the corresponding screen recognition information in the instrument information database according to the instrument type in the experimental instrument data. The screen recognition information includes the shape of the screen area, the position of the digital feature area on the screen, and the position of the non-digital feature area on the screen. The non-digital feature is a text feature or a letter feature. Identify the instrument measurement parameters in the instrument screen image according to the position of the digital feature area on the screen and the position of the non-digital feature area on the screen. S4, compare the identified instrument measurement parameters with the data recorded in the experimental instrument data; if they are different, issue an experimental instrument data error response; step S4 includes: S41, compare and match each recorded data and the identified data in the experimental instrument data to obtain the first recorded parameter and the first identified parameter that cannot be matched; S42, query whether there is a non-digital feature area in the instrument screen image. If it exists, obtain the first non-digital feature area corresponding to the first digital feature area where the first identification parameter is located, and identify the first unit of measurement in the first non-digital feature area. S43, based on the first unit of measurement, query the instrument information database to see if there is a unit conversion relationship group containing the first unit of measurement; S44, if a unit conversion relationship group containing the first unit of measurement exists, then the predetermined parameter unit of the first recorded parameter is obtained from the experimental instrument data; the first identified parameter is converted into a conversion parameter corresponding to the predetermined parameter unit according to the unit conversion relationship group; and compared with the first recorded parameter. If they are different, a data error action is triggered; or If a unit conversion relationship group containing the first unit of measurement exists, the predetermined parameter unit of the first recorded parameter is obtained from the experimental instrument data. The first recorded parameter is converted into a conversion parameter corresponding to the first unit of measurement according to the unit conversion relationship group, and compared with the first identification parameter. If they are different, a data error action is triggered.

2. The method of claim 1, wherein, Step S42 further includes: S421, If ​​there is no non-digital feature area in the instrument screen image, then obtain the predetermined parameter unit of the first recorded parameter from the experimental instrument data; S422, Query the unit conversion relationship group containing the predetermined parameter unit in the instrument information database according to the predetermined parameter unit; S423, obtain the conversion formula of the predetermined parameter unit and other convertible candidate units of measurement, convert the first recorded parameter in sequence and compare the converted parameter with the first identification parameter. If they are different, perform the conversion of the next candidate unit of measurement until they are the same or the conversion comparison of all candidate units of measurement is completed. If the comparisons are all different, trigger the data error action.

3. The method of claim 1, wherein the method further comprises: Step S4 includes: The second unit of measurement in the identified non-digital feature area is compared with the predetermined parameter units of the experimental instrument data. If there is the same second predetermined parameter unit, the second record parameter corresponding to the second predetermined parameter unit in the experimental instrument data is obtained, and the second record parameter is compared with the second identification parameter in the second digital feature area corresponding to the second non-digital feature area of ​​the identified second unit of measurement. If they are different, a data error action is triggered. If there is no identical second predetermined parameter unit, it is determined whether there are any recorded parameters in the experimental instrument data that have not been matched and verified. If so, the unit conversion relationship group containing the second unit of measurement is queried in the instrument information database according to the second unit of measurement. The second record parameter is converted into the corresponding candidate unit of measurement based on the unit conversion relationship group. Each conversion parameter is then compared with the record parameter that has not completed the matching verification. If they are all different, a data error action is triggered.

4. The method of claim 1, wherein, Step S4 includes: Each predetermined parameter unit of the experimental instrument data is compared with the unit of measurement in the identified non-digital feature area. If the same unit exists, the identification parameter in the digital feature area corresponding to the non-digital feature area where the unit of measurement is located is obtained and compared. If they are different, a data error action is triggered.

5. A verification system for experimental data in electronic records, used to verify and validate experimental instrument data entered in electronic experimental records, characterized in that, include: The instruction receiving module is used to receive data verification instructions, which include the audit and verification area in the electronic experimental record. The data acquisition module is used to sequentially acquire the data of each experimental instrument recorded within the audit and verification area and the corresponding bound instrument screen image; The identification module is used to query the corresponding screen identification information in the instrument information database according to the instrument type in the experimental instrument data. The screen identification information includes the shape of the screen area, the position of the digital feature area on the screen, and the position of the non-digital feature area on the screen. The non-digital features are text features or letter features. The instrument measurement parameters in the instrument screen image are identified according to the position of the digital feature area on the screen and the position of the non-digital feature area on the screen. The comparison module is used to compare the identified instrument measurement parameters with the data recorded in the experimental instrument's data storage. If they are different, an error response is issued for the experimental instrument's data. The comparison module includes: The matching module is used to compare and match each recorded data in the experimental instrument data with the identification data to obtain the first record parameter and the first identification parameter that cannot be matched. The unit acquisition module is used to query whether there is a non-digital feature area in the instrument screen image. If it exists, it acquires the first non-digital feature area corresponding to the first digital feature area where the first identification parameter is located, and identifies the first unit of measurement in the first non-digital feature area. The query module is used to query the instrument information database to see if there is a unit conversion relationship group containing the first unit of measurement. The unit conversion module is used to obtain the predetermined parameter unit of the first recorded parameter from the experimental instrument data when there is a unit conversion relationship group containing the first unit of measurement, convert the first identified parameter into a conversion parameter corresponding to the predetermined parameter unit according to the unit conversion relationship group, and compare it with the first recorded parameter. If they are different, a data error action is triggered.

6. The verification system for experimental data in electronic records according to claim 5, characterized in that, The unit acquisition module includes: The first parameter acquisition module is used to obtain the predetermined parameter unit of the first recorded parameter from the experimental instrument data when there is no non-digital feature area in the instrument screen image; The conversion relationship query module is used to query the unit conversion relationship group containing the predetermined parameter unit in the instrument information database; The comparison module is used to obtain the conversion formulas of the predetermined parameter unit and other convertible candidate units of measurement, convert the first recorded parameter in sequence, and compare the converted parameter with the first identification parameter. If they are different, the conversion of the next candidate unit of measurement is performed until they are the same or the conversion and comparison of all candidate units of measurement are completed. If the comparisons are all different, a data error action is triggered.

7. A device for verifying experimental data in an electronic record, comprising a memory, a processor, and a computer program stored in the memory and executable on the processor, characterized in that: When the processor executes the computer program, it implements the steps of the method as described in any one of claims 1-4.

8. A computer-readable storage medium storing a computer program, characterized in that: When the computer program is executed by a processor, it implements the steps of the method as described in any one of claims 1-4.

Images