摘要
提出了一种达到毫秒级的快速历史数据存储与查询方案,该方案采用哈希散列和多级索引的组织结构,应用了定时和定差的存储策略及分级压缩方法,并针对方案进行查询性能的分析和优化.目前采用该方案实现的数据库系统已经在商用组态软件中稳定运行,与同类产品相比,有着良好的存储和查询效率.
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.
出处
《江南大学学报(自然科学版)》
CAS
2005年第6期579-583,共5页
Joural of Jiangnan University (Natural Science Edition)