工业历史数据库的研究  

Construction of Huge Capacity and Rapid Querying Historical Database

作　　者：嵇月强[1] 王文海[2] 

机构地区：[1]浙江大学工业控制技术国家重点实验室,浙江杭州310027 [2]浙江工业大学自动化系,浙江杭州310032

出　　处：《工业控制计算机》2007年第8期43-44,47,共3页Industrial Control Computer

摘　　要：提出了一种最高容量为60000个信号点、记录达到秒级的快速历史数据存储与查询方案,该方案采用二级缓存和二级索引的组织方式,应用了高效的二级压缩方法。目前采用该方案实现的数据库系统已经在商用组态软件中稳定运行,实践证明有良好的存储和查询效率。This paper proposes a rapid method to take second to store and query max to 60 thousands sample points＇ historical data,bases on summarizing the storing and querying characteristics of historical data.The paper suggests using multiple buffer structure and multiple index structure.It also designs multiple historical data compression.The new method has been applied to the commercial SCADA system,which has a good efficiency in storing and querying compared with other products.

关 键 词：历史数据 存储 查询 压缩 

分 类 号：TP392[自动化与计算机技术—计算机应用技术]