Using Internet of Things technology to effectively track and identify medicines
0 Preface
As a special commodity, medicines, if improperly managed and misused, will pose a serious threat to people's health and safety [1]. At present, there are two main problems in the circulation of medicines: the efficiency of the supply chain and the problem of counterfeit medicines.
Under the premise of ensuring the safety of patients, drug safety management needs to ensure the safety of the process of manufacturing, selling, and distributing drugs to the final patient medication. This article proposes to use the Internet of Things technology to effectively track and identify medicines from the beginning of the manufacturer to the end user (patients taking medicines), and to realize the monitoring of medicines at all links in the supply chain, so that the safety of medicines for patients Get the maximum protection.
1 System architecture design
The Internet of Things-based drug traceability management system makes full use of network infrastructure, integrates the Internet and Internet of Things related information resources collected and stored in the drug supply chain. The system operates within the framework of security mechanisms and standards, forming a unified whole, from data collection , Data service, data application three levels to ensure the rationality and efficiency of the system architecture.
The functional structure of the system is shown in Figure 1. It includes the following functional units: National Traceability Platform, Label Issuance Center, Pharmaceutical Factory Application Subsystem, Imported Drug Management Subsystem, Wholesale Warehousing Management Subsystem, Drug In-transit Management, Retail Management Subsystem system.
The National Traceability Platform implements data center interaction and data sharing tasks. As the core module of the system, other modules interact with the platform for drug circulation data.
The label issuance center regularly collects the label requirements of each pharmaceutical factory; places orders to label manufacturers according to the label requirements of pharmaceutical factories; and carries out label issuance operations according to the label requirements fed back by the pharmaceutical factories.
The application subsystem of the pharmaceutical factory is distributed in every enterprise with the qualification for the production of pharmaceutical products in the country. It is combined with the existing system to complete the collection and reporting of the production information and storage information of pharmaceutical products.
The imported drug management subsystem is deployed in the pharmaceutical product importer information center and warehouse. Through coordination with the national regulatory center, it completes the functions of approval for the import of pharmaceutical products, collection and reporting of warehousing and logistics information, etc.
The wholesale warehousing management subsystem is deployed in every wholesale warehouse in the country as an intermediate link for distribution, to complete the storage and distribution of pharmaceutical products.
The in-transit drug management subsystem uses GPS technology to achieve tracking, positioning and transportation information collection during drug delivery. For drugs with high transportation environment requirements, cold chain logistics vehicles need to be used for full-track tracking and transportation temperature monitoring.
With the help of the dealer's existing cash register system and the nationwide perfect communication network, the retail management subsystem directly summarizes product sales information to the national supervision center.
The system has a complete safety mechanism and standard specifications, and cooperates with the corresponding management system to provide stable operation guarantee measures for the construction of the drug traceability management system.
2 Construction of National Traceability Platform
The National Traceability Platform provides a unified data storage, exchange, and query platform for the traceability management of medicines, to achieve unified management of drug circulation information, and to ensure data consistency and authority.
2.1 Data storage
2.1.1 Basic database
The basic database is used to store the business database and basic data information. The business database includes the business database of pharmaceutical production, wholesale, retail, supervision and other links. The basic information database includes the medicine production information database, the medicine wholesale information database, the imported medicine information database, Drug retail information database, drug regulatory information database, etc.
2.1.2 Data Warehouse
The data warehouse provides a data base for rapid analysis, query, and statistics. Based on the basic supporting data, it forms a drug analysis topic through classification and summary processing, and supports the analysis and query operations of the drug circulation data by the regulatory center.
2.1.3 Support database
The support database is used to support special databases for various applications, including meta databases and exchange databases. The meta-database stores the data information that explains the data; the exchange database stores the information of the data exchange platform application.
2.2 Data sharing and exchange service
During the construction of the national traceability platform, it is necessary to collect drug circulation data from multiple departments such as drug manufacturers, drug wholesalers, retailers, importers, and drug regulatory departments. There is a large number of data exchange needs. In order to complete these data exchange tasks, It is necessary to build a unified data sharing and exchange platform. As the underlying platform of the application system, it provides a unified integrated framework for drug traceability, and at the same time provides data processing and delivery services between various business systems and various manufacturers in the supply chain.
2.3 Data conversion service
Data conversion services mainly include data extraction, conversion, cleaning and loading services [2]. Data extraction completes data synchronization and migration between multiple types of databases; implements data conversion and data cleaning from different manufacturers, using conditional filtering, removing duplicate records, controlling processing, and removing invalid data, and batches the data in the form of bulk loading The fastest way to load into the database.
2.4 Data query service
The platform provides public users with a unified drug information query service. Through this service, the public users can obtain real-time drug production and distribution information; at the same time, the platform can provide the drug supervision and management department with query services that meet the needs of the department. Users can flexibly choose query conditions, and the system can generate corresponding statistical reports according to the user's selection.
3 Application system construction
3.1 Construction of label distribution center
The label issuance center completes the issuance management operations of drug identification labels, including label storage management, inventory inquiry, label issuance management, bad label management, label issuance management, label issuance query statistics, label issuance content management, data synchronization and log of the supervision center, Support functions such as authority and equipment [3].
3.2 Construction of the application subsystem of the pharmaceutical factory
The functions of the application subsystem of the pharmaceutical factory are mainly divided into the information center of the pharmaceutical factory, production line management of the pharmaceutical factory, warehouse management of the pharmaceutical factory, and supporting functions.
The pharmaceutical factory information center is mainly responsible for the collection of drug production information, statistical inquiries, unified management of drug inventory information and other functions, and it is necessary to regularly report the factory's drug production and inventory information statistics to the national traceability platform data center.
The production line management system of the pharmaceutical factory needs to transform the production line, install labeling machines and other equipment to carry out labeling, issuance of medicine outer packaging, and recycling management of bad labels.
The warehouse management system of the pharmaceutical factory manages the exit and entry of medicines.
3.3 Construction of imported medicine management subsystem
The imported drug management has completed the tracking management of the customs clearance information of the imported drugs, the origin of the drugs, the production information, and the circulation information in the country. The system mainly includes import warehouse information center, drug label placement management, import warehouse management and necessary system support functions.
The import warehouse information center is mainly responsible for the collection of drug import information, statistical inquiry and unified management of imported drug inventory information, and needs to regularly report the imported drug information statistics to the national traceability platform data center.
The drug label placement management system requires the labeling, issuance of the outer packaging of imported drugs, and the management of the recovery of bad labels.
The imported drug warehouse management system manages the export and import of medicines.
3.4 Construction of Wholesale Warehouse Management Subsystem
Wholesale warehousing management mainly completes the tracking and management of the drug information entering the wholesale sales channel, including inventory management, data management and system support functions, and needs to regularly report the drug in and out and wholesale information statistics to the national traceability platform data center.
3.5 Construction of Drug Subsystem Management Subsystem
The drug in-transit management subsystem uses GPS positioning technology, sensor technology, RFID and other technologies to cooperate with the drug in-transit management [4].
The system reports the location information of the medicine, the label information of the medicine, and the internal temperature information of the medicine transportation vehicle to the in-transit management center system in real time through the dual channels of GPS and RFID reader. The central system saves the in-transit information of medicines and regularly reports the information to the data center of the national traceability platform.
3.6 Construction of retail management subsystem
The retail management subsystem integrates the RFID reader into the drug cash register system [5], completes the real-time collection and management of drug sales information and in-out information, and regularly reports the information to the data center of the National Traceability Platform.
4 Conclusion
Based on the construction of the drug traceability management system based on the Internet of Things, it is proposed to use advanced GPS, RFID, temperature sensors and other Internet of things technologies to solve the full life cycle management of drug information, improve the production management level of drug companies and strengthen the information on imported drugs Resource management and comprehensive on-the-go management of medicines to ensure that there is no dead end in the whole process, so as to contain counterfeit products and solve the safety management of medicines to a certain extent.
Modular Jack section
China Keystone Jack,Ethernet Wall Jack,Ethernet Wall Plate,Rj45 Keystone, we offered that you can trust. Welcome to do business with us.
RJ45 interface can be used to connect RJ-45 connectors. It is suitable for the network constructed by twisted pair. This port is the most common port, which is generally provided by Ethernet hub. The number of hubs we usually talk about is the number of RJ-45 ports.
RJ45 is a type of different connectors (for example: RJ11 is also a type of connector, but it is used on the telephone); there are two different ways to arrange the RJ-45 connector: one is white orange, orange, white green, blue, white blue, green, white brown, brown; the other is white green, green, white orange, blue, white blue, orange, white brown, brown; therefore, there are also wires with RJ45 connector There are two kinds: straight line and interleaved line.
The RJ-45 port of the hub can be directly connected to terminal devices such as computers and network printers, and can also be connected with other hub equipment and routers such as switches and hubs. It should be noted that when connecting to different devices, the jumper method of twisted pair cable used is different.
Keystone Jack,Ethernet Wall Jack,Ethernet Wall Plate,Rj45 Keystone
ShenZhen Antenk Electronics Co,Ltd , https://www.antenkconn.com