CN116957475A - Cloud computing-based oral cavity clinic warehouse management method, system and device - Google Patents
Cloud computing-based oral cavity clinic warehouse management method, system and device Download PDFInfo
- Publication number
- CN116957475A CN116957475A CN202310997688.4A CN202310997688A CN116957475A CN 116957475 A CN116957475 A CN 116957475A CN 202310997688 A CN202310997688 A CN 202310997688A CN 116957475 A CN116957475 A CN 116957475A
- Authority
- CN
- China
- Prior art keywords
- consumable
- representing
- information
- inventory
- value
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Granted
Links
- 238000007726 management method Methods 0.000 title claims abstract description 120
- 210000000214 mouth Anatomy 0.000 title claims description 9
- 238000012545 processing Methods 0.000 claims abstract description 8
- 239000000463 material Substances 0.000 claims description 77
- 230000006870 function Effects 0.000 claims description 40
- 238000004364 calculation method Methods 0.000 claims description 32
- 238000012544 monitoring process Methods 0.000 claims description 25
- 238000004519 manufacturing process Methods 0.000 claims description 22
- 238000007405 data analysis Methods 0.000 claims description 18
- 238000007637 random forest analysis Methods 0.000 claims description 18
- 238000012549 training Methods 0.000 claims description 17
- 238000011156 evaluation Methods 0.000 claims description 12
- 238000003860 storage Methods 0.000 claims description 10
- 238000007781 pre-processing Methods 0.000 claims description 9
- 230000002159 abnormal effect Effects 0.000 claims description 6
- 230000036512 infertility Effects 0.000 claims description 6
- 238000010606 normalization Methods 0.000 claims description 6
- 230000008439 repair process Effects 0.000 claims description 6
- 238000001356 surgical procedure Methods 0.000 claims description 6
- 238000010276 construction Methods 0.000 claims description 5
- 230000003239 periodontal effect Effects 0.000 claims description 5
- 238000005057 refrigeration Methods 0.000 claims description 5
- 238000012706 support-vector machine Methods 0.000 claims description 3
- 238000012360 testing method Methods 0.000 claims description 3
- 238000004140 cleaning Methods 0.000 claims description 2
- 238000000034 method Methods 0.000 description 18
- 238000007689 inspection Methods 0.000 description 10
- 239000012567 medical material Substances 0.000 description 5
- 230000009467 reduction Effects 0.000 description 5
- 238000010586 diagram Methods 0.000 description 4
- 238000005516 engineering process Methods 0.000 description 3
- 230000036541 health Effects 0.000 description 3
- 230000001932 seasonal effect Effects 0.000 description 3
- 238000003066 decision tree Methods 0.000 description 2
- 239000004053 dental implant Substances 0.000 description 2
- GBIHOLCMZGAKNG-UHFFFAOYSA-N flucythrinate Chemical compound C=1C=C(OC(F)F)C=CC=1C(C(C)C)C(=O)OC(C#N)C(C=1)=CC=CC=1OC1=CC=CC=C1 GBIHOLCMZGAKNG-UHFFFAOYSA-N 0.000 description 2
- 238000012423 maintenance Methods 0.000 description 2
- 238000005457 optimization Methods 0.000 description 2
- 239000002699 waste material Substances 0.000 description 2
- 241000764238 Isis Species 0.000 description 1
- 238000004458 analytical method Methods 0.000 description 1
- 230000009286 beneficial effect Effects 0.000 description 1
- 230000008859 change Effects 0.000 description 1
- 238000001816 cooling Methods 0.000 description 1
- 230000003247 decreasing effect Effects 0.000 description 1
- 238000011161 development Methods 0.000 description 1
- 238000003745 diagnosis Methods 0.000 description 1
- 230000000694 effects Effects 0.000 description 1
- 238000003384 imaging method Methods 0.000 description 1
- 230000003287 optical effect Effects 0.000 description 1
- 238000004321 preservation Methods 0.000 description 1
- 230000002035 prolonged effect Effects 0.000 description 1
- 238000013139 quantization Methods 0.000 description 1
- 238000004904 shortening Methods 0.000 description 1
- 230000001954 sterilising effect Effects 0.000 description 1
- 230000001502 supplementing effect Effects 0.000 description 1
- 239000013077 target material Substances 0.000 description 1
- 230000007306 turnover Effects 0.000 description 1
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q10/00—Administration; Management
- G06Q10/08—Logistics, e.g. warehousing, loading or distribution; Inventory or stock management
- G06Q10/087—Inventory or stock management, e.g. order filling, procurement or balancing against orders
- G06Q10/0875—Itemisation or classification of parts, supplies or services, e.g. bill of materials
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F17/00—Digital computing or data processing equipment or methods, specially adapted for specific functions
- G06F17/10—Complex mathematical operations
- G06F17/18—Complex mathematical operations for evaluating statistical data, e.g. average values, frequency distributions, probability functions, regression analysis
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F18/00—Pattern recognition
- G06F18/20—Analysing
- G06F18/21—Design or setup of recognition systems or techniques; Extraction of features in feature space; Blind source separation
- G06F18/214—Generating training patterns; Bootstrap methods, e.g. bagging or boosting
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F18/00—Pattern recognition
- G06F18/20—Analysing
- G06F18/24—Classification techniques
- G06F18/243—Classification techniques relating to the number of classes
- G06F18/24323—Tree-organised classifiers
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06K—GRAPHICAL DATA READING; PRESENTATION OF DATA; RECORD CARRIERS; HANDLING RECORD CARRIERS
- G06K17/00—Methods or arrangements for effecting co-operative working between equipments covered by two or more of main groups G06K1/00 - G06K15/00, e.g. automatic card files incorporating conveying and reading operations
- G06K17/0022—Methods or arrangements for effecting co-operative working between equipments covered by two or more of main groups G06K1/00 - G06K15/00, e.g. automatic card files incorporating conveying and reading operations arrangements or provisions for transferring data to distant stations, e.g. from a sensing device
- G06K17/0029—Methods or arrangements for effecting co-operative working between equipments covered by two or more of main groups G06K1/00 - G06K15/00, e.g. automatic card files incorporating conveying and reading operations arrangements or provisions for transferring data to distant stations, e.g. from a sensing device the arrangement being specially adapted for wireless interrogation of grouped or bundled articles tagged with wireless record carriers
Landscapes
- Engineering & Computer Science (AREA)
- Physics & Mathematics (AREA)
- Theoretical Computer Science (AREA)
- Data Mining & Analysis (AREA)
- General Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- Business, Economics & Management (AREA)
- Life Sciences & Earth Sciences (AREA)
- Bioinformatics & Cheminformatics (AREA)
- Bioinformatics & Computational Biology (AREA)
- Evolutionary Biology (AREA)
- Mathematical Analysis (AREA)
- Computational Mathematics (AREA)
- Pure & Applied Mathematics (AREA)
- Economics (AREA)
- Mathematical Physics (AREA)
- Evolutionary Computation (AREA)
- Computer Vision & Pattern Recognition (AREA)
- Operations Research (AREA)
- Mathematical Optimization (AREA)
- Artificial Intelligence (AREA)
- Entrepreneurship & Innovation (AREA)
- Development Economics (AREA)
- Computer Networks & Wireless Communication (AREA)
- Probability & Statistics with Applications (AREA)
- Software Systems (AREA)
- Finance (AREA)
- Databases & Information Systems (AREA)
- Algebra (AREA)
- Accounting & Taxation (AREA)
- Human Resources & Organizations (AREA)
- Marketing (AREA)
- Quality & Reliability (AREA)
- Strategic Management (AREA)
- Tourism & Hospitality (AREA)
- General Business, Economics & Management (AREA)
- General Factory Administration (AREA)
Abstract
The invention relates to the technical field of inventory data processing, and discloses an oral clinic inventory management method based on cloud computing.
Description
Technical Field
The invention relates to the technical field of inventory data processing, in particular to an oral cavity clinic warehouse management method, system and device based on cloud computing.
Background
Due to the rapid development of computers, computer-based information technology continues to be in deep reach various areas of society. In daily life, as people pay more attention to oral health, the oral diagnosis is improved in medical level and service level and efficiency. In the prior art, an office information system is deployed in an oral office mostly, so that the management efficiency of the oral office on various information is improved, but the management of the oral office on a warehouse is not advanced enough, the inventory management efficiency cannot be improved, great cost loss and error are caused by manual classification, a scientific optimized replenishment strategy is not available, and automatic and fine management cannot be realized.
The Chinese patent with the application publication number of CN109299902A discloses a hospital secondary warehouse management system and a management method, and belongs to the technical field of control and management. The system and the method are provided with the authority management unit, and operate medical supplies of the secondary warehouse of the hospital in linkage with the medical supply management unit and the report unit, so that the medical supplies in the secondary warehouse can be operated according to the change authority, and an operation report is generated for backup and reference. The system and the method also comprise a reminding unit which can remind medical materials which are failed or recently failed in the secondary warehouse of the hospital at regular time, and the reminding unit is linked with the medical material management unit to allocate the recently failed medical materials among different departments and clear the failed medical materials in time, so that the labor cost and the waste of the medical materials are reduced, and meanwhile, the potential safety hazard is avoided.
For example, chinese patent application publication No. CN107633280a discloses a warehouse management method and system based on RFID, which are used for improving the efficiency of warehouse material management and reliability of warehouse data. The method of the embodiment of the invention comprises the following steps: installing RFID tags on different materials, wherein the RFID tags record material information of the corresponding materials; the corresponding material information in the RFID tag on the warehouse-in material is read through the handheld RFID reader-writer and is uploaded to a warehouse management platform; inquiring target RFID label information corresponding to the target material information from the warehouse management platform through the mobile terminal, and sending a radio frequency signal according to the target RFID label information so as to position the corresponding target RFID label.
The problems presented in the background art exist in the above patents: the management of the warehouse by the oral clinic is not advanced enough, the inventory management efficiency cannot be improved, the significant cost loss and error are caused by manual classification, the scientific optimization replenishment strategy is not available, and the automation and the fine management cannot be realized. In order to solve the problem, the application provides an oral cavity clinic warehouse management method, system and device based on cloud computing.
Disclosure of Invention
This section is intended to outline some aspects of embodiments of the application and to briefly introduce some preferred embodiments. Some simplifications or omissions may be made in this section as well as in the description of the application and in the title of the application, which may not be used to limit the scope of the application.
The present application has been made in view of the above-mentioned problems with existing cloud computing-based methods, systems, and devices for oral clinic warehouse management.
Accordingly, it is an object of the present application to provide a cloud computing based oral clinic warehouse management method, system and apparatus.
In order to solve the technical problems, the application provides an oral clinic warehouse management method based on cloud computing, which comprises the following steps:
Performing consumable identification;
performing consumable classification by using a consumable identification model and a hierarchical classification rule;
performing intelligent management on the classified consumables, and performing real-time monitoring;
associating order information with inventory information to manage orders;
and carrying out comprehensive data analysis on the order information and the inventory information.
As a preferred embodiment of the cloud computing-based oral clinic warehouse management method of the present invention, the method comprises: the consumable identification comprises consumable collection and preprocessing, consumable identification model construction, consumable identification model training and consumable identification model evaluation;
the consumable collection and preprocessing comprises collecting image information of consumable, recording name, category and specification information of the consumable, forming a consumable set, then performing image scaling, clipping and graying on the image information, forming an image pixel value set, and performing normalization processing, wherein the calculation formula of the normalization processing is as follows:
；
in the formula ,representing the +.>Normalized value of seed consumable,/>Indicate->Consumable supplies->Indicate->Image pixel value of the seed consumable, +.>、/>Respectively representing the maximum value and the minimum value in the image pixel point value set.
As a preferred embodiment of the cloud computing-based oral clinic warehouse management method of the present invention, the method comprises: the consumable identification model is a model constructed by means of a support vector machine, and comprises the following components: combining the image pixel point value set and the consumable set to form a data set, dividing the data set into a 75% training set and a 25% testing set, and constructing the consumable identification model according to the following formula:
；
in the formula ,predictive data representing the identification of consumables, +.>Indicate->Consumable supplies->Representing the total number of sets of image pixel values, and (2)>Represents the Lagrangian multiplier, +.>Classification label representing said set of image pixel values,/->Representing a kernel function->Represents the offset +.>Representing a superparameter for controlling the offset;
wherein ,the calculation formula of (2) is +.>When->Time indicates +.>The material consumption is low value material consumption whenTime indicates +.>The seed consumable is a high-value consumable, ">The formula of (2) is +.>，/>Indicate->Image pixel value of the seed consumable, +.>Representing new image pixel values.
As a preferred embodiment of the cloud computing-based oral clinic warehouse management method of the present invention, the method comprises: the consumable identification model further comprises: the low-value consumable and the high-value consumable are identified and then classified in layers, the class of the consumable in the consumable set is selected as a classification characteristic, and the hierarchical classification rule of the low-value consumable is as follows:
If the description of the category is examination, classifying the oral examination consumable;
if the description of the category is cleaning, classifying the category as periodontal treatment consumable;
if the description of the category is sanitary, classifying the category as oral hygiene consumable;
the hierarchical classification rule of the high-value consumable is as follows:
if the description of the category is surgery, classifying the category as dental surgery consumable;
if the description of the category is repair, classifying the dental repair consumable;
if the description of the category is planting, classifying the category as dental planting consumables;
and if the description of the category is an image, classifying the image as dental image consumable.
As a preferred embodiment of the cloud computing-based oral clinic warehouse management method of the present invention, the method comprises: training the consumable identification model through a training function, wherein the calculation formula of the training function is as follows:
；
in the formula ,representing the calculated value of said training function, +.>Indicate->Consumable supplies->Representing the total number of sets of image pixel values, and (2)>Indicate->Tag of seed consumable->The identification of the consumable is correctly 1 +.>The identification error of the seed consumable is 0, < >>Indicate->The probability of correct material supply prediction;
evaluating the consumable identification model through an evaluation function, wherein the calculation formula of the evaluation function is as follows:
；
in the formula ,representing the calculated value of said evaluation function, +.>Predictive data representative of the identity of the consumable,raw data representing consumable identification, +.>Representing the mean of raw data of consumable identification.
As a preferred embodiment of the cloud computing-based oral clinic warehouse management method of the present invention, the method comprises: the intelligent management comprises counting consumable parts in a warehouse, and a form is generated, wherein the form comprises consumable part information, inventory information and supplier information, and functions of the consumable parts in the warehouse are as follows:
；
in the formula ,a statistical function representing said consumable, +.>A unique identifier representing said consumable, +.>Name representing the consumable->Representing the class of the consumable,/->The specification information of the consumable material comprises common and special specification information>Representing the stock quantity of said consumable, +.>Representing the position of the consumable,/->Indicating the time of warehousing of said consumables, +.>Representing the time of delivery of said consumable, +.>Representing the price of the purchase of the consumable>Representing the retail price of said consumable, +.>A lowest inventory warning line representing said consumable, < >>Representing the date of production of said consumable, +.>Indicating the shelf life of said consumable, +. >A vendor name representing the consumable, +.>A vendor contact representing the consumable;
wherein ,the functional expression of (2) is +.>；
in the formula ,representing the class of the consumable,/->Indicating the frequency of use of said consumable, +.>Representing the warehousing time of the consumable;
wherein ,the calculation formula of (2) is +.>；
in the formula ,indicating that the content in the brackets is counted;
the placement rule of the positions of the consumable materials is as follows:
if it isFor the low value consumable, then +.>Placing the materials in a material rack or a material cabinet;
the material rack is a two-layer trolley, the consumable cabinet comprises an upper consumable cabinet, a middle consumable cabinet and a lower consumable cabinet, the upper consumable cabinet is provided with three layers, the middle consumable cabinet is provided with five layers, and the lower consumable cabinet is provided with two layers;
if it isPlacing the low-value consumable on the upper layer of the object rack;
if it isPlacing the low-value consumable on the lower layer of the object rack;
if it isPlacing the low-value consumable on the upper two layers of the middle consumable cabinet of the consumable cabinet;
if it isFor the high value consumable, then +.>Placing the materials into a consumable cabinet;
if it isPlacing the high-value consumable in the lower three layers of the middle consumable cabinet of the consumable cabinet;
if it isPlacing the high-value consumable in an upper consumable cabinet of the consumable cabinet;
If it isPlacing the high-value consumable in a lower consumable cabinet of the consumable cabinet;
if it isIf the requirements of refrigeration and sterility are met, placing the consumable material into a special refrigeration and sterility area;
and placing the low-value consumable and the high-value consumable according to the warehousing time, wherein the low-value consumable and the high-value consumable are placed in front of the consumable in a warehousing mode, and the high-value consumable and the consumable are placed in back of the consumable in a warehousing mode.
As a preferred embodiment of the cloud computing-based oral clinic warehouse management method of the present invention, the method comprises: the real-time monitoring comprises inventory warning line reminding and consumable acceptance and expiration monitoring, and the real-time monitoring flow is as follows:
monitoring whether the inventory of the consumable is less than the minimum inventory fence;
if the stock quantity of the consumable is smaller than the lowest stock warning line, the system alarms to prompt that the replenishment operation is needed;
if the stock quantity of the consumable is greater than or equal to the lowest stock warning line, ending the monitoring flow;
the replenishment operation automatically generates a stock list according to the stock quantity of the consumable and the supplier information, sends the stock list to a designated supplier, and orders and notifies the supplier to deliver;
The suppliers are specified suppliers extracted from the supplier information;
checking the production date of the consumable and the quality guarantee period of the consumable;
rejecting by an acceptance person if the shelf life is more than two years and the time from the date of manufacture at acceptance exceeds 30% of the shelf life;
if the shelf life is more than two years and the time from the production date at the time of acceptance is not more than 30% of the shelf life, receiving the consumable by an acceptance person and executing the intelligent management;
rejecting by an acceptance person if the shelf life is less than two years and the time from the date of manufacture at acceptance exceeds 10% of the shelf life;
if the quality guarantee period is less than two years and the time from the production date is not more than 10% of the quality guarantee period during acceptance, receiving the consumable by an acceptance person and executing the intelligent management;
and if the shelf life is up, destroying the consumable.
As a preferred embodiment of the cloud computing-based oral clinic warehouse management method of the present invention, the method comprises: the order management comprises supplier management and order inventory interconnection;
the provider management comprises the steps of sorting the provider information, generating an Excel table, and sorting the function expression of the provider information as follows:
；
in the formula ,finishing function representing said supplier information, < >>A vendor name representing the consumable, +.>A supplier contact representing said consumable, < >>Representing the price of the purchase of the consumable>Representing vendor reliability +.>Representing a predetermined delivery time of said consumable, < >>Representing the actual delivery time of said consumable, < >>Representing the number of transactions of said consumable, +.>Representing the return times of the consumable;
wherein the vendor reliabilityThe judgment criteria of (2) are as follows:
if the delivery of the consumable is timely and the quality is good, the reliability of the supplier is highest;
if the delivery of the consumable is timely and of medium quality, the supplier reliability is high;
if the delivery of the consumable is timely and the quality is poor, the reliability of the supplier is medium;
if the delivery of the consumable is not timely and the quality is good, the reliability of the supplier is medium;
if the delivery of the consumable is not timely and of medium quality, the supplier reliability is low;
if the delivery of the consumable is not timely and the quality is poor, the reliability of the supplier is the lowest;
the judgment standard of whether the delivery time of the consumable is timely or not is as follows:
If it isThe delivery is indicated to be in time;
if it isIndicating that delivery is not timely;
wherein, the formula of calculation of the quality of consumptive material is:
；
in the formula ,representing the number of transactions of said consumable, +.>Representing the return times of the consumable;
the quality judgment standard of the consumable is as follows:
if it isThe quality of the consumable is good;
if it isThe quality of the consumable is stated to be medium;
if it isAnd then the quality of the consumable is poor.
As a preferred embodiment of the cloud computing-based oral clinic warehouse management method of the present invention, the method comprises: the order inventory interconnection comprises order information and inventory information, and a function expression for recording the order information is as follows:
；
in the formula ,recording function representing said order information, +.>Representing order number->Representing the approval of the order->Representing the stock quantity of said consumable, +.>A lowest inventory warning line representing said consumable, < >>Representing the replenishment quantity of the consumable material,representing the price of the purchase of the consumable>Representing a retail price of the consumable;
wherein whenDuring the time, the amount of the goods is added>The calculation formula of (2) is +.>When->During the time, the amount of the goods is added>The calculation formula of (2) is +.>；
in the formula ,represents rounding the number in the brackets, < > >Representing the stock quantity of said consumable, +.>A lowest inventory warning line representing said consumable, < >>Representing the price of the purchase of the consumable>Representing the retail price of the consumable.
As a preferred embodiment of the cloud computing-based oral clinic warehouse management method of the present invention, the method comprises: the data analysis includes analyzing, predicting and optimizing inventory conditions;
the data analysis step includes:
s1, collecting and arranging order information of the consumable materials, inventory information of the consumable materials and other information of the consumable materials, wherein the order information comprises names, categories, specifications, order quantity, inventory quantity, replenishment period, supplier reliability and inventory cost, and an information set is formed;
s2, selecting order quantity, stock quantity, replenishment period, supplier reliability and stock cost from the information set as feature selection;
s3, preprocessing the collected and tidied information set, including deleting repeated information, filling in missing information and modifying abnormal information;
s4, constructing a random forest model;
s5, predicting the inventory condition of the consumable;
s6, evaluating by using a random forest model;
s7, predicting and visualizing the inventory condition of the consumable.
An oral clinic warehouse management system based on cloud computing comprises a classification management module, an inventory management module, an order management module and a data analysis module;
the sorting management module utilizes a consumable identification model to identify and sort consumable, the inventory management module carries out statistics, intelligent management and real-time monitoring on the sorted consumable, the order management module associates order information with the inventory management module, and the data analysis module analyzes, predicts and optimizes the inventory condition.
An oral clinic warehouse management device based on cloud computing comprises a storage medium and a processor, wherein the storage medium is used for storing operation instructions, and the processor is used for realizing an oral clinic warehouse management method based on cloud computing.
The invention has the beneficial effects that: according to the invention, consumable materials are identified, consumable material identification models and hierarchical classification rules are utilized to classify the consumable materials, so that labor cost and error rate are reduced, the classified consumable materials are intelligently managed and monitored in real time, inventory efficiency is improved, order information and inventory information are associated, order management is performed, order tracking and optimizing replenishment strategies are ensured in real time, comprehensive data analysis is performed on the order information and the inventory information, and fine management is realized.
Drawings
In order to more clearly illustrate the technical solutions of the embodiments of the present invention, the drawings that are needed in the description of the embodiments will be briefly described below, it being obvious that the drawings in the following description are only some embodiments of the present invention, and that other drawings may be obtained according to these drawings without inventive effort for a person skilled in the art. Wherein:
fig. 1 is a method flow diagram of an oral clinic warehouse management method based on cloud computing according to the present invention.
Fig. 2 is a flow chart of real-time monitoring according to the cloud computing-based method for managing an oral clinic warehouse of the present invention.
Fig. 3 is a random forest map of inventory conditions according to the cloud computing-based method for inventory management in an oral clinic of the present invention.
Fig. 4 is a block diagram of a system of the cloud computing-based oral clinic warehouse management system of the present invention.
Detailed Description
In order that the above-recited objects, features and advantages of the present invention will become more readily apparent, a more particular description of the invention will be rendered by reference to specific embodiments thereof which are illustrated in the appended drawings.
In the following description, numerous specific details are set forth in order to provide a thorough understanding of the present invention, but the present invention may be practiced in other ways other than those described herein, and persons skilled in the art will readily appreciate that the present invention is not limited to the specific embodiments disclosed below.
Further, reference herein to "one embodiment" or "an embodiment" means that a particular feature, structure, or characteristic can be included in at least one implementation of the invention. The appearances of the phrase "in one embodiment" in various places in the specification are not necessarily all referring to the same embodiment, nor are separate or alternative embodiments mutually exclusive of other embodiments.
Further, in describing the embodiments of the present invention in detail, the cross-sectional view of the device structure is not partially enlarged to a general scale for convenience of description, and the schematic is only an example, which should not limit the scope of protection of the present invention. In addition, the three-dimensional dimensions of length, width and depth should be included in actual fabrication.
Example 1
Referring to fig. 1, a method flowchart of a cloud computing-based oral clinic warehouse management method is provided, as in fig. 1, comprising:
s1, performing consumable identification.
The automatic classification and management of consumable materials in the oral cavity clinic storeroom are realized based on the cloud computing image recognition technology, and the labor cost and the error rate are reduced;
the consumable identification comprises consumable collection and preprocessing, consumable identification model construction, consumable identification model training and consumable identification model evaluation;
The consumable collection and preprocessing comprises collecting image information of consumable, recording name, category and specification information of the consumable, forming a consumable set, then performing image scaling, clipping and graying operation on the image information, forming an image pixel value set, performing normalization processing, wherein the calculation formula of the normalization processing is as follows:
；
in the formula ,representing the +.>Normalized value of seed consumable,/>Indicate->Consumable supplies->Indicate->Image pixel value of the seed consumable, +.>、/>Respectively representing image pixel pointsMaximum and minimum values in the value set;
s2, performing consumable classification by using a consumable identification model and a hierarchical classification rule.
The consumable identification model is a model constructed by means of a support vector machine, can better handle the classification of nonlinear problems, combines an image pixel point value set and a consumable set to form a data set, and divides the data set into a 75% training set and a 25% testing set, wherein the formula for constructing the consumable identification model is as follows:
；
in the formula ,predictive data representing the identification of consumables, +.>Indicate->Consumable supplies->Representing the total number of sets of image pixel values, and (2)>Represents the Lagrangian multiplier, +.>Classification label representing said set of image pixel values,/- >Representing a kernel function->Represents the offset +.>Representing a superparameter for controlling the offset;
wherein ,the calculation formula of (2) is +.>When->Time indicates +.>The material consumption is low value material consumption whenTime indicates +.>The seed consumable is a high-value consumable, ">The formula of (2) is +.>，/>Indicate->Image pixel value of the seed consumable, +.>Representing new image pixel values.
The low-value consumable material refers to consumable materials with relatively low unit price, relatively large demand and relatively general purpose, and the high-value consumable material refers to consumable materials with relatively high unit price and relatively small demand, and most of consumable materials are special consumable materials;
the consumable identification model identifies low-value consumables and high-value consumables and then carries out hierarchical classification, so that fine classification can be realized, the class of consumable centralized consumables is selected as classification characteristics, and the hierarchical classification rule of the low-value consumables is as follows:
if the description of the category is examination, classifying the oral examination consumable;
if the description of the category is clean, classifying the category as periodontal treatment consumable;
if the description of the category is sanitary, classifying the category as oral hygiene consumable;
the hierarchical classification rule of the high-value consumable is as follows:
if the description of the category is surgery, classifying the category as dental surgery consumable;
if the description of the category is repair, classifying the category as dental repair consumable;
If the description of the category is planting, classifying the category as dental planting consumables;
if the description of the category is an image, the image is classified as dental image consumable.
The consumable identification model is trained through the training function, and the calculation formula of the training function is as follows:
；
in the formula ,representing the calculated value of said training function, +.>Indicate->Consumable supplies->Representing the total number of sets of image pixel values, and (2)>Indicate->Tag of seed consumable->The identification of the consumable is correctly 1 +.>The identification error of the seed consumable is 0, < >>Indicate->The probability of correct material supply prediction;
the consumable identification model is evaluated through an evaluation function, and the calculation formula of the evaluation function is as follows:
；
in the formula ,representing the calculated value of said evaluation function, +.>Predictive data representing the identification of consumables, +.>Raw data representing consumable identification, +.>Representing the mean of raw data of consumable identification.
In specific applications, the consumable identification model successfully identifies 15 oral examination consumables, 16 periodontal treatment consumables, 18 oral hygiene consumables, 20 dental surgical consumables, 11 dental restoration consumables, 14 dental implant consumables and 10 dental imaging consumables.
And S3, performing intelligent management on the classified consumables, and performing real-time monitoring.
The intelligent management includes the consumptive material of statistics storehouse, generates the form, and the form includes consumptive material information, stock information and supplier information, and the function of consumptive material in the statistics storehouse is as follows:
；
in the formula ,statistical function representing consumable ∈ ->Representing the unique identity of the consumable->The name of the consumable is indicated,representing the class of consumable->Representing specification information of the consumable, wherein the specification information of the consumable comprises two types of common use and special use,/-up>Indicating the stock quantity of the consumable material,/->Indicating the position of the consumable->Indicating the time of warehousing the consumable>Indicating the time of delivery of the consumable,/->Representing the price of the purchase of the consumable,/->Representing retail price of consumable->A lowest inventory warning line representing a consumable, +.>Representing the life of a consumableDate of birth,/->Indicating the shelf life of the consumable,/->Vendor name representing consumable,/>A vendor contact representing a consumable;
wherein ,the functional expression of (2) is +.>；
in the formula ,representing the class of consumable->Indicating the frequency of use of the consumable,/->Representing the warehousing time of the consumable;
wherein ,the calculation formula of (2) is +.>；
in the formula ,indicating that the content in the brackets is counted;
the placement rule of the consumable position is as follows:
if it isIs a low-value consumable, will be->Placing the materials in a material rack or a material cabinet;
The material rack is a two-layer trolley, the consumable cabinet comprises three consumable cabinets, namely an upper consumable cabinet, a middle consumable cabinet and a lower consumable cabinet, the upper consumable cabinet is provided with three layers, the middle consumable cabinet is provided with five layers, and the lower consumable cabinet is provided with two layers;
if it isPlacing low-value consumables on the upper layer of the object rack;
if it isPlacing low-value consumables at the lower layer of the object rack;
if it isPlacing the low-value consumable in the upper two layers of the middle consumable cabinet of the consumable cabinet;
if it isFor high value consumable, will be->Placing the materials into a consumable cabinet;
if it isPlacing high-value consumables in the lower three layers of a middle consumable cabinet of the consumable cabinet;
if it isPlacing the high-value consumable in an upper consumable cabinet of the consumable cabinet;
if it isPlacing the high-value consumable in a lower consumable cabinet of the consumable cabinet;
if it isWith cooling meansPlacing the consumable material into a special refrigerating and sterilizing area when the requirement of preservation and sterility is met;
placing low-value consumables and high-value consumables according to the time of entering the warehouse, wherein the low-value consumables and the high-value consumables are placed in front of the consumables in a warehouse firstly, and then placed in the back of the consumables in a warehouse later;
the real-time monitoring comprises the steps of reminding an inventory warning line, monitoring consumable inspection and acceptance and expiration, and the real-time monitoring comprises the following steps:
monitoring whether the stock quantity of the consumable is smaller than a minimum stock warning line;
if the stock quantity of the consumable is smaller than the lowest stock warning line, the system alarms to prompt that the replenishment operation is needed;
If the stock quantity of the consumable is greater than or equal to the lowest stock warning line, ending the monitoring flow;
the system automatically generates a stock list according to the stock quantity of the consumable and the information of the suppliers, sends the stock list to the appointed suppliers, and gives a bill to inform the suppliers to deliver;
the vendor is a designated vendor extracted from vendor information;
checking the production date of the consumable and the quality guarantee period of the consumable;
if the quality guarantee period is more than two years and the time from the inspection time to the production date exceeds 30% of the quality guarantee period, rejecting by the inspection personnel;
if the quality guarantee period is more than two years and the time from the inspection time to the production date is not more than 30% of the quality guarantee period, receiving consumables by an inspection person and performing intelligent management;
if the quality guarantee period is less than two years and the time from the inspection time to the production date exceeds 10% of the quality guarantee period, rejecting by the inspection personnel;
if the quality guarantee period is less than two years and the time from the inspection time to the production date is not more than 10% of the quality guarantee period, receiving consumables by an inspection person and performing intelligent management;
if the shelf life is up, destroying the consumable;
in order to ensure reasonable management of consumable materials, general hospitals and clinics can adopt stricter management, and the acceptance standards of consumable materials with different shelf lives are different, so that the phenomenon that the purchased consumable materials expire in a warehouse can be prevented, the shelf life of the consumable materials also needs to be focused, all expired consumable materials need to be destroyed, the date cannot be changed or the consumer cannot be deceived to purchase, and medical safety is ensured.
In particular applications, taking an oral hygiene consumable as an example, the name of the consumable is an interdental brush, and the unique identifier of the consumable isThe use frequency is high, the stock quantity is 50, the warehouse-in time is updated for 20 times, the warehouse-out time is updated for 18 times, no special requirements of refrigeration, light shielding and sterility are met, the production date is 2021, 12 months and 5 days, the quality guarantee period is 24 months, the date of acceptance is 20 days away from the production date, the commodity is 53.6 yuan, the retail price of the consumable is 70 yuan, the lowest stock warning line of the consumable is 30, the supplier name of the consumable is doctor-fast doctor-gram large pharmacy flagship store, the supplier contact is Li Xiaojie, and the use frequency of the consumable is calculated to be>The statistical function expression of the oral hygiene consumable is thatAccording to the arrangement rule of the consumable, the consumable can be arranged on the upper layer of the object rack, the stock quantity is compared with the lowest stock warning line, and the stock quantity is larger than the lowest stock warning line, so that the replenishment operation is not required, the production date of the consumable is 2021, 12 months and 5 days, the quality guarantee period is 24 months, the production date is 20 days away from the inspection and acceptance, and the consumable can be normally inspected and accepted and intelligent management is executed according to the flow of real-time monitoring.
S4, associating order information with inventory information, and performing order management.
The order management comprises supplier management and order inventory interconnection, and the order information is associated with an inventory management module, so that real-time order tracking and optimized replenishment strategy can be ensured;
the vendor management includes sorting vendor information, generating an Excel table, and sorting the vendor information as follows:
；
in the formula ,finishing function representing vendor information, +.>Vendor name representing consumable,/>Vendor contacts representing consumables, +.>Representing the price of the purchase of the consumable,/->Representing vendor reliability +.>Representing a predetermined delivery time of the consumable, +.>Representing the actual delivery time of the consumable, +.>Representing the number of transactions of the consumable, +.>Representing the return times of the consumable;
wherein the vendor reliabilityThe judgment criteria of (2) are as follows:
if the delivery of the consumable is timely and the quality is good, the reliability of the supplier is highest;
if the delivery of the consumable is timely and of medium quality, the supplier reliability is high;
if the delivery of the consumable is timely and the quality is poor, the reliability of the supplier is medium;
if the delivery of the consumable is not timely and the quality is good, the reliability of the supplier is medium;
if the delivery of the consumable is not timely and of medium quality, the supplier reliability is low;
If the delivery of the consumable is not timely and the quality is poor, the reliability of the supplier is the lowest;
the judgment standard of whether the delivery time of the consumable is timely or not is as follows:
if it isThe delivery is indicated to be in time;
if it isIndicating that delivery is not timely;
wherein, the formula of calculation of the quality of consumptive material is:
；
in the formula ,representing the number of transactions of the consumable, +.>Representing the return times of the consumable;
the quality judgment standard of the consumable is as follows:
if it isThe quality of consumable materials is good;
if it isThe quality of the consumable is described as medium;
if it isThe quality of the consumable is poor;
the order inventory interconnection comprises recorded order information and inventory information, and the function expression of the recorded order information is as follows:
；
in the formula ,record function representing order information +.>Representing order number->Representing the approval of the order->Indicating the stock quantity of the consumable material,/->A lowest inventory warning line representing a consumable, +.>Representing the replenishment quantity of consumable supplies->Representing the price of the purchase of the consumable,/->Representing a retail price of the consumable;
wherein whenDuring the time, the amount of the goods is added>The calculation formula of (2) is +.>When->During the time, the amount of the goods is added>The calculation formula of (2) is +.>；
in the formula ,represents rounding the number in the brackets, < >>Indicating the stock quantity of the consumable material,/- >A lowest inventory warning line representing a consumable, +.>Representing the price of the purchase of the consumable,/->Representing the retail price of the consumable.
In a specific application, the name of a provider purchasing an interdental brush is a doctor-express large pharmacy flagship store, the provider contact of the consumable is Li Xiaojie, the incoming price of the consumable is 53.6 yuan, the scheduled delivery time of the consumable is 2021, 12 months and 27 days, the actual delivery time of the consumable is 2021, 12 months and 25 days, the number of times of delivery of the consumable is 16, the number of times of return of the consumable is 4, and the provider delivery time can be judged according to the judgment standard of whether delivery is in time or not, andthe consumable material has good quality, and according to the judgment standard of the reliability of the suppliers, the reliability of the suppliers in the doctor-quick doctor-gram large pharmacy flagship is comprehensively seen to be the highest, and the sorted function expression is +.>One patient uses one box of teethBrushing, generating order number of +.>The order approval is a doctor of king, the stock quantity of the consumable is 50, the lowest stock guard line of the consumable is 30, and the consumable is not less than the lowest stock guard line, so that the replenishment is not needed, and the recorded function expression is +.>。
S5, comprehensive data analysis is conducted on the order information and the inventory information.
The data analysis comprises analysis, prediction and optimization of inventory conditions, and the random forest and big data analysis technology is utilized to predict and optimize the inventory conditions, so that waste and unbalance of supply and demand caused by too much or too little inventory are avoided, and fine management is realized;
the data analysis step includes:
s1, collecting and arranging order information of consumable materials, inventory information of the consumable materials and other information of the consumable materials, including names, categories, specifications, order quantity, inventory quantity, replenishment period, supplier reliability and inventory cost, and forming an information set;
the replenishment period is determined by the stock quantity of the consumable and the lowest inventory warning line of the consumable, and if the stock quantity of the consumable is smaller than the lowest inventory warning line of the consumable, replenishment is needed, and the replenishment period is the time from the last replenishment to the last replenishment;
the inventory cost comprises storage cost, risk cost and fund cost, wherein the storage cost refers to actual cost related to inventory storage and maintenance, the actual cost comprises storage cost, equipment maintenance cost and manpower resource cost, the risk cost refers to potential risks brought by the inventory, the potential risks comprise expiration loss, consumable damage and the like, and the fund cost refers to the fund occupied by inventory consumables can not be used for other investment activities;
Importing order information in the order management module and inventory information in the inventory management module and other information into an Excel table, and arranging the information into an information set, wherein the information comprises information of names, categories, specifications, order quantity, inventory quantity, replenishment period, supplier reliability and inventory cost;
s2, selecting order quantity, stock quantity, replenishment period, supplier reliability and stock cost from the information set as feature selection;
selecting proper characteristics as characteristic selection, quantifying data in the information set, wherein the order quantity, the stock quantity, the replenishment period, the supplier reliability and the stock cost have great influence on the stock condition in the information set, and the quantified rules are as follows: classification is divided into 1 and 2, wherein 1 represents low-value consumables in classification, and 2 represents high-value consumables in classification; the specification is divided into 1 and 2, wherein 1 represents the specification as common use, and 2 represents the specification as special use; the order quantity is divided into 1, 2 and 3, wherein 1 represents that the order quantity is reduced, 2 represents that the order quantity is unchanged, and 3 represents that the order quantity is increased; the stock quantity is divided into 1, 2 and 3,1 means that the stock quantity is reduced, 2 means that the stock quantity is unchanged, and 3 means that the stock quantity is increased; the replenishment period is divided into 1, 2 and 3, wherein 1 represents that the replenishment period is shortened, 2 represents that the replenishment period is unchanged, and 3 represents that the replenishment period is prolonged; the supplier reliability is divided into 1, 2, 3, 4 and 5,1 means that the supplier reliability is the lowest, 2 means that the supplier reliability is low, 3 means that the supplier reliability is medium, 4 means that the supplier reliability is high, 5 means that the supplier reliability is the highest; inventory costs are divided into 1, 2 and 3,1 indicating a decrease in inventory cost, 2 indicating a constant inventory cost, and 3 indicating an increase in inventory cost; the inventory conditions are divided into 1, 2 and 3, wherein 1 represents that the inventory condition is reduced inventory, 2 represents that the inventory condition is unchanged, and 3 represents that the inventory condition is increased inventory;
Finishing the quantization end into an Excel table, and calculating a characteristic weight value of data in the Excel table by using SPSS data analysis software, wherein the obtained result is shown in the following table, wherein the proportion of stock is 28.77%, the weight of the characteristic is highest, the characteristic plays a key role in constructing a random forest model, the proportion of stock cost is 21.68%, the importance of the characteristic is inferior, the characteristic plays an important role in constructing the random forest model, the proportion of order quantity is 18.26%, the proportion of replenishment period is 16.79%, and the proportion of supplier reliability is 14.5%;
s3, preprocessing the collected and tidied information set, including deleting repeated information, filling in missing information and modifying abnormal information;
inquiring whether two rows of duplicate information are identical in the Excel table, deleting one row if the duplicate information is identical, inquiring whether a blank value exists in one row in the Excel table, supplementing the blank value if the blank value exists, inquiring whether abnormal information exists in the Excel table, and modifying the abnormal information if the abnormal information exists;
s4, constructing a random forest model;
the feature selection comprises order quantity, stock quantity, replenishment period, supplier reliability and inventory cost, and decision tree construction is respectively carried out on the order quantity, stock quantity, replenishment period, supplier reliability and inventory cost, wherein the increase or decrease of the order quantity is considered from five aspects of whether seasonal factors exist, oral health consciousness exist, public praise and marketing exist, accessibility strength and service range and quality strength, the increase or decrease of the stock quantity is considered from five aspects of whether seasonal factors exist, whether the supplier has reliability, whether the consumable validity period is reasonable, whether the inventory management strategy is reasonable and the requirement fluctuation is increased or decreased, the extension or shortening of the replenishment cycle is considered from five aspects of increasing or reducing the demand fluctuation, whether the supplier has reliability, whether seasonal factors exist, whether the product validity period is reasonable, and whether the inventory cost increases or reduces, whether the supplier has reliability is considered from five aspects of whether the delivery timeliness, the product quality is strong or weak, whether the supply stability exists, the reputation of the supplier is strong or weak, and the after-sales service strength, and the increase or reduction of the inventory cost is considered from five aspects of increasing or reducing the inventory quantity, the inventory turnover rate, the purchase cost, the reliability of the supplier and the increase or reduction of the demand fluctuation, and a random forest model with the function of predicting the inventory situation is formed by integrating five decision trees constructed according to the order quantity, the inventory quantity, the replenishment cycle, the reliability of the supplier and the inventory cost, as shown in fig. 3;
S5, predicting the inventory condition of the consumable;
the constructed random forest model makes decisions of order quantity or increase or decrease, stock quantity or increase or decrease, replenishment period or decrease or prolongation, supplier or reliable or medium reliable or unreliable, stock cost or increase or decrease from the five aspects of order quantity, stock quantity, replenishment period, supplier reliability and stock cost respectively, and then makes decisions of stock reduction, stock invariance or stock increase for stock conditions comprehensively;
in specific application, due to the fact that marketing is successful near holidays and public oral health consciousness is improved, service quality is good, order quantity is increased, a high-value consumable exists for increasing consumption of consumable materials, the consumption of the high-value consumable materials is increased, stock quantity is reduced, replenishment is needed to be carried out for guaranteeing the consumption of the high-value consumable materials, replenishment period is shortened, a supplier is selected for replenishment, the delivery of the supplier is timely, the product quality is good, the reputation of the supplier is good, after-sale service is moderate, but purchase price may be expensive, data can be quantified firstly from the description, the type is 2, the specification is 2, the order quantity is 3, the stock quantity is 1, the replenishment period is 1, the reliability of the supplier is 2, the stock cost is 1, and the quantified data is input into a random forest model to obtain the stock of consumable materials with the high value which should be added to the clinic;
S6, evaluating by using a random forest model;
integrating the inventory situation result predicted by the random forest model into the last column of an Excel table comprising names, categories, specifications, inventory quantity, replenishment period, supplier reliability and inventory cost, and calculating the accuracy rate and recall rate of the random forest model by using a random forest method in SPSS data analysis software, wherein the calculation formula of the accuracy rate is as follows:
;
wherein, the prediction result is positive and the prediction is correct, and the prediction result is positive and the prediction is incorrect;
the calculation formula of the recall rate is as follows:
；
wherein, the prediction result is positive and the prediction is correct, and the prediction result is negative and the prediction is incorrect;
in a specific application, 1000 pieces of data are included in the information set, 320 pieces of data are included in the inventory situation, wherein the predicted result is positive, 150 pieces of data are included in the predicted correct data, the predicted result is positive, 10 pieces of data are included in the predicted incorrect data, 9 pieces of data are included in the predicted incorrect data, the predicted result is negative, and 141 pieces of data are included in the predicted correct data; the stock condition is that 360 pieces of data exist, the prediction result is positive, 130 pieces of data are predicted correctly, the prediction result is positive, 10 pieces of data are predicted incorrectly, the prediction result is negative, and 110 pieces of data are predicted correctly; the stock condition is that 320 pieces of data are added, the prediction result is positive, 5 pieces of data are predicted correctly, the prediction result is negative, 16 pieces of data are predicted incorrectly, the prediction result is negative, and 154 pieces of data are predicted correctly; the inventory condition is that the accuracy rate calculation result of the inventory reduction is 0.9375, the recall rate calculation result of the inventory reduction is 0.9434, the inventory condition is that the accuracy rate calculation result of the inventory invariance is 0.9286, the recall rate calculation result of the inventory invariance is 0.9286, the accuracy rate calculation result of the inventory increase is 0.9667, the recall rate calculation result of the inventory increase is 0.9006, the comprehensive accuracy rate is 0.9443, the comprehensive recall rate is 0.9242, and the construction success of the random forest model can be determined by combining the accuracy rate and the recall rate;
S7, predicting and visualizing the inventory condition of the consumable.
The inventory condition predicted by the random forest model can know the inventory management strategy required by each consumable, combines the category with the inventory condition according to the rule of hierarchical classification by the category to obtain a scatter diagram, summarizes and obtains the inventory of the oral examination consumable, the oral hygiene consumable and the common oral equipment required by the oral clinic, reduces the inventory of the dental implant consumable and the dental image consumable, and keeps the inventory of the periodontal treatment consumable, the dental operation consumable and the dental restoration consumable unchanged.
Example 2
This embodiment provides a cloud computing-based oral clinic warehouse management system according to a second embodiment of the present invention, and a system block diagram is shown in fig. 4:
the system comprises a classification management module, an inventory management module, an order management module and a data analysis module;
placing an oral clinic warehouse management system based on cloud computing in a private cloud platform to realize classification of warehouse consumables, management of inventory, management of orders and data analysis of inventory conditions;
the classification management module utilizes a consumable identification model to identify and classify consumable, the inventory management module carries out statistics, intelligent management and real-time monitoring on classified consumable, automatic management and monitoring are realized by utilizing the monitoring and alarming functions of the cloud platform, inventory efficiency is improved, the order management module associates order information with the inventory management module, and the data analysis module analyzes, predicts and optimizes the inventory condition.
Example 3
The present embodiment provides an oral cavity clinic warehouse management device based on cloud computing, including a storage medium and a processor, where the storage medium is used to store operation instructions, and the processor executes the operation instructions to implement an oral cavity clinic warehouse management method based on cloud computing, and the storage medium may include: various media capable of storing program codes, such as a U disk, a mobile hard disk, a read-only memory, a random access memory, a magnetic disk or an optical disk.
It should be noted that the above embodiments are only for illustrating the technical solution of the present invention and not for limiting the same, and although the present invention has been described in detail with reference to the preferred embodiments, it should be understood by those skilled in the art that the technical solution of the present invention may be modified or substituted without departing from the spirit and scope of the technical solution of the present invention, which is intended to be covered in the scope of the claims of the present invention.
Claims (12)
1. The oral cavity clinic warehouse management method based on cloud computing is characterized by comprising the following steps of: comprising the following steps:
performing consumable identification;
performing consumable classification by using a consumable identification model and a hierarchical classification rule;
performing intelligent management on the classified consumables, and performing real-time monitoring;
Associating order information with inventory information to manage orders;
and (5) carrying out comprehensive data analysis on the order information and the inventory information.
2. The cloud computing-based oral clinic warehouse management method as claimed in claim 1, wherein: the consumable identification comprises consumable collection and preprocessing, consumable identification model construction, consumable identification model training and consumable identification model evaluation;
the consumable collection and preprocessing comprises collecting image information of consumable, recording name, category and specification information of the consumable, forming a consumable set, then performing image scaling, clipping and graying on the image information, forming an image pixel value set, and performing normalization processing, wherein the calculation formula of the normalization processing is as follows:
；
in the formula ,representing the +.>Normalized value of seed consumable,/>Indicate->Consumable supplies->Indicate->Image pixel value of the seed consumable, +.>、/>Respectively representing the maximum value and the minimum value in the image pixel point value set.
3. The cloud computing-based oral clinic warehouse management method as claimed in claim 2, wherein: the consumable identification model is a model constructed by means of a support vector machine, and comprises the following components: combining the image pixel point value set and the consumable set to form a data set, dividing the data set into a 75% training set and a 25% testing set, and constructing the consumable identification model according to the following formula:
；
in the formula ,predictive data representing the identification of consumables, +.>Indicate->Consumable supplies->Representing the total number of sets of image pixel values, and (2)>Represents the Lagrangian multiplier, +.>Classification label representing said set of image pixel values,/->Representing a kernel function->Represents the offset +.>Representing a superparameter for controlling the offset;
wherein ,the calculation formula of (2) is +.>When->Time indicates +.>The species consumable is a low-value consumable, when +.>Time indicates +.>The seed consumable is a high-value consumable, ">Formula of (2)Is->，/>Indicate->Image pixel value of the seed consumable, +.>Representing new image pixel values.
4. The cloud computing-based oral clinic warehouse management method as claimed in claim 3, wherein: the consumable identification model further comprises: the low-value consumable and the high-value consumable are identified and then classified in layers, the class of the consumable in the consumable set is selected as a classification characteristic, and the hierarchical classification rule of the low-value consumable is as follows:
if the description of the category is examination, classifying the oral examination consumable;
if the description of the category is cleaning, classifying the category as periodontal treatment consumable;
if the description of the category is sanitary, classifying the category as oral hygiene consumable;
The hierarchical classification rule of the high-value consumable is as follows:
if the description of the category is surgery, classifying the category as dental surgery consumable;
if the description of the category is repair, classifying the dental repair consumable;
if the description of the category is planting, classifying the category as dental planting consumables;
and if the description of the category is an image, classifying the image as dental image consumable.
5. The cloud computing-based oral clinic warehouse management method as claimed in claim 4, wherein: training the consumable identification model through a training function, wherein the calculation formula of the training function is as follows:
；
in the formula ,representing the calculated value of said training function, +.>Indicate->Consumable supplies->Representing the total number of sets of image pixel values, and (2)>Indicate->Tag of seed consumable->The identification of the consumable is correctly 1 +.>The identification error of the seed consumable is 0, < >>Indicate->The probability of correct material supply prediction;
evaluating the consumable identification model through an evaluation function, wherein the calculation formula of the evaluation function is as follows:
；
in the formula ,representing the calculated value of said evaluation function, +.>Predictive data representing the identification of consumables, +.>Raw data representing consumable identification, +.>Representing the mean of raw data of consumable identification.
6. The cloud computing-based oral clinic warehouse management method as claimed in claim 5, wherein: the intelligent management comprises counting consumable parts in a warehouse, and a form is generated, wherein the form comprises consumable part information, inventory information and supplier information, and functions of the consumable parts in the warehouse are as follows:
；
in the formula ,a statistical function representing said consumable, +.>A unique identifier representing said consumable, +.>Name representing the consumable->Representing the class of the consumable,/->The specification information of the consumable material comprises common and special specification information>Representing the stock quantity of said consumable, +.>Representing the position of the consumable,/->Indicating the time of warehousing of said consumables, +.>Representing the time of delivery of said consumable, +.>Representing the price of the purchase of the consumable>Representing the retail price of said consumable, +.>A lowest inventory warning line representing said consumable, < >>Representing the date of production of said consumable, +.>Indicating the shelf life of said consumable, +.>A vendor name representing the consumable, +.>A vendor contact representing the consumable;
wherein ,the functional expression of (2) is +.>；
in the formula ,representing the class of the consumable,/- >Indicating the frequency of use of said consumable, +.>Representing the warehousing time of the consumable;
wherein ,the calculation formula of (2) is +.>；
in the formula ,indicating that the content in the brackets is counted;
the placement rule of the positions of the consumable materials is as follows:
if it isFor the low value consumable, then +.>Placing the materials in a material rack or a material cabinet;
the material rack is a two-layer trolley, the consumable cabinet comprises an upper consumable cabinet, a middle consumable cabinet and a lower consumable cabinet, the upper consumable cabinet is provided with three layers, the middle consumable cabinet is provided with five layers, and the lower consumable cabinet is provided with two layers;
if it isPlacing the low-value consumable on the upper layer of the object rack;
if it isPlacing the low-value consumable on the lower layer of the object rack;
if it isPlacing the low-value consumable on the upper two layers of the middle consumable cabinet of the consumable cabinet;
if it isFor the high value consumable, then +.>Placing the materials into a consumable cabinet;
if it isPlacing the high-value consumable in the lower three layers of the middle consumable cabinet of the consumable cabinet;
if it isPlacing the high-value consumable in an upper consumable cabinet of the consumable cabinet;
if it isPlacing the high-value consumable in a lower consumable cabinet of the consumable cabinet;
if it isIf the requirements of refrigeration and sterility are met, placing the consumable material into a special refrigeration and sterility area;
And placing the low-value consumable and the high-value consumable according to the warehousing time, wherein the low-value consumable and the high-value consumable are placed in front of the consumable in a warehousing mode, and the high-value consumable and the consumable are placed in back of the consumable in a warehousing mode.
7. The cloud computing-based oral clinic warehouse management method as claimed in claim 6, wherein: the real-time monitoring comprises inventory warning line reminding and consumable acceptance and expiration monitoring, and the real-time monitoring flow is as follows:
monitoring whether the inventory of the consumable is less than the minimum inventory fence;
if the stock quantity of the consumable is smaller than the lowest stock warning line, the system alarms to prompt that the replenishment operation is needed;
if the stock quantity of the consumable is greater than or equal to the lowest stock warning line, ending the monitoring flow;
the replenishment operation automatically generates a stock list according to the stock quantity of the consumable and the supplier information, sends the stock list to a designated supplier, and orders and notifies the supplier to deliver;
the suppliers are specified suppliers extracted from the supplier information;
checking the production date of the consumable and the quality guarantee period of the consumable;
rejecting by an acceptance person if the shelf life is more than two years and the time from the date of manufacture at acceptance exceeds 30% of the shelf life;
If the shelf life is more than two years and the time from the production date at the time of acceptance is not more than 30% of the shelf life, receiving the consumable by an acceptance person and executing the intelligent management;
rejecting by an acceptance person if the shelf life is less than two years and the time from the date of manufacture at acceptance exceeds 10% of the shelf life;
if the quality guarantee period is less than two years and the time from the production date is not more than 10% of the quality guarantee period during acceptance, receiving the consumable by an acceptance person and executing the intelligent management;
and if the shelf life is up, destroying the consumable.
8. The cloud computing-based oral clinic warehouse management method as claimed in claim 7, wherein: the order management comprises supplier management and order inventory interconnection;
the provider management comprises the steps of sorting the provider information, generating an Excel table, and sorting the function expression of the provider information as follows:
；
in the formula ,finishing function representing said supplier information, < >>A vendor name representing the consumable, +.>A supplier contact representing said consumable, < >>Representing the price of the purchase of the consumable>Representing vendor reliability +. >Representing a predetermined delivery time of said consumable, < >>Representing the actual delivery time of said consumable, < >>Representing the number of deals of the consumable,representing the return times of the consumable;
wherein the vendor reliabilityThe judgment criteria of (2) are as follows:
if the delivery of the consumable is timely and the quality is good, the reliability of the supplier is highest;
if the delivery of the consumable is timely and of medium quality, the supplier reliability is high;
if the delivery of the consumable is timely and the quality is poor, the reliability of the supplier is medium;
if the delivery of the consumable is not timely and the quality is good, the reliability of the supplier is medium;
if the delivery of the consumable is not timely and of medium quality, the supplier reliability is low;
if the delivery of the consumable is not timely and the quality is poor, the reliability of the supplier is the lowest;
the judgment standard of whether the delivery time of the consumable is timely or not is as follows:
if it isThe delivery is indicated to be in time;
if it isIndicating that delivery is not timely;
wherein, the formula of calculation of the quality of consumptive material is:
；
in the formula ,representing the number of transactions of said consumable, +.>Representing the return times of the consumable;
the quality judgment standard of the consumable is as follows:
If it isThe quality of the consumable is good;
if it isThe quality of the consumable is stated to be medium;
if it isAnd the quality of the consumable is poor.
9. The cloud computing-based oral clinic warehouse management method as claimed in claim 8, wherein: the order inventory interconnection comprises order information and inventory information, and a function expression for recording the order information is as follows:
；
in the formula ,recording function representing said order information, +.>Representing order number->Representing the approval of the order->Representing the stock quantity of said consumable, +.>A lowest inventory warning line representing said consumable, < >>Representing the replenishment quantity of the consumable material, +.>Representing the price of the purchase of the consumable>Representing a retail price of the consumable;
wherein whenDuring the time, the amount of the goods is added>The calculation formula of (2) is +.>When (when)During the time, the amount of the goods is added>The calculation formula of (2) is +.>；
in the formula ,represents rounding the number in the brackets, < >>Representing the stock quantity of said consumable, +.>A lowest inventory warning line representing said consumable, < >>Representing the price of the purchase of the consumable>Representing the retail price of the consumable.
10. The cloud computing-based oral clinic warehouse management method as claimed in claim 9, wherein: the data analysis includes analyzing, predicting and optimizing inventory conditions;
The data analysis step includes:
s1, collecting and arranging order information of the consumable materials, inventory information of the consumable materials and other information of the consumable materials, wherein the order information comprises names, categories, specifications, order quantity, inventory quantity, replenishment period, supplier reliability and inventory cost, and an information set is formed;
s2, selecting order quantity, stock quantity, replenishment period, supplier reliability and stock cost from the information set as feature selection;
s3, preprocessing the collected and tidied information set, including deleting repeated information, filling in missing information and modifying abnormal information;
s4, constructing a random forest model;
s5, predicting the inventory condition of the consumable;
s6, evaluating by using a random forest model;
s7, predicting and visualizing the inventory condition of the consumable.
11. An oral clinic warehouse management system based on cloud computing, which is realized based on the oral clinic warehouse management method based on cloud computing as claimed in any one of claims 1-10, and is characterized in that: the system comprises:
the system comprises a classification management module, an inventory management module, an order management module and a data analysis module;
the sorting management module utilizes a consumable identification model to identify and sort consumable, the inventory management module carries out statistics, intelligent management and real-time monitoring on the sorted consumable, the order management module associates order information with the inventory management module, and the data analysis module analyzes, predicts and optimizes the inventory condition.
12. Oral cavity clinic storehouse management device based on cloud calculates, its characterized in that: comprising a storage medium for storing operational instructions for implementing the cloud computing-based oral clinic library management method of any one of claims 1-10, and a processor executing the operational instructions.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202310997688.4A CN116957475B (en) | 2023-08-09 | 2023-08-09 | Cloud computing-based oral cavity clinic warehouse management method, system and device |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202310997688.4A CN116957475B (en) | 2023-08-09 | 2023-08-09 | Cloud computing-based oral cavity clinic warehouse management method, system and device |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN116957475A true CN116957475A (en) | 2023-10-27 |
| CN116957475B CN116957475B (en) | 2024-06-21 |
Family
ID=88456584
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202310997688.4A Active CN116957475B (en) | 2023-08-09 | 2023-08-09 | Cloud computing-based oral cavity clinic warehouse management method, system and device |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN116957475B (en) |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN117635983A (en) * | 2024-01-26 | 2024-03-01 | 江南大学附属医院 | Medical consumable warehousing management method, device, equipment and medium |
Citations (16)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN107230033A (en) * | 2017-06-07 | 2017-10-03 | 北京矩阵魔方网络科技有限公司 | A kind of stock's pre-warning management system and its method based on data analysis technique |
| CN109460702A (en) * | 2018-09-14 | 2019-03-12 | 华南理工大学 | Passenger's abnormal behaviour recognition methods based on human skeleton sequence |
| CN109784800A (en) * | 2018-06-01 | 2019-05-21 | 太仓市第一人民医院 | Low-cost medical consumables three-level treasury management system and its working method under SPD mode |
| CN110349190A (en) * | 2019-06-10 | 2019-10-18 | 广州视源电子科技股份有限公司 | Target tracking method, device and equipment for adaptive learning and readable storage medium |
| CN111832984A (en) * | 2020-05-27 | 2020-10-27 | 福建亿能达信息技术股份有限公司 | High-value consumable management system |
| CN113935831A (en) * | 2021-09-29 | 2022-01-14 | 光大科技有限公司 | Trusted product pricing method and device, storage medium and electronic device |
| CN114021757A (en) * | 2022-01-05 | 2022-02-08 | 天津医药集团众健康达医疗器械有限公司 | High-value disposable consumable management method and system based on SPD mode |
| CN114021801A (en) * | 2021-10-29 | 2022-02-08 | 中国计量大学 | Multi-objective optimization management method for standard substances |
| WO2022074988A1 (en) * | 2020-10-05 | 2022-04-14 | 友規 各務 | Inventory management system, inventory management method, and inventory management program |
| US20230004581A1 (en) * | 2021-06-29 | 2023-01-05 | Naver Corporation | Computer-Implemented Method for Improving Classification of Labels and Categories of a Database |
| CN115966293A (en) * | 2023-02-02 | 2023-04-14 | 辉岭加拿大有限公司 | Software and hardware cooperative algorithm for realizing automatic replenishment of in-vitro diagnostic reagent VMI |
| CN115985479A (en) * | 2023-03-20 | 2023-04-18 | 南京沃德睿医疗科技有限公司 | RFID medical consumable intelligent goods shelf warehousing management system, method and device |
| CN116130069A (en) * | 2023-01-16 | 2023-05-16 | 中实医疗科技江苏有限公司 | Inventory management system for medical laboratory |
| CN116230191A (en) * | 2023-05-08 | 2023-06-06 | 深圳市普朗医疗科技发展有限公司 | Intelligent management method and system for infusion medical consumables |
| EP4194107A1 (en) * | 2021-12-10 | 2023-06-14 | Fraunhofer-Gesellschaft zur Förderung der angewandten Forschung e.V. | Apparatus and method for classifying material objects |
| US20230237346A1 (en) * | 2020-09-18 | 2023-07-27 | Tbo Healthcare Co., Ltd. | Integrated hospital logistics management system using ai technology, and integrated hospital logistics management method using same |
-
2023
- 2023-08-09 CN CN202310997688.4A patent/CN116957475B/en active Active
Patent Citations (16)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN107230033A (en) * | 2017-06-07 | 2017-10-03 | 北京矩阵魔方网络科技有限公司 | A kind of stock's pre-warning management system and its method based on data analysis technique |
| CN109784800A (en) * | 2018-06-01 | 2019-05-21 | 太仓市第一人民医院 | Low-cost medical consumables three-level treasury management system and its working method under SPD mode |
| CN109460702A (en) * | 2018-09-14 | 2019-03-12 | 华南理工大学 | Passenger's abnormal behaviour recognition methods based on human skeleton sequence |
| CN110349190A (en) * | 2019-06-10 | 2019-10-18 | 广州视源电子科技股份有限公司 | Target tracking method, device and equipment for adaptive learning and readable storage medium |
| CN111832984A (en) * | 2020-05-27 | 2020-10-27 | 福建亿能达信息技术股份有限公司 | High-value consumable management system |
| US20230237346A1 (en) * | 2020-09-18 | 2023-07-27 | Tbo Healthcare Co., Ltd. | Integrated hospital logistics management system using ai technology, and integrated hospital logistics management method using same |
| WO2022074988A1 (en) * | 2020-10-05 | 2022-04-14 | 友規 各務 | Inventory management system, inventory management method, and inventory management program |
| US20230004581A1 (en) * | 2021-06-29 | 2023-01-05 | Naver Corporation | Computer-Implemented Method for Improving Classification of Labels and Categories of a Database |
| CN113935831A (en) * | 2021-09-29 | 2022-01-14 | 光大科技有限公司 | Trusted product pricing method and device, storage medium and electronic device |
| CN114021801A (en) * | 2021-10-29 | 2022-02-08 | 中国计量大学 | Multi-objective optimization management method for standard substances |
| EP4194107A1 (en) * | 2021-12-10 | 2023-06-14 | Fraunhofer-Gesellschaft zur Förderung der angewandten Forschung e.V. | Apparatus and method for classifying material objects |
| CN114021757A (en) * | 2022-01-05 | 2022-02-08 | 天津医药集团众健康达医疗器械有限公司 | High-value disposable consumable management method and system based on SPD mode |
| CN116130069A (en) * | 2023-01-16 | 2023-05-16 | 中实医疗科技江苏有限公司 | Inventory management system for medical laboratory |
| CN115966293A (en) * | 2023-02-02 | 2023-04-14 | 辉岭加拿大有限公司 | Software and hardware cooperative algorithm for realizing automatic replenishment of in-vitro diagnostic reagent VMI |
| CN115985479A (en) * | 2023-03-20 | 2023-04-18 | 南京沃德睿医疗科技有限公司 | RFID medical consumable intelligent goods shelf warehousing management system, method and device |
| CN116230191A (en) * | 2023-05-08 | 2023-06-06 | 深圳市普朗医疗科技发展有限公司 | Intelligent management method and system for infusion medical consumables |
Non-Patent Citations (4)
| Title |
|---|
| 安志伟 等: "基于UNet++卷积神经网络的断层识别", 《HTTPS://DOI.ORG/10.19292/J.CNKI.JDXXP.20230707.002》, pages 1 - 12 * |
| 林皓 等: "基于深度学习的铁路路基雷达检测信号中强干扰压制方法研究", 《HTTP://KNS.CNKI.NET/KCMS/DETAIL/11.2982.P.20230613.1523.018.HTML》, pages 1 - 11 * |
| 盛永健 等: "基于改进卷积神经网络的燃气调压器故障识别研究", 《现代制造工程》, no. 04, pages 132 - 138 * |
| 马君亮: "基于图的半监督分类算法研究", 《中国博士学位论文全文数据库基础科学辑》, no. 01, pages 002 - 51 * |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN117635983A (en) * | 2024-01-26 | 2024-03-01 | 江南大学附属医院 | Medical consumable warehousing management method, device, equipment and medium |
| CN117635983B (en) * | 2024-01-26 | 2024-04-05 | 江南大学附属医院 | Medical consumable warehousing management method, device, equipment and medium |
Also Published As
| Publication number | Publication date |
|---|---|
| CN116957475B (en) | 2024-06-21 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US20090182594A1 (en) | System and method to manage assets of healthcare facility | |
| CA2779034C (en) | High-risk procurement analytics and scoring system | |
| US8069101B1 (en) | Financial methodology to valuate and predict the news impact of major events on financial instruments | |
| CN108960741B (en) | Stock management system for spare parts of nuclear power station group plant | |
| CN109117990B (en) | Nuclear power station spare part inventory prediction and index decomposition device | |
| CN116957475B (en) | Cloud computing-based oral cavity clinic warehouse management method, system and device | |
| US8103539B2 (en) | Sample store forecasting process and system | |
| US20060178955A1 (en) | System and method for product imputation relating to sample stores | |
| CN111882420A (en) | Generation method of response rate, marketing method, model training method and device | |
| Cheng et al. | Intermittent demand forecasting in a tertiary pediatric intensive care unit | |
| CN116308470B (en) | Store commodity expiration date full life cycle management system based on data analysis | |
| Patra et al. | A two-period newsvendor model for prepositioning with a post-disaster replenishment using Bayesian demand update | |
| CN118229338A (en) | Furniture part sales supply platform based on Internet of things | |
| CN113837701A (en) | Storage supervisory systems based on RFID label | |
| Rauliajtys-Grzybek et al. | Cost accounting in public hospitals in Poland: Usefulness for internal and external purposes | |
| CN111339389A (en) | Early warning method and system for identifying online store transfer | |
| CN114119237A (en) | Method and device for screening pension products | |
| CN113850609A (en) | Customer management system, method, computer equipment and storage medium | |
| JP6907099B2 (en) | Information processing equipment, information processing methods and programs | |
| US10636521B1 (en) | Blood marketplace system and method | |
| Bieler et al. | Incorporating medical claims data in the Consumer Price Index | |
| CN113628717B (en) | Medical article management data calculation method and device | |
| CN117273615B (en) | Intelligent medicine sales data management system | |
| KR102494168B1 (en) | Method and apparatus for managing stock | |
| Gusliana et al. | Determination of Community-Based Health Microinsurance Premiums Based on Health Costs |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |