An automated management system for drug storage

Abstract

The present invention relates to the technical field of warehouse automation management systems, and in particular to a drug warehouse automation management system comprising: a drug sorting robot, a data acquisition module, a drug database, a data update module, and a control module, which is used to adjust the buffer pool size when the drug is in and out of the warehouse when the accuracy of the data acquisition module is determined to be unsatisfactory according to the sorting error ratio, or to determine the real-time performance of the data update module in combination with the sorting error ratio and the update time of the drug database after the drug is out of the warehouse, or to determine whether the drug database reclassifies and stores the expiring drugs according to the expiring time of the drugs, and to adjust the isolation level of the drug database when the real-time performance of the data update module is determined to be unsatisfactory. The present invention improves the accuracy and real-time performance of drug warehouse automation management.

Description

Technical Field

[0001] The present invention relates to the technical field of warehouse automation management systems, and in particular to a medicine warehouse automation management system. Background Art

[0002] In the existing technology, the pharmacy automation equipment market covers a variety of functions, such as drug storage systems, dispensing robots and dispensing systems. These systems can provide accurate drug information and tracking functions, improve the efficiency and accuracy of dispensing, and save labor costs. With the continuous advancement of technology, the pharmacy automation equipment market shows a trend of increasing intelligence. The application of artificial intelligence and machine learning technology makes drug management and dispensing services more efficient.

[0003] Chinese Patent Publication No.: CN102708529B discloses a drug storage information management system for a pharmacy, which includes a basic information management module, an outbound management module, an inbound management module, an inventory management module, a statistical information analysis module and a system management module; the basic information management module is used for the maintenance and management of employee information, the maintenance and management of drug supplier information and the maintenance and management of patient information; the inbound management module is used for inbound operation, storage location management, inbound query and inbound return management; the outbound management module is used for manual outbound operation, outbound query and outbound return management; the inventory management module is used for inventory query, inventory alarm and inventory transfer function management; the statistical information analysis module is used for employee information statistics, supplier information Statistics, drug inbound statistics, drug inbound statistical analysis, drug outbound statistics, and drug outbound statistical analysis management; system management module, used for system administrator management, administrator password management, data backup, data restoration, and authority management; so that the system has inventory management and inventory analysis functions, cargo location management functions, various report processing functions, system management functions, and the function of providing multiple operating modes; the outbound management module also includes an interface module, which is the source of data information for the entire system and is used to achieve: (1) synchronous update of drug information with the hospital HIS system; (2) saving the prescription information and prescription receiving status of the HIS system to the local database; (3) feeding back the prescription completion status to the HIS system for data exchange;The inbound and outbound management modules are mainly used for the inbound and outbound information management of drugs. Among them, the inbound management module mainly includes inbound operation, storage location management, inbound query and inbound drug return management. The inbound operation includes the operation management of the entry of new drugs and the entry of out-of-stock drugs. The entry of new drugs means finding a storage location suitable for the drugs according to their external dimensions, and at the same time, the storage location is closest to the inbound and outbound ports. The entry operation of out-of-stock drugs means finding a storage location suitable for the drugs according to their external dimensions. When there are multiple storage locations occupied by the drugs entering the warehouse, it is necessary to select the most suitable storage location for them based on the principle of batch number proximity. When the batch number proximity is met, the inbound drug must be matched with the drug. When there are still multiple storage locations to choose from under the premise, it is necessary to select the most suitable storage location based on the principle of the closest distance to the entry and exit. Storage location management is to manage the status and storage location information of the storage location. The storage location status includes 3 types, namely, idle, occupied, and faulty for repair. The functions mainly include query and modification of information. Storage location information includes the length, width, height, storage location coordinates, storage drug name, drug code, storage location number and other information. The functions mainly include query, modification, addition, and deletion operations. Storage location information is the information basis for entry and exit operations. Entry query includes information such as entry time, entry order number, drug name, drug code, etc. The module supports query of information, fuzzy and multi-condition query at the same time. Inbound return means that the medicines that have been in the warehouse need to be returned for some reason. In this case, the medicines are withdrawn from the pharmacy through the inbound return operation, and the relevant information of the medicines is deleted from the inbound information table, storage location information table and inventory table; the outbound management module mainly includes outbound operation, manual outbound operation, outbound query and outbound return management. The outbound operation is to select the storage location of the outbound medicines according to the prescription information transmitted from the HIS system and the principle of giving priority to the outbound medicine batch number. At the same time, all the storage locations of the outbound medicines are arranged according to the principle of the shortest sum of the distances of all the medicine storage locations, and finally generate the outbound information. , and pass this information to the control system to execute the drug delivery operation. The manual delivery operation is used for emergency response when the automatic drug delivery system fails. At the same time, the manual delivery operation can also be used for delivery of other drugs that are not in the automatic drug delivery system. The delivery query and delivery return operation functions are exactly the same as the warehousing operation. The delivery module also includes a data interface module. The data interface is the information transmission with the hospital HIS system. The hospital HIS system transmits prescription information and drug information to the management system. The management system transmits the drug inventory update and prescription completion status to the HIS system to ensure the synchronization of hospital drug and prescription information.Its inventory management module mainly includes the management of inventory query, inventory alarm and inventory transfer functions. Inventory query includes fuzzy and multi-condition query operations of information such as drug name, drug barcode, drug manufacturer, and drug supplier. Inventory alarm is the operation of setting the inventory bottom limit of various drugs, including adding, modifying, querying, and deleting functions. Inventory transfer is the operation of transferring drugs from other warehouses to the pharmacy, including the operation of transferring drugs from the main drug warehouse, western medicine warehouse, and traditional Chinese medicine warehouse to the pharmacy; its statistical information management module mainly includes employee information statistics, supplier information statistics, drug warehousing statistics, drug warehousing statistical analysis, drug outbound statistics, and drug outbound statistical analysis. Employee information statistics mainly summarizes the situation of the employee's outbound and inbound drugs in a certain period of time, and presents it in the form of a report, and supports printing, storage and other functions. Similarly, supplier information statistics, drug inbound statistics, and drug outbound statistics mainly summarize the situation of the outbound and inbound drugs provided by the supplier in a certain period of time and the outbound and inbound situation of a certain type of drug. Statistics are summarized in the form of reports, and support printing, storage and other functions. The statistical analysis of drug inbound and outbound can be based on the statistics of a certain drug in and out of the warehouse during a period of time, and finally form an analysis report to provide decision support services for the pharmacy department and hospital leaders to select drug types, suppliers and the amount of drugs to be purchased. The system management module mainly includes the management of system administrators, the management of administrator passwords, data backup, data restoration and authority management. Administrator management is to manage the basic information of all system operators in the pharmacy, including the operator's name and operation password. Its functions mainly include adding, modifying, deleting and querying operations. The administrator password is mainly to modify the operator's password. Data backup and restoration are mainly to perform timely backup and restoration operations on the data table of the backend server database. The authority management module is used to manage the operators who use the system and assign different permissions to them. Different operators log in to the management system and use different management functions. It can be seen that a pharmacy drug storage information management system has problems with low system accuracy and real-time performance. ; Summary of the invention

[0004] To this end, the present invention provides a drug storage automation management system to overcome the problem of low accuracy and real-time performance of drug storage automation management systems in the prior art.

[0005] To achieve the above object, the present invention provides a drug storage automation management system, comprising:

[0006] Medicine sorting robots, used to sort and transport medicines;

[0007] A data collection module, which is connected to the drug sorting robot and is used to collect storage characteristic data of the drugs, the storage characteristic data includes an outbound characteristic data set, an inbound characteristic data set and drug QR code data, and the data collection module also includes a buffer pool;

[0008] A drug database, which is connected to the data collection module and is used to classify and store storage characteristic data;

[0009] A data update module, which is connected to the data acquisition module, is used to update the inventory turnover rate, drug inventory information, drug flow direction and drug expiration date of the drug database in real time;

[0010] The control module is connected to the drug sorting robot, the data acquisition module, the data update module and the drug database respectively, and is used to adjust the buffer pool size when the drug is in and out of the warehouse when the accuracy of the data acquisition module is determined to be unsatisfactory according to the sorting error ratio, or to determine the real-time performance of the data update module in combination with the sorting error ratio and the update time of the drug database after the drug is out of the warehouse, or to determine whether the drug database reclassifies and stores the expiring drugs according to the expiring time of the drugs.

[0011] And, when it is determined that the real-time performance of the data update module does not meet the requirements, the isolation level of the drug database is adjusted.

[0012] Furthermore, it also includes an environmental monitoring module connected to the control module for collecting the temperature, humidity, and microbial bacteria content in the air of the drug storage environment to form storage environment data, which includes:

[0013] Temperature sensor, used to collect the internal air temperature of the drug storage space;

[0014] Humidity sensor, used to collect air humidity in the drug storage space;

[0015] Microbial collector, used to collect the content of microorganisms and bacteria in the air of the drug storage space;

[0016] Among them, if the storage environment data reaches the environmental alarm triggering condition, the control module issues an environmental alarm message.

[0017] Furthermore, the environmental alarm triggering condition is that the internal air temperature of the drug storage space is greater than a preset temperature, or the humidity is greater than or equal to a preset humidity, or the microbial bacteria content is greater than or equal to a preset microbial bacteria content.

[0018] Furthermore, the data acquisition module includes:

[0019] A QR code management unit, which is connected to the drug sorting robot and is used to collect drug QR code data corresponding to the drug QR code;

[0020] The storage unit is connected to the QR code management unit and is used to identify and store the drug QR code data and record the storage time and storage quantity to form a storage feature data set;

[0021] The outbound unit is connected to the QR code management unit and is used to combine the drug QR code data with the outbound time, outbound quantity and drug flow direction to form an outbound feature data set.

[0022] Furthermore, the control module is connected to the drug sorting robot and the data acquisition module respectively, and is used to calculate the sorting error ratio according to the number of sorting errors of the sorted drugs in a unit time. When the sorting error ratio is greater than or equal to a preset second error ratio, it is determined that the accuracy of the system does not meet the requirements, and the size of the buffer pool when the drugs are in and out of the warehouse is adjusted respectively;

[0023] If the sorting error ratio is greater than the preset first error ratio and less than the preset second error ratio, the control module preliminarily determines that the real-time performance of the system does not meet the requirements.

[0024] Furthermore, if the sorting error ratio during warehousing is greater than or equal to a preset second error ratio, the control module reduces the size of the buffer pool; if the sorting error ratio during outbound storage is greater than or equal to the preset second error ratio, the control module increases the size of the buffer pool.

[0025] Furthermore, the control module is connected to the data update module to calculate the average update time of the drug database based on the update time of several times after the drugs are shipped out of the warehouse, and to determine for the second time that the real-time performance of the system does not meet the requirements when the average update time is greater than the preset update time, and to reduce the isolation level of the drug database.

[0026] Furthermore, the control module is connected to the data acquisition module and the data update module respectively to obtain the drug inventory quantity. If the drug inventory quantity is lower than the inventory preset value, the control module sends an inventory warning signal and sets a pop-up window reminder.

[0027] Among them, the inventory preset value is determined based on the inventory turnover rate of the drug, the drug price and the drug supplier information.

[0028] Furthermore, the control module is respectively connected to the data acquisition module, the drug database and the data update module to obtain the drug expiration time. If the drug expiration time is less than or equal to the first expiration preset value and greater than the second expiration preset value, the control module classifies the expiring drugs to form a primary expiring drug database.

[0029] If the drug expiration time is less than or equal to the preset second drug preset value and greater than the third drug expiration preset value, the control module performs secondary classification on the expiring drugs to form a secondary expiring drug database.

[0030] If the drug's expiration time is less than or equal to the third expiration preset value, the control module classifies the expiring drugs three times to form an expired drug database and issues a pop-up reminder.

[0031] Among them, the drug expiration date is the difference between the current date of the drug and the drug’s expiration date.

[0032] Furthermore, the formula for the duration of drug expiration is:

[0033] T=t i -t0

[0034] Among them, T is the duration of drug expiration, t i is the expiration date of the drug, and t0 is the date of the drug today.

[0035] Compared with the prior art, the beneficial effect of the present invention lies in that the system of the present invention sets a sorting robot and performs data path training on it. The sorting robot adopts advanced computer vision and deep learning technology, can quickly and accurately identify, grab and transport medicines, improve sorting efficiency, shorten the sorting cycle, improve the overall sorting efficiency, and further reduce the operating cost of the enterprise. The sorting robot adopts a closed design with built-in safety sensors and emergency braking devices, which effectively avoids accidental injuries and ensures the safety and integrity of medicines; by setting a data acquisition module to strictly control the drug in and out data, it is possible to quickly and accurately record the drug in and out information data, reducing the operation time and error rate; by setting a data update module, the drug information is kept updated, and the amount of decision-making errors caused by information lag is reduced. By setting important parameters such as inventory quantity, inventory location, and drug expiration date, accurate data support is provided for warehouse management; by setting a control module to make corresponding adjustments when the system accuracy and real-time performance do not meet the requirements, the system can improve the data processing speed and thus improve the system accuracy and real-time performance, and optimize the inventory management and resource allocation of the drug warehouse management system.

[0036] Furthermore, the system of the present invention monitors the drug storage environment in real time by setting an environmental monitoring module. When the environmental parameters in the warehouse exceed the set range, the system can automatically trigger the alarm mechanism, thereby reducing drug losses or quality problems caused by environmental changes and providing more suitable environmental conditions for drug storage. By analyzing historical storage environment data, the changing trend of the environment in the warehouse can be obtained, providing a scientific basis for warehouse management. At the same time, these data can also be used for work such as drug quality tracing and recall, further improving the efficiency and quality of drug storage management, and improving the safety and effectiveness of drugs.

[0037] Furthermore, the system of the present invention ensures the accuracy of drug in-and-out warehouse information by setting up a data acquisition module and adopting two-dimensional code automatic recognition technology. It realizes real-time and accurate tracing of the entire process of drugs from storage to drug flow through data acquisition and storage management technology, thereby ensuring the authenticity and reliability of drug information. The two-dimensional code contains all the information required for the drug and each two-dimensional code is unique, thereby reducing duplication and omissions that occur when collecting drug information. Administrators can quickly locate problematic drugs through drug two-dimensional codes, thereby realizing drug quality control and risk management.

[0038] Furthermore, the system of the present invention improves the data processing speed and accuracy of the system by adjusting the buffer pool size when drugs are put in and out of the warehouse when the system accuracy does not meet the requirements, further reduces the false positive and missed positive rate when the system processes data, and improves the accuracy of the system.

[0039] Furthermore, the system of the present invention reduces the isolation level of the drug database when the system real-time performance does not meet the requirements, thereby preventing the sorting robot from processing in a timely manner and mixing processing information due to data lock contention when receiving a large number of processing instructions, reducing the workload of the sorting robot in processing information, optimizing the information processing operation and thus reducing the processing time, and further improving the real-time performance of the system.

[0040] Furthermore, the system of the present invention reduces production stagnation and order delays caused by insufficient inventory by issuing an early warning when the drug inventory quantity is too low, reminding management personnel to replenish the stock, thereby analyzing key indicators such as inventory turnover and order processing frequency, thereby optimizing inventory management and reducing inventory costs.

[0041] Furthermore, the system of the present invention reclassifies expiring drugs and divides them into three levels according to the length of time to expiration, so as to simply and clearly display the types and quantities of expiring drugs, reduce the misjudgment of inventory quantity due to the accumulation of expiring drugs, and reduce the occurrence of losses due to expiration. At the same time, the system can ensure that the drugs are used within the validity period, ensure the safety of patients' medication, and avoid expired drugs from entering the market; the three-level classification standard for expiring drugs helps to reasonably arrange the distribution sequence according to the shelf life of the drugs, and ensure that the drugs are delivered within the validity period; in addition, by analyzing the data on the length of time to expiration of expiring drugs, the inventory, drug flow and other conditions of expiring drugs can be collected and analyzed, providing data support for decisions such as warehouse procurement and inventory allocation, thereby realizing the optimization of inventory management strategies. BRIEF DESCRIPTION OF THE DRAWINGS

[0042] Figure 1 This is an overall structural diagram of the pharmaceutical storage automation management system according to an embodiment of the present invention;

[0043] Figure 2 This is a structural block diagram of a data acquisition module of a pharmaceutical warehouse automation management system according to an embodiment of the present invention;

[0044] Figure 3 This is a logic flow chart of reclassification of expiring drugs in the automated management system for drug storage according to an embodiment of the present invention;

[0045] Figure 4 The following is a logic flow chart of the automated management system for pharmaceutical warehouses according to an embodiment of the present invention. DETAILED DESCRIPTION

[0046] In order to make the objects and advantages of the present invention more clearly understood, the present invention is further described below in conjunction with embodiments; it should be understood that the specific embodiments described herein are only used to explain the present invention and are not used to limit the present invention.

[0047] The preferred embodiments of the present invention are described below with reference to the accompanying drawings. It should be understood by those skilled in the art that these embodiments are only used to explain the technical principles of the present invention and are not intended to limit the protection scope of the present invention.

[0048] It should be noted that, in the description of the present invention, terms such as "up", "down", "left", "right", "inside" and "outside" indicating directions or positional relationships are based on the directions or positional relationships shown in the drawings. This is only for the convenience of description and does not indicate or imply that the device or element must have a specific orientation, be constructed and operated in a specific orientation. Therefore, it should not be understood as a limitation on the present invention.

[0049] In addition, it should be noted that in the description of the present invention, unless otherwise clearly specified and limited, the terms "installed", "connected", and "connected" should be understood in a broad sense, for example, it can be a fixed connection, a detachable connection, or an integral connection; it can be a mechanical connection or an electrical connection; it can be a direct connection, or it can be indirectly connected through an intermediate medium, or it can be the internal communication of two components. For those skilled in the art, the specific meanings of the above terms in the present invention can be understood according to specific circumstances.

[0050] See also Figure 1 , Figure 2 , Figure 3 as well as Figure 4 As shown, they are respectively the overall structure block diagram of the drug storage automation management system of the embodiment of the present invention, the data acquisition module structure block diagram, the near-expiry drug reclassification logic flow chart; and the logic flow chart. The drug storage automation management system of the present invention includes:

[0051] Medicine sorting robots, used to sort and transport medicines;

[0052] A data collection module, which is connected to the drug sorting robot and is used to collect storage characteristic data of the drugs, the storage characteristic data includes an outbound characteristic data set, an inbound characteristic data set and drug QR code data, and the data collection module also includes a buffer pool;

[0053] A drug database, which is connected to the data collection module and is used to classify and store storage characteristic data;

[0054] A data update module, which is connected to the data acquisition module, is used to update the inventory turnover rate, drug inventory information, drug flow direction and drug expiration date of the drug database in real time;

[0055] The control module is connected to the drug sorting robot, the data acquisition module, the data update module and the drug database respectively, and is used to adjust the buffer pool size when the drug is in and out of the warehouse when the accuracy of the data acquisition module is determined to be unsatisfactory according to the sorting error ratio, or to determine the real-time performance of the data update module in combination with the sorting error ratio and the update time of the drug database after the drug is out of the warehouse, or to determine whether the drug database reclassifies and stores the expiring drugs according to the expiring time of the drugs.

[0056] And, when it is determined that the real-time performance of the data update module does not meet the requirements, the isolation level of the drug database is adjusted.

[0057] In implementation, the system of the present invention sets a sorting robot and performs data path training on it. The sorting robot adopts advanced computer vision and deep learning technology, which can quickly and accurately identify, grab and transport medicines, improve sorting efficiency, shorten the sorting cycle, improve the overall sorting efficiency, and further reduce the operating costs of the enterprise. The sorting robot adopts a closed design with built-in safety sensors and emergency braking devices, which effectively avoids accidental injuries and ensures the safety and integrity of the medicines; by setting a data acquisition module to strictly control the drug in and out data, it is possible to quickly and accurately record the drug in and out information data, reducing the operation time and error rate; by setting a data update module, the drug information is kept updated, and the amount of decision-making errors caused by information lag is reduced. By setting important parameters such as inventory quantity, inventory location, and drug expiration date, accurate data support is provided for warehouse management; by setting a control module to make corresponding adjustments when the system accuracy and real-time performance do not meet the requirements, the system can improve the data processing speed and thus improve the system accuracy and real-time performance, and optimize the inventory management and resource allocation of the drug warehouse management system.

[0058] Specifically, the classification of basic drug data is based on drug efficacy and function, pharmacological action, dosage form, drug management requirements, and source of drugs.

[0059] Specifically, the drug database is a database formed by classifying warehouse characteristic data according to different classification methods.

[0060] Specifically, the inventory turnover rate refers to the ratio of drug sales to the average drug inventory within a month, where drug sales refers to the total sales of drugs within a month; and the average drug inventory refers to the average drug inventory within a month.

[0061] Specifically, it also includes an environmental monitoring module connected to the control module for collecting the temperature, humidity, and microbial bacteria content in the air of the drug storage environment to form storage environment data, which includes:

[0062] Temperature sensor, used to collect the internal air temperature of the drug storage space;

[0063] Humidity sensor, used to collect air humidity in the drug storage space;

[0064] Microbial collector, used to collect the content of microorganisms and bacteria in the air of the drug storage space;

[0065] Among them, if the storage environment data reaches the environmental alarm triggering condition, the control module issues an environmental alarm message.

[0066] Specifically, the environmental alarm triggering conditions are that the internal air temperature of the drug storage space is greater than the preset temperature, or the humidity is greater than or equal to the preset humidity, or the microbial bacteria content is greater than or equal to the preset microbial bacteria content.

[0067] Specifically, the microbial bacterial content refers to the number of microbial colonies per cubic meter of air.

[0068] Specifically, the drug storage space includes normal temperature warehouse, cold storage and cold storage, which correspond to preset normal temperature, preset cold temperature and preset cold storage temperature.

[0069] Specifically, the medicine storage space is a rectangular space with 13 temperature sensors installed in it, which are respectively set in the 8 corners of the medicine storage space and the centers of the 5 planes excluding the plane where the storage door is installed. The internal air temperature of the medicine storage space is the average value of the measurement values ​​of the 13 temperature sensors.

[0070] Specifically, the medicine storage space is a rectangular space with 6 humidity sensors installed in it. They are installed on the three side planes of the medicine storage space excluding the plane where the storage door is installed. Each plane is provided with two temperature sensors. The installation positions of the two sensors are evenly distributed on parallel lines 1.5m away from the bottom surface. The air humidity of the medicine storage space is the average value of the measurement values ​​of the 6 humidity sensors.

[0071] Specifically, the pharmaceutical storage space is a rectangular space in which 7 microorganism collectors are installed, and 6 microorganism collectors are installed on the three side planes of the pharmaceutical storage space excluding the plane where the storage door is installed. Two microorganism collectors are respectively provided on each plane. The installation positions of the two sensors are evenly distributed on parallel lines 1 m away from the bottom surface. One microorganism collector is installed 30 cm near the ventilation equipment in the pharmaceutical storage space. The air humidity of the pharmaceutical storage space is taken as the average value of the measurement values ​​of the 7 microorganism collectors.

[0072] In implementation, the preset normal temperature generally ranges from [28°C, 32°C], the preset cold temperature generally ranges from [18°C, 22°C], and the preset cold storage temperature generally ranges from [0°C, 8°C].

[0073] Preferably, the preferred embodiment of the preset normal temperature is 30°C, the preferred embodiment of the preset normal temperature is 20°C, and the preferred embodiment of the preset normal temperature is 4°C.

[0074] In practice, the preset humidity generally ranges from [45%, 75%].

[0075] Preferably, the preset humidity is 60%.

[0076] In practice, the preset microbial bacterial content is generally in the range of [160 cfu / m 3 , 200 cfu / m 3 ].

[0077] Preferably, the preset microbial bacterial content is 180 cfu / m 3 .

[0078] In practice, the system of the present invention monitors the drug storage environment in real time by setting up an environmental monitoring module. When the environmental parameters in the warehouse exceed the set range, the system can automatically trigger the alarm mechanism, thereby reducing drug losses or quality problems caused by environmental changes and providing more suitable environmental conditions for drug storage. By analyzing historical storage environment data, the changing trend of the environment in the warehouse can be obtained, providing a scientific basis for warehouse management. At the same time, these data can also be used for drug quality tracing and recall, further improving the efficiency and quality of drug storage management, and improving the safety and effectiveness of drugs.

[0079] In practice, many drugs need to be stored within a specific temperature range to maintain the stability and activity of their chemical components. Too high or too low a temperature may cause changes in the physical or chemical properties of the drug, thereby affecting its therapeutic effect. Relevant regulations and standards in the pharmaceutical industry have clear provisions on the storage temperature of drugs. By controlling the temperature, it can be ensured that the temperature in the warehouse meets regulatory requirements and avoid compliance issues caused by improper temperature.

[0080] In practice, excessive humidity may cause drugs to become damp and moldy, thus affecting their quality and safety. By controlling the humidity, it can be ensured that the humidity in the warehouse is within a reasonable range to prevent drugs from getting damp.

[0081] In practice, microbial contamination is a process during the production and storage of drugs that may increase the side effects of drugs or reduce the therapeutic effects, thus posing a threat to patient health. By monitoring and controlling the content of microbial bacteria in the air, the contamination of drugs by microorganisms can be effectively reduced, and drugs can be stored in a sterile and safe environment, thereby ensuring the safety of patients' use of drugs.

[0082] The system of the present invention controls the temperature, humidity and the content of microorganisms and bacteria in the air.

[0083] Specifically, the data acquisition module includes:

[0084] A QR code management unit, which is connected to the drug sorting robot and is used to collect drug QR code data corresponding to the drug QR code;

[0085] The storage unit is connected to the QR code management unit and is used to identify and store the drug QR code data and record the storage time and storage quantity to form a storage feature data set;

[0086] The outbound unit is connected to the QR code management unit and is used to combine the drug QR code data with the outbound time, outbound quantity and drug flow direction to form an outbound feature data set.

[0087] Specifically, drug information includes drug name, drug quantity, warehouse location code, supplier information and drug attributes. Supplier information includes place of origin, drug report, special drug qualifications, etc. Drug attributes include drug size, weight, volume, purchase price, expiration date, and temperature, humidity and other conditions that need to be met during storage.

[0088] Specifically, the basic data of stored drugs include drug information, storage time and storage quantity.

[0089] Specifically, the basic data of outbound drugs include drug information, outbound time, outbound quantity and drug flow direction.

[0090] During implementation, the system of the present invention ensures the accuracy of drug in-and-out warehouse information by setting up a data acquisition module and adopting two-dimensional code automatic recognition technology. It realizes real-time and accurate tracing of the entire process of drugs from storage to drug flow through data acquisition and storage management technology, thereby ensuring the authenticity and reliability of drug information. The two-dimensional code contains all the information required for the drug and each two-dimensional code is unique, thereby reducing duplication and omissions that occur when collecting drug information. Administrators can quickly locate problematic drugs through drug two-dimensional codes, thereby realizing drug quality control and risk management.

[0091] Specifically, the control module is connected to the drug sorting robot and the data acquisition module respectively, and is used to calculate the sorting error ratio according to the number of sorting errors of the sorted drugs in a unit time. When the sorting error ratio is greater than or equal to a preset second error ratio, it is determined that the accuracy of the system does not meet the requirements, and the buffer pool size is adjusted when the drugs are in and out of the warehouse respectively;

[0092] If the sorting error ratio is greater than the preset first error ratio and less than the preset second error ratio, the control module preliminarily determines that the real-time performance of the system does not meet the requirements.

[0093] Specifically, if the sorting error ratio during warehousing is greater than or equal to the preset second error ratio, the control module reduces the size of the buffer pool; if the sorting error ratio during outbound storage is greater than or equal to the preset second error ratio, the control module increases the size of the buffer pool.

[0094] Specifically, sorting errors include incorrect identification of drug types, incorrect identification of drug quantities, and incorrect operations during sorting that cause deformation of drug packaging.

[0095] Specifically, the formula for the sorting error ratio is:

[0096]

[0097] Among them, i is the sorting error ratio, i0 is the total number of sorted drugs per unit time, and i n The number of incorrectly sorted drugs per unit time.

[0098] In implementation, the preset first error ratio generally ranges from [0.028, 0.04], and the preset second error ratio generally ranges from [0.06, 0.08].

[0099] Specifically, the size of the buffer pool is a percentage of the occupied storage space.

[0100] Preferably, the preferred embodiment of the preset first error ratio is 0.03, and the preferred embodiment of the preset second error ratio is 0.07.

[0101] In implementation, for every time the difference between the sorting error ratio during warehousing and the preset second error ratio exceeds 0.01, the size of the buffer pool is reduced by 5%. For example, if the sorting error ratio during warehousing is 0.09 and the current buffer pool size is 60%, the buffer pool size is reduced to 50%. For every time the difference between the sorting error ratio during outbound delivery and the preset second error ratio exceeds 0.01, the size of the buffer is increased by 3%. For example, if the sorting error ratio during outbound delivery is 0.1 and the current buffer pool size is 70%, the buffer pool size is increased to 79%.

[0102] In practice, the system of the present invention improves the data processing speed and accuracy of the system by adjusting the buffer pool size when drugs are put in and out of the warehouse when the system accuracy does not meet the requirements, further reduces the false positive and false negative rate when the system processes data, and improves the accuracy of the system.

[0103] Specifically, the control module is connected to the data update module to calculate the average update time of the drug database based on the update time of several times after the drugs are shipped out of the warehouse, and to determine for the second time that the real-time performance of the system does not meet the requirements when the average update time is greater than the preset update time, and to reduce the isolation level of the drug database.

[0104] Specifically, the formula for average update time is:

[0105]

[0106] Among them, S is the average update time, s i is the duration of the ith update of the drug database after the drug is shipped out of the warehouse, n is the number of times the drug is shipped out of the warehouse, and n is a natural number greater than 1.

[0107] Specifically, the data isolation level refers to a set of rules that must be followed when multiple transactions are executed in a concurrent system to access and modify system data, in order to ensure data consistency and integrity.

[0108] Specifically, the data isolation level can be adjusted through SQL statements or database configuration files.

[0109] Specifically, the system data isolation level is set to level 4.

[0110] In practice, the preset update duration generally ranges from [400ms, 800ms].

[0111] Preferably, the preferred embodiment of the preset update duration is 600ms.

[0112] In implementation, for every 200ms the difference between the average update time and the preset update time exceeds, the data isolation level is reduced by one level from the highest level. For example, when the average update time is 1000ms, the data isolation level is reduced to level 2.

[0113] In implementation, the system of the present invention reduces the isolation level of the drug database when the system real-time performance does not meet the requirements, thereby preventing the sorting robot from processing in a timely manner and mixing processing information due to data lock contention when receiving a large number of processing instructions, reducing the workload of the sorting robot in processing information, optimizing the information processing operation and thus reducing the processing time, and further improving the real-time performance of the system.

[0114] Specifically, the control module is connected to the data acquisition module and the data update module to obtain the drug inventory quantity. If the drug inventory quantity is lower than the preset inventory value, the control module will issue an inventory warning signal and set a pop-up window reminder.

[0115] Among them, the inventory preset value is determined based on the inventory turnover rate of the drug, the drug price and the drug supplier information.

[0116] In practice, the system of the present invention reduces production stagnation and order delays caused by insufficient inventory by issuing an early warning when the drug inventory quantity is too low, reminding management personnel to replenish the stock, thereby analyzing key indicators such as inventory turnover and order processing frequency, thereby optimizing inventory management and reducing inventory costs.

[0117] Specifically, the control module is connected to the data acquisition module, the drug database and the data update module respectively to obtain the drug expiration time. If the drug expiration time is less than or equal to the first expiration preset value and greater than the second expiration preset value, the control module classifies the expiring drugs to form a primary expiring drug database.

[0118] If the drug expiration time is less than or equal to the preset second drug preset value and greater than the third drug expiration preset value, the control module performs secondary classification on the expiring drugs to form a secondary expiring drug database.

[0119] If the drug's expiration time is less than or equal to the third expiration preset value, the control module classifies the expiring drugs three times to form an expired drug database and issues a pop-up reminder.

[0120] Among them, the drug expiration date is the difference between the current date of the drug and the drug’s expiration date.

[0121] Specifically, the formula for the duration of drug expiration is:

[0122] T=t i -t0

[0123] Among them, T is the duration of drug expiration, t i is the expiration date of the drug, and t0 is the date of the drug today.

[0124] In implementation, the general range of values ​​for the preset first near-expiry preset value is [300 days, 400 days], and the general range of values ​​for the preset second near-expiry preset value is [160 days, 200 days].

[0125] Preferably, the preset first near-due preset value is 360 days, the preset second near-due preset value is 180 days, and the preset third near-due preset value is 0 day.

[0126] In implementation, the system of the present invention reclassifies expiring drugs and divides them into three levels according to the length of time to expiration, so as to simply and clearly display the types and quantities of expiring drugs, reduce the misjudgment of inventory quantity due to the accumulation of expiring drugs, and reduce the occurrence of losses due to expiration. At the same time, the system can ensure that the drugs are used within the validity period, ensure the safety of patients' medication, and avoid expired drugs from entering the market; the three-level classification standard for expiring drugs helps to reasonably arrange the distribution sequence according to the shelf life of the drugs, and ensure that the drugs are delivered within the validity period; in addition, by analyzing the data on the length of time to expiration of expiring drugs, the inventory, drug flow and other conditions of expiring drugs can be collected and analyzed, providing data support for decisions such as warehouse procurement and inventory allocation, thereby realizing the optimization of inventory management strategies.

[0127] So far, the technical solutions of the present invention have been described in conjunction with the preferred embodiments shown in the accompanying drawings. However, it is easy for those skilled in the art to understand that the protection scope of the present invention is obviously not limited to these specific embodiments. Without departing from the principle of the present invention, those skilled in the art can make equivalent changes or substitutions to the relevant technical features, and the technical solutions after these changes or substitutions will fall within the protection scope of the present invention.

Claims

1. A drug storage automation management system, characterized in that: include: Medicine sorting robots, used to sort and transport medicines; A data acquisition module connected to the drug sorting robot for collecting storage characteristic data of the drug, wherein the storage characteristic data includes a storage characteristic data set, a storage characteristic data set, and drug QR code data, and the data acquisition module further includes a buffer pool; A medicine database, which is connected to the data acquisition module and is used to classify and store the storage characteristic data; A data updating module, which is connected to the data acquisition module and is used to update the inventory turnover rate, drug inventory information, drug flow direction and drug expiration date of the drug database in real time; A control module, which is respectively connected to the drug sorting robot, the data acquisition module, the data update module and the drug database; When the control module is connected to the drug sorting robot and the data acquisition module respectively, the control module is used to calculate the sorting error ratio according to the number of sorting errors of sorted drugs per unit time; When the sorting error ratio is greater than or equal to the preset second error ratio, it is determined that the accuracy of the system does not meet the requirements, and the size of the buffer pool when the medicine is in and out of the warehouse is adjusted respectively; wherein, if the sorting error ratio when entering the warehouse is greater than or equal to the preset second error ratio, the control module reduces the size of the buffer pool; if the sorting error ratio when leaving the warehouse is greater than or equal to the preset second error ratio, the control module increases the size of the buffer pool; the size of the buffer pool is a percentage of the occupied storage space; If the sorting error ratio is greater than a preset first error ratio and less than a preset second error ratio, the control module preliminarily determines that the real-time performance of the system does not meet the requirements; When the control module is connected to the data update module, the control module is used to calculate the average update time according to the update time of the drug database after several drugs are shipped out of the warehouse, and when the average update time is greater than the preset update time, it is determined for the second time that the real-time performance of the system does not meet the requirements, and the isolation level of the drug database is reduced.

2. The drug storage automation management system according to claim 1 is characterized in that: It also includes an environmental monitoring module connected to the control module for collecting the temperature, humidity, and microbial bacteria content in the air of the drug storage environment to form storage environment data, which includes: Temperature sensor, used to collect the internal air temperature of the drug storage space; Humidity sensor, used to collect air humidity in the drug storage space; Microbial collector, used to collect the content of microorganisms and bacteria in the air of the drug storage space; If the storage environment data reaches an environmental alarm triggering condition, the control module issues an environmental alarm message.

3. The drug storage automation management system according to claim 2 is characterized in that: The environmental alarm triggering condition is that the internal air temperature of the drug storage space is greater than a preset temperature, or the humidity is greater than or equal to a preset humidity, or the microbial bacteria content is greater than or equal to a preset microbial bacteria content.

4. The drug storage automation management system according to claim 1, characterized in that: The data acquisition module comprises: A two-dimensional code management unit, which is connected to the drug sorting robot and is used to collect the drug two-dimensional code data corresponding to the drug two-dimensional code; A storage unit, which is connected to the two-dimensional code management unit, is used to identify the two-dimensional code data of the medicine, store it in the warehouse, and record the storage time and storage quantity to form the storage feature data set; The outbound unit is connected to the two-dimensional code management unit and is used to combine the drug two-dimensional code data, outbound time, outbound quantity and drug flow direction to form the outbound feature data set.

5. The drug storage automation management system according to claim 1, characterized in that: When the control module is connected to the data acquisition module and the data update module respectively, the control module is used to obtain the drug inventory quantity. If the drug inventory quantity is lower than the inventory preset value, the control module sends an inventory warning signal and sets a pop-up reminder, wherein the inventory preset value is determined based on the drug inventory turnover rate, drug price and drug supplier information.

6. The drug storage automation management system according to claim 1, characterized in that: Also includes, When the control module is connected to the data acquisition module, the drug database and the data update module respectively, the control module is used to obtain the drug expiration time; If the drug expiration time is less than or equal to the first expiration preset value and greater than the second expiration preset value, the control module classifies the expiring drugs once to form a primary expiring drug database; If the drug expiration time is less than or equal to the preset second drug value and greater than the third preset expiration time, the control module performs secondary classification on the expiring drug to form a secondary expiring drug database; If the drug is about to expire, the control module classifies the drug three times to form an expired drug database and issues a pop-up reminder; Among them, the drug expiration date is the difference between the current date of the drug and the expiration date of the drug.

7. The drug storage automation management system according to claim 6, characterized in that: The formula for the duration of the drug's expiration date is: T=ti-t0 Wherein, T is the expiration date of the drug, ti is the validity date of the drug, and t0 is the current date of the drug.

Images