组态软件中历史数据存储与查询的一种新方法  

A New Method of Storing and Querying Historical Data in SCADA

作　　者：江勇[1] 王文海[1] 张龙旗 

机构地区：[1]浙江大学工业控制技术国家重点实验室,浙江杭州310027 [2]浙大中自集成控制股份有限公司,浙江杭州310007

出　　处：《江南大学学报（自然科学版）》2005年第6期579-583,共5页Joural of Jiangnan University (Natural Science Edition)　

摘　　要：提出了一种达到毫秒级的快速历史数据存储与查询方案,该方案采用哈希散列和多级索引的组织结构,应用了定时和定差的存储策略及分级压缩方法,并针对方案进行查询性能的分析和优化.目前采用该方案实现的数据库系统已经在商用组态软件中稳定运行,与同类产品相比,有着良好的存储和查询效率.This paper summarizes the storing and querying characteristics of historical data and proposes a rapid method to take microsecond to store and query historical data. The paper has also designed hash and multiple Index structure by using timing and fix-difference tactics and subsection compression. Furthermore, the paper analyzes and improves querying performance. The new method has been applied to the commercial SCADA system, which has a good efficiency in storing and querying compared with other products.

关 键 词：历史数据 存储 查询 组态软件 

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