摘要
为了实现水泥厂生产线设备运行状态大量实时数据的存储与分析,目前使用的较多的存储为时序数据库,考虑到成本等因素,选择关系数据库进行实时数据的存储,关系数据库在存储大量工业实时数据时有一些技术难点,针对这些需要解决的问题,提出了中间缓冲和相同数据放弃存储等技术,中间缓存技术很好地解决了大量实时数据在存入关系数据库时的效率问题,相同数据放弃存储则可以很好地压缩数据量,使得整个系统更加轻便和利于后续的分析工作;首先对水泥厂实时数据采集方案设计的过程进行认知和分解,指出关系数据库存储大量实时数据是设计过程中的难点;综上设计了总体模型,采用opc协议与采集服务器进行通信,通过在水泥厂现场部署数据采集客户端运行,效果良好,验证了该设计的有效性。
To storage and analyse a large number of real-time data that represent cement production line equipment running status, cur- rently used more stored as a temporal database, considering the factors such as cost, choose a relational database for real-time data storage, a relational database in the storage a large number of industrial real-time data there are some technical difficulties, to solve these problems, put forward the intermediate buffer and give up the same data storage technology, such as the middle cache technology to solve a large num- ber of real-time data in the efficiency problem when deposited in the relational database, the same data not store is a good way to compress the data, make the system more portable and conducive to the analysis of the follow-up work. First on the project of the cement plant real -time data acquisition and decomposition process of cognition, points out that the relational database to store a large number of real-time data is difficult in the process of design. In the design of the overall model, using OPC protocol and acquisition server for communication, through the deployment of data acquisition at the scene of the cement plant client operation, good effect, verify the effectiveness of the pro posed design.
出处
《计算机测量与控制》
2016年第8期174-177,共4页
Computer Measurement &Control
基金
四川省科技厅项目(2012GZ0112)
关键词
实时数据
关系数据库
缓冲
OPC协议
水泥厂
real-time data
relational database
buffer
OPC protocol
cement plant
