“百仑慧神”发酵数据采集/分析系统的设计及应用
|
摘要
随着发酵工程和传感器技术的发展,实验室及工业化规模的发酵过程数据量与日俱增,如何有效地管理和利用这些数据已经成为困扰技术人员的难题之一。为解决这一难题,利用C#2010设计了"百仑慧神"发酵数据采集/分析系统(Bioplot)。Bioplot软件预留了DDE、OPC和TCP三种通用的通信接口用于采集数据,利用后台MySQL数据库管理数据,同时为用户提供了数据汇总、数据表展示以及灵活的多批次多参数曲线图比较功能。利用Bioplot软件连接两台来自不同生产厂商的发酵设备,并在实际的发酵过程中验证其有效性和通用性。结果表明,Bioplot软件所包含的各个功能模块均能够正常运行并达到预期的效果。
With the development of fermentation and sensor technology,the amount of fermentation data from laboratory and fermentation industries is increasing quickly. How to effectively manage and utilize these data has become one of the puzzling problems for technicians. In order to solve this problem,the"Bai Lun Hui Shen"fermentation data collection/analysis system( Bioplot) was designed by using C #2010. The Bioplot software collected data through reserved general communication interface,including DDE,OPC,and TCP. Additionally,it managed data using My SQL database and provided the users with functions of data summary,data table display,and comparing multibatch and multi-parameter curves flexibly. The Bioplot software was used to connect two bioreactors produced by different manufacturers,and its effectiveness and universality during the real fermentation process were validated. The results indicated that all the functional modules contained in Bioplot could run normally and show the desired effects.
With the development of fermentation and sensor technology,the amount of fermentation data from laboratory and fermentation industries is increasing quickly. How to effectively manage and utilize these data has become one of the puzzling problems for technicians. In order to solve this problem,the"Bai Lun Hui Shen"fermentation data collection/analysis system( Bioplot) was designed by using C #2010. The Bioplot software collected data through reserved general communication interface,including DDE,OPC,and TCP. Additionally,it managed data using My SQL database and provided the users with functions of data summary,data table display,and comparing multibatch and multi-parameter curves flexibly. The Bioplot software was used to connect two bioreactors produced by different manufacturers,and its effectiveness and universality during the real fermentation process were validated. The results indicated that all the functional modules contained in Bioplot could run normally and show the desired effects.
引文
[1]程辉,邵惠鹤.生物发酵装置上位机软件的开发和设计[J].自动化仪表,2005,26(1):47-49.
[2]刘力.组态软件在PLC实验系统中的应用[J].实验室研究与探索,2014,33(4):127-129,136.
[3]程海军,任国臣,姜丕杰.组态软件力控6. 0中数据管理功能的实现[J].辽宁工业大学学报(自然科学版),2012,(4):219-222.
[4]吕光帅,朱江华,潘丰.基于VC的发酵过程监控与状态预估软件开发[J].微计算机信息,2006,22(2):182-184.
[5]李佳,付强,丁宁. C#开发技术大全[M].北京:清华大学出版社,2009.
[6] MILOSEVI'CD,PEPI'CS,SARACEVI'CM,et al. Weighted Moore-Penrose generalized matrix inverse:MySQL vs. Cassandra database storage system[J]. Sādhanā,2016,41(8):1-10.
[7] BAOCHUAN F U,WANG Z,BAN J,et al. Realization of Dynamic Data Exchange Based on CGI for Embedded Remote Monitoring System[J]. Computer Engineering,2005,31(24):196-198.
[8]冯江涛.组态王与MATLAB的DDE通信设计[J].电力学报,2006,21(3):291-293.
[9]周新民,涂铮.基于OPC技术的PC与S7-200 PLC的实时通信[J].武汉理工大学学报(交通科学与工程版),2008,32(2):354-357.
[10]赵军伟,刘勋,董浩.基于TCP协议的远程监控系统的实现[J].中国测试,2010,36(1):78-81.
[2]刘力.组态软件在PLC实验系统中的应用[J].实验室研究与探索,2014,33(4):127-129,136.
[3]程海军,任国臣,姜丕杰.组态软件力控6. 0中数据管理功能的实现[J].辽宁工业大学学报(自然科学版),2012,(4):219-222.
[4]吕光帅,朱江华,潘丰.基于VC的发酵过程监控与状态预估软件开发[J].微计算机信息,2006,22(2):182-184.
[5]李佳,付强,丁宁. C#开发技术大全[M].北京:清华大学出版社,2009.
[6] MILOSEVI'CD,PEPI'CS,SARACEVI'CM,et al. Weighted Moore-Penrose generalized matrix inverse:MySQL vs. Cassandra database storage system[J]. Sādhanā,2016,41(8):1-10.
[7] BAOCHUAN F U,WANG Z,BAN J,et al. Realization of Dynamic Data Exchange Based on CGI for Embedded Remote Monitoring System[J]. Computer Engineering,2005,31(24):196-198.
[8]冯江涛.组态王与MATLAB的DDE通信设计[J].电力学报,2006,21(3):291-293.
[9]周新民,涂铮.基于OPC技术的PC与S7-200 PLC的实时通信[J].武汉理工大学学报(交通科学与工程版),2008,32(2):354-357.
[10]赵军伟,刘勋,董浩.基于TCP协议的远程监控系统的实现[J].中国测试,2010,36(1):78-81.