| 组态软件中历史数据存储与查询的一种新方法 |
| |
| 引用本文： | 江勇,王文海,张龙旗.组态软件中历史数据存储与查询的一种新方法[J].江南大学学报(自然科学版),2005,4(6):579-583. |
| |
| 作者姓名： | 江勇 王文海 张龙旗 |
| |
| 作者单位： | 1. 浙江大学,工业控制技术国家重点实验室,浙江杭州,310027
2. 浙大中自集成控制股份有限公司,浙江杭州,310007 |
| |
| 摘 要： | 提出了一种达到毫秒级的快速历史数据存储与查询方案，该方案采用哈希散列和多级索引的组织结构，应用了定时和定差的存储策略及分级压缩方法，并针对方案进行查询性能的分析和优化.目前采用该方案实现的数据库系统已经在商用组态软件中稳定运行，与同类产品相比，有着良好的存储和查询效率．
|
| 关 键 词： | 历史数据 存储 查询 组态软件 |
| 文章编号： | 1671-7147（2005）06-0579-05 |
| 收稿时间： | 2004-10-14 |
| 修稿时间： | 2004-10-142004-11-05 |
A New Method of Storing and Querying Historical Data in SCADA |
| |
| JIANG Yong,WANG Wen-hai,ZHANG Long-qi.A New Method of Storing and Querying Historical Data in SCADA[J].Journal of Southern Yangtze University:Natural Science Edition,2005,4(6):579-583. |
| |
| Authors: | JIANG Yong WANG Wen-hai ZHANG Long-qi |
| |
| Institution: | 1. National Laboratory of Industrial Control Technology, Zhejiang University, Hangzhou 310027, China; 2. Zheda Zhongzi Integrated Control Stock Co., Ltd., Hangzhou 310007,China |
| |
| Abstract: | 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. |
| |
| Keywords: | historical data storing querying SCADA |
| 本文献已被 CNKI 维普 万方数据 等数据库收录！ |
