Design,Development And Application Of PC Client Of BioJN Fermentation Service System

With the development of industrial biotechnology and its surrounding disciplines,the amount and complexity of fermentation process data are increasing day by day.How to better manage fermentation data and how to use it effectively has become a problem that most fermentation companies have to solve.This project uses Python 3.6 and MySQL in combination with a cloud server to build a BioJN fermentation technology service system,with the following main research and conclusions:(1)PC client GUI and its function development: the GUI of the client was designed and developed using the wx Python graphics library,and the basic functions of the system PC client are as follows: 1)online fermentation data collection and monitoring,manual entry of offline fermentation data;2)secondary calculation of fermentation data;3)batch naming feature field configuration,parameter configuration and secondary calculation formula 4)Data visualization function based on Matplotlib library to plot fermentation data into graphs;5)Management and sharing of fermentation data from different sites and remote control of different fermentation batches using cloud services;6)A user rights management mechanism is designed to ensure the security of fermentation data;7)Extension of package functions to achieve automatic control of the fermentation process.(2)Building the database: Build databases: design and build high-performance fermentation database systems using MySQL relational databases and the visualization tool Navicat.Select storage methods according to the type of data to improve storage efficiency and ensure data reliability,stability,and standardisation;optimize database performance according to the characteristics of the data to improve the speed of retrieving and accessing data.(3)Communication module development: Four common industrial control data interfaces,DDE,Modbus,OPC DA,and OPC UA,are used to achieve data interaction between the software and the device,and the communication server type and parameters are stored in a JSON file in the form of key-value pairs.(4)PC client of the BioJN Fermentation Service System was connected to different devices and applied to the fermentation process of Lactobacillus plantarum for the production of extracellular polysaccharides and Pichia pastoris for the production of heterologous proteins to verify its functionality and stability.The results show that all functional modules of the BioJN system PC client can operate stably and achieve the expected results.