西门子828D数控系统数据采集与存储

Data acquisition and storage of Siemens 828D CNC system

西门子828D数控系统是西门子的全数字化中高端数控系统。主要研究西门子机床自身的OPC UA,并开发符合OPC UA规范的客户端,利用该客户端获取变量的信息,通过Python开发的程序采集OPC UA服务器当中的数据,并将采集的数据处理后存储到MySQL数据库中。结果表明,在数据表的基础上,利用数据表区分功能减少的单表存储量,采用数据库的读写分离的架构,避免数据阻塞,从而提高了数据库的性能。

Siemens 828D CNC system is a full digital high-end CNC system.This paper mainly studies the OPC UA of Siemens machine tool itself,and develops a client that conforms to the OPC UA specification.Using the client to obtain the information of variables,the data in OPC UA server is collected through the program developed by python,and the collected data is stored in MySQL database after processing.The results show that on the basis of the data table,the single table storage is reduced by using the data table differentiation function,and the read-write separation architecture of the database is adopted to avoid data blocking,so as to improve the performance of the database.