基于SQL数据库的过程数据压缩方法  

Process Data Compression Method Based on SQL Database

作　　者：赵利强[1] 于涛[1] 王建林[1] 

机构地区：[1]北京化工大学信息科学与技术学院,北京100029

出　　处：《计算机工程》2008年第14期58-59,62,共3页Computer Engineering

摘　　要：利用SQLServer数据库存储过程历史数据,提出一种增量型的SDT压缩算法,有效地实现了过程历史数据的实时存储。对于通过OPC方式从化工过程底层读取的实时数据,利用增量型的SDT算法进行实时压缩存储,利用LZW算法对存储的值进行二次无损压缩。实验测试表明,该方法能够实时处理大量的过程数据,同时尽最大可能对过程数据进行压缩,降低存储成本。在容差为1%、测点为1000个时,该算法使平均压缩率达到约85%。This paper presents incremental Swinging Door Trending（SDT） algorithm of historical data based on SQL Server database. For the real-time process data obtained by the OLE for Process Control（OPC）, it is compressed by using the incremental SDT algorithm, and the LZW （Lempel-Ziv-Welch） algorithm is adopted for the storage value in the second-level lossless compression. Experimental results show that it can deal with the large process data on line, and at the same time it can reach the utmost compression ratio for the process history data. This storage method can also reduce the storage cost. For the 1 000 data points in one petrochemical factory, the average compression ratio can reach 85% with incremental SDT when the compression tolerance is set to 1%.

关 键 词：过程数据压缩 增量型SDT算法 LZW算法 

分 类 号：TP311.13[自动化与计算机技术—计算机软件与理论]