Automatic management system for medicine storage
By combining drug sorting robots and data modules, efficient, accurate, and real-time drug management has been achieved in the drug warehouse management system. This solves the problems of insufficient accuracy and real-time performance in existing technologies, optimizes inventory and environmental monitoring, and ensures the safety and efficacy of drugs.
Patent Information
- Application Number
- CN202410972933.0
- Authority / Receiving Office
- CN · China
- Patent Type
- Applications(China)
- Current Assignee / Owner
- Filing Date
- 2024-07-19
- Publication Date
- 2024-11-08
- Estimated Expiration
- 2044-07-19
AI Technical Summary
The accuracy and real-time performance of existing automated drug storage management systems are not high, resulting in insufficient precision and timeliness in drug management.
The system employs a drug sorting robot, a data acquisition module, a data update module, and a control module, combined with an environmental monitoring module. It uses computer vision and deep learning technologies to identify drugs, update inventory information in real time, monitor the storage environment, and make adjustments when the system's accuracy and real-time performance do not meet requirements.
It improves the efficiency and accuracy of drug sorting, reduces error rates and information lag, optimizes inventory management, ensures drug safety and efficacy, and provides scientific environmental monitoring and decision support.
Smart Images

Figure CN118917775A_ABST
Abstract
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] Among existing technologies, the global pharmacy automation equipment market has continued to grow in the past few years and is expected to reach a significant market size by 2025. 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 technologies 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, a warehouse-out management module, a warehouse-in 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 warehouse-in management module is used for warehouse-in operation, storage location management, warehouse-in query and warehouse-in return management; the warehouse-out management module is used for manual warehouse-out operation, warehouse-out query and warehouse-out return management; the inventory management module is used for the management of inventory query, inventory alarm and inventory transfer function; the statistical information analysis module is used for employee information The system management module is used for the management of system administrators, administrator passwords, 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 operation 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;Its inbound and outbound management module is mainly used for the inbound and outbound information management of drugs, among which 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 adding new drugs into the warehouse and out-of-stock drugs into the warehouse. The inbound operation of new drugs is to find a storage location suitable for the drugs according to their external dimensions, and at the same time, the storage location is the closest to the inbound and outbound ports. The inbound operation of out-of-stock drugs is to find a storage location suitable for the drugs according to the inbound drugs. When there are multiple storage locations occupied by the inbound drugs, it is necessary to select the most suitable storage location for them based on the principle of batch number proximity. When there are still multiple storage locations to choose from under the premise of batch number proximity, it is necessary to select the most suitable storage location for them based on the principle of the closest distance to the inbound and outbound ports. The storage location management is to manage the status and storage location information of the storage locations, among which the storage location status is the same as the storage location information. There are three types of states, namely, idle, occupied and faulty for repair. The functions mainly include operations of querying and modifying information. Storage location information includes the length, width, height and storage location coordinates of the storage location. It stores information such as drug name, drug code and storage location number. The functions mainly include query, modification, addition and deletion. Storage location information is the information basis for inbound and outbound operations. Inbound query includes query according to the inbound time, inbound order number, drug name, drug code and other information. It also supports fuzzy and multi-condition query. Inbound return means that the inbound drugs need to be returned for some reason. In this case, the drugs are withdrawn from the pharmacy through the inbound return operation, and the relevant information of the drugs 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 based on HI The prescription information transmitted by the S system selects the storage location of the outgoing drugs according to the principle of drug batch number priority, and arranges all the storage locations of the outgoing drugs according to the principle of the shortest sum of the distances of all drug storage locations. Finally, the outgoing information is generated and transmitted to the control system to execute the drug outgoing operation. The manual outgoing operation is used for emergency response when the automatic drug dispensing system fails. At the same time, the manual outgoing operation can also be used for other drugs that are not in the automatic drug dispensing system. The outgoing query and outgoing return operation functions are exactly the same as the warehousing operation. The outgoing module also includes a data interface module, which is the information transmission with the hospital HIS system. The hospital HIS system transmits the prescription information and drug information to the management system, and the management system transmits the drug inventory update and prescription completion status to the HIS system to ensure the synchronization of the hospital's 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 functions such as printing and storage. 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 certain period of time, and finally form an analysis report to provide decision-making support services for the pharmacy department and hospital leaders in selecting drug types, suppliers, and the number of drugs to be purchased. Its 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 respectively. Different operators log in to the management system and use different management functions. It can be seen that the system accuracy and real-time performance of the pharmacy drug storage information management system are not high. ; Summary of the invention
[0004] To this end, the present invention provides a drug storage automation management system to overcome the problems 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 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;
[0008] A medicine database, which is connected to the data acquisition module and is used to classify and store the storage characteristic data;
[0009] 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;
[0010] A 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 not to meet the requirements 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 drug storage space;
[0016] If the storage environment data reaches an 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 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;
[0020] A storage unit, which is connected to the two-dimensional code management unit, is used to identify and store the two-dimensional code data of the medicine and record the storage time and storage quantity to form the storage feature data set;
[0021] The outbound unit is connected to the two-dimensional code management unit and is used to combine the drug two-dimensional code data with the outbound time, outbound quantity and drug flow direction to form the 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 within 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 when the drugs are in and out of the warehouse is adjusted respectively;
[0023] 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.
[0024] Furthermore, 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.
[0025] Furthermore, the control module is connected to the data update module to calculate the average update time according to the update time of the drug data set after several drug shipments, 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] 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 once to form a primary expiring drug database.
[0029] 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.
[0030] If the drug is about to expire, the control module will classify the drug three times to form an expired drug database and issue a pop-up window reminder.
[0031] Among them, the drug expiration date is the difference between the current date of the drug and the expiration date of the drug.
[0032] Furthermore, the formula for the duration of the drug's expiration date is:
[0033] T=t i -t0
[0034] Where T is the duration of the drug's expiration date, 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 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.
[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 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, and 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 merely 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 cannot 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 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;
[0053] A medicine database, which is connected to the data acquisition module and is used to classify and store the storage characteristic data;
[0054] 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;
[0055] A 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 not to meet the requirements 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 drugs, 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 drugs. 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 drug storage space;
[0065] If the storage environment data reaches an environmental alarm triggering condition, the control module issues an environmental alarm message.
[0066] Specifically, 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.
[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 / m3, 200 cfu / m3].
[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 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 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;
[0085] A storage unit, which is connected to the two-dimensional code management unit, is used to identify and store the two-dimensional code data of the medicine and record the storage time and storage quantity to form the storage feature data set;
[0086] The outbound unit is connected to the two-dimensional code management unit and is used to combine the drug two-dimensional code data with the outbound time, outbound quantity and drug flow direction to form the 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 sorted drugs within 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 of the drugs when entering and leaving the warehouse is adjusted respectively;
[0092] 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.
[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 implementation, 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 according to the update time of the drug data set after several drug shipments, 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 i-th update time of the drug dataset after the drug is shipped out, n is the number of times the drug is shipped out, 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 practice, 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 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.
[0115] 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 once to form a primary expiring drug database.
[0118] 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.
[0119] If the drug is about to expire, the control module will classify the drug three times to form an expired drug database and issue a pop-up window reminder.
[0120] Among them, the drug expiration date is the difference between the current date of the drug and the expiration date of the drug.
[0121] Specifically, the formula for the duration of the drug's expiration date is:
[0122] T=t i -t0
[0123] Where T is the duration of the drug's expiration date, 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 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 not to meet the requirements 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, 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.
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 and store the two-dimensional code data of the medicine 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 with the 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: 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 per unit time, and 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 when the drugs are in and out of the warehouse is adjusted respectively; 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.
6. The drug storage automation management system according to claim 5, characterized in that: 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.
7. The drug storage automation management system according to claim 6, characterized in that: The control module is connected to the data update module, and is used to calculate the average update time according to the update time of the drug data set after several drug shipments, 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.
8. The drug storage automation management system according to claim 1, characterized in that: The control module is respectively 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 inventory preset value, the control module sends an inventory warning signal and sets a pop-up window reminder. The inventory preset value is determined based on the inventory turnover rate of the drug, the drug price and the drug supplier information.
9. The drug storage automation management system according to claim 1, characterized in that: 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 expiration drugs once to form a primary expiration 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 and the duration is less than or equal to the third preset value, the control module classifies the drug three times to form an expired drug database and issues a pop-up window reminder. Among them, the drug expiration date is the difference between the current date of the drug and the expiration date of the drug.
10. The drug storage automation management system according to claim 9, characterized in that: The formula for the drug's expiration date is: T=t i -t0 Where T is the duration of the drug's expiration date, t i is the expiration date of the drug, and t0 is the current date of the drug.
Citation Information
Patent Citations
Method for updating status information of data stream, system and equipment thereof
CN101945045A
Warehouse-out method, warehouse-out end and warehousing system
CN113496364A
Automatic warehouse entering and exiting material control method
CN117533686A
Rapid positioning and sorting method for medicines
CN117654918A
Intelligent warehousing operation and maintenance method and system
CN117670198A
