Pharmaceutical technological process data management system

Abstract

The utility model discloses a pharmaceutical technological process data management system, a field side of the pharmaceutical technological process data management system is provided with a plurality of data acquisition units and a plurality of man-machine interaction units, and a center side of the pharmaceutical technological process data management system is provided with at least two mutually redundant data servers. Each data server is connected with a corresponding real-time database, the data servers are connected with the data acquisition unit to acquire data, and the man-machine interaction unit is connected with the real-time database to store the data. According to the utility model, through the redundancy design of the real-time database, the problems of data inquiry lagging and insufficient data acquisition rate in the data management of the pharmaceutical process can be effectively solved.

Description

Technical Field

[0001] The utility model relates to data acquisition and monitoring technology, in particular to a data management system for pharmaceutical process. Background Art

[0002] The records and data of drug production inspection are the only vouchers for enterprises to produce in compliance with laws and regulations, and are the key sources for the full traceability of drug safety. Data management is crucial in the pharmaceutical production process.

[0003] The current data management system for pharmaceutical process only uses a single server for data acquisition and management. When the data volume is too large, there will be problems such as slow query and lag of batch data, and it is also difficult to achieve high-speed data acquisition, thus unable to realize data playback in specific scenarios, resulting in greater difficulty in data management of pharmaceutical process. Content of the Utility Model

[0004] The technical problem to be solved by the utility model: Aiming at the above problems of the prior art, a data management system for pharmaceutical process is provided, which can effectively solve the problems of data query lag and insufficient data acquisition rate in the data management of pharmaceutical process.

[0005] To solve the above technical problems, the technical solution adopted by the utility model is as follows:

[0006] A data management system for pharmaceutical process, on the field side of the data management system for pharmaceutical process, there are multiple data acquisition units and multiple human-computer interaction units, on the central side of the data management system for pharmaceutical process, there are at least two mutually redundant data servers, each data server is connected to a corresponding real-time database, the data server and the data acquisition unit are connected to collect data, and the human-computer interaction unit and the real-time database are connected to save data.

[0007] Optionally, on the central side of the data management system for pharmaceutical process, there are also a domain control server and a customer manufacturing execution system. The domain control server and the data server are connected to synchronize and back up the data collected by the data server, and the customer manufacturing execution system and the data server are connected to schedule production resources and optimize production plans according to the data collected by the data server.

[0008] Optionally, a first data forwarding unit is provided at the front end of the data server and a second data forwarding unit is provided at the back end. The data server is connected to the data acquisition unit through the first data forwarding unit, the human-computer interaction unit is connected to the real-time database through the first data forwarding unit, and the data server is respectively connected to the domain control server and the customer manufacturing execution system through the second data forwarding unit.

[0009] Optionally, a printer is further provided on the field side of the pharmaceutical process data management system. The data input end of the printer is connected to the data acquisition unit and / or the real-time database through a first data forwarding unit, and the control end of the printer is connected to the human-machine interaction unit through the first data forwarding unit.

[0010] Optionally, the data transmitted by the data acquisition unit to the data server includes process data, alarm records, and batch information, and the data transmitted by the human-machine interaction unit to the real-time database includes audit trail information.

[0011] Optionally, the data acquisition unit is a PLC unit, and the data acquisition end of the PLC unit is connected to the corresponding instruments or meters on the field side of the pharmaceutical process data management system.

[0012] Optionally, the human-machine interaction unit uses an industrial control computer with a human-machine interaction interface.

[0013] Optionally, both the first data forwarding unit and the second data forwarding unit adopt network switches.

[0014] Optionally, the customer manufacturing execution system reads the data collected by the data server through an OPC protocol interface.

[0015] Optionally, the real-time database adopts a disk storage device.

[0016] Compared with the prior art, the advantages of the present utility model are as follows:

[0017] The present utility model adopts at least two mutually redundant data servers, and each data server is connected to the corresponding real-time database, thereby realizing the redundant design of the real-time database, which can effectively support the high-speed acquisition of pharmaceutical data, reduce data access latency, and improve query speed.

[0018] The present utility model adopts a structure in which the human-machine interaction unit and the data acquisition unit are separated, making the human-machine interaction smoother, and the human-machine interaction operation does not affect data acquisition, greatly improving the stability of the pharmaceutical control system. Description of the Drawings

[0019] Figure 1 It is a schematic diagram of the overall architecture of an embodiment of the present utility model.

[0020] Figure 2 It is a schematic diagram of the data flow direction of an embodiment of the present utility model.

[0021] Legend: 1 - data acquisition unit, 2 - human-machine interaction unit, 3 - data server, 4 - real-time database, 5 - domain control server, 6 - customer manufacturing execution system, 7 - first data forwarding unit, 8 - second data forwarding unit, 9 - printer. Detailed implementation manners

[0022] The present utility model will be further described below in conjunction with the accompanying drawings of the specification and specific preferred embodiments, but the protection scope of the present utility model is not limited thereby.

[0023] In order to solve the problems of difficult data management, poor data integrity, and slow data query in the pharmaceutical process, this embodiment proposes a pharmaceutical process data management system. As Figure 1 shown, a plurality of data acquisition units 1 and a plurality of human-computer interaction units 2 are provided on the field side of the pharmaceutical process data management system of this embodiment. At least two mutually redundant data servers 3 are provided on the central side of the pharmaceutical process data management system. Each data server 3 is connected to a corresponding real-time database 4. The data server 3 and the data acquisition unit 1 are connected to collect data, and the human-computer interaction unit 2 and the real-time database 4 are connected to save data.

[0024] With the above structure, the pharmaceutical process data management system of this embodiment adopts a redundant real-time database. The redundant real-time database realizes complete redundancy between nodes and between libraries, improving data security. In addition, the data acquisition unit 1 and the human-computer interaction unit 2 are completely separated, making the human-computer interaction operation of the human-computer interaction unit 2 smoother, and the operation does not affect data acquisition, greatly improving the stability of pharmaceutical control.

[0025] As Figure 2 shown, the data transmitted by the data acquisition unit 1 to the data server 3 includes process data, alarm records, and batch information collected by the data acquisition unit 1. The data transmitted by the human-computer interaction unit 2 to the real-time database 4 includes audit trail information of the human-computer interaction unit 2.

[0026] In this embodiment, the data server 3 can collect data from the data acquisition unit 1 at a high frequency of 100 ms / time through data acquisition software and store it in the corresponding real-time database 4. During the data saving process, all historical data in the process data, alarm records, and batch information collected from the data acquisition unit 1 and the audit trail information of the human-computer interaction unit 2 are archived into the real-time database 4, so that all information such as data, alarms, audits, and parameters of the entire system is stored in the real-time database, realizing the integrity of the report.

[0027] As Figure 1As shown in the figure, a domain control server 5 and a customer MES (Manufacturing Execution System) 6 are also provided on the central side of the pharmaceutical process data management system of this embodiment. The domain control server 5 is connected to the data server 3 to synchronize and back up the data collected by the data server 3. The customer manufacturing execution system 6 is connected to the data server 3 and reads the data collected by the data server 3 through an OPC protocol interface, so as to schedule production resources and optimize the production plan according to the data collected by the data server 3.

[0028] To solve the communication problems between the various units on the field side and the central side, such as Figure 1 As shown in the figure, in this embodiment, a first data forwarding unit 7 is provided at the front end of the data server 3 and a second data forwarding unit 8 is provided at the rear end. The data server 3 is connected to the data acquisition unit 1 through the first data forwarding unit 7. The human-computer interaction unit 2 is connected to the real-time database 4 through the first data forwarding unit 7. The data server 3 is respectively connected to the domain control server 5 and the customer manufacturing execution system 6 through the second data forwarding unit 8. In this embodiment, both the first data forwarding unit 7 and the second data forwarding unit 8 adopt network switches.

[0029] Such as Figure 1 As shown in the figure, a printer 9 is also provided on the field side of the pharmaceutical process data management system of this embodiment. The data input end of the printer 9 is connected to the data acquisition unit 1 and / or the real-time database 4 through the first data forwarding unit 7. The control end of the printer 9 is connected to the human-computer interaction unit 2 through the first data forwarding unit 7. Thus, on-site staff can operate the printer 9 on the field side through the human-computer interaction unit 2 to print out the specified data in the data acquisition unit 1 or the real-time database 4 in real time.

[0030] In this embodiment, the data acquisition unit 1 adopts a PLC unit. The data acquisition end of the PLC unit is connected to the corresponding instruments or meters on the field side of the pharmaceutical process data management system, so as to collect the process data, alarm records and batch information in the corresponding instruments or meters in real time.

[0031] In this embodiment, the human-computer interaction unit 2 adopts an industrial control computer with a human-computer interaction interface, which is convenient for on-site staff to perform human-computer interaction operations.

[0032] In this embodiment, the real-time database 4 adopts a disk storage device. The historical data in the real-time database 4 adopts the archival format of the real-time database. The historical data is archived into a pair of library files corresponding to the two real-time databases every day. The number of online databases is not limited, only limited by the disk capacity. It can support historical data query for more than 10 years, and can realize the copy-style data backup and restoration function, without complex additional, separation and other database processing solutions, reducing the manual maintenance cost.

[0033] In summary, the present utility model discloses a data management system for pharmaceutical process, which is constructed around three aspects: data acquisition, data storage, and user use. The independent data acquisition unit 1 and human-computer interaction unit 2 separate data from operations, making the human-computer interaction operation more fluent, enhancing the user experience. By designing redundant data servers and real-time databases, it supports high-frequency data acquisition, improves data security at the same time, and meets the data integrity requirements of the pharmaceutical industry. In addition, the redundant real-time database also increases the data storage capacity, simplifies the operations of data backup and data restoration, and reduces the personnel maintenance cost.

[0034] The above description is only a preferred embodiment of the present utility model. The protection scope of the present utility model is not limited to the above embodiments. All technical solutions falling within the concept of the present utility model belong to the protection scope of the present utility model. It should be noted that for those of ordinary skill in the art in this technical field, several improvements and refinements made without departing from the principle of the present utility model should also be regarded as within the protection scope of the present utility model.

Claims

1. A pharmaceutical process data management system, characterized in that: The pharmaceutical process data management system is provided with a plurality of data acquisition units (1) and a plurality of human-computer interaction units (2) on the field side, and at least two mutually redundant data servers (3) on the central side. Each data server (3) is connected to a corresponding real-time database (4). The data server (3) is connected to the data acquisition unit (1) to collect data, and the human-computer interaction unit (2) is connected to the real-time database (4) to store data.

2. The pharmaceutical process data management system according to claim 1, characterized in that: The central side of the pharmaceutical process data management system is also provided with a domain control server (5) and a customer manufacturing execution system (6). The domain control server (5) and the data server (3) are connected to synchronize and back up the data collected by the data server (3). The customer manufacturing execution system (6) and the data server (3) are connected to schedule production resources and optimize production plans according to the data collected by the data server (3).

3. The pharmaceutical process data management system according to claim 2, characterized in that: The data server (3) is provided with a first data forwarding unit (7) at the front end and a second data forwarding unit (8) at the back end; the data server (3) is connected to the data acquisition unit (1) via the first data forwarding unit (7); the human-computer interaction unit (2) is connected to the real-time database (4) via the first data forwarding unit (7); and the data server (3) is connected to the domain control server (5) and the customer manufacturing execution system (6) respectively via the second data forwarding unit (8).

4. The pharmaceutical process data management system according to claim 3, characterized in that: The on-site side of the pharmaceutical process data management system is also provided with a printer (9), the data input end of the printer (9) is connected to the data acquisition unit (1) and / or the real-time database (4) via the first data forwarding unit (7), and the control end of the printer (9) is connected to the human-computer interaction unit (2) via the first data forwarding unit (7).

5. The pharmaceutical process data management system according to claim 1, characterized in that: The data transmitted by the data acquisition unit (1) to the data server (3) include process data, alarm records and batch information, and the data transmitted by the human-computer interaction unit (2) to the real-time database (4) include audit trail information.

6. The pharmaceutical process data management system according to claim 1, characterized in that: The data acquisition unit (1) is a PLC unit, and the data acquisition end of the PLC unit is connected to a corresponding instrument or meter on the field side of the pharmaceutical process data management system.

7. The pharmaceutical process data management system according to claim 1, characterized in that: The human-machine interaction unit (2) adopts an industrial computer with a human-machine interaction interface.

8. The pharmaceutical process data management system according to claim 3, characterized in that: The first data forwarding unit (7) and the second data forwarding unit (8) both adopt network switches.

9. The pharmaceutical process data management system according to claim 2, characterized in that: The customer manufacturing execution system (6) reads the data collected by the data server (3) through the OPC protocol interface.

10. The pharmaceutical process data management system according to claim 1, characterized in that: The real-time database (4) uses a disk storage.

Images