CN115510145A - Chemical storage cabinet management and control system based on raspberry group and cloud server - Google Patents
Chemical storage cabinet management and control system based on raspberry group and cloud server Download PDFInfo
- Publication number
- CN115510145A CN115510145A CN202211478952.5A CN202211478952A CN115510145A CN 115510145 A CN115510145 A CN 115510145A CN 202211478952 A CN202211478952 A CN 202211478952A CN 115510145 A CN115510145 A CN 115510145A
- Authority
- CN
- China
- Prior art keywords
- management
- chemical
- module
- cloud server
- raspberry
- 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.)
- Pending
Links
- 239000000126 substance Substances 0.000 title claims abstract description 136
- 238000003860 storage Methods 0.000 title claims abstract description 89
- 240000007651 Rubus glaucus Species 0.000 title claims abstract description 60
- 235000011034 Rubus glaucus Nutrition 0.000 title claims abstract description 60
- 235000009122 Rubus idaeus Nutrition 0.000 title claims abstract description 60
- 238000011161 development Methods 0.000 claims abstract description 47
- 230000002159 abnormal effect Effects 0.000 claims abstract description 29
- 238000001514 detection method Methods 0.000 claims abstract description 26
- 230000003993 interaction Effects 0.000 claims abstract description 19
- 230000005540 biological transmission Effects 0.000 claims abstract description 9
- 238000013136 deep learning model Methods 0.000 claims abstract description 9
- 238000005516 engineering process Methods 0.000 claims abstract description 4
- 238000012544 monitoring process Methods 0.000 claims description 7
- 238000005303 weighing Methods 0.000 claims description 7
- 238000012549 training Methods 0.000 claims description 3
- 230000004927 fusion Effects 0.000 claims description 2
- 238000005457 optimization Methods 0.000 claims description 2
- 238000013526 transfer learning Methods 0.000 claims description 2
- 238000011160 research Methods 0.000 abstract description 3
- 238000000034 method Methods 0.000 description 9
- 230000006870 function Effects 0.000 description 6
- 230000008569 process Effects 0.000 description 6
- 238000010586 diagram Methods 0.000 description 5
- 206010000117 Abnormal behaviour Diseases 0.000 description 4
- 238000012546 transfer Methods 0.000 description 4
- 239000003814 drug Substances 0.000 description 3
- 230000006855 networking Effects 0.000 description 3
- 238000012545 processing Methods 0.000 description 3
- 238000004458 analytical method Methods 0.000 description 2
- 238000004422 calculation algorithm Methods 0.000 description 2
- 230000005059 dormancy Effects 0.000 description 2
- 230000007613 environmental effect Effects 0.000 description 2
- 238000012795 verification Methods 0.000 description 2
- 239000002253 acid Substances 0.000 description 1
- 150000007513 acids Chemical class 0.000 description 1
- 230000004913 activation Effects 0.000 description 1
- 230000009286 beneficial effect Effects 0.000 description 1
- 238000004364 calculation method Methods 0.000 description 1
- 231100000481 chemical toxicant Toxicity 0.000 description 1
- 238000004891 communication Methods 0.000 description 1
- 238000010276 construction Methods 0.000 description 1
- 238000013527 convolutional neural network Methods 0.000 description 1
- 238000001816 cooling Methods 0.000 description 1
- 230000007797 corrosion Effects 0.000 description 1
- 238000005260 corrosion Methods 0.000 description 1
- 238000005265 energy consumption Methods 0.000 description 1
- 238000004880 explosion Methods 0.000 description 1
- 239000002360 explosive Substances 0.000 description 1
- 208000015181 infectious disease Diseases 0.000 description 1
- 230000010365 information processing Effects 0.000 description 1
- 238000004519 manufacturing process Methods 0.000 description 1
- 231100000572 poisoning Toxicity 0.000 description 1
- 230000000607 poisoning effect Effects 0.000 description 1
- 238000011897 real-time detection Methods 0.000 description 1
- 238000004064 recycling Methods 0.000 description 1
- 230000008054 signal transmission Effects 0.000 description 1
- 239000003440 toxic substance Substances 0.000 description 1
- 238000009423 ventilation Methods 0.000 description 1
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/25—Integrating or interfacing systems involving database management systems
- G06F16/252—Integrating or interfacing systems involving database management systems between a Database Management System and a front-end application
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/28—Databases characterised by their database models, e.g. relational or object models
- G06F16/284—Relational databases
-
- 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 provisious for transferring data to distant stations, e.g. from a sensing device
-
- 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
-
- G—PHYSICS
- G16—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR SPECIFIC APPLICATION FIELDS
- G16C—COMPUTATIONAL CHEMISTRY; CHEMOINFORMATICS; COMPUTATIONAL MATERIALS SCIENCE
- G16C20/00—Chemoinformatics, i.e. ICT specially adapted for the handling of physicochemical or structural data of chemical particles, elements, compounds or mixtures
- G16C20/90—Programming languages; Computing architectures; Database systems; Data warehousing
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Databases & Information Systems (AREA)
- Business, Economics & Management (AREA)
- General Physics & Mathematics (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- Computing Systems (AREA)
- Economics (AREA)
- Data Mining & Analysis (AREA)
- Life Sciences & Earth Sciences (AREA)
- Entrepreneurship & Innovation (AREA)
- Bioinformatics & Cheminformatics (AREA)
- Crystallography & Structural Chemistry (AREA)
- Chemical & Material Sciences (AREA)
- Accounting & Taxation (AREA)
- Finance (AREA)
- Development Economics (AREA)
- Software Systems (AREA)
- Bioinformatics & Computational Biology (AREA)
- Human Resources & Organizations (AREA)
- Marketing (AREA)
- Operations Research (AREA)
- Quality & Reliability (AREA)
- Strategic Management (AREA)
- Tourism & Hospitality (AREA)
- General Business, Economics & Management (AREA)
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
The invention relates to a chemical storage cabinet management and control system based on a raspberry pi and a cloud server, which comprises a raspberry pi 4B development board 1 and a cloud server 2; the raspberry pi 4B development board 1 and the cloud server 2 are connected through a network to perform instruction transmission and data exchange; deploying a chemical safety intelligent management system 3, a deep learning model 4 and a MySQL database 5 on the cloud server 2; the intelligent chemical safety management system comprises a system management and control module 6, an abnormal condition detection module 7 and a human-computer interaction module 8. The system can realize classified storage, intelligentization and accurate management and control of dangerous chemicals, has high automation and intelligentization degrees, and can trace information; but wide application in colleges and universities, science and technology company and scientific research institute realize the standardization and intelligent management and control to dangerous chemical, reduce the accident rate that causes because of the use dangerous chemical of violating the regulations, have good popularization meaning and practical value.
Description
Technical Field
This patent belongs to chemical safety management and control technical field, concretely relates to chemical cabinet management and control system based on raspberry group and cloud ware.
Background
In order to strengthen the management of dangerous chemicals, the state provides regulations on dangerous chemical management and catalogues on dangerous chemicals. In recent years, various laboratory safety accidents happen occasionally, and loss is not measurable. Analysis of these incidents showed that the types of laboratory safety incidents were mainly fire, explosion, poisoning, infection, corrosion burn categories 5. The safety accidents of the laboratory frequently occur, and the problems that the safety responsibility is not implemented, the management system is not sound, the safety management of dangerous goods is not in place, the operation of experimenters is violated, and the safety supervision of related departments has weak links exist in the management of the laboratory are revealed. The construction of a standard dangerous chemical storage management and control system intelligently manages and controls dangerous chemicals, and is very necessary and urgent.
Therefore, aiming at the problems, a management and control system for dangerous chemical storage is urgently needed to be designed so as to meet the requirement of actual use, and the management and control system has great practical significance for solving safe storage of dangerous chemicals in a laboratory and guaranteeing the safety of the laboratory, and has wide application prospect and market value.
Disclosure of Invention
Aiming at the problems, the invention provides a chemical storage cabinet management and control system based on a raspberry group and a cloud server, which realizes intelligent and networked management and control on dangerous chemicals, meets the actual use needs and safety needs, and has great practical significance for solving the problems of dangerous chemical storage safety and use safety of colleges and universities and scientific research institutions.
A chemical storage cabinet management and control system based on a raspberry pi and a cloud server comprises a raspberry pi 4B development board and the cloud server; and the raspberry pi 4B development board and the cloud server are connected through a network to perform instruction transmission and data exchange.
And deploying a chemical safety intelligent management system, a deep learning model and a MySQL database on the cloud server.
The intelligent chemical safety management system comprises a system management and control module, an abnormal condition detection module and a man-machine interaction module.
The system management and control module comprises a user management module, a unit information management module, a chemical information management module, a storage cabinet environment information management module, a video monitoring management module, a scanning module, a weighing module, an exhaust control module, a power supply control module and a voice module.
The abnormal condition detection module comprises a chemical warehousing abnormal condition detection module, a chemical quality abnormal condition detection module and a chemical borrowing and returning record abnormal condition detection module.
The man-machine interaction module comprises a computer terminal, a mobile terminal, a cabinet screen and other operation terminals; the chemical storage cabinet is used for checking storage information, inputting instructions and controlling and managing the chemical storage cabinet in real time.
The chemical medicine storage cabinet management and control system further comprises an operation interface developed based on a PyQt5 technology, and relevant parameters of the storage cabinet, such as alarm threshold values of temperature, humidity and VOC gas concentration in the cabinet, operation time of an exhaust system, cabinet body screen dormancy time and the like, are set through the operation terminal.
In the system operation process, a terminal user accesses the chemical safety intelligent management system deployed on the cloud server through the man-machine interaction module. The method comprises the steps of firstly obtaining an IP address of a cloud server through a DNS domain name resolution protocol, and then establishing corresponding connection according to operation requirements of a user, wherein the transmission of texts, pictures, videos and control instructions can be completed through an HTTP hypertext transfer protocol and an FTP file transfer protocol. The raspberry pi 4B development board establishes network connection with the cloud server, completes interaction of data and control instructions through a TCP/IP protocol, and transmits the control instructions input by the user terminal to the raspberry pi 4B development board. Control instructions of components (such as a temperature and humidity sensor, a VOC gas sensor and the like) directly connected with the raspberry Pi 4B development board can be directly sent to the raspberry Pi 4B development board 1; the control instruction of the equipment (such as an industrial camera and a hard disk video recorder) connected with the raspberry pi 4B development board through the network needs an industrial router for forwarding. The industrial router searches for target equipment in a formed network through an ARP/RARP protocol and sends a control command to the target equipment through the network.
The invention has the following positive beneficial effects: the raspberry pi 4B development board is used as a data and instruction control center, the cloud server is used as a carrier of a system, and compared with a traditional chemical storage control facility, the raspberry pi 4B development board uses an encryption algorithm to generate a storage cabinet code and endows a unique anti-counterfeiting virtual 'identity card number' to a chemical; setting user authority and standard operation flow to ensure the storage safety and the use safety of the medicine; the chemicals are strictly stored in different storehouses and classified, so that the standard operation and mutual supervision of related personnel are ensured, and the intelligent, accurate and safe management of information traceability, management and control, summary statistics and the like of the chemicals is realized; high automation and intelligence degree, low energy consumption and low cost. The invention can be widely applied to universities, scientific and technological companies, scientific research institutions and other related application places, can realize the standardized and intelligent management and control of dangerous chemicals, ensures the storage and use safety of the dangerous chemicals, reduces the accident rate caused by illegal use of the dangerous chemicals, and has good popularization significance and practical value.
Drawings
Fig. 1 is a schematic diagram of a module structure of a chemical storage cabinet management and control system according to the present invention.
Fig. 2 is a schematic diagram of a networking mode and a work flow of the chemical storage cabinet management and control system of the present invention.
FIG. 3 is a schematic diagram of a circuit connection of the chemical cabinet management and control system of the present invention.
Fig. 4 is a schematic flow chart of the electromagnetic lock being opened and closed by the Python script in the chemical storage cabinet management and control system of the present invention.
In the figure: 1 raspberry pi 4B development board; 2, a cloud server; 3, a chemical safety intelligent management system; 4, deep learning model; 5 MySQL database; 6, a system management and control module; 6-1 user management module; 6-2 unit information management module; 6-3 chemical information management module; 6-4 storage cabinet environment information management module; 6-5 video monitoring management module; 6-6 scanning module; 6-7 weighing module; 6-8 air exhaust control modules; 6-9 a power supply control module; 6-10 voice module; 7 an abnormal condition detection module; 7-1 chemical warehousing abnormal condition detection module 7;7-2, a chemical quality abnormal condition detection module; 7-3, a detection module for borrowing and recording abnormal conditions of chemicals; 8, a human-computer interaction module; 8-1 computer terminal; 8-2 mobile terminal; 8-3 cabinet screens.
Detailed Description
In order to make the objects, technical solutions and outstanding advantages of the present invention more apparent, the following detailed description of the present invention will be made with reference to the accompanying drawings and detailed description. The module in the invention comprises components and a component management and control program combination, and can realize corresponding functions.
As shown in fig. 1, a chemical storage cabinet management and control system based on a raspberry pi and a cloud server includes a raspberry pi 4B development board 1 and a cloud server 2; and the raspberry pi 4B development board 1 and the cloud server 2 are connected through a network to perform instruction transmission and data exchange.
The raspberry pi 4B development board 1 is a data and instruction control center, and is used for receiving data information acquired by each module, uploading the data information to the cloud server 2, sending instructions to each module, coordinating information transmission and information processing among the modules, and realizing functions of instruction transmission, instruction processing, signal transmission, signal processing and the like.
And a chemical safety intelligent management system 3, a deep learning model 4 and a MySQL database 5 are deployed on the cloud server 2.
The chemical safety intelligent management system 3 comprises a system management and control module 6, an abnormal condition detection module 7 and a human-computer interaction module 8; the system is used for user information management, chemical storage and information management, storage safety management, abnormal condition detection and management and man-machine information interaction management. The system has a strong report function, and can carry out statistics and analysis on recorded data; and the excel file can be derived from the statistical result, so that the excel file is convenient to print and file.
The deep learning model 4 is based on a PyTorch library, and is based on YOLOv5 and is improved by the following specific improvements: a) Improving the network structure by using a feature fusion mode in a dense network; b) Performing clustering optimization on network parameters of the target frame by using K-means + +; c) The network is trained in a transfer learning mode, and training time is shortened. Model parameters of the deep learning model 4 are obtained through convolutional neural network training, and the trained model is used for extracting characteristic information in image data recorded by an industrial camera and detecting and identifying abnormal behaviors of a user.
The MySQL database 5 is used for storing various data, performing centralized storage management on the data and reducing the redundancy degree of the data; meanwhile, the method has a fault repairing function, can recover faults occurring when the database system operates as soon as possible, prevents data from being damaged, and ensures safety and reliability of the data.
The system management and control module 6 comprises a user management module 6-1, a unit information management module 6-2, a chemical information management module 6-3, a storage cabinet environment information management module 6-4, a video monitoring management module 6-5, a scanning module 6-6, a weighing module 6-7, an exhaust control module 6-8, a power supply control module 6-9 and a voice module 6-10; the method is used for managing and recording storage information, distributing operation authority, controlling system operation, monitoring real-time display, voice broadcasting, generating statistical data reports and the like.
The user management module 6-1 is used for managing user information and operation authority, recording the operation information of the user and displaying abnormal behaviors of the user; the use safety is guaranteed by setting user permission and a standard operation flow, and the user is standardized and supervised to operate according to related specifications.
And the unit information management module 6-2 is used for managing the basic information of the unit to which the storage cabinet belongs and the information of the manager of the unit. The unit managers include a unit manager and a department manager. The unit administrator can manage all the storage cabinets, department administrators and users of the unit, and the department administrator can manage all the storage cabinets and users of the department, so that authority hierarchical management is realized. The user refers to a person who can view and store the related information of the chemicals in the cabinet and borrow and return the chemicals.
The chemical storage information module 6-3 is used for managing and recording the information of the stored chemicals, and comprises the basic information, the inventory information, the borrowing and returning statistical information, the scrapping and recycling statistical information, the inventory counting information and the storage cabinet codes of the chemicals stored in the cabinet; the chemical classes which can be stored in the storage cabinet can be set, and the chemical stored in the storage cabinet is automatically identified and classified, so that the dangerous chemicals are strictly subjected to storage management in a classified manner. The user can check corresponding information at the operation terminal, so that the user can conveniently use and a department administrator can conveniently manage the chemical in and out of the warehouse.
And the storage cabinet environment information management module 6-4 is used for recording and managing the environment information inside the storage cabinet, including the temperature and humidity information and the VOC gas concentration information in the cabinet. When the temperature and the humidity in the chemical storage cabinet are abnormal or the concentration of VOC gas exceeds a set threshold value, the module gives an alarm and sends an instruction in time to open the exhaust device, and informs a department of a manager to deal with danger in time, so that the safety is guaranteed.
And the video monitoring management module 6-5 is used for detecting and recording the environmental information around the storage cabinet in real time, storing video and photo data and realizing traceability of operation.
And the scanning module 6-6 is used for scanning the two-dimensional code or the bar code on the chemical package when the chemicals are borrowed and returned, automatically generating borrowing and returning records, and is convenient and quick.
The weighing module 6-7 is used for weighing the weight of the chemicals when the chemicals are borrowed and returned, and automatically calculating the chemical difference (even the dosage) when the chemicals are borrowed and returned when the chemicals are returned; whether the predicted usage amount of the chemicals is consistent with the predicted usage amount of the chemicals in the lending record or not is automatically judged (the error is not more than 20 percent), and if the predicted usage amount of the chemicals exceeds 20 percent, the reason for the exceeding usage amount needs to be described and a department administrator is informed to process the exceeding usage amount.
The air exhaust control module 6-8 is used for exhausting gas in the storage cabinet; the starting exhaust device sucks external low-temperature gas from the outside of the cabinet through the one-way air inlet arranged on the cabinet body, and the gas is cooled inside the storage cabinet, and meanwhile, harmful gas in the storage cabinet is discharged and then purified or subjected to harmless treatment. The one-way air inlet is controlled by a pneumatic control one-way valve, so that harmful gas in the cabinet is prevented from diffusing to the outside of the cabinet body through the air inlet.
And the power supply control modules 6-9 are used for providing power for all electric components of the storage cabinet and ensuring the safe and reliable operation of the storage cabinet.
And the voice module 6-10 is used for voice reminding of relevant operations and alarming or warning when an abnormal condition occurs.
The abnormal condition detection module 7 comprises a chemical warehousing abnormal condition detection module 7-1, a chemical quality abnormal condition detection module 7-2 and a chemical borrowing and returning record abnormal condition detection module 7-3; for identifying the abnormal information and giving an alarm or warning to the abnormal information.
The chemical warehousing abnormal condition detection module 7-1 is used for detecting and identifying the types of the chemicals put into the storage cabinet; the MySQL database 5 stores chemical type information which can be stored in the storage cabinet, and when the chemicals are put in storage, alarms or warnings are sent to the chemicals which do not belong to the storage category of the storage cabinet, so that the chemicals are stored in different cabinets and classified.
And the chemical quality abnormal condition detection module 7-2 is used for supervising and managing the quality of the stored chemicals. The information of the types of the chemicals which are set and stored is stored in the MySQL database 5, and the basic information comprises: chemical name, manufacturer, storage quantity, production date, quality guarantee period and the like. If the chemicals are overdue, the system automatically identifies the overdue chemicals and carries out scrapping registration, and notifies a department administrator to carry out scrapping treatment and updating in time.
And the chemical borrowing and returning record abnormal condition detection module 7-3 is used for detecting the chemical borrowing and returning record and supervising the user to operate and manage according to relevant specifications. The user management module 6-1 stores each chemical borrowing and returning record of each user in the MySQL database 5 of the cloud server 2, and when the user does not return the chemicals after the user is overdue, the chemical borrowing and returning record abnormal condition detection module 7-3 sends a corresponding reminding notice to the user to urge the user to return the chemicals in time; if the usage amount of the chemicals obtained by weighing calculation exceeds 20% of the predicted usage amount due to loan or the returned chemical class does not belong to the storage cabinet, the module gives an alarm or warning and informs a department administrator to process the alarm or warning.
The man-machine interaction module 8 comprises operation terminals such as a computer terminal 8-1, a mobile terminal 8-2 and a cabinet screen 8-3; the chemical storage cabinet is used for checking storage information, inputting instructions and controlling and managing chemical storage cabinets in real time, and is convenient for users to use.
The invention also comprises an operation interface developed based on the PyQt5 technology, and relevant parameters of the storage cabinet, such as alarm threshold values of temperature, humidity and VOC gas concentration in the cabinet, running time of an exhaust system, screen dormancy time of the cabinet body and the like, are set through the operation terminal.
Fig. 2 is a schematic flow chart showing the interaction of data and instruction transmission during the operation of the system. The terminal user accesses the intelligent chemical safety management system 3 deployed on the cloud server 2 through the human-computer interaction module 8. The IP address of the cloud server 2 is obtained through a DNS, and then corresponding connection is established according to the operation requirement of a user, such as the HTTP hypertext transfer protocol and the FTP file transfer protocol, so that the transmission of texts, pictures, videos and control instructions can be completed. The raspberry pi 4B development board 1 establishes network connection with the cloud server 2, completes interaction of data and control instructions through a TCP/IP protocol, and transmits the control instructions input by the user terminal to the raspberry pi 4B development board 1. Control instructions of components (such as a temperature and humidity sensor, a VOC gas sensor and the like) directly connected with the raspberry pi 4B development board 1 can be directly sent by the raspberry pi 4B development board 1; the control instruction of the device (such as an industrial camera and a hard disk video recorder) connected with the raspberry pi 4B development board 1 through the network needs an industrial router for forwarding. The industrial router searches for target equipment in a formed network through an ARP/RARP protocol and sends a control instruction to the target equipment through the network.
In the embodiment, the storage cabinet needs to be activated in a networking mode before use, a unit administrator inputs a storage cabinet code through the human-computer interaction module 8, the storage cabinet code is uploaded to the chemical safety intelligent management system 3 deployed by the cloud server 2 through a TCP/IP protocol to verify the storage cabinet code, and the storage cabinet networking activation is completed after the verification. The cabinet code is obtained by encrypting the MAC address of the raspberry pi 4B development board 1 through an MD5 encryption algorithm.
In this embodiment, the unit administrator allocates a department administrator, a user account, and a password, and sets a corresponding use authority. A user inputs an account and a password through the man-machine interaction module 8 to log in the chemical safety intelligent management system 3, the account and the password are uploaded to the chemical safety intelligent management system 3 deployed by the cloud server 2 through a TCP/IP protocol to verify the user name and the password, and the user can enter the chemical safety intelligent management system 3 after verification to perform subsequent operation.
In this embodiment, the warehousing of the chemicals is completed by a department administrator, and the two-dimensional code or the bar code needs to be attached to the chemical package before the chemicals are warehoused. The two-dimensional code or the bar code comprises basic information of chemicals and a virtual 'identity card number'; the virtual 'identity card number' consists of eight-bit current date code + two-bit chemical classification code + four-bit warehousing batch code (such as 20221001FS 0001); the chemical classification code comprises: JD (highly toxic chemicals), YB (explosive chemicals), YR (flammable chemicals), FS (corrosive acids or bases), etc.
Fig. 3 is a schematic circuit connection diagram of the chemical storage cabinet management and control system of the present invention, and fig. 4 is a schematic flow diagram of the operation of the Python script switching electromagnetic lock of the chemical storage cabinet management and control system of the present invention.
In this embodiment, if chemical borrowing is performed, the user should click the unlocking button to send an unlocking instruction, the unlocking instruction sends an HTTP request to the cloud server 2 through the operation terminal, and the cloud server 2 performs unlocking processing after receiving the request. The specific unlocking process is as follows: the cloud server 2 changes the door lock state information stored in the MySQL database 5 into 'on', and meanwhile, a Python script running on the raspberry group 4B development board 1 is connected with the cloud server 2 through network service provided by an industrial router, and the door lock state in the MySQL database 5 is inquired in real time; if the door lock state is 'open' through inquiry, a Python script is operated to send an unlocking instruction, the unlocking instruction sets the raspberry pi 4B development board 1 and a GPIO pin connected with and controlling an electromagnetic lock relay to be high level, so that the relay is communicated, a power supply control module 6-9 supplies power to the electromagnetic lock, and the door lock is opened; meanwhile, the Python script sends a voice broadcast instruction to call the voice modules 6-10 to operate, and unlocking reminding is carried out.
In this embodiment, after unlocking, the user management module 6-1 stores the user unlocking record in the MySQL database 5. The chemical scanning borrowing and returning operation can be carried out subsequently, and meanwhile, the user management module 6-1 stores the borrowing and returning operation record of the user chemical into the MySQL database 5. The borrowing and returning instruction generated by the borrowing and returning operation operates the chemical information management module 6-3 to modify the chemical inventory records in the MySQL database 5, namely the inventory quantity is reduced when the chemicals are borrowed and the inventory quantity is increased when the chemicals are returned.
In this embodiment, when the door lock is opened, the Python script that raspberry group 4B development board 1 ran uses OpenCV class library to send the video recording instruction, controls the industrial camera and carries out real-time video recording to the cabinet surrounding environment, takes a candid photograph simultaneously to in storing video recorder with video and photo.
In this embodiment, the Python script running on the raspberry pi 4B development board 1 sends an HTTP request to the cloud server 2 through a network service provided by an industrial router and uploads a shot photo, the deep learning model 4 deployed and running in the cloud server 2 detects the photo, and a detection result is fed back to the raspberry pi 4B development board 1. If the abnormal behavior of the user is detected, the Python script running in the raspberry pi 4B development board 1 is in SSH connection with the cloud server 2, the captured photos are uploaded to the MySQL database 5 of the cloud server 2 to be stored, and the photos are displayed in the user management module 6-1. And if no abnormal behavior exists, deleting the captured photos.
In this embodiment, after the chemical borrowing and returning operation is completed, the user should click the lock closing button to perform the lock closing operation, the operation terminal sends the HTTP request to the cloud server 2, and the cloud server 2 performs the lock closing process after receiving the request. The specific locking process is as follows: the cloud server 2 changes the door lock state information stored in the MySQL database 5 into 'off', and meanwhile, a Python script running on the raspberry group 4B development board 1 establishes connection with the cloud server 2 through network service provided by an industrial router and queries the door lock state in the MySQL database 5 in real time; if the door lock state is 'off' through inquiry, operating a Python script to send a lock closing instruction, and setting the raspberry pi 4B development board 1 and a GPIO pin connected with a door lock control relay to be low level through the lock closing instruction, so that the relay is disconnected, the power supply control module 6-9 finishes power supply to the electromagnetic lock, and the door lock is closed; meanwhile, the Python script sends a voice broadcast instruction to call the voice modules 6-10 to operate, and lock closing reminding is carried out.
In this embodiment, after the lock is closed, the user management module 6-1 stores the user lock closing record in the MySQL database 5. When the door lock is closed, a Python script running on the raspberry pi 4B development board 1 sends a video recording stopping instruction by using an OpenCV (open content description language) library, and an industrial camera is controlled to stop recording and take photos.
In this embodiment, the operation terminal provided by the human-computer interaction module 8 can display the environmental information of the storage cabinet, such as the temperature, humidity, VOC gas concentration information, and the chemical exhaust system condition in the cabinet, and can perform corresponding parameter setting. The raspberry pi 4B development board 1 runs a Python script and sends a temperature and humidity information acquisition instruction by using an Adafruit-DHT class library, and a temperature and humidity sensor is controlled to acquire temperature and humidity information in a cabinet; the SSH connection established between the Python script running in the raspberry pi 4B development board 1 and the cloud server 2 uploads the acquired temperature and humidity information to the MySQL database 5 of the cloud server 2 for storage. The raspberry group 4B development board 1 runs a Python script to use a serial library to realize serial port communication, a VOC gas concentration acquisition instruction is sent to a VOC gas sensor to control the VOC gas sensor to detect the VOC gas concentration in a storage cabinet, and the VOC gas sensor feeds back a real-time detection result to the raspberry group 4B development board 1; the SSH connection established between the Python script running in the raspberry Pi 4B development board 1 and the cloud server 2 uploads the collected VOC gas concentration information to the MySQL database 5 of the cloud server 2 for storage. Because the working voltage of the temperature and humidity sensor and the VOC gas sensor is 5V weak current, the problem of voltage drop of a long-distance line is solved by adopting a double operational amplifier.
In the embodiment, the ventilation of the storage cabinet is realized by the air exhaust control module 6-9, when an air exhaust system is started, a Python script running in the raspberry group 4B development board 1 sends an air exhaust starting instruction to control a GPIO pin, the raspberry group 4B development board 1 and the GPIO pin connected with and controlling an air exhaust fan relay are set to be in a high level, so that the relay is communicated, the power supply control module 6-9 supplies power to the variable-frequency direct-current air exhaust fan, and the air exhaust system runs; when the exhaust system is closed, the Python script is operated in the raspberry group 4B development board 1 to send an exhaust closing instruction to control a GPIO pin, the GPIO pin of the raspberry group 4B development board 1 and a relay of a connection control exhaust fan is set to be low level, so that the relay is disconnected, the power supply control module 6-9 stops supplying power to the variable-frequency direct-current exhaust fan, and the exhaust system stops operating.
In this embodiment, raspberry pi 4B development board 1 can generate heat for continuous operation, and for its equipment radiator fan cooling, guarantee its long-time steady operation.
When the embodiment is applied, the main storage cabinet is provided with the industrial router, the hard disk video recorder and the switch, has a wireless network connection function, and can be in wireless network connection with the cloud server for data exchange.
And no industrial router, hard disk video recorder and switch are arranged on the slave storage cabinet, and the slave storage cabinet does not have a wireless network connection function. The slave storage cabinet is connected with the cloud server through the master storage cabinet in a network mode, and photos and monitoring videos shot by the slave storage cabinet can be uploaded and stored in the hard disk video recorder of the master storage cabinet.
The main storage cabinet can be used independently, and can also be combined with one or more auxiliary storage cabinets, so that the acquisition cost of the auxiliary storage cabinets can be reduced.
The management and control system can be installed on a chemical storage cabinet, a warehouse, a storage room and other buildings, and classification and intelligent management and control of dangerous chemicals are achieved.
Claims (6)
1. The utility model provides a chemical cabinet management and control system based on raspberry group and cloud ware which characterized in that: the system comprises a raspberry pi 4B development board (1) and a cloud server (2); the raspberry group 4B development board (1) and the cloud server (2) are connected through a network to perform instruction transmission and data exchange;
deploying a chemical safety intelligent management system (3), a deep learning model (4) and a MySQL database (5) on the cloud server (2);
the chemical safety intelligent management system (3) comprises a system management and control module (6), an abnormal condition detection module (7) and a man-machine interaction module (8);
the system management and control module (6) comprises a user management module (6-1), a unit information management module (6-2), a chemical information management module (6-3), a storage cabinet environment information management module (6-4), a video monitoring management module (6-5), an air exhaust control module (6-8) and a power supply control module (6-9);
the abnormal condition detection module (7) comprises a chemical warehousing abnormal condition detection module (7-1), a chemical quality abnormal condition detection module (7-2) and a chemical borrowing and returning record abnormal condition detection module (7-3).
2. The chemical storage cabinet management and control system based on the raspberry pi and the cloud server as claimed in claim 1, wherein: the storage cabinet also comprises an operation interface developed based on the PyQt5 technology, and related parameters of the storage cabinet can be set through an operation terminal.
3. The chemical storage cabinet management and control system based on the raspberry pi and the cloud server as claimed in claim 1, wherein: the deep learning model (4) is improved based on YOLOv5 on the basis of a PyTorch library, and the specific improvements are as follows: a) Improving the network structure by using a feature fusion mode in a dense network; b) Performing clustering optimization on network parameters of the target frame by using K-means + +; c) The network is trained in a transfer learning mode, and training time is shortened.
4. The chemical storage cabinet management and control system based on the raspberry pi and the cloud server as claimed in claim 1, wherein: the man-machine interaction module (8) comprises a computer terminal (8-1), a mobile terminal (8-2) and a cabinet screen (8-3).
5. The chemical storage cabinet management and control system based on the raspberry pi and the cloud server as claimed in claim 1, wherein: the system management and control module (6) further comprises a scanning module (6-6), a weighing module (6-7) and a voice module (6-10).
6. The chemical storage cabinet management and control system based on the raspberry pi and the cloud server as claimed in any one of claims 1 to 5, wherein: an end user accesses a chemical safety intelligent management system (3) deployed on the cloud server (2) through the human-computer interaction module (8); the IP address of the cloud server (2) is obtained through a DNS domain name resolution protocol, and then corresponding connection is established according to the operation requirement of a user; the raspberry pi 4B development board (1) is in network connection with the cloud server (2), data and control command interaction is completed through a TCP/IP protocol, and a control command input by a user terminal is transmitted to the raspberry pi 4B development board (1); the control instruction of equipment directly connected with the raspberry group 4B development board (1) is directly sent by the raspberry group 4B development board (1), and the control instruction of equipment connected with the raspberry group 4B development board (1) through a network is forwarded by an industrial router; the industrial router searches for target equipment in a formed network through an ARP/RARP protocol and sends a control instruction to the target equipment through the network.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202211478952.5A CN115510145A (en) | 2022-11-24 | 2022-11-24 | Chemical storage cabinet management and control system based on raspberry group and cloud server |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202211478952.5A CN115510145A (en) | 2022-11-24 | 2022-11-24 | Chemical storage cabinet management and control system based on raspberry group and cloud server |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN115510145A true CN115510145A (en) | 2022-12-23 |
Family
ID=84513682
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202211478952.5A Pending CN115510145A (en) | 2022-11-24 | 2022-11-24 | Chemical storage cabinet management and control system based on raspberry group and cloud server |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN115510145A (en) |
Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN107995263A (en) * | 2017-11-20 | 2018-05-04 | 河海大学 | A kind of multiple terminals Intelligent housing platform based on cloud computing and Raspberry Pi |
| CN111432175A (en) * | 2020-04-08 | 2020-07-17 | 成都理工大学 | Intelligent recognition abnormal behavior alarm system |
| CN111723704A (en) * | 2020-06-09 | 2020-09-29 | 杭州古德微机器人有限公司 | Raspberry pie-based van body door opening monitoring method |
| CN113148385A (en) * | 2020-11-17 | 2021-07-23 | 吉林大学 | Single-inlet three-dimensional automatic access cabinet and cloud material management system |
-
2022
- 2022-11-24 CN CN202211478952.5A patent/CN115510145A/en active Pending
Patent Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN107995263A (en) * | 2017-11-20 | 2018-05-04 | 河海大学 | A kind of multiple terminals Intelligent housing platform based on cloud computing and Raspberry Pi |
| CN111432175A (en) * | 2020-04-08 | 2020-07-17 | 成都理工大学 | Intelligent recognition abnormal behavior alarm system |
| CN111723704A (en) * | 2020-06-09 | 2020-09-29 | 杭州古德微机器人有限公司 | Raspberry pie-based van body door opening monitoring method |
| CN113148385A (en) * | 2020-11-17 | 2021-07-23 | 吉林大学 | Single-inlet three-dimensional automatic access cabinet and cloud material management system |
Non-Patent Citations (2)
| Title |
|---|
| 周贤伟 等: ""基于Yolov5的视觉风险评估方法：以高校实验室为例"", 《武汉理工大学学报（信息与管理工程版）》 * |
| 瞿秋亮: ""材料化学实验室信息管理系统的设计与实现"", 《中国优秀博硕士学位论文全文数据库(硕士) 信息科技辑》 * |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN106960405B (en) | Intelligent file big data platform system | |
| CN103944915B (en) | A kind of industrial control system threat detection defence installation, system and method | |
| US10359771B2 (en) | Prediction of false alarms in sensor-based security systems | |
| CN205015693U (en) | Storage safety monitoring system | |
| CN110158648A (en) | A kind of Urban Underground pipe gallery O&M monitoring management system | |
| CN205508055U (en) | Door and window security protection system based on thing networking | |
| CN111524306A (en) | Centralized monitoring system for power environment of machine room | |
| US20040167672A1 (en) | Field panel event logging in a building control system | |
| CN103578240A (en) | Security and protection service network based on Internet of Things | |
| CN104750081A (en) | Unattended station intelligent management system and control method based on remote terminal control | |
| CN106155023B (en) | A kind of anti-misoperation system and its method of universal scattered control system | |
| CN107450422A (en) | A kind of laboratory safety intelligent management | |
| CN108810844A (en) | One kind relating to electric management of public safety system | |
| CN205507857U (en) | Safe high -efficient express delivery system of asking for based on thing networking | |
| CN112966993A (en) | Storage warehouse safety control method, system and computer readable storage medium | |
| CN212115369U (en) | Network management system for dangerous goods | |
| CN115510145A (en) | Chemical storage cabinet management and control system based on raspberry group and cloud server | |
| CN102508469A (en) | Intelligent management system for safety tools and appliances | |
| CN108833414B (en) | A kind of online service abnormality monitoring method | |
| CN106899420A (en) | The caution device of high in the clouds monitoring | |
| CN206039788U (en) | Intelligent safe -guard system | |
| CN107516079A (en) | A kind of demographic using recognition of face and warning system and its method | |
| CN107701043A (en) | A kind of intelligent door safety-protection system based on Internet of Things | |
| CN209182687U (en) | Smart profile supervisory systems | |
| CN112153065A (en) | Environment perception information verification system based on artificial intelligence and network security |
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 | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20221223 |
|
| RJ01 | Rejection of invention patent application after publication |