CN116798641A - Collation method and apparatus for check items, device and storage medium - Google Patents
Collation method and apparatus for check items, device and storage medium Download PDFInfo
- Publication number
- CN116798641A CN116798641A CN202310801383.1A CN202310801383A CN116798641A CN 116798641 A CN116798641 A CN 116798641A CN 202310801383 A CN202310801383 A CN 202310801383A CN 116798641 A CN116798641 A CN 116798641A
- Authority
- CN
- China
- Prior art keywords
- test item
- target
- comparison
- information
- item
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Pending
Links
- 238000000034 method Methods 0.000 title claims abstract description 52
- 238000012360 testing method Methods 0.000 claims abstract description 412
- 238000007689 inspection Methods 0.000 claims abstract description 43
- 238000004590 computer program Methods 0.000 claims description 9
- 238000012545 processing Methods 0.000 claims description 5
- 238000010586 diagram Methods 0.000 description 13
- 238000012795 verification Methods 0.000 description 7
- 238000001514 detection method Methods 0.000 description 4
- 230000005540 biological transmission Effects 0.000 description 3
- 238000005516 engineering process Methods 0.000 description 3
- 230000008676 import Effects 0.000 description 2
- 230000003993 interaction Effects 0.000 description 2
- 238000003032 molecular docking Methods 0.000 description 2
- 230000001360 synchronised effect Effects 0.000 description 2
- 230000009286 beneficial effect Effects 0.000 description 1
- 238000011161 development Methods 0.000 description 1
- 238000005286 illumination Methods 0.000 description 1
- 210000001503 joint Anatomy 0.000 description 1
- 238000009533 lab test Methods 0.000 description 1
- 238000004989 laser desorption mass spectroscopy Methods 0.000 description 1
- 238000012986 modification Methods 0.000 description 1
- 230000004048 modification Effects 0.000 description 1
- 230000007170 pathology Effects 0.000 description 1
- 238000012552 review Methods 0.000 description 1
- 230000003068 static effect Effects 0.000 description 1
- 230000001960 triggered effect Effects 0.000 description 1
Landscapes
- Debugging And Monitoring (AREA)
Abstract
The embodiment of the invention discloses a comparison method, a device, equipment and a storage medium for checking items, wherein the method comprises the following steps: receiving a control request at least comprising a target control group and control conditions, wherein the target control group at least comprises a first test item table to be controlled and a second test item table to be controlled, and the control conditions at least comprise target parameter types used for controlling in item information of test items in the first test item table; using the first information corresponding to the target parameter type in the first test item table to carry out information matching with the second information corresponding to the target parameter type in the second test item table, and determining a second test item matched with the first test item in the second test item table; and adding the corresponding relation between the first test item and the second test item into a comparison table of the target comparison group. By the method, the inspection item comparison of the target comparison group can be automatically realized, the manual participation and influence are reduced, and the time and labor saving efficiency is high.
Description
Technical Field
The present invention relates to the field of inspection project management technologies, and in particular, to a method, an apparatus, a device, and a storage medium for inspecting an inspection project.
Background
With the development of medical examination, the information-based promotion requirement of laboratories is also increasing. In the informatization advancing process, information butt joint (test data interaction) of test systems of different hospitals is a very key link. The realization of the system docking can greatly reduce the error rate of manual input, ensure the integrity of patient information, the accurate transmission of test items and the timeliness of the return of test results ， The most critical link for realizing accurate transmission of the test items by system docking is the test item comparison among different systems.
There are hundreds of systems for examining pathology information in use today. The inspection systems used by different hospitals are five-in-eight, even if the inspection systems are the same, the same inspection project is different, project codes and names maintained by different hospitals are different, the number of inspection projects of a normal third-level hospital is 300-500, the number of inspection projects of a second-level hospital is about 200, the number of inspection projects which are within 100 of a first-level hospital is more than that of the inspection projects which are calculated to be different, and the number of detection projects which can be detected by some mature laboratory groups is up to 3000 or even more, so that accurate transmission, accurate data interaction and project comparison among different systems are realized.
However, taking laboratory and hospital information systems as an example, the most widely used control modes are: and collecting item lists (including item codes, item names and item prices) of check items provided by the hospital information system, guiding an item list (including item codes, item names and standard charge prices) which can be detected by a laboratory, and manually searching and copying and pasting the item list in the two lists to complete an item comparison table.
Because of different information systems, project codes are inconsistent, project names are different, and the same project has multiple methodologies, if a project comparison table with excellent quality is obtained, the time and the labor are very consumed, and the project comparison efficiency is low.
Disclosure of Invention
The invention mainly aims to provide a comparison method, a comparison device, a comparison equipment and a storage medium for a test item, which can solve the problem of low manual comparison efficiency in the prior art.
To achieve the above object, a first aspect of the present invention provides a collation method for a test item, the method comprising:
receiving a comparison request, wherein the comparison request at least comprises a target comparison group and comparison conditions, the target comparison group at least comprises a first test item table to be compared and a second test item table to be compared, the test item table comprises item information of test items, and the comparison conditions at least comprise target parameter types used for comparison in the item information of the test items in the first test item table;
Performing information matching with second information corresponding to the target parameter type in the second test item table by using first information corresponding to the target parameter type of a first test item in the first test item table, and determining a second test item matched with the first test item in the second test item table;
and adding the corresponding relation between the first test item and the second test item to a comparison table of the target comparison group.
In a possible implementation manner, the comparison request further includes a target comparison group identifier of the target comparison group, and then, using first information corresponding to the target parameter type of a first test item in the first test item table, performing information matching with second information corresponding to the target parameter type in the second test item table, determining a second test item matched with the first test item in the second test item table, where before further includes:
performing history record searching processing by using a preset history record library and the target comparison group identifier, and determining whether a target history comparison table corresponding to the target comparison group identifier exists or not, wherein the history record library comprises a corresponding relation between the history comparison table and the comparison group identifier;
If the target history comparison table exists, carrying out information matching with third information corresponding to the target parameter type in the target history comparison table by using the first information, and determining a second test item matched with the first test item in the target history comparison table;
and if the target history comparison table does not exist, continuing to execute the step of utilizing the first information corresponding to the target parameter type of the first test item in the first test item table, performing information matching with the second information corresponding to the target parameter type in the second test item table, and determining a second test item matched with the first test item in the second test item table.
In one possible implementation manner, the target parameter type includes at least one of an item code, an item name, a methodology, and an item price, and the determining, by using the first information, the second check item in the target history lookup table that matches the first check item, where the second check item matches the target parameter type in the target history lookup table includes:
determining whether the target third information which is the same as the first information exists in the target history comparison table;
If the target third information exists, searching a third check item corresponding to the target third information from the target history comparison table, and taking the third check item as a second check item matched with the first check item;
and if the target third information does not exist, continuing to execute the step of using the first information corresponding to the target parameter type of the first test item in the first test item table to perform information matching with the second information corresponding to the target parameter type in the second test item table, and determining a second test item matched with the first test item in the second test item table.
In one possible implementation manner, if the target history comparison table does not exist, or if the target third information does not exist, performing information matching with the second information corresponding to the target parameter type in the second test item table by using the first information corresponding to the target parameter type of the first test item in the first test item table, and determining a second test item matched with the first test item in the second test item table, where before further includes:
Determining whether target fourth information which is the same as the first information exists in a high-frequency comparison table or not by using a preset high-frequency comparison table and the first information, wherein the high-frequency comparison table at least comprises a test item of which the comparison frequency is not lower than a preset frequency threshold value;
if the target fourth information exists in the high-frequency comparison table, searching a fourth check item corresponding to the target fourth information from the high-frequency comparison table, and taking the fourth check item as the second check item;
and if the target fourth information does not exist in the high-frequency comparison table, continuing to execute the step of utilizing the first information corresponding to the target parameter type of the first test item in the first test item table, performing information matching with the second information corresponding to the target parameter type in the second test item table, and determining a second test item matched with the first test item in the second test item table.
In a possible implementation manner, the determining, by using the first information corresponding to the target parameter type of the first test item in the first test item table, the information matching with the second information corresponding to the target parameter type in the second test item table, the second test item matching with the first test item in the second test item table includes:
And carrying out fuzzy matching by using the first information and the second information, and determining a second check item matched with the first check item in the second check item table.
In a possible implementation, the method further comprises, after:
counting the comparison frequency of each inspection item in the history record library;
and updating the high-frequency record by using the comparison frequency and a preset high-frequency comparison table to obtain an updated high-frequency comparison table.
In one possible implementation manner, the comparison request further includes a target system type identifier, where the target system type identifier is used to reflect a system type of the inspection information system, and the adding the correspondence between the first inspection item and the second inspection item to the comparison table of the target comparison group further includes:
determining a target comparison table format by utilizing a corresponding relation between a preset system type identifier and the comparison table format and the target system type identifier;
adding the corresponding relation between the first test item and the second test item into a reference table of the target reference group according to the target reference table format, and determining a target reference table;
And transmitting the target comparison table to the inspection information system.
To achieve the above object, a second aspect of the present invention provides a collation apparatus for a test item, the apparatus comprising:
a request receiving module: the control request is used for receiving a control request, the control request at least comprises a target control group and control conditions, the target control group at least comprises a first test item table to be controlled and a second test item table to be controlled, the test item table comprises item information of test items, and the control conditions at least comprise target parameter types used for controlling in the item information of the test items in the first test item table;
and the information matching module is used for: the method comprises the steps of carrying out information matching with second information corresponding to the target parameter type in the second test item table by using first information corresponding to the target parameter type of a first test item in the first test item table, and determining a second test item matched with the first test item in the second test item table;
a control generation module: and the corresponding relation between the first test item and the second test item is added into the comparison table of the target comparison group.
To achieve the above object, a third aspect of the present invention provides a computer-readable storage medium storing a computer program, which when executed by a processor causes the processor to perform the steps as described in the first aspect and any one of the possible implementations.
To achieve the above object, a fourth aspect of the present invention provides a computer device comprising a memory and a processor, the memory storing a computer program which, when executed by the processor, causes the processor to perform the steps as described in the first aspect and any one of the possible implementations.
The embodiment of the invention has the following beneficial effects:
the invention provides a comparison method for checking items, which comprises the following steps: receiving a comparison request, wherein the comparison request at least comprises a target comparison group and comparison conditions, the target comparison group at least comprises a first test item table to be compared and a second test item table to be compared, the test item table comprises item information of test items, and the comparison conditions at least comprise target parameter types used for comparison in the item information of the test items in the first test item table; using the first information corresponding to the target parameter type in the first test item table to carry out information matching with the second information corresponding to the target parameter type in the second test item table, and determining a second test item matched with the first test item in the second test item table; and adding the corresponding relation between the first test item and the second test item into a comparison table of the target comparison group.
By the method, the first test item list to be compared and the second test item list to be compared, which are included in the target comparison group, can be automatically compared according to the target parameter types of the comparison conditions, the second test item matched with the first test item in the second test item list is determined, the corresponding relation between the first test item and the second test item is automatically added into the comparison list of the target comparison group, and a project comparison list is completed without manually searching, copying and pasting.
Drawings
In order to more clearly illustrate the embodiments of the invention or the technical solutions in the prior art, the drawings that are required in the embodiments or the description of the prior art will be briefly described, it being obvious that the drawings in the following description are only some embodiments of the invention, and that other drawings may be obtained according to these drawings without inventive effort for a person skilled in the art.
Wherein:
FIG. 1 is a flow chart of a comparison method for checking items in an embodiment of the invention;
FIG. 2 (a) is a schematic diagram of a first check item table according to an embodiment of the present invention;
FIG. 2 (b) is a diagram of a second check item table according to an embodiment of the present invention;
FIG. 3 (a) is a diagram illustrating a comparison table according to an embodiment of the present invention;
FIG. 3 (b) is another diagram of a comparison table according to an embodiment of the present invention;
FIG. 4 is another flow chart of a comparison method for checking items in an embodiment of the present invention;
FIG. 5 is a block diagram of a control device for testing items according to an embodiment of the present invention;
fig. 6 is a block diagram of a computer device in an embodiment of the invention.
Detailed Description
The following description of the embodiments of the present invention will be made clearly and completely with reference to the accompanying drawings, in which it is apparent that the embodiments described are only some embodiments of the present invention, but not all embodiments. All other embodiments, which can be made by those skilled in the art based on the embodiments of the invention without making any inventive effort, are intended to be within the scope of the invention.
Referring to fig. 1, fig. 1 is a flowchart of a comparison method for checking items in an embodiment of the present invention, where the method shown in fig. 1 is applicable to a terminal, and may be applied to a server, and the terminal may be a desktop terminal or a mobile terminal, and the mobile terminal may be at least one of a mobile phone, a tablet computer, a notebook computer, and the like, and the server may be implemented by an independent server or a server cluster formed by a plurality of servers, and the method shown in fig. 1 includes the following steps:
101. Receiving a comparison request, wherein the comparison request at least comprises a target comparison group and comparison conditions, the target comparison group at least comprises a first test item table to be compared and a second test item table to be compared, the test item table comprises item information of test items, and the comparison conditions at least comprise target parameter types used for comparison in the item information of the test items in the first test item table;
in order to achieve the purpose of automatic information comparison among different test item tables, the terminal may receive a comparison request, where the comparison request includes at least a target comparison group and a comparison condition, where the target comparison group includes a test item table to be compared, the test item table includes item information of test items, where the item information includes, but is not limited to, a combination code, a combination name, a item code, a item name, a sample type, a package code, a package name, a detection post, a methodology, and a state, and the number of test item tables in the target comparison group is at least two, and therefore, the target comparison group includes at least a first test item table to be compared and a second test item table to be compared, where the terminal may include a display screen, the first test item table and the second test item table may be displayed on the display screen, the comparison request may be automatically triggered when the target comparison group is introduced into the terminal by a user, and the comparison condition may be that the test item types of test items in the first test item table are generated according to the various parameter types of the test item table, and may be generated after the target comparison item table is spontaneously clicked on the display screen, and the terminal may not be limited to the display after the user clicks on the display screen. The present embodiment is exemplified by generating the above-mentioned collation request by clicking on each item information of the inspection item table on the display screen by the user after importing the target collation group into the above-mentioned terminal.
Wherein, the item information of a plurality of inspection items is recorded in the inspection item table, and the inspection items can be classified into: the item information includes, but is not limited to, combination code, combination name, item code, item name, specimen type, package code, package name, detection post, status, etc., and the item information of different inspection items is different, and the target parameter types may be one or more, i.e. the user may select one parameter type in the inspection item table as a comparison condition, i.e. select multiple parameter types in the inspection item table as a comparison condition.
The data sources of the test item tables in the target comparison group are different, and naming rules or setting rules of test items in the test item tables with different data sources are different, and for example, the first test item table may be a test item table of a certain hospital, the second test item table may be a test item table of a certain laboratory, fig. 2 (a) may be referred to, fig. 2 (a) is a schematic diagram of a first test item table in an embodiment of the present invention, and each column of the first test item table shown in fig. 2 (a) may respectively represent a test item: parameter types such as a combination code, a combination name, a project code, a project name, a specimen type, a project price (price for short) and the like; referring to fig. 2 (b), fig. 2 (b) is a schematic diagram of a second test item table according to an embodiment of the present invention, where the import format of the second test item table shown in fig. 2 (b) indicates that each column may respectively represent a test item: package code, package name, combination code, combination name, item code, item name, specimen type, price, detection post, status, etc., wherein the import format may reflect the setting rules of the inspection item table. The number of test items in the test item table of the hospital is smaller than the number of test items in the test item table of the laboratory. I.e. laboratory test items would contain hospital test items.
102. Performing information matching with second information corresponding to the target parameter type in the second test item table by using first information corresponding to the target parameter type of a first test item in the first test item table, and determining a second test item matched with the first test item in the second test item table;
furthermore, the comparison may be performed by using a comparison condition, specifically, the first information corresponding to the target parameter type of the first test item in the first test item table is used to perform information matching with the second information corresponding to the target parameter type in the second test item table, so as to determine the second test item matched with the first test item in the second test item table. The user may generate the comparison request by double clicking the "white rule" in the first test item table as shown in fig. 2 (a), and the target parameter type included in the comparison condition is the "combination name", the first information is the "white rule", the first test item is the "white rule", and the second information is the information in the column of the "combination name" in the second test item table, so that the first information and the second information are used for information matching, the second test item matched with the first test item is determined, for example, the first information and the second information are used for fuzzy matching, and the second test item matched with the first test item in the second test item table is determined, wherein the information matching method includes, but is not limited to, a data matching technology such as fuzzy matching, so as to determine the possibility that the first information and the second information belong to the same entity, and finally, the second test item indicated by the second information with the highest possibility can be regarded as the second test item matched with the first test item.
103. And adding the corresponding relation between the first test item and the second test item to a comparison table of the target comparison group.
Finally, after obtaining the second test item matched with the first test item, the corresponding relation between the first test item and the second test item can be established, and the corresponding relation between the first test item and the second test item is added into the comparison table of the target comparison group. And further, the information matching comparison of the same kind of test items with different expression modes in different test item tables is realized. The comparison table can also be displayed on a display screen of the terminal for the user to review. The format of the comparison table may include at least two types, and refer to fig. 3 (a) and fig. 3 (b), where fig. 3 (a) is a schematic diagram of one comparison table in the embodiment of the present invention, and fig. 3 (b) is another schematic diagram of one comparison table in the embodiment of the present invention. The format of the suitable comparison table may be selected according to different inspection information systems, and the comparison table shown in fig. 3 (a) or fig. 3 (b) may be generated. It can be understood that when the correspondence between the first test item and the second test item is added to the comparison table of the target comparison group, not only the comparison between the first test item and the second test item, but also the item information of the first test item and the second test item are compared. The number of the first test items may be one or more, that is, the test items in the first test item table may be collated one by one, or the whole item of the first test item table may be collated directly, which is not limited herein.
The invention provides a comparison method for checking items, which comprises the following steps: receiving a comparison request, wherein the comparison request at least comprises a target comparison group and comparison conditions, the target comparison group at least comprises a first test item table to be compared and a second test item table to be compared, the test item table comprises item information of test items, and the comparison conditions at least comprise target parameter types used for comparison in the item information of the test items in the first test item table; using the first information corresponding to the target parameter type in the first test item table to carry out information matching with the second information corresponding to the target parameter type in the second test item table, and determining a second test item matched with the first test item in the second test item table; and adding the corresponding relation between the first test item and the second test item into a comparison table of the target comparison group. By the method, the first test item list to be compared and the second test item list to be compared, which are included in the target comparison group, can be automatically compared according to the target parameter types of the comparison conditions, the second test item matched with the first test item in the second test item list is determined, the corresponding relation between the first test item and the second test item is automatically added into the comparison list of the target comparison group, and a project comparison list is completed without manually searching, copying and pasting.
Referring to fig. 4, fig. 4 is another flowchart of a comparison method for checking items in an embodiment of the invention, and the method shown in fig. 4 includes the following steps:
401. receiving a comparison request, wherein the comparison request at least comprises a target comparison group and comparison conditions, the target comparison group at least comprises a first test item table to be compared and a second test item table to be compared, the test item table comprises item information of test items, and the comparison conditions at least comprise target parameter types used for comparison in the item information of the test items in the first test item table;
in a possible implementation, step 401 is similar to the content of step 101 shown in fig. 1, and for avoiding repetition, reference may be made to the content of step 101 shown in fig. 1.
402. Performing history record searching processing by using a preset history record library and the target comparison group identifier, and determining whether a target history comparison table corresponding to the target comparison group identifier exists or not, wherein the history record library comprises a corresponding relation between the history comparison table and the comparison group identifier;
in order to distinguish different control groups, the different control groups have different control group identifications, the control group identifications are in one-to-one correspondence with the control groups, the control group identifications can be dynamically generated by each test item table included in the control groups, for example, the target control group identification can be [ hospital 1+lab1 ] if the target control group includes a first test item table of hospital 1 and a second test item table of laboratory 1 ], or the target control group identification can be [ hospital 1+lab1+2 ] if the target control group identification can be [ hospital 1+lab1 ] if the target control group includes the first test item table of hospital 1 and the second test item table of laboratory 1, and then the corresponding control group identification can be dynamically generated according to the combination of the actual target illumination groups.
In order to further improve the comparison efficiency of the target comparison group, the comparison table of the target comparison group can be saved to the history record library after each comparison is finished, then, when the comparison of the target comparison group is needed next time, the history record of the target comparison group can be searched first to improve the comparison efficiency, further, the comparison request can also comprise the target comparison group identifier of the target comparison group, whether the history record exists in the history record can be searched by utilizing the target comparison group identifier of the target comparison group, so that the comparison efficiency is improved, specifically, the history record searching processing is performed by utilizing the preset history record library and the target comparison group identifier, whether the target history record table corresponding to the target comparison group identifier exists is determined, the history record library comprises the corresponding relation between the history record table and the comparison group identifier, and then whether the same comparison group identifier exists can be determined by utilizing the target comparison group identifier, so that the target history record table is determined. And the target history comparison table records the past comparison record of the target comparison group, namely the corresponding relation between the comparison records, namely the comparison items in the target comparison group.
403. If the target history comparison table exists, carrying out information matching with third information corresponding to the target parameter type in the target history comparison table by using the first information, and determining a second test item matched with the first test item in the target history comparison table;
Further, if the target history lookup table exists, the first information of the first test item to be compared can be used for carrying out information matching with the third information corresponding to the target parameter type in the target history lookup table, so as to determine the second test item matched with the first test item in the target history lookup table. Step 403 may specifically include steps a01 to a03:
a01, determining whether target third information which is the same as the first information exists in the target history comparison table;
a02, if the target third information exists, searching a third check item corresponding to the target third information from the target history comparison table, and taking the third check item as a second check item matched with the first check item;
and A03, if the target third information does not exist, continuing to execute the step of utilizing the first information corresponding to the target parameter type of the first test item in the first test item table to perform information matching with the second information corresponding to the target parameter type in the second test item table, and determining the second test item matched with the first test item in the second test item table.
It should be noted that, the first test item of the past comparison request may be different from the first test item of the current comparison request, and the correspondence relationship recorded in the target history comparison table may be different, that is, the target history comparison table may or may not have recorded therein the same comparison record as the first test item. Therefore, first, through step A1, it is determined whether there is the same target third information as the first information in the target history lookup table, taking the first information as an example of the item name "white band convention", and determining whether there is the target third information "white band convention" in the target history lookup table, where if there is the target third information, step A2 may be executed, searching the target history lookup table for a third check item corresponding to the target third information, and taking the third check item as a second check item matched with the first check item, where exemplary target history lookup table includes at least: the corresponding relation between the inspection item N and the inspection item M, wherein the third information of the inspection item N at least comprises: project name "white tape routine"; and searching in the target history comparison table by using the first information as the item name 'white-band conventional', so that the item name of the test item N is the same as the first information, the third information indicating the test item N is the target third information, the test item N has a corresponding relation with the test item M, and the second test item corresponding to the target third information is the test item M, thereby obtaining the second test item corresponding to the first test item. Otherwise, if the target third information does not exist, step A2 is executed, step 405 is continued, and fuzzy matching is performed through the second test item table, so as to obtain a second test item.
Wherein the absence of the target third information may be due to several reasons: (1) The history control of the target control group is not the whole item control, that is, there is a check item which is not subjected to control, even if there is a history control table of the target control group, the history control table will not record the check item (2) which is not subjected to control, but the first check item table in the subsequent target control group is updated, for example, the check item of the first check item table is added or deleted, and the content is updated.
404. If the target history comparison table does not exist, continuing to execute the step of utilizing the first information corresponding to the target parameter type of the first test item in the first test item table, performing information matching with the second information corresponding to the target parameter type in the second test item table, and determining a second test item matched with the first test item in the second test item table;
further, if the target history lookup table does not exist, it indicates that the target is the first time to be checked, and thus, the step 405 is continued to obtain the second check item.
In a possible implementation manner, in order to further improve the comparison efficiency, the present application further sets a high-frequency comparison table in advance, where a correspondence relationship between test items with higher comparison frequency is recorded, and if there is no target history comparison table, or if there is no target third information, the comparison efficiency may be further improved by the high-frequency comparison table before executing step 405, and steps B01 to B03 may be further included before executing step 405:
b01, determining whether target fourth information which is the same as the first information exists in a high-frequency comparison table or not by utilizing a preset high-frequency comparison table and the first information, wherein the high-frequency comparison table at least comprises a test item of which the comparison frequency is not lower than a preset frequency threshold value;
b02, if the target fourth information exists in the high-frequency comparison table, searching a fourth test item corresponding to the target fourth information from the high-frequency comparison table, and taking the fourth test item as the second test item;
and B03, if the target fourth information does not exist in the high-frequency comparison table, continuing to execute the step of utilizing the first information corresponding to the target parameter type of the first test item in the first test item table, performing information matching with the second information corresponding to the target parameter type in the second test item table, and determining a second test item matched with the first test item in the second test item table.
It should be noted that a high-frequency comparison table may be preset, and the correspondence relationship between the test items with higher comparison frequency is stored in the high-frequency comparison table. And then, whether the target fourth information which is the same as the first information exists in the high-frequency comparison table or not can be determined through the preset high-frequency comparison table and the first information, if so, a fourth inspection item corresponding to the target fourth information can be searched from the high-frequency comparison table, and the fourth inspection item is used as a second inspection item. If not, execution continues with step 405.
Furthermore, the high-frequency comparison table can be updated and iterated continuously based on the history record of the history record library, so that the high-frequency comparison table is updated dynamically.
405. Performing information matching with second information corresponding to the target parameter type in the second test item table by using first information corresponding to the target parameter type of a first test item in the first test item table, and determining a second test item matched with the first test item in the second test item table;
406. and adding the corresponding relation between the first test item and the second test item to a comparison table of the target comparison group.
It should be noted that, steps 405 and 406 are similar to the contents of steps 102 and 103 in fig. 1, and reference may be made to the contents of steps 102 and 103 in fig. 1 for avoiding repetition of the description.
In one possible implementation, the generated lookup table may be sent to and stored in a verification information system, where the verification information system includes, but is not limited to, a laboratory information management system (Laboratory Information Management System abbreviated LIMS), and the verification information system is an information management system that combines an information technology with a laboratory management requirement, which uses a database as a core, and then the lookup table of the target lookup group may be further sent to and stored in the verification information system, where different verification information systems have different lookup table formats, for example, fig. 3 (a) and fig. 3 (b) may respectively represent lookup table formats of two different systems, so in order to meet the lookup table format requirement of the different systems, the comparison request may further include a target system type identifier, where the target system type identifier is used to reflect the system type of the verification information system, and step 406 may include: determining a target comparison table format by using a corresponding relation between a preset system type identifier and the comparison table format and a target system type identifier; adding the corresponding relation between the first test item and the second test item into a reference table of a target reference group according to a target reference table format, and determining a target reference table; and sends the target lookup table to the verification information system.
Further, adding the correspondence between the first test item and the second test item to the reference table of the target reference group increases a history record, updates a history record library, and further performs statistics on the reference frequency of the test items through the updated history record library, so as to determine the test item with higher reference frequency in the history record library, and updates the high-frequency reference table, so that adding the correspondence between the first test item and the second test item to the reference table of the target reference group further comprises: counting the comparison frequency of each inspection item in the history record library; and updating the high-frequency record by using the comparison frequency and a preset high-frequency comparison table to obtain an updated high-frequency comparison table.
The comparison frequency can be obtained through the recording times of the test items, for example, the recording times of the test items as objects to be compared and the recording times of the objects to be compared are weighted to obtain the comparison frequency of the test items, when the comparison frequency is larger than a preset frequency threshold value, the test items are used as test items with higher comparison frequency, the corresponding relation of the test items is added into a high-frequency comparison table, or the test items are ordered according to the comparison frequency from high to low to obtain a test item sequence, and the corresponding relation of the first n test items in the test item sequence is added into the high-frequency comparison table.
The invention provides a comparison method for checking items, which comprises the following steps: receiving a comparison request, wherein the comparison request at least comprises a target comparison group and comparison conditions, the target comparison group at least comprises a first test item table to be compared and a second test item table to be compared, the test item table comprises item information of test items, and the comparison conditions at least comprise target parameter types used for comparison in the item information of the test items in the first test item table; performing history record searching processing by using a preset history record library and a target comparison group identifier, and determining whether a target history comparison table corresponding to the target comparison group identifier exists or not, wherein the history record library comprises a corresponding relation between the history comparison table and the comparison group identifier; if the target history comparison table exists, carrying out information matching with third information corresponding to the target parameter type in the target history comparison table by using the first information, and determining a second test item matched with the first test item in the target history comparison table; if the target history comparison table does not exist, continuing to execute the step of utilizing the first information corresponding to the target parameter type of the first test item in the first test item table to carry out information matching with the second information corresponding to the target parameter type in the second test item table, and determining a second test item matched with the first test item in the second test item table; using the first information corresponding to the target parameter type in the first test item table to carry out information matching with the second information corresponding to the target parameter type in the second test item table, and determining a second test item matched with the first test item in the second test item table; and adding the corresponding relation between the first test item and the second test item into a comparison table of the target comparison group. By the method, the first test item list to be compared and the second test item list to be compared, which are included in the target comparison group, can be automatically compared according to the target parameter types of the comparison conditions, the second test item matched with the first test item in the second test item list is determined, the corresponding relation between the first test item and the second test item is automatically added into the comparison list of the target comparison group, and a project comparison list is completed without manually searching, copying and pasting. And the history comparison table and the high-frequency comparison table of the history comparison library can be utilized to further improve the comparison efficiency.
Referring to fig. 5, fig. 5 is a block diagram illustrating a comparison device for checking items according to an embodiment of the present invention, where the device shown in fig. 5 includes:
request receiving module 501: the control request is used for receiving a control request, the control request at least comprises a target control group and control conditions, the target control group at least comprises a first test item table to be controlled and a second test item table to be controlled, the test item table comprises item information of test items, and the control conditions at least comprise target parameter types used for controlling in the item information of the test items in the first test item table;
information matching module 502: the method comprises the steps of carrying out information matching with second information corresponding to the target parameter type in the second test item table by using first information corresponding to the target parameter type of a first test item in the first test item table, and determining a second test item matched with the first test item in the second test item table;
control generation module 503: and the corresponding relation between the first test item and the second test item is added into the comparison table of the target comparison group.
It should be noted that, the content of the comparison device shown in fig. 5 is similar to that of each step in the comparison method shown in fig. 1, and for avoiding repetition, the content of each step in the comparison method shown in fig. 1 may be referred to specifically.
The invention provides a comparison device for checking items, which comprises: a request receiving module: the control request comprises at least a target control group and control conditions, wherein the target control group at least comprises a first test item table to be controlled and a second test item table to be controlled, the test item table comprises item information of test items, and the control conditions at least comprise target parameter types used for controlling in the item information of the test items in the first test item table; and the information matching module is used for: the method comprises the steps of carrying out information matching on first information corresponding to a target parameter type of a first test item in a first test item table and second information corresponding to a target parameter type in a second test item table, and determining a second test item matched with the first test item in the second test item table; a control generation module: and the corresponding relation between the first test item and the second test item is added to the comparison table of the target comparison group. By the device, the first inspection item list to be compared and the second inspection item list to be compared, which are included in the target comparison group, can be automatically compared according to the target parameter types of the comparison conditions, the second inspection item matched with the first inspection item in the second inspection item list is determined, the corresponding relation between the first inspection item and the second inspection item is automatically added into the comparison list of the target comparison group, and a project comparison list is completed without manually searching, copying and pasting.
FIG. 6 illustrates an internal block diagram of a computer device in one embodiment. The computer device may specifically be a terminal or a server. As shown in fig. 6, the computer device includes a processor, a memory, and a network interface connected by a system bus. The memory includes a nonvolatile storage medium and an internal memory. The non-volatile storage medium of the computer device stores an operating system, and may also store a computer program which, when executed by a processor, causes the processor to implement the method described above. The internal memory may also have stored therein a computer program which, when executed by a processor, causes the processor to perform the method described above. It will be appreciated by those skilled in the art that the structure shown in FIG. 6 is merely a block diagram of some of the structures associated with the present inventive arrangements and is not limiting of the computer device to which the present inventive arrangements may be applied, and that a particular computer device may include more or fewer components than shown, or may combine some of the components, or have a different arrangement of components.
In one embodiment, a computer device is presented comprising a memory and a processor, the memory storing a computer program that, when executed by the processor, causes the processor to perform the steps shown in fig. 1 or fig. 4.
In one embodiment, a computer readable storage medium is provided, storing a computer program which, when executed by a processor, causes the processor to perform the steps shown in fig. 1 or fig. 4.
Those skilled in the art will appreciate that all or part of the processes in the methods of the above embodiments may be implemented by a computer program for instructing relevant hardware, where the program may be stored in a non-volatile computer readable storage medium, and where the program, when executed, may include processes in the embodiments of the methods described above. Any reference to memory, storage, database, or other medium used in embodiments provided herein may include non-volatile and/or volatile memory. The nonvolatile memory can include Read Only Memory (ROM), programmable ROM (PROM), electrically Programmable ROM (EPROM), electrically Erasable Programmable ROM (EEPROM), or flash memory. Volatile memory can include Random Access Memory (RAM) or external cache memory. By way of illustration and not limitation, RAM is available in a variety of forms such as Static RAM (SRAM), dynamic RAM (DRAM), synchronous DRAM (SDRAM), double Data Rate SDRAM (DDRSDRAM), enhanced SDRAM (ESDRAM), synchronous Link DRAM (SLDRAM), memory bus direct RAM (RDRAM), direct memory bus dynamic RAM (DRDRAM), and memory bus dynamic RAM (RDRAM), among others.
The technical features of the above embodiments may be arbitrarily combined, and all possible combinations of the technical features in the above embodiments are not described for brevity of description, however, as long as there is no contradiction between the combinations of the technical features, they should be considered as the scope of the description.
The foregoing examples illustrate only a few embodiments of the application and are described in detail herein without thereby limiting the scope of the application. It should be noted that it will be apparent to those skilled in the art that several variations and modifications can be made without departing from the spirit of the application, which are all within the scope of the application. Accordingly, the scope of protection of the present application is to be determined by the appended claims.
Claims (10)
1. A method of collation of a test item, the method comprising:
receiving a comparison request, wherein the comparison request at least comprises a target comparison group and comparison conditions, the target comparison group at least comprises a first test item table to be compared and a second test item table to be compared, the test item table comprises item information of test items, and the comparison conditions at least comprise target parameter types used for comparison in the item information of the test items in the first test item table;
Performing information matching with second information corresponding to the target parameter type in the second test item table by using first information corresponding to the target parameter type of a first test item in the first test item table, and determining a second test item matched with the first test item in the second test item table;
and adding the corresponding relation between the first test item and the second test item to a comparison table of the target comparison group.
2. The method of claim 1, wherein the control request further includes a target control group identifier of the target control group, and wherein the determining, by using the first information corresponding to the target parameter type of the first test item in the first test item table and the second information corresponding to the target parameter type in the second test item table, the second test item matching the first test item in the second test item table further includes:
performing history record searching processing by using a preset history record library and the target comparison group identifier, and determining whether a target history comparison table corresponding to the target comparison group identifier exists or not, wherein the history record library comprises a corresponding relation between the history comparison table and the comparison group identifier;
If the target history comparison table exists, carrying out information matching with third information corresponding to the target parameter type in the target history comparison table by using the first information, and determining a second test item matched with the first test item in the target history comparison table;
and if the target history comparison table does not exist, continuing to execute the step of utilizing the first information corresponding to the target parameter type of the first test item in the first test item table, performing information matching with the second information corresponding to the target parameter type in the second test item table, and determining a second test item matched with the first test item in the second test item table.
3. The method of claim 2, wherein the target parameter type includes at least one of an item code, an item name, a methodology, and an item price, and wherein said using the first information to match information with third information corresponding to the target parameter type in the target history lookup table, determining a second check item in the target history lookup table that matches the first check item comprises:
Determining whether the target third information which is the same as the first information exists in the target history comparison table;
if the target third information exists, searching a third check item corresponding to the target third information from the target history comparison table, and taking the third check item as a second check item matched with the first check item;
and if the target third information does not exist, continuing to execute the step of using the first information corresponding to the target parameter type of the first test item in the first test item table to perform information matching with the second information corresponding to the target parameter type in the second test item table, and determining a second test item matched with the first test item in the second test item table.
4. The method of claim 3, wherein if the target history lookup table does not exist or if the target third information does not exist, the determining, by using the first information corresponding to the target parameter type of the first test item in the first test item table, the information matching with the second information corresponding to the target parameter type in the second test item table, further comprises:
Determining whether target fourth information which is the same as the first information exists in a high-frequency comparison table or not by using a preset high-frequency comparison table and the first information, wherein the high-frequency comparison table at least comprises a test item of which the comparison frequency is not lower than a preset frequency threshold value;
if the target fourth information exists in the high-frequency comparison table, searching a fourth check item corresponding to the target fourth information from the high-frequency comparison table, and taking the fourth check item as the second check item;
and if the target fourth information does not exist in the high-frequency comparison table, continuing to execute the step of utilizing the first information corresponding to the target parameter type of the first test item in the first test item table, performing information matching with the second information corresponding to the target parameter type in the second test item table, and determining a second test item matched with the first test item in the second test item table.
5. The method according to any one of claims 1-4, wherein said determining a second test item in the second test item table that matches the first test item using first information in the first test item table that corresponds to the target parameter type and second information in the second test item table that corresponds to the target parameter type comprises:
And carrying out fuzzy matching by using the first information and the second information, and determining a second check item matched with the first check item in the second check item table.
6. The method according to claim 1, characterized in that the method further comprises after that:
counting the comparison frequency of each inspection item in the history record library;
and updating the high-frequency record by using the comparison frequency and a preset high-frequency comparison table to obtain an updated high-frequency comparison table.
7. The method of claim 1, wherein the collation request further includes a target system type identifier, the target system type identifier being used to reflect a system type of the inspection information system, and wherein the adding the correspondence of the first inspection item and the second inspection item to the collation table of the target collation group further comprises:
determining a target comparison table format by utilizing a corresponding relation between a preset system type identifier and the comparison table format and the target system type identifier;
adding the corresponding relation between the first test item and the second test item into a reference table of the target reference group according to the target reference table format, and determining a target reference table;
And transmitting the target comparison table to the inspection information system.
8. A collation apparatus for testing items, the apparatus comprising:
a request receiving module: the control request is used for receiving a control request, the control request at least comprises a target control group and control conditions, the target control group at least comprises a first test item table to be controlled and a second test item table to be controlled, the test item table comprises item information of test items, and the control conditions at least comprise target parameter types used for controlling in the item information of the test items in the first test item table;
and the information matching module is used for: the method comprises the steps of carrying out information matching with second information corresponding to the target parameter type in the second test item table by using first information corresponding to the target parameter type of a first test item in the first test item table, and determining a second test item matched with the first test item in the second test item table;
a control generation module: and the corresponding relation between the first test item and the second test item is added into the comparison table of the target comparison group.
9. A computer readable storage medium storing a computer program, which when executed by a processor causes the processor to perform the steps of the method according to any one of claims 1 to 7.
10. A computer device comprising a memory and a processor, wherein the memory stores a computer program which, when executed by the processor, causes the processor to perform the steps of the method of any of claims 1 to 7.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202310801383.1A CN116798641A (en) | 2023-06-30 | 2023-06-30 | Collation method and apparatus for check items, device and storage medium |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202310801383.1A CN116798641A (en) | 2023-06-30 | 2023-06-30 | Collation method and apparatus for check items, device and storage medium |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN116798641A true CN116798641A (en) | 2023-09-22 |
Family
ID=88041874
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202310801383.1A Pending CN116798641A (en) | 2023-06-30 | 2023-06-30 | Collation method and apparatus for check items, device and storage medium |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN116798641A (en) |
-
2023
- 2023-06-30 CN CN202310801383.1A patent/CN116798641A/en active Pending
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US7324998B2 (en) | Document search methods and systems | |
| CN111221726A (en) | Test data generation method and device, storage medium and intelligent equipment | |
| CN108388640B (en) | Data conversion method and device and data processing system | |
| CN109635276B (en) | Information matching method and terminal | |
| CN111679851B (en) | Demand code management method, device, system and computer readable storage medium | |
| CN112364923A (en) | Sample data processing method, device and system, storage medium and electronic equipment | |
| CN113010208B (en) | Version information generation method, device, equipment and storage medium | |
| CN110334019B (en) | Test method, test device and readable storage medium | |
| CN109542890B (en) | Data modification method, device, computer equipment and storage medium | |
| CN116798641A (en) | Collation method and apparatus for check items, device and storage medium | |
| EP2406737A1 (en) | Systems and methods for address intelligence | |
| CN111736848A (en) | Packet conflict positioning method and device, electronic equipment and readable storage medium | |
| CN115129355B (en) | Page repair method, system and computer equipment thereof | |
| CN117555955B (en) | Data conversion method, data conversion device, computer device, and storage medium | |
| CN115118616B (en) | Display result testing method, device, computer equipment and storage medium | |
| CN114327377B (en) | Method and device for generating demand tracking matrix, computer equipment and storage medium | |
| CN111309623B (en) | Coordinate class data classification test method and device | |
| CN114595159B (en) | Test data generation method, device, equipment and storage medium | |
| CN116226168A (en) | Method and system for verifying wide-table data | |
| CN115795120A (en) | User portrait information verification method and device | |
| CN114780401A (en) | Interface testing method and device, computer equipment and storage medium | |
| CN117033242A (en) | Test data generation method, device, computer equipment and storage medium | |
| CN115080401A (en) | Automatic testing method and related device | |
| CN113918631A (en) | Data writing method and device, computer equipment and storage medium | |
| CN117667648A (en) | Method, device, computer equipment and storage medium for detecting code branch line |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination |