Electronic supervision code real-time online efficient inspection method

Abstract

The invention relates to drug supervision code inspection, in particular to an electronic supervision code real-time online efficient inspection method, which comprises the following steps of: performing distributed deployment on a production database table and a verification database table; collecting to-be-verified drug supervision code data of the products, and respectively importing and storing the to-be-verified drug supervision code data into a specified verification database table according to product categories; establishing a corresponding verification service interface and an interface distribution mechanism according to the verification database table; judging the product category according to the to-be-verified drug supervision code data of the product, and matching a verification service interface based on an interface distribution mechanism; performing data verification on the to-be-verified drug supervision code data by using the verification service interface, importing and storing the to-be-verified drug supervision code data which is qualified in data verification into a specified verified database table, and rejecting the to-be-verified drug supervision code data which is unqualified in data verification; according to the technical scheme provided by the invention, the defect that accurate and efficient online inspection of the drug administration code data is difficult in the prior art can be effectively overcome.

Description

Technical Field

[0001] The present invention relates to drug supervision code inspection, and in particular to a method for real-time online and efficient inspection of electronic supervision codes. Background Art

[0002] In order to ensure that the drug supervision code data is authentic, reliable, safe and unique, it is necessary to verify the drug supervision code data collected by each production line. The traditional drug supervision code data verification method generally puts all the collected drug supervision code data together for centralized verification. This method results in a huge amount of verification data. The verification data of various categories of products are centralized together and verified through a unified interface. It is easy to cause timeouts in real-time inspection of the production line, seriously affecting production efficiency. Summary of the invention

[0003] 1. Technical issues to be solved

[0004] In view of the above-mentioned shortcomings of the prior art, the present invention provides a method for real-time online efficient verification of electronic supervision codes, which can effectively overcome the defect of the prior art that it is difficult to perform accurate and efficient online verification of drug supervision code data.

[0005] (II) Technical solution

[0006] To achieve the above objectives, the present invention is implemented through the following technical solutions:

[0007] A method for real-time online efficient verification of electronic supervision codes comprises the following steps:

[0008] S1. Distribute the production database table and the verification database table;

[0009] S2. Collect the drug monitoring code data of the products to be verified, and import and store the drug monitoring code data to be verified into the designated verification database table according to product categories;

[0010] S3. Establish corresponding verification service interface and interface allocation mechanism according to the verification database table;

[0011] S4. Determine the product category based on the drug supervision code data to be verified, and match the verification service interface based on the interface allocation mechanism;

[0012] S5. Use the verification service interface to verify the drug monitoring code data to be verified, and import and store the drug monitoring code data to be verified that has passed the data verification into the specified verified database table, and remove the drug monitoring code data to be verified that has failed the data verification;

[0013] S6. Perform duplicate code verification on the drug supervision code data to be verified in the verified database table.

[0014] Preferably, in S1, the production database table and the verification database table are distributedly deployed, including:

[0015] S11. Establish independent production data server and verification data server;

[0016] S12. Deploy the production database table and the verification database table in the production data server and the verification data server respectively.

[0017] Preferably, before collecting the drug supervision code data of the product to be verified in S2 and importing and storing the drug supervision code data to be verified into the designated verification database table according to product categories, the process includes:

[0018] S21. Create corresponding product-specific tables according to different product categories or business requirements;

[0019] S22. Select appropriate fields in the product-specific table to create a data index.

[0020] Preferably, in S21, a corresponding product-specific table is created according to different product categories or business requirements, including:

[0021] Determine the structure and fields of the table to ensure that the requirements for data storage and verification are met;

[0022] Consider factors including the data validity period, and plan the table size and storage strategy appropriately to keep the data volume within a manageable range.

[0023] Preferably, in S22, selecting a suitable field in the product-specific table to establish a data index includes:

[0024] According to the frequency of queries and performance requirements, select appropriate fields in the product-specific table to create data indexes;

[0025] Regularly maintain and optimize data indexes to ensure that the performance of data indexes always remains in good condition.

[0026] Preferably, in S3, a corresponding verification service interface and interface allocation mechanism are established according to the verification database table, including:

[0027] S31, establishing a corresponding verification service interface according to the verification database table;

[0028] S32. Create an interface allocation mechanism based on the product category corresponding to the drug supervision code data to be verified stored in the verification database table and in combination with the verification service interface.

[0029] Preferably, the verification service interface has the function of verifying the legitimacy of data, defines clear verification rules and algorithms, ensures the accuracy and reliability of data verification, and the verification service interface uses a variety of data verification methods including format verification, logic verification and database query verification to perform data verification.

[0030] Preferably, in S5, the drug supervision code data to be verified that has passed the data verification is imported and stored into the designated verified database table, including:

[0031] Ensure the security and integrity of data storage, establish data backup and recovery mechanisms to prevent data loss or damage, and clean up data regularly to remove expired and invalid data.

[0032] Preferably, in S6, the drug supervision code data to be verified in the verified database table is subjected to duplicate code verification, including:

[0033] S61. When duplicate code verification is required, extract the drug monitoring code data to be verified from the verified database table;

[0034] S62, using the duplicate checking service interface to perform duplicate code checking on the extracted drug monitoring code data to be checked;

[0035] S63. For drug monitoring code data to be verified that has duplicate codes, timely mark them and send reminder messages for processing.

[0036] Preferably, the duplicate checking service interface has the function of verifying the data repeatability, defines clear verification rules and algorithms, ensures the accuracy and reliability of duplicate code verification, and the duplicate checking service interface adopts a variety of duplicate code verification methods including hash algorithm and database query verification to perform duplicate code verification.

[0037] (III) Beneficial effects

[0038] Compared with the prior art, the method for real-time online efficient verification of electronic supervision codes provided by the present invention has the following beneficial effects:

[0039] 1) Distribute and store the collected drug monitoring code data to be verified according to product categories, realize the classification of drug monitoring code data to be verified, and improve the efficiency of data verification;

[0040] 2) Create a corresponding product-specific table and select appropriate fields in the product-specific table to establish data indexes to improve the query and verification efficiency of the table;

[0041] 3) Distribute the production database table and the verification database table, store the drug supervision code data to be verified according to product categories, and establish corresponding verification service interfaces according to product categories to improve the total throughput of enterprise production data verification, while improving the stability and anti-interference of the verification service interface operation;

[0042] 4) Establish an interface allocation mechanism to match each production line with the corresponding calibration service interface according to product category, avoid calibration interference between products of different categories on other production lines, and improve the security of the calibration service interface;

[0043] 5) The client can quickly obtain the required verification service through the verification service interface, and the system can also process the client's request in a timely manner, which improves the efficiency and reliability of the entire data verification process and realizes a reasonable and rapid response to data verification;

[0044] 6) By establishing an interface allocation mechanism to effectively avoid the transfer link, not only the response speed is improved, but also the accuracy of data verification is further improved, unnecessary waiting time and resource consumption are reduced, so that the production line can complete production tasks more efficiently, thereby improving the overall production quality and efficiency. BRIEF DESCRIPTION OF THE DRAWINGS

[0045] In order to more clearly illustrate the embodiments of the present invention or the technical solutions in the prior art, the drawings required for use in the embodiments or the prior art descriptions are briefly introduced below. Obviously, the drawings described below are only some embodiments of the present invention, and for ordinary technicians in this field, other drawings can be obtained based on these drawings without creative work.

[0046] Figure 1 It is a schematic diagram of the process of the present invention. DETAILED DESCRIPTION

[0047] In order to make the purpose, technical solution and advantages of the embodiments of the present invention clearer, the technical solution in the embodiments of the present invention will be clearly and completely described below in conjunction with the drawings in the embodiments of the present invention. Obviously, the described embodiments are part of the embodiments of the present invention, not all of the embodiments. Based on the embodiments of the present invention, all other embodiments obtained by ordinary technicians in this field without creative work are within the scope of protection of the present invention.

[0048] A method for real-time online and efficient verification of electronic supervision codes, such as Figure 1 As shown, S1, distributed deployment of production database tables and verification database tables, specifically including:

[0049] S11. Establish independent production data server and verification data server;

[0050] S12. Deploy the production database table and the verification database table in the production data server and the verification data server respectively.

[0051] S2. Collect the drug supervision code data to be verified of the product, and import and store the drug supervision code data to be verified into the designated verification database table according to product categories.

[0052] Specifically, before collecting the drug supervision code data to be verified of the product and importing and storing the drug supervision code data to be verified into the designated verification database table according to product categories, it includes:

[0053] S21. Create corresponding product-specific tables according to different product categories or business requirements;

[0054] S22. Select appropriate fields (such as product number, production date, etc.) in the product-specific table to establish a data index.

[0055] 1) In S21, create corresponding product-specific tables according to different product categories or business needs, including:

[0056] Determine the structure and fields of the table to ensure that the requirements for data storage and verification are met;

[0057] Consider factors including the data validity period, and plan the table size and storage strategy appropriately to keep the data volume within a manageable range.

[0058] 2) In S22, select appropriate fields in the product-specific table to create data indexes, including:

[0059] According to the frequency of queries and performance requirements, select appropriate fields in the product-specific table to create data indexes;

[0060] Regularly maintain and optimize data indexes to ensure that the performance of data indexes always remains in good condition.

[0061] S3. Establish corresponding verification service interface and interface allocation mechanism according to the verification database table, including:

[0062] S31, establishing a corresponding verification service interface according to the verification database table;

[0063] S32. Create an interface allocation mechanism based on the product category corresponding to the drug supervision code data to be verified stored in the verification database table and in combination with the verification service interface.

[0064] In the technical solution of the present application, the verification service interface has the function of verifying the legality of data, defines clear verification rules and algorithms, ensures the accuracy and reliability of data verification, and the verification service interface uses a variety of data verification methods including format verification, logic verification and database query verification to perform data verification.

[0065] The verification service interface is specially designed for product categories and can provide effective verification services. By using the interface allocation mechanism to timely feedback the correct verification service interface, the client can directly access the required resources, avoiding unnecessary searches and attempts. When the production line client performs data verification, it can directly access the "exclusive" verification service interface for the product category, which can avoid the transfer link, reduce the path and time of data transmission, and thus improve the response speed. Direct access can also reduce the risk of errors and loss of data during the transfer process.

[0066] S4. Determine the product category based on the drug supervision code data to be verified, and match the verification service interface based on the interface allocation mechanism.

[0067] S5. Use the verification service interface to verify the drug monitoring code data to be verified, and import and store the drug monitoring code data to be verified that pass the data verification into the specified verified database table, and remove the drug monitoring code data to be verified that fail the data verification.

[0068] Specifically, the drug supervision code data to be verified that has passed the data verification is imported and stored in the specified verified database table, including:

[0069] Ensure the security and integrity of data storage, establish data backup and recovery mechanisms to prevent data loss or damage, and clean up data regularly to remove expired and invalid data.

[0070] S6. Perform duplicate code verification on the drug monitoring code data to be verified in the verified database table, specifically including:

[0071] S61. When duplicate code verification is required, extract the drug monitoring code data to be verified from the verified database table;

[0072] S62, using the duplicate checking service interface to perform duplicate code checking on the extracted drug monitoring code data to be checked;

[0073] S63. For drug monitoring code data to be verified that has duplicate codes, timely mark them and send reminder messages for processing.

[0074] In the technical solution of the present application, the duplicate checking service interface has the function of verifying the data duplication, and defines clear verification rules and algorithms to ensure the accuracy and reliability of duplicate code verification. The duplicate checking service interface adopts a variety of duplicate code verification methods including hash algorithm and database query verification to perform duplicate code verification.

[0075] The above embodiments are only used to illustrate the technical solutions of the present invention, rather than to limit the same. Although the present invention has been described in detail with reference to the aforementioned embodiments, those skilled in the art should understand that the technical solutions described in the aforementioned embodiments may still be modified, or some of the technical features may be replaced by equivalents. Such modifications or replacements will not cause the essence of the corresponding technical solutions to deviate from the spirit and scope of the technical solutions of the embodiments of the present invention.

Claims

1. A method for real-time online and efficient verification of electronic supervision codes, characterized in that: The following steps are involved: S1. Distribute the production database table and the verification database table; S2. Collect the drug supervision code data of the products to be verified, and import and store the drug supervision code data to the designated verification database table according to product categories; S3. Establish corresponding verification service interface and interface allocation mechanism according to the verification database table; S4. Determine the product category based on the drug supervision code data to be verified, and match the verification service interface based on the interface allocation mechanism; S5. Use the verification service interface to verify the drug monitoring code data to be verified, and import and store the drug monitoring code data to be verified that has passed the data verification into the specified verified database table, and remove the drug monitoring code data to be verified that has failed the data verification; S6. Perform duplicate code verification on the drug supervision code data to be verified in the verified database table.

2. The method for real-time online efficient verification of electronic supervision codes according to claim 1 is characterized in that: In S1, the production database table and the verification database table are distributedly deployed, including: S11. Establish independent production data server and verification data server; S12. Deploy the production database table and the verification database table in the production data server and the verification data server respectively.

3. The method for real-time online efficient verification of electronic supervision codes according to claim 1 is characterized in that: In S2, the drug monitoring code data of the products to be verified are collected, and the drug monitoring code data to be verified are imported and stored in the designated verification database table according to product categories, including: S21. Create corresponding product-specific tables according to different product categories or business requirements; S22. Select appropriate fields in the product-specific table to create a data index.

4. The method for real-time online efficient verification of electronic supervision codes according to claim 3 is characterized in that: In S21, create corresponding product-specific tables according to different product categories or business needs, including: Determine the structure and fields of the table to ensure that the requirements for data storage and verification are met; Consider factors including the data validity period, and plan the table size and storage strategy appropriately to keep the data volume within a manageable range.

5. The method for real-time online efficient verification of electronic supervision codes according to claim 3 is characterized in that: In S22, select appropriate fields in the product-specific table to create data indexes, including: According to the frequency of queries and performance requirements, select appropriate fields in the product-specific table to create data indexes; Regularly maintain and optimize data indexes to ensure that the performance of data indexes always remains in good condition.

6. The method for real-time online efficient verification of electronic supervision codes according to claim 1 is characterized in that: In S3, the corresponding verification service interface and interface allocation mechanism are established according to the verification database table, including: S31, establishing a corresponding verification service interface according to the verification database table; S32. Create an interface allocation mechanism based on the product category corresponding to the drug supervision code data to be verified stored in the verification database table and in combination with the verification service interface.

7. The method for real-time online efficient verification of electronic supervision codes according to claim 6 is characterized in that: The verification service interface has the function of verifying the legitimacy of data, defines clear verification rules and algorithms, and ensures the accuracy and reliability of data verification. The verification service interface uses a variety of data verification methods including format verification, logic verification and database query verification to perform data verification.

8. The method for real-time online efficient verification of electronic supervision codes according to claim 1 is characterized in that: In S5, the drug supervision code data to be verified that has passed the data verification is imported and stored in the specified verified database table, including: Ensure the security and integrity of data storage, establish data backup and recovery mechanisms to prevent data loss or damage, and clean up data regularly to remove expired and invalid data.

9. The method for real-time online efficient verification of electronic supervision codes according to claim 1, characterized in that: In S6, the drug supervision code data to be verified in the verified database table is verified for duplicate codes, including: S61. When duplicate code verification is required, extract the drug monitoring code data to be verified from the verified database table; S62, using the duplicate checking service interface to perform duplicate code checking on the extracted drug monitoring code data to be checked; S63. For drug monitoring code data to be verified that has duplicate codes, timely mark them and send reminder messages for processing.

10. The method for real-time online efficient verification of electronic supervision codes according to claim 9, characterized in that: The duplicate checking service interface has the function of verifying the data duplication, and defines clear verification rules and algorithms to ensure the accuracy and reliability of duplicate code verification. The duplicate checking service interface adopts a variety of duplicate code verification methods including hash algorithm and database query verification to perform duplicate code verification.

Images