CN105897883A - Processing method of traditional Chinese medicine production data - Google Patents
Processing method of traditional Chinese medicine production data Download PDFInfo
- Publication number
- CN105897883A CN105897883A CN201610212496.8A CN201610212496A CN105897883A CN 105897883 A CN105897883 A CN 105897883A CN 201610212496 A CN201610212496 A CN 201610212496A CN 105897883 A CN105897883 A CN 105897883A
- Authority
- CN
- China
- Prior art keywords
- data
- server
- production
- chinese medicine
- storage
- 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
Classifications
-
- H—ELECTRICITY
- H04—ELECTRIC COMMUNICATION TECHNIQUE
- H04L—TRANSMISSION OF DIGITAL INFORMATION, e.g. TELEGRAPHIC COMMUNICATION
- H04L67/00—Network arrangements or protocols for supporting network services or applications
- H04L67/01—Protocols
- H04L67/12—Protocols specially adapted for proprietary or special-purpose networking environments, e.g. medical networks, sensor networks, networks in vehicles or remote metering networks
-
- H—ELECTRICITY
- H04—ELECTRIC COMMUNICATION TECHNIQUE
- H04L—TRANSMISSION OF DIGITAL INFORMATION, e.g. TELEGRAPHIC COMMUNICATION
- H04L67/00—Network arrangements or protocols for supporting network services or applications
- H04L67/01—Protocols
- H04L67/10—Protocols in which an application is distributed across nodes in the network
- H04L67/1097—Protocols in which an application is distributed across nodes in the network for distributed storage of data in networks, e.g. transport arrangements for network file system [NFS], storage area networks [SAN] or network attached storage [NAS]
-
- H—ELECTRICITY
- H04—ELECTRIC COMMUNICATION TECHNIQUE
- H04L—TRANSMISSION OF DIGITAL INFORMATION, e.g. TELEGRAPHIC COMMUNICATION
- H04L67/00—Network arrangements or protocols for supporting network services or applications
- H04L67/50—Network services
- H04L67/56—Provisioning of proxy services
- H04L67/565—Conversion or adaptation of application format or content
Abstract
A processing method of traditional Chinese medicine production data disclosed by the present invention comprises the following steps of using a distributed control system (DCS) server to acquire the production equipment data signal possessing the production equipment data and transform the signal into a first digital signal and store in a DCS storage server; using a process analytical technology (PAT) server to acquire a production quality data signal possessing the production quality data and transform the signal into a second digital signal and store in a PAT storage server; using the DCS storage server and the PAT storage server to integrate the first digital signal and the second digital signal into the traditional Chinese medicine production data respectively in an open database connectivity manner; after the traditional Chinese medicine production data enters a traditional Chinese medicine production data storage server via a data channel, orderly using a storage buffer pool to carry out the high-speed storage, using a data copy management device to carry out the copy backup and using a plurality of sub-servers to carry out the classification storage, on the traditional Chinese medicine production data. The processing method of the present invention realizes the acquisition and storage of the traditional Chinese medicine production data, is convenient for the check, retrieval and later analysis of the traditional Chinese medicine production data, and is high in automation degree.
Description
Technical field
The present invention relates to technical field of data processing, it is more particularly related to a kind of Chinese medicine produces
The processing method of data.
Background technology
Medicine is a kind of special commodity, and curing the sickness to save the patient is its function that should possess, therefore, drug quality
It is critical that.At present, country formulate strict GMP (Good Manufacturing Practices,
Good Manufacturing Practice and Quality Control of Drug) specification, prevent all to the pollution of medicine and cross-contamination, prevent medicine
Quality declines the generation of situation.But, the supervision of medicine manufacture process is a complicated system
Engineering, only by inner directed behavior and the artificial supervision of people, drug quality problems can not be solved.
Although country increases the supervision of drug quality, but various drug quality problems occurs the most again and again.
During Chinese medicine produces, owing to tcm product ingredient is sufficiently complex, there is production process and disturb
Dynamic big variable is many, equipment brand diversified, automation degree of equipment is uneven, production process data kind
The features such as class is diversified, creation data is many, accordingly, it would be desirable to develop a kind of Chinese medicine production data acquisition and deposit
Method for storing, online monitoring and management and the data mining in later stage for Chinese medicine creation data provide basis.
Summary of the invention
For weak point present in above-mentioned technology, the present invention provides the process of a kind of Chinese medicine creation data
Method, it is achieved the collection of Chinese medicine creation data and storage, the checking of convenient Chinese creation data, retrieve with
And post analysis, automaticity is high.
In order to realize according to object of the present invention and further advantage, the present invention is by the following technical programs
Realize:
The processing method of Chinese medicine creation data of the present invention, including: comprise the following steps: DCS takes
Business device collection has the production device data signal of production device data and converts thereof into the first digital signal
Store to DCS storage server；PAT collection of server has the quality of production data of quality of production data
Signal and convert thereof into the second digital signal store to PAT store server；Described DCS stores service
Described first numeral is believed by the way of Open Database Connectivity by device and described PAT storage server respectively
Number and described second digital signal be integrated into Chinese medicine creation data；Described Chinese medicine creation data is led to by data
After road enters Chinese medicine creation data storage server, pass sequentially through the storage high speed storing of Buffer Pool, data
The copy backup of replica management device and the classification storage of some child servers.
Preferably, produce device data signal described in described DCS collection of server, comprise the following steps:
The the first production equipment supporting Transmission Control Protocol reads the first production number of devices with the first production device data
The number of it is believed that also is sent to described TCP server；The the second production equipment supporting OPC agreement reads to be had
Second the second production device data signal producing device data is also sent to described opc server；Support
The instrument of I/O agreement or valve read the third production device data signal with third production device data
And it is sent to described I/O server；Described first produces device data through described TCP server, institute
State the second production device data through described opc server and described third production device data through institute
State I/O server to be sent respectively to described DCS server and form described production device data.
Preferably, described PAT collection of server quality of production data signal, comprise the following steps:
The online quality control assembly holding OPC agreement reads the quality of production data signal with quality of production data
And it is sent to described opc server, the institute that opc server described in described PAT collection of server sends
State quality of production data signal.
Preferably, the classification storage of described some child servers, including by Data Source classification or by life
Produce workshop section's classification or store by production batch classification.
Preferably, communicate to connect between described some child servers.
The present invention at least includes following beneficial effect:
1) processing method of the Chinese medicine creation data that the present invention provides, by different servers, storage clothes
Business device carries out producing device data and the collection of quality of production data, storage respectively, then by open number
Form Chinese medicine creation data according to the mode integral data of storehouse interconnection, be last transmitted to the storage of Chinese medicine creation data
Server, it is achieved that the backup of the high speed storing of Chinese medicine creation data, copy and classification storage, at data
Reason automaticity is high, the checking of convenient Chinese creation data, retrieves and post analysis；
2) life that the production equipment supporting Transmission Control Protocol, OPC agreement and I/O agreement respectively is read
Produce device data, be sent respectively to the server of respective protocol, it is achieved the classification to producing device data is adopted
Collection, improves the automaticity of data acquisition further, is easy to data management；
3) the classification storage of some child servers, classifies including by Data Source, or by producing workshop section's classification,
Or press production batch classification；If Chinese medicine creation data is divided into dry type, different child servers enter
Line pipe is managed, it is simple to the classification of Chinese medicine creation data is checked, retrieves and analyzed；
4) communicate to connect between some child servers, can carry out as required between different child servers
Data are transmitted.
Part is embodied by the further advantage of the present invention, target and feature by description below, and part also will
By the research of the present invention and practice are understood by the person skilled in the art.
Accompanying drawing explanation
Fig. 1 is the schematic flow sheet of the processing method of Chinese medicine creation data of the present invention；
Fig. 2 is the flow chart of steps of the processing method of Chinese medicine creation data of the present invention；
Fig. 3 is the flow chart of steps that DCS collection of server of the present invention produces device data signal.
Detailed description of the invention
The present invention is described in further detail below in conjunction with the accompanying drawings, to make those skilled in the art's reference
Description word can be implemented according to this.
Should be appreciated that used herein such as " have ", " comprising " and " including " term not
Allot other element one or more or the existence of a combination thereof or interpolation.
The present invention provides the processing method of a kind of Chinese medicine creation data, comprises the following steps:
S10, DCS (Distributed Control System, dcs) collection of server has
Have to produce the production device data signal of device data and convert thereof into the first digital signal and store to DCS
Storage server；
S20, PAT (Process Analytical Technology, process analysis technique) collection of server has
There is the quality of production data signal of quality of production data and convert thereof into the second digital signal and store to PAT
Storage server；
S30, by the way of Open Database Connectivity, described DCS storage server and described PAT deposit
Described first digital signal and described second digital signal are integrated into Chinese medicine and produce number by storage server respectively
According to；
S40, after described Chinese medicine creation data enters Chinese medicine creation data storage server by data channel,
Pass sequentially through the storage high speed storing of Buffer Pool, the copy backup of data trnascription manager and some sub-clothes
The classification storage of business device.
In above-mentioned embodiment, data channel enters Chinese medicine creation data storage clothes as Chinese medicine creation data
The passage of business device；Storage Buffer Pool buffering after mass data inputs, improves Chinese medicine creation data and deposits
The speed stored up, the high speed storing realizing mass data；Data trnascription manager is used for carrying out data backup,
The situations such as disk failures, node failure, network interruption occur when child servers, Chinese medicine creation data stores
Server can Backup Data in called data replica management device, it is to avoid the loss that factor data is lost and caused.
In embodiment of the present invention, by different servers (DCS server and PAT server),
Different storage servers (DCS storage server and PAT store server) carries out production equipment respectively
Data and the collection of quality of production data, storage, then by Open Database Connectivity (Open Database
Connectivity, ODBC) mode integral data formed Chinese medicine creation data, be last transmitted to Chinese medicine
Creation data storage server, it is achieved that the backup of the high speed storing of Chinese medicine creation data, copy and classification
Storage, datamation degree is high, the classification of convenient Chinese creation data checks, retrieve and after
Phase is analyzed.
In above-mentioned embodiment, produce device data signal and quality of production data signal includes electric current respectively
At least one in signal, resistance signal and capacitance signal.
As a kind of detailed description of the invention of the present invention, DCS collection of server produces device data signal,
Comprise the following steps:
S11, supports TCP (Transmission Control Protocol, transmission control protocol) agreement
First production equipment reads to be had the first production device data signal of the first production device data and is sent to
TCP server；
S12, supports OPC (OLE for Process Control, for the OLE of process control) agreement
The second production equipment read the second production device data signal sending with the second production device data
To opc server；
S13, supports that the instrument of I/O (Input/Output, input/output end port) agreement or valve read tool
There is the third production device data signal of third production device data and be sent to I/O server；
S14, first produces device data through TCP server, the second production device data through OPC
Server and third production device data are sent respectively to DCS server through I/O server and form life
Produce device data.
In above-mentioned embodiment, Transmission Control Protocol, OPC agreement and the production of I/O agreement will be supported respectively
The production device data that equipment reads, is sent respectively to the server of respective protocol, it is achieved to the equipment of production
The classification collection of data, improves the automaticity of data acquisition further, is easy to later data management.
In above-mentioned embodiment, first produces equipment or second produces equipment, includes respectively: extraction equipment,
Concentrator, precipitate with ethanol/water precipitating equipment, extraction equipment, macroporous resin column, ethanol refinery equipment, be dried set
One in standby, preparation equipment and packaging facilities.
In above-mentioned embodiment, instrument valve, including thermometer, Pressure gauge, liquidometer, densimeter,
At least one in effusion meter, conductivity meter, regulation valve and PH meter.By arranging instrument valve,
Realize reading the third production device data signal with third production device data, beneficially later stage to produce
The segmentation of device data signal and scalable, improve the accuracy producing device data signal.
In above-mentioned embodiment, the first production device data or second produces device data or third production sets
Standby data, include respectively device name, unit type specification, product batch number, operator, temperature,
At least one in pressure, liquid level, density, flow, electrical conductivity, valve opening.
As a kind of detailed description of the invention of the present invention, PAT collection of server quality of production data signal,
Comprise the following steps: support the online quality control assembly of OPC agreement to read and there are quality of production data
Quality of production data signal is also sent to opc server, and PAT collection of server opc server sends
Quality of production data signal.
In above-mentioned embodiment, quality of production data include: active substance content, solid content, ethanol are dense
Degree.
In above-mentioned embodiment, online quality control assembly can be any raw with collection for on-line checking
The assembly of yield and quality data signal.
As another embodiment of the invention, the classification storage of some child servers, including by data
Origin classification or by produce workshop section classification or by production batch classification store.
In above-mentioned embodiment, by Data Source classification or by producing workshop section's classification or pressing production batch classification,
If Chinese medicine creation data is divided into dry type, different child servers it is managed, it is simple to Chinese medicine is raw
The classification producing data is checked, retrieves and is analyzed.
Preferred as above-mentioned embodiment, is included according to device parameter data, work by Data Source classification
Skill supplemental characteristic and mass parameter data are classified.
Preferred as above-mentioned embodiment, includes according to extracting workshop section's data, dense by producing workshop section's classification
Contracting workshop section data, precipitate with ethanol/water precipitating workshop section data, extraction workshop section data, purification by macroporous resin workshop section data,
Ethanol refinery workshop section data, drying section data, preparation workshop section data and packing department data are carried out point
Class.
Preferred as above-mentioned embodiment, some child servers can expand online, it is ensured that data message
Be uniformly distributed and equalize.
Preferred as above-mentioned embodiment, communicates to connect between some child servers, different sub-services
Can carry out data transmission as required between device.That is, in some child servers one break down cannot
When storage Chinese medicine creation data or the storage to some child servers reclassify, permissible between child servers
Carry out Data Migration and data exchange.
Although embodiment of the present invention are disclosed as above, but it is not restricted to description and embodiment party
Listed utilization in formula.It can be applied to various applicable the field of the invention completely.For being familiar with ability
Other amendment it is easily achieved for the personnel in territory.Therefore without departing substantially from claim and equivalency range
Under the general concept limited, the present invention is not limited to specific details and shown here as the legend with description.
Claims (5)
1. the processing method of a Chinese medicine creation data, it is characterised in that comprise the following steps:
DCS collection of server has and produces the production device data signal of device data and convert thereof into the
One digital signal stores to DCS storage server；
PAT collection of server has the quality of production data signal of quality of production data and converts thereof into
Two digital signal stores to PAT storage server；
Described DCS storage server and described PAT storage server are by the way of Open Database Connectivity
Respectively described first digital signal and described second digital signal are integrated into Chinese medicine creation data；
After described Chinese medicine creation data enters Chinese medicine creation data storage server by data channel, successively
Backed up and some child servers by the copy of the storage high speed storing of Buffer Pool, data trnascription manager
Classification storage.
2. the processing method of Chinese medicine creation data as claimed in claim 1, it is characterised in that described
Produce device data signal described in DCS collection of server, comprise the following steps:
The the first production equipment reading supporting Transmission Control Protocol has the first production of the first production device data and sets
Standby data signal is also sent to described TCP server；
The the second production equipment reading supporting OPC agreement has the second production of the second production device data and sets
Standby data signal is also sent to described opc server；
Instrument or the valve of supporting I/O agreement read the third production equipment with third production device data
Data signal is also sent to described I/O server；
Described first produces device data through described TCP server, described second production device data warp
Cross described opc server and described third production device data sends respectively through described I/O server
Described production device data is formed to described DCS server.
3. the processing method of Chinese medicine creation data as claimed in claim 1, it is characterised in that described
PAT collection of server quality of production data signal, comprises the following steps:
The online quality control assembly supporting OPC agreement reads the quality of production number with quality of production data
The number of it is believed that also is sent to described opc server, and opc server described in described PAT collection of server is sent out
The described quality of production data signal sent.
4. the processing method of Chinese medicine creation data as claimed in claim 1, it is characterised in that if described
The classification of dry child servers stores, including by Data Source classification or by producing workshop section's classification or criticizing by producing
Subseries stores.
5. the processing method of the Chinese medicine creation data as described in claim 1 or 4, it is characterised in that institute
State and communicate to connect between some child servers.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201610212496.8A CN105897883A (en) | 2016-04-07 | 2016-04-07 | Processing method of traditional Chinese medicine production data |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201610212496.8A CN105897883A (en) | 2016-04-07 | 2016-04-07 | Processing method of traditional Chinese medicine production data |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN105897883A true CN105897883A (en) | 2016-08-24 |
Family
ID=57013386
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201610212496.8A Pending CN105897883A (en) | 2016-04-07 | 2016-04-07 | Processing method of traditional Chinese medicine production data |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN105897883A (en) |
Cited By (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN107992013A (en) * | 2017-12-29 | 2018-05-04 | 苏州泽达兴邦医药科技有限公司 | A kind of Chinese medicine preparation equipment integrated system |
| CN108153491A (en) * | 2017-12-22 | 2018-06-12 | 深圳市瑞驰信息技术有限公司 | A kind of storage method and framework for closing part server |
| CN109104468A (en) * | 2018-07-25 | 2018-12-28 | 河南太龙药业股份有限公司 | A kind of Chinese materia medica preparation production process data acquisition system |
| CN110553994A (en) * | 2019-09-06 | 2019-12-10 | 云南大唐汉方制药股份有限公司 | method for automatically collecting and integrating dragon blood production data |
| CN110947505A (en) * | 2019-11-29 | 2020-04-03 | 甘肃中医药大学 | Traditional Chinese medicine multi-crushing control system and method for pharmaceutical workshop |
Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101140455A (en) * | 2007-10-22 | 2008-03-12 | 广东工业大学 | Real time monitoring system for production processes and monitoring method |
| CN101488021A (en) * | 2009-02-16 | 2009-07-22 | 山东浪潮齐鲁软件产业股份有限公司 | Air pressure difference data acquisition processing method for medicine production department |
| CN102038757A (en) * | 2010-10-12 | 2011-05-04 | 北京同仁堂科技发展股份有限公司 | Quality inspection and control system for medicinal compositions |
| US8493442B2 (en) * | 1998-03-19 | 2013-07-23 | Lot 3 Acquisition Foundation, Llc | Object location information |
| CN104268219A (en) * | 2014-09-24 | 2015-01-07 | 国家电网公司 | Management method and system thereof for mass electricity utilization information collection data |
-
2016
- 2016-04-07 CN CN201610212496.8A patent/CN105897883A/en active Pending
Patent Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US8493442B2 (en) * | 1998-03-19 | 2013-07-23 | Lot 3 Acquisition Foundation, Llc | Object location information |
| CN101140455A (en) * | 2007-10-22 | 2008-03-12 | 广东工业大学 | Real time monitoring system for production processes and monitoring method |
| CN101488021A (en) * | 2009-02-16 | 2009-07-22 | 山东浪潮齐鲁软件产业股份有限公司 | Air pressure difference data acquisition processing method for medicine production department |
| CN102038757A (en) * | 2010-10-12 | 2011-05-04 | 北京同仁堂科技发展股份有限公司 | Quality inspection and control system for medicinal compositions |
| CN104268219A (en) * | 2014-09-24 | 2015-01-07 | 国家电网公司 | Management method and system thereof for mass electricity utilization information collection data |
Cited By (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN108153491A (en) * | 2017-12-22 | 2018-06-12 | 深圳市瑞驰信息技术有限公司 | A kind of storage method and framework for closing part server |
| CN108153491B (en) * | 2017-12-22 | 2021-06-25 | 深圳市瑞驰信息技术有限公司 | Storage method and architecture capable of closing part of servers |
| CN107992013A (en) * | 2017-12-29 | 2018-05-04 | 苏州泽达兴邦医药科技有限公司 | A kind of Chinese medicine preparation equipment integrated system |
| CN109104468A (en) * | 2018-07-25 | 2018-12-28 | 河南太龙药业股份有限公司 | A kind of Chinese materia medica preparation production process data acquisition system |
| CN110553994A (en) * | 2019-09-06 | 2019-12-10 | 云南大唐汉方制药股份有限公司 | method for automatically collecting and integrating dragon blood production data |
| CN110947505A (en) * | 2019-11-29 | 2020-04-03 | 甘肃中医药大学 | Traditional Chinese medicine multi-crushing control system and method for pharmaceutical workshop |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN105897883A (en) | Processing method of traditional Chinese medicine production data | |
| US8438192B2 (en) | System and method for retrieving and storing industrial data | |
| CN105468677B (en) | A kind of Log Clustering method based on graph structure | |
| CN104317970A (en) | Data flow type processing method based on data processing center | |
| Rios | Big data infrastructure for analyzing data generated by wireless sensor networks | |
| CN104111996A (en) | Health insurance outpatient clinic big data extraction system and method based on hadoop platform | |
| CN106980669A (en) | A kind of storage of data, acquisition methods and device | |
| CN104615677A (en) | Graph data access method and system | |
| CN105404757A (en) | Intelligent transformer station SCD file standardization degree verification method | |
| CN111026808A (en) | Heterogeneous database synchronization system and synchronization method based on domestic environment | |
| Alwidian et al. | Big data ingestion and preparation tools | |
| Hongqian et al. | Cloud-based data management system for automatic real-time data acquisition from large-scale laying-hen farms | |
| Parthiban et al. | Big data architecture for capturing, storing, analyzing and visualizing of web server logs | |
| CN114328759A (en) | Data construction and management method and terminal of data warehouse | |
| US10924551B2 (en) | IRC-Infoid data standardization for use in a plurality of mobile applications | |
| CN104133900A (en) | Definition description method of 360-degree treeview | |
| Suciu et al. | Big data technology for scientific applications | |
| CN110502529A (en) | Data processing method, device, server and storage medium | |
| Hamed et al. | T-Recs: Time-aware twitter-based drug recommender system | |
| WO2015199533A1 (en) | System and method for managing change data in database | |
| EP4323906A1 (en) | Method for analyzing data consisting of a large number of individual messages, computer program product and computer system | |
| Gamero et al. | Scalability Testing Approach for Internet of Things for Manufacturing SQL and NoSQL Database Latency and Throughput | |
| Quafiq et al. | Advanced Analytics for Smart Farming in a Big Data Architecture Secured by Blockchain and pBFT | |
| Joshi et al. | Review of Youtube Data Analysis | |
| CN104504157B (en) | A kind of collecting method |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| CB03 | Change of inventor or designer information |
Inventor after: Li Yerui Inventor after: Liu Xuesong Inventor after: Xiao Wei Inventor after: Chen Yong Inventor after: Cao Yaqing Inventor before: Li Yerui Inventor before: Liu Xuesong Inventor before: Chen Yong Inventor before: Cao Yaqing |
|
| CB03 | Change of inventor or designer information | ||
| TA01 | Transfer of patent application right |
Effective date of registration: 20170822 Address after: 215163 Jiangsu province Suzhou New District kolding Road No. 78 Su Gaoxin Software Park Building No. 8 Applicant after: Industrial Technology Research Institute of Zhejiang University Applicant after: Kangyuan Pharmceutical Co., Ltd. Address before: Kolding road high tech Zone of Suzhou City, Jiangsu province 215163 No. 78 Su Gaoxin Software Park Building No. 8 Applicant before: Industrial Technology Research Institute of Zhejiang University |
|
| TA01 | Transfer of patent application right | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20160824 |
|
| RJ01 | Rejection of invention patent application after publication |