Intelligent medicine warehouse management system and method based on big data
Through big data analysis and Internet of Things technology, drug storage location allocation and replenishment management are optimized, and the problems of inaccurate position management and untimely replenishment in drug storage management are solved, and drug management efficiency and inventory stability are improved.
Patent Information
- Application Number
- CN202411573798.9
- Authority / Receiving Office
- CN · China
- Patent Type
- Applications(China)
- Current Assignee / Owner
- Filing Date
- 2024-11-06
- Publication Date
- 2024-12-03
- Estimated Expiration
- 2044-11-06
AI Technical Summary
The existing drug storage management system has problems such as inaccurate location management and untimely replenishment of drugs during the drug entry and exit process, which leads to confusion in management and inventory pressure, increasing the risk of drug expiration.
Adopt a smart drug warehousing management system based on big data, including in-store grouping module, big data module, management terminal module, drug acquisition planning module and automatic replenishment module. By calculating the probability and correlation of drug use, drug demand is predicted. Optimize the allocation of drug storage locations, plan the walking routes of drug managers, and automatically judge the replenishment needs based on inventory forecasts.
It realizes automated management of drug inlet and outflow, reduces manual operations, improves work efficiency, reduces warehousing management costs, and ensures the continuity and stability of drug supply.
Smart Images

Figure CN119067571A_ABST
Abstract
Description
Technical Field
[0001] The present invention relates to the field of drug storage management, and in particular to a smart drug storage management system and method based on big data. Background Art
[0002] Pharmaceutical warehousing refers to the process and system for storing, managing and distributing drugs, including drug storage, inventory management, drug distribution and warehouse renewal. A mature pharmaceutical warehousing system uses advanced technology and systems to manage the storage and distribution of drugs, which can improve the efficiency, safety and traceability of drug management.
[0003] For the convenience of management, pharmacies usually put the same type or similar name drugs on the same shelf, but this storage method requires storage addressing, which lengthens the drug outbound process and increases the risk of drug misconfiguration. The existing auxiliary management program focuses on recording the location of drugs and cannot accurately guide drug management personnel in and out of the warehouse, which may cause management confusion.
[0004] In addition, when the drug inventory is insufficient, the pharmacy needs to replenish the stock from the drug manufacturer, but it takes a certain amount of logistics time from issuing a replenishment request to the drug entering the warehouse. The logistics time also varies for different drugs. Too little replenishment will result in insufficient drugs being shipped out of the warehouse within a certain period of time, while excessive replenishment will increase storage pressure and the risk of drug expiration. Summary of the invention
[0005] The purpose of the present invention is to provide a smart drug warehouse management system and method based on big data to solve the problems raised in the above background technology.
[0006] In order to solve the above technical problems, the present invention provides the following technical solutions: a smart drug warehouse management system based on big data, comprising: a storage grouping module, a big data module, a management terminal module, a drug collection planning module and an automatic replenishment module; The entry grouping module is used to group and number the drug storage shelves according to the distance between the shelves and the drug dispensing window, record the shelf location and drug information of the drugs when the drugs are in and out of the warehouse, provide guidance for the drug entry process, and send signals when the shelves are empty or full; The big data module is used to calculate the probability of drug use and the correlation between drugs based on historical data and drug information in the database, and link the pharmacy database with the medical registration database, predict the type and amount of drug use based on the diagnosis information of medical registration personnel, the probability of drug use and the correlation between drugs, generate a predicted delivery order, and allocate the storage location of the drugs according to the predicted delivery order; The management terminal module is used to set up a terminal device at the drug management personnel, track the terminal device of the drug management personnel through the Internet of Things system, bind the drug configuration list with the terminal device, and obtain the personnel location information through the positioning function in the terminal device after receiving the drug outbound list; The medicine collection planning module is used to plan the walking route of the medicine management personnel according to the personnel positioning and the medicine outbound list, the walking distance, the medicine inventory and the misuse rate of the medicines on the same shelf, so as to make the route outbound distance the shortest, and generate medicine collection reminder information according to the medicines stored on the shelf when the personnel collect the medicines, and enter the verification information when the medicines are outbound; The automatic replenishment module is used to generate an expected inventory function of the storage quantity and time of each drug according to the probability of drug use and the current inventory, and determine the alarm threshold by the average drug use quantity, drug information, replenishment logistics time and a preset coefficient. When the expected inventory function of the drug is lower than the threshold, the replenishment drug type and replenishment quantity are automatically determined to ensure that the expected inventory function of the drug in the next cycle is not lower than the threshold, and a replenishment notification is generated on the terminal device.
[0007] Further, the warehousing grouping module includes: a shelf classification unit and a warehouse entry unit; The shelf classification unit is used to construct a distribution model of shelves in the warehouse and number the shelves according to the distance between the shelves and the medicine dispensing port; The storage input unit is used to receive the information of incoming medicines, guide the medicines into the warehouse, and record the information of medicines on the shelves. The historical outbound information includes: the amount of each medicine taken, the number of times it is taken, and the overlap rate of taking.
[0008] Further, the big data module includes: a database unit, an access analysis unit and a storage allocation unit; The database unit is used to store the location information of the drugs on the shelf, and the historical drug in-and-out information; The use analysis unit is used to analyze historical data to determine the probability of drug use and the probability of associated drug use, wherein the historical data includes: historical prescriptions, drug storage records and registration records; The storage allocation unit is used to allocate the drugs to be stored to different shelves according to the analysis results of the drugs, and record the allocation results.
[0009] Further, the management terminal module includes: a warehouse management unit and a mobile positioning unit; The storage management unit is used to construct human-computer interaction software in the mobile terminal to display the storage location of the medicine and provide route guidance; The mobile positioning unit is used to bind the drug management personnel to the mobile terminal, determine the location of the drug management personnel in real time, and feed back the location to the cloud.
[0010] Furthermore, the medicine collection planning module includes: an order checking unit and a path guiding unit; The order checking unit is used to receive drug delivery requirements, digitize drug numbers and withdrawal measurements, and search in a database; The path guidance unit is used to plan the walking route of the drug management personnel according to the location of the required drugs on the shelf, so as to shorten the total outbound distance, and display the guidance route in the terminal device.
[0011] Further, the automatic replenishment module includes: an inventory prediction unit, a floating standard unit and a replenishment notification unit; The inventory prediction unit is used to predict the future inventory of each drug based on the diagnosis information and historical records of medical registration personnel in the current period, and generate an expected inventory function of the drug storage quantity and time; The floating standard unit is used to calculate the alarm threshold according to the average amount of medicine taken in the current cycle, medicine information, replenishment logistics time and preset coefficient; The replenishment notification unit is used to generate a drug replenishment notification when the expected inventory function of the drug is lower than a threshold value, and record the drug name and replenishment quantity in the replenishment notification.
[0012] A smart drug storage management method based on big data, comprising the following steps: Step S1. Number the shelves in ascending order according to the distance between the shelves and the shipping port, and generate a warehouse entry list according to the type and quantity of the drugs to be warehoused; Step S2. Calculate the probability distribution function of the single drug usage amount according to the distribution fitting method based on the historical outbound information, take the usage amount when the probability distribution function is the maximum as the first usage amount, multiply the first usage amount by the usage overlap rate of other drugs, and obtain the second usage amount; Step S3. Combine each first amount of medicine and its related medicines into a storage unit, use the medicine usage ratio as the weight, split the storage list according to the storage allocation method, and store the medicines to be stored in order, and store them in order according to the shelf numbers when entering the warehouse; Step S4. Bind the drug management personnel to the mobile terminal device, obtain the management personnel's location in real time, and plan the drug collection route for the management personnel according to the recorded drug storage location when executing the outbound list, so that the outbound distance of the drug collection is the shortest, and generate reminder information; Step S5. Based on the number of drugs shipped out during the period, the future inventory of each drug is predicted, and an expected inventory function of the drug's storage quantity and time is generated. When the integral of the expected inventory function within the drug logistics time is lower than the threshold, a reminder is issued to replenish the stock.
[0013] Further, step S1 includes: Step S11. Construct a distribution model of shelves in the warehouse, and number the shelves in ascending order according to the distance between the shelves and the shipping port. The numbering results are recorded as {W1, W2, ..., Wn}, where n is the number of shelves in the warehouse and Wn is the number of the nth shelf; Step S12: Before the drugs are put into storage, the names and quantities of all drugs to be put into storage are entered, and a storage list is generated and stored in the database.
[0014] Further, step S2 includes: Step S21. Obtain historical outbound information from the warehouse management database, the historical outbound information including: the amount of each drug taken, the number of times taken, and the overlap rate of taking, the overlap rate of taking represents the probability of different drugs being taken out of the warehouse at the same time; Step S22. Calculate the probability distribution function of the single dose of the drug according to a distribution fitting method, wherein the distribution fitting method is as follows: ; Where F(x) is the probability distribution function of the single drug usage, x is the single drug usage, σ is the standard deviation of the drug usage, N is the current number of drug usage in the historical records, μ is the mean of the drug usage, and xi is the drug usage at the i-th time. Step S23. Calculate the maximum value of the function F(x), the single drug dosage corresponding to the maximum value is recorded as the first dosage, and calculate the second dosage according to the following method: ; Where IX1 and IX2 represent the first and second dosages of the drug, respectively. i represents the overlap rate between the current drug and the i-th other drug, and m represents the number of drug types.
[0015] Further, step S3 includes: Step S31. The first amount of current medicine and the second amount of other medicines form a storage unit, where i∈{1, 2, ..., m-1); Step S32: Split the incoming inventory list according to the incoming inventory allocation method, the incoming inventory allocation method is as follows: Step S32-1. Calculate the distribution weight of each drug: ; Among them, Q represents the weight of the drug, P represents the remaining number of drugs in the inventory list, N is the number of times the current drug is taken in the historical record, NE is the total number of times all drugs are taken in the historical record, NV represents the number of times the current drug is put into the warehouse, the initial value is 0, P i Represents the remaining quantity of the i-th drug in the inventory list; Step S32-2. The storage unit corresponding to the drug with the highest allocation weight is put into storage. When entering the storage, it is stored in ascending order according to the shelf number, and the number of drug entry times NV is increased by 1, and the type of the drug entering the storage is recorded; If there are drugs to be distributed that can be combined into storage units in the inventory list, go to step S32-1, otherwise go to step S32-3; Step S32-3. The remaining drugs in the inventory are stored as a storage unit to complete the drug distribution; Step S33. Record the shelf number of each storage unit in the database. When the medicine is shipped out, it is allowed to call the medicine between different storage units.
[0016] Further, step S4 includes: Step S41. A mobile terminal device is set at the drug management personnel. When the mobile terminal device receives a demand for drug delivery, the drug management personnel is located. Step S42. Detect the number of remaining drugs on the shelf, and plan a walking route for the drug manager with the current location as the starting point and the delivery port as the end point, so that the drugs on the shelves along the walking route can meet the drug delivery demand. If there is no such path, an alarm of insufficient inventory is issued; Step S43. The drug management personnel walk along the planned route. When passing by the shelves where the outbound drugs are stored, a prompt is given on the mobile terminal device, displaying the type, quantity and precautions of the drugs to be taken.
[0017] Further, step S5 includes: Step S51. Preset the detection cycle T, obtain the outbound quantity U of each drug according to the outbound record of the drug T time before the current moment, calculate the outbound speed V, V=U / T, and use the function fitting tool to obtain the outbound speed function g(t) of the drug according to the outbound speed in the previous cycle, and generate the expected function of drug inventory G(t)=G0-g(t)·t, where t represents time; Step S52. Obtain the average logistics time TA of the medicine, calculate the definite integral of the inventory expectation function in the integral limit [0,TA], and when the definite integral value is less than the preset threshold, remind the warehouse to replenish the stock.
[0018] Compared with the prior art, the beneficial effects achieved by the present invention are: 1. The present invention can calculate the probability and relevance of drug use by dosage according to historical prescriptions, drug delivery records and current registration information, calculate the optimal distance according to the relevance of drug use and misuse rate, allocate storage locations for drugs, and realize automatic warehousing management of drugs, which can reduce manual operations and time, complete the drug warehousing process more quickly, save time costs, and improve work efficiency.
[0019] 2. The present invention can track the terminal devices of drug management personnel through the Internet of Things system, bind the drug configuration list to the terminal device, and plan the walking routes of personnel according to the distribution of drugs on the shelves, which can reduce the overall drug storage management cost, reduce the workload of outbound personnel, and increase the efficiency of drug circulation.
[0020] 3. The present invention can generate an expected function of the inventory of each drug in the future cycle based on the probability of drug use and drug inventory. When the expected function of the drug inventory is lower than a threshold, it automatically determines the type of drug to be replenished and generates a replenishment document. Drugs can be replenished in time according to sales data and inventory conditions to ensure the continuity and stability of drug supply. BRIEF DESCRIPTION OF THE DRAWINGS
[0021] The accompanying drawings are used to provide a further understanding of the present invention and constitute a part of the specification. Together with the embodiments of the present invention, they are used to explain the present invention and do not constitute a limitation of the present invention. In the accompanying drawings: Figure 1 It is a structural schematic diagram of a smart drug storage management system based on big data of the present invention; Figure 2 It is a schematic diagram of the steps of a smart drug warehouse management method based on big data of the present invention. DETAILED DESCRIPTION
[0022] The following will be combined with the drawings in the embodiments of the present invention to clearly and completely describe the technical solutions in the embodiments of the present invention. Obviously, the described embodiments are only part of the embodiments of the present invention, not all of the embodiments. Based on the embodiments of the present invention, all other embodiments obtained by ordinary technicians in this field without creative work are within the scope of protection of the present invention.
[0023] See also Figure 1 ,The present invention provides a technical solution: a smart drug warehouse management system based on big data, including: a storage grouping module, a big data module, a management terminal module, a drug collection planning module and an automatic replenishment module; The entry grouping module is used to group and number the drug storage shelves according to the distance between the shelves and the drug dispensing window, record the shelf location and drug information of the drugs when the drugs are in and out of the warehouse, provide guidance for the drug entry process, and send signals when the shelves are empty or full; The warehousing grouping module includes: a shelf classification unit and a warehouse entry unit; The shelf classification unit is used to construct a distribution model of shelves in the warehouse and number the shelves according to the distance between the shelves and the medicine dispensing port; The storage input unit is used to receive the information of incoming medicines, guide the medicines into the warehouse, and record the information of medicines on the shelves. The historical outbound information includes: the amount of each medicine taken, the number of times it is taken, and the overlap rate of taking.
[0024] The big data module is used to calculate the probability of drug use and the correlation between drugs based on historical data and drug information in the database, and link the pharmacy database with the medical registration database, predict the type and amount of drug use based on the diagnosis information of medical registration personnel, the probability of drug use and the correlation between drugs, generate a predicted delivery order, and allocate the storage location of the drugs according to the predicted delivery order; The big data module includes: a database unit, an access analysis unit and a storage allocation unit; The database unit is used to store the location information of the drugs on the shelf, and the historical drug in-and-out information; The use analysis unit is used to analyze historical data to determine the probability of drug use and the probability of associated drug use, wherein the historical data includes: historical prescriptions, drug storage records and registration records; The storage allocation unit is used to allocate the drugs to be stored to different shelves according to the analysis results of the drugs, and record the allocation results.
[0025] The management terminal module is used to set up a terminal device at the drug management personnel, track the terminal device of the drug management personnel through the Internet of Things system, bind the drug configuration list with the terminal device, and obtain the personnel location information through the positioning function in the terminal device after receiving the drug outbound list; The management terminal module includes: a warehouse management unit and a mobile positioning unit; The storage management unit is used to construct human-computer interaction software in the mobile terminal to display the storage location of the medicine and provide route guidance; The mobile positioning unit is used to bind the drug management personnel to the mobile terminal, determine the location of the drug management personnel in real time, and feed back the location to the cloud.
[0026] The medicine collection planning module is used to plan the walking route of the medicine management personnel according to the personnel positioning and the medicine outbound list, the walking distance, the medicine inventory and the misuse rate of the medicines on the same shelf, so as to make the route outbound distance the shortest, and generate medicine collection reminder information according to the medicines stored on the shelf when the personnel collect the medicines, and enter the verification information when the medicines are outbound; The medicine collection planning module includes: an order checking unit and a path guiding unit; The order checking unit is used to receive drug delivery requirements, digitize drug numbers and withdrawal measurements, and search in a database; The path guidance unit is used to plan the walking route of the drug management personnel according to the location of the required drugs on the shelf, so as to shorten the total outbound distance, and display the guidance route in the terminal device.
[0027] The automatic replenishment module is used to generate an expected inventory function of the storage quantity and time of each drug according to the probability of drug use and the current inventory, and determine the alarm threshold by the average drug use quantity, drug information, replenishment logistics time and a preset coefficient. When the expected inventory function of the drug is lower than the threshold, the replenishment drug type and replenishment quantity are automatically determined to ensure that the expected inventory function of the drug in the next cycle is not lower than the threshold, and a replenishment notification is generated on the terminal device.
[0028] The automatic replenishment module includes: a stock prediction unit, a floating standard unit and a replenishment notification unit; The inventory prediction unit is used to predict the future inventory of each drug based on the diagnosis information and historical records of medical registration personnel in the current period, and generate an expected inventory function of the drug storage quantity and time; The floating standard unit is used to calculate the alarm threshold according to the average amount of medicine taken in the current cycle, medicine information, replenishment logistics time and preset coefficient; The replenishment notification unit is used to generate a drug replenishment notification when the expected inventory function of the drug is lower than a threshold value, and record the drug name and replenishment quantity in the replenishment notification.
[0029] like Figure 2 As shown, a smart drug warehouse management method based on big data includes the following steps: Step S1. Number the shelves in ascending order according to the distance between the shelves and the shipping port, and generate a warehouse entry list according to the type and quantity of the drugs to be warehoused; Step S1 includes: Step S11. Construct a distribution model of shelves in the warehouse, and number the shelves in ascending order according to the distance between the shelves and the shipping port. The numbering results are recorded as {W1, W2, ..., Wn}, where n is the number of shelves in the warehouse and Wn is the number of the nth shelf; Step S12: Before the drugs are put into storage, the names and quantities of all drugs to be put into storage are entered, and a storage list is generated and stored in the database.
[0030] Step S2. Calculate the probability distribution function of the single drug usage amount according to the distribution fitting method based on the historical outbound information, take the usage amount when the probability distribution function is the maximum as the first usage amount, multiply the first usage amount by the usage overlap rate of other drugs, and obtain the second usage amount; Step S2 includes: Step S21. Obtain historical outbound information from the warehouse management database, the historical outbound information including: the amount of each drug taken, the number of times taken, and the overlap rate of taking, the overlap rate of taking represents the probability of different drugs being taken out of the warehouse at the same time; Step S22. Calculate the probability distribution function of the single dose of the drug according to a distribution fitting method, wherein the distribution fitting method is as follows: ; Where F(x) is the probability distribution function of the single drug usage, x is the single drug usage, σ is the standard deviation of the drug usage, N is the current number of drug usage in the historical records, μ is the mean of the drug usage, and xi is the drug usage at the i-th time. Step S23. Calculate the maximum value of the function F(x), the single drug dosage corresponding to the maximum value is recorded as the first dosage, and calculate the second dosage according to the following method: ; Where IX1 and IX2 represent the first and second dosages of the drug, respectively. i represents the overlap rate between the current drug and the i-th other drug, and m represents the number of drug types.
[0031] Step S3. Combine each first amount of medicine and its related medicines into a storage unit, use the medicine usage ratio as the weight, split the storage list according to the storage allocation method, and store the medicines to be stored in order, and store them in order according to the shelf numbers when entering the warehouse; Step S3 includes: Step S31. The first amount of current medicine and the second amount of other medicines form a storage unit, where i∈{1, 2, ..., m-1); Step S32: Split the incoming inventory list according to the incoming inventory allocation method, the incoming inventory allocation method is as follows: Step S32-1. Calculate the distribution weight of each drug: ; Among them, Q represents the weight of the drug, P represents the remaining number of drugs in the inventory list, N is the number of times the current drug is taken in the historical record, NE is the total number of times all drugs are taken in the historical record, NV represents the number of times the current drug is put into the warehouse, the initial value is 0, P i Represents the remaining quantity of the i-th drug in the inventory list; Step S32-2. The storage unit corresponding to the drug with the highest allocation weight is put into storage. When entering the storage, it is stored in ascending order according to the shelf number, and the number of drug entry times NV is increased by 1, and the type of the drug entering the storage is recorded; If there are drugs to be distributed that can be combined into storage units in the inventory list, go to step S32-1, otherwise go to step S32-3; Step S32-3. The remaining drugs in the inventory are stored as a storage unit to complete the drug distribution; Step S33. Record the shelf number of each storage unit in the database. When the medicine is shipped out, it is allowed to call the medicine between different storage units.
[0032] Step S4. Bind the drug management personnel to the mobile terminal device, obtain the management personnel's location in real time, and plan the drug collection route for the management personnel according to the recorded drug storage location when executing the outbound list, so that the outbound distance of the drug collection is the shortest, and generate reminder information; Step S4 includes: Step S41. A mobile terminal device is set at the drug management personnel. When the mobile terminal device receives a demand for drug delivery, the drug management personnel is located. Step S42. Detect the number of remaining drugs on the shelf, and plan a walking route for the drug manager with the current location as the starting point and the delivery port as the end point, so that the drugs on the shelves along the walking route can meet the drug delivery demand. If there is no such path, an alarm of insufficient inventory is issued; Step S43. The drug management personnel walk along the planned route. When passing by the shelves where the outbound drugs are stored, a prompt is given on the mobile terminal device, displaying the type, quantity and precautions of the drugs to be taken.
[0033] Step S5. Based on the number of drugs shipped out during the period, the future inventory of each drug is predicted, and an expected inventory function of the drug's storage quantity and time is generated. When the integral of the expected inventory function within the drug logistics time is lower than the threshold, a reminder is issued to replenish the stock.
[0034] Step S5 includes: Step S51. Preset the detection cycle T, obtain the outbound quantity U of each drug according to the outbound record of the drug T time before the current moment, calculate the outbound speed V, V=U / T, and use the function fitting tool to obtain the outbound speed function g(t) of the drug according to the outbound speed in the previous cycle, and generate the expected function of drug inventory G(t)=G0-g(t)·t, where t represents time; Step S52. Obtain the average logistics time TA of the medicine, calculate the definite integral of the inventory expectation function in the integral limit [0,TA], and when the definite integral value is less than the preset threshold, remind the warehouse to replenish the stock.
[0035] Example: There are 3 kinds of medicines waiting to be put into storage, with quantities of 10, 20 and 30 respectively. The first usage of medicine 1 is 5, and the second usage of medicines 2 and 3 are 2 and 10 respectively. The first usage of medicine 2 is 7, and the second usage of medicines 1 and 3 are 1 and 5 respectively. The first usage of medicine 3 is 10, and the second usage of medicines 1 and 2 are 2 and 4 respectively. The allocation result is [drug 3, drug 1, drug 2, drug 2], and they are put into storage according to the distance between the shelf and the medicine collection port.
[0036] It should be noted that, in this article, relational terms such as first and second, etc. are only used to distinguish one entity or operation from another entity or operation, and do not necessarily require or imply any such actual relationship or order between these entities or operations. Moreover, the terms "include", "comprise" or any other variants thereof are intended to cover non-exclusive inclusion, so that a process, method, article or device including a series of elements includes not only those elements, but also other elements not explicitly listed, or also includes elements inherent to such process, method, article or device.
[0037] Finally, it should be noted that the above description is only a preferred embodiment of the present invention and is not intended to limit the present invention. Although the present invention has been described in detail with reference to the aforementioned embodiments, those skilled in the art can still modify the technical solutions described in the aforementioned embodiments or replace some of the technical features therein by equivalents. Any modification, equivalent replacement, improvement, etc. made within the spirit and principle of the present invention shall be included in the protection scope of the present invention.
Claims
1. A smart drug storage management method based on big data, It is characterized in that The method comprises the following steps: Step S1. Number the shelves in ascending order according to the distance between the shelves and the shipping port, and generate a warehouse entry list according to the type and quantity of the drugs to be warehoused; Step S2. Calculate the probability distribution function of the single drug usage amount according to the distribution fitting method based on the historical outbound information, take the usage amount when the probability distribution function is the maximum as the first usage amount, multiply the first usage amount by the usage overlap rate of other drugs, and obtain the second usage amount; Step S3. Combine each first amount of medicine and its related medicines into a storage unit, use the medicine usage ratio as the weight, split the storage list according to the storage allocation method, and store the medicines to be stored in order, and store them in order according to the shelf number when entering the warehouse; Step S4. Bind the drug management personnel to the mobile terminal device, obtain the management personnel's location in real time, and plan the drug collection route for the management personnel according to the recorded drug storage location when executing the outbound list, so that the outbound distance of the drug collection is the shortest, and generate reminder information; Step S5. Based on the number of drugs shipped out during the period, the future inventory of each drug is predicted, and an expected inventory function of the drug's storage quantity and time is generated. When the integral of the expected inventory function within the drug logistics time is lower than the threshold, a reminder is issued to replenish the stock.
2. According to the big data-based smart drug storage management method of claim 1, Features: Step S1 includes: Step S11. Construct a distribution model of shelves in the warehouse, and number the shelves in ascending order according to the distance between the shelves and the shipping port. The numbering results are recorded as {W1, W2, ..., Wn}, where n is the number of shelves in the warehouse and Wn is the number of the nth shelf; Step S12. Before the drugs are put into storage, the names and quantities of all drugs to be put into storage are input, a storage list is generated, and stored in the database; Step S2 includes: Step S21. Acquire historical outbound information from the warehouse management database, the historical outbound information including: the amount of each drug taken, the number of times taken, and the overlap rate of taking, the overlap rate of taking represents the probability of different types of drugs being taken out of the warehouse at the same time; Step S22. Calculate the probability distribution function of the single dose of the drug according to a distribution fitting method, wherein the distribution fitting method is as follows: ; Where F(x) is the probability distribution function of the single drug usage, x is the single drug usage, σ is the standard deviation of the drug usage, N is the current number of drug usage in the historical records, μ is the mean of the drug usage, and xi is the drug usage at the i-th time. Step S23. Calculate the maximum value of the function F(x), the single drug dosage corresponding to the maximum value is recorded as the first dosage, and calculate the second dosage according to the following method: ; Where IX1 and IX2 represent the first and second dosages of the drug, respectively. i represents the overlap rate between the current drug and the i-th other drug, and m represents the number of drug types.
3. According to the big data-based smart drug storage management method of claim 2, Features: Step S3 includes: Step S31. The first amount of current medicine and the second amount of other medicines form a storage unit, where i∈{1, 2, ..., m-1); Step S32: Split the incoming inventory list according to the incoming inventory allocation method, the incoming inventory allocation method is as follows: Step S32-1. Calculate the distribution weight of each drug: ; Among them, Q represents the weight of the drug, P represents the remaining number of drugs in the inventory list, N is the number of times the current drug is taken in the historical record, NE is the total number of times all drugs are taken in the historical record, NV represents the number of times the current drug is put into the warehouse, the initial value is 0, P i Represents the remaining quantity of the i-th drug in the inventory list; Step S32-2. The storage unit corresponding to the drug with the highest allocation weight is put into storage. When entering the storage, it is stored in ascending order according to the shelf number, and the number of drug entry times NV is increased by 1, and the type of the drug entering the storage is recorded; If there are drugs to be distributed that can be combined into storage units in the inventory list, go to step S32-1, otherwise go to step S32-3; Step S32-3. The remaining drugs in the inventory are stored as a storage unit to complete the drug distribution; Step S33. Record the shelf number of each storage unit in the database. When the medicine is shipped out, it is allowed to call the medicine between different storage units.
4. According to the big data-based smart drug storage management method of claim 3, Features: Step S4 includes: Step S41. A mobile terminal device is set at the drug management personnel. When the mobile terminal device receives a demand for drug delivery, the drug management personnel is located. Step S42. Detect the number of remaining drugs on the shelf, and plan a walking route for the drug manager with the current location as the starting point and the delivery port as the end point, so that the drugs on the shelves along the walking route can meet the drug delivery demand. If there is no such path, an alarm of insufficient inventory is issued; Step S43. The drug management personnel walk along the planned route. When passing by the shelves where the outbound drugs are stored, a prompt is given on the mobile terminal device, displaying the type, quantity and precautions of the drugs to be taken.
5. According to the big data-based smart drug storage management method of claim 4, Features: Step S5 includes: Step S51. Preset the detection cycle T, obtain the outbound quantity U of each drug according to the outbound record of the drug T time before the current moment, calculate the outbound speed V, V=U / T, and use the function fitting tool to obtain the outbound speed function g(t) of the drug according to the outbound speed in the previous cycle, and generate the expected function of drug inventory G(t)=G0-g(t)·t, where t represents time; Step S52. Obtain the average logistics time TA of the medicine, calculate the definite integral of the inventory expectation function in the integral limit [0,TA], and when the definite integral value is less than the preset threshold, remind the warehouse to replenish the stock.
6. A smart drug warehouse management system based on big data, It is characterized in that The system includes the following modules: warehousing grouping module, big data module, management terminal module, medicine collection planning module and automatic replenishment module; The entry grouping module is used to group and number the drug storage shelves according to the distance between the shelves and the drug dispensing window, record the shelf location and drug information of the drugs when the drugs are in and out of the warehouse, provide guidance for the drug entry process, and send signals when the shelves are empty or full; The big data module is used to calculate the probability of drug use and the correlation between drugs based on historical data and drug information in the database, and link the pharmacy database with the medical registration database, predict the type and amount of drug use based on the diagnosis information of medical registration personnel, the probability of drug use and the correlation between drugs, generate a predicted delivery order, and allocate the storage location of the drugs according to the predicted delivery order; The management terminal module is used to set up a terminal device at the drug management personnel, track the terminal device of the drug management personnel through the Internet of Things system, bind the drug configuration list with the terminal device, and obtain the personnel location information through the positioning function in the terminal device after receiving the drug outbound list; The medicine collection planning module is used to plan the walking route of the medicine management personnel according to the personnel positioning and the medicine outbound list, the walking distance, the medicine inventory and the misuse rate of the medicines on the same shelf, so as to make the route outbound distance the shortest, and generate medicine collection reminder information according to the medicines stored on the shelf when the personnel collect the medicines, and enter the verification information when the medicines are outbound; The automatic replenishment module is used to generate an expected inventory function of the storage quantity and time of each drug according to the probability of drug use and the current inventory, and determine the alarm threshold by the average drug use quantity, drug information, replenishment logistics time and a preset coefficient. When the expected inventory function of the drug is lower than the threshold, the replenishment drug type and replenishment quantity are automatically determined to ensure that the expected inventory function of the drug in the next cycle is not lower than the threshold, and a replenishment notification is generated on the terminal device.
7. According to claim 6, a smart drug storage management system based on big data, Features: The warehousing grouping module includes: a shelf classification unit and a warehouse entry unit; The shelf classification unit is used to construct a distribution model of shelves in the warehouse and number the shelves according to the distance between the shelves and the medicine dispensing port; The storage input unit is used to receive the information of incoming medicines, guide the medicines into the warehouse, and record the information of medicines on the shelves. The historical outbound information includes: the amount of each medicine taken, the number of times it is taken, and the overlap rate of taking.
8. According to the big data-based smart drug storage management system of claim 7, Features: The big data module includes: a database unit, an access analysis unit and a storage allocation unit; The database unit is used to store the location information of the drugs on the shelf, and the historical drug in-and-out information; The use analysis unit is used to analyze historical data to determine the probability of drug use and the probability of associated drug use, wherein the historical data includes: historical prescriptions, drug storage records and registration records; The storage allocation unit is used to allocate the drugs to be stored to different shelves according to the analysis results of the drugs, and record the allocation results.
9. According to the big data-based smart drug storage management system of claim 8, Features: The management terminal module includes: a warehouse management unit and a mobile positioning unit; The storage management unit is used to construct human-computer interaction software in the mobile terminal to display the storage location of the medicine and provide route guidance; The mobile positioning unit is used to bind the drug management personnel to the mobile terminal, determine the location of the drug management personnel in real time, and feed back the location to the cloud; The medicine collection planning module includes: an order checking unit and a path guiding unit; The order checking unit is used to receive drug delivery requirements, digitize drug numbers and withdrawal measurements, and search in a database; The path guidance unit is used to plan the walking route of the drug management personnel according to the location of the required drugs on the shelf, so as to shorten the total outbound distance, and display the guidance route in the terminal device.
10. According to claim 9, a smart drug storage management system based on big data, Features: The automatic replenishment module includes: a stock prediction unit, a floating standard unit and a replenishment notification unit; The inventory prediction unit is used to predict the future inventory of each drug based on the diagnosis information and historical records of medical registration personnel in the current period, and generate an expected inventory function of the drug storage quantity and time; The floating standard unit is used to calculate the alarm threshold according to the average amount of medicine taken in the current cycle, medicine information, replenishment logistics time and preset coefficient; The replenishment notification unit is used to generate a drug replenishment notification when the expected inventory function of the drug is lower than a threshold value, and record the drug name and replenishment quantity in the replenishment notification.
Citation Information
Patent Citations
Intelligent pharmacy control and management system
CN102819674A
Intelligent storeroom management system for TCM pharmacy
CN105809397A
Intelligent medicine getting system and control method thereof
CN106504155A
Three-dimensional warehouse management system and method based on RFID
CN110414638A
Hospital medicine purchase plan prediction method and system based on LSTM
CN113888090A
Cited By
Drug addressing and positioning method based on WMS system
CN119338382A
Intelligent pharmacy data processing method and device, equipment and storage medium
CN120376078A
Inventory analysis and management optimization method of intelligent pharmacy management system
CN121544184A
Inventory analysis and management optimization method of smart pharmacy management system
CN121544184B
Method for automatically generating medicine warehouse ex-warehouse task based on driving mode
CN122175511A
