In recent years, the shortcomings of traditional operation mode in fermentation industry have been gradually emerged, including the low level of automation, outdated management mode and low utilization of fermentation statistics. To solve these problems in actual fermentation process, the PC terminal of BioJN fermentation technology service system was designed and developed with Python 3.6. This PC terminal has a simple operation interface and a full-featured data visualization module. A complete database system for data storage, retrieval and management was built by MySQL, and the communication module could collect data through reserved communication interfaces, including dynamic data exchange (DDE), OLE for process control data access (OPC DA) and OPC unified architecture (OPC UA). The PC terminal can upload the local collected data to the server, which can be used together with the server to achieve the functions of user authority management, fermentation data management, remote monitoring and control of fermenters. The PC terminal was connected to different bioreactors for multiple fermentation experiments to fully validate its effectiveness and versatility. The results indicated that all function modules this system worked stably as expected. All function modules in this PC terminal have been running stably as expected.
DAI Jingjing
,
LYU Kui
,
SHI Zhongping
. Design, development and application of BioJN fermentation technology service system PC terminal[J]. Food and Fermentation Industries, 2021
, 47(3)
: 150
-156
.
DOI: 10.13995/j.cnki.11-1802/ts.024716
[1] 程辉,邵惠鹤.生物发酵装置上位机软件的开发和设计[J].自动化仪表,2005(1):49-51.
CHENG H,SHAO H H.Development and design of the software in host computerof biological fermentation device[J].Process Automation Instrumentation,2005(1):49-51.
[2] 张劲楠,丁健,严建,等.“百仑慧神”发酵数据采集/分析系统的设计及应用[J].食品与发酵工业,2019,45(2):107-112.
ZHANG J N,DING J,YAN J,et al.Design and application of“Bai Lun Hui Shen”data collection /analysissystem for fermentation industry[J].Food and Fermentation Industries,2019,45(2):107-112.
[3] 刘力.组态软件在PLC实验系统中的应用[J].实验室研究与探索,2014,33(4):127-129;136.
LIU L.The application of configuration software in PLC experimental system[J].Research and Exploration in Laboratory,2014,33(4):127-129;136.
[4] http://www.nc-bio.com/products/reconstruction-projects/352.html[EB/OL]
[5] 陈亚华,王树青.用数据驱动实现的抗生素发酵过程监控软件[J].计算机工程与应用,2004(29):223-225.
CHI Y H,WANG S Q.The software of antibiotic fermentation monitoring based on data-driven[J].Computer Engineering and Applications,2004(29):223-225.
[6] 范丽.基于Python的数据可视化[J].电子世界,2020(8):52-53.
FAN L.Python-based data visualization[J].Electronics World,2020(8):52-53.
[7] 马佳琪,滕国文.基于Matplotlib的大数据可视化应用研究[J].电脑知识与技术,2019,15(17):18-19.
MA J Q,TENG G W.Big data visualization application research based on Matplotlib[J].Computer Knowledge and Technology,2019,15(17):18-19.
[8] DANIJELA M,SeLVER P,MUZAFER S,et al.Weighted moore-penrose generalized matrix inverse:MySQL vs.Cassandra database storage system[J].Sādhanā,2016,41(8):1-10.
[9] 郑智方,魏恺乐,李彬,等.MySQL得到广泛使用的原因以及它的嵌入应用[J].科技风,2020(5):114.
ZHENG Z F,WEI K L,LI B,XIE Y Z.Reasons for the widespread use of MySQL and its embedded applications[J].Technology Wind,2020(5):114.
[10] 唐东明,李磊民.DDE技术在Lon Works控制系统中的应用[J].电子测量技术,2007(1):123-124;127.
TANG D M,LI L M.Application of DDE in the Lon Works system[J].Electronic Measurement Technology,2007(1):123-124;127.
[11] 张建武,高国琴.OPC客户/服务器模型设计[J].计算机仿真,2005(4):152-154;171.
ZHANG J W,GAO G Q.OPC client/server model design[J].Computer Integrated Manufacturing Systems,2005(4):152-154;171.
[12] 周新民,涂铮.基于OPC技术的PC与S7-200 PLC的实时通信[J].武汉理工大学学报(交通科学与工程版),2008(2):354-357.
ZHOU X M,TU Z.Distribution regularity analysis of ship arrivaland department at the Tianjin port main channel[J].Journal of Wuhan University of Technology,2008(2):354-357.
[13] FABIAN S,GERALD E,ROBERT M,et al.Smart factory equipment integration through standardised OPC UA communication with companion specifications and equipment specific information models[J].International Journal of Mechatronics and Manufacturing Systems,2019,12(3-4):344-364.
[14] OZGUR C,COLLIAU T,ROGERS G,et al.MatLab vs.Python vs.R[J].Journal of Data Science,2017,15(3):355-372.
[15] 王宝,全雪贞.ArcPy与WxPython在地理国情普查数据检查中的应用[J].中国科技信息,2016(23):42-43;45;12.
WANG B,QUAN X Z.Application of arcPy and WxPython in geographic census data inspection[J].China Science and Technology Information,2016(23):42-43;45;12.
[16] 吕光帅,朱江华,潘丰.基于VC的发酵过程监控与状态预估软件开发[J].微计算机信息,2006(2):182-184.
LÜ G S,ZHU J H,PAN F.Design of ferment process monitoring and state prediction software based on VC[J].Microcomputer Information,2006(2):182-184.
