摘要
利用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%.
出处
《计算机工程》
CAS
CSCD
北大核心
2008年第14期58-59,62,共3页
Computer Engineering
