作者投稿和查稿 主编审稿 专家审稿 编委审稿 远程编辑

计算机工程

• 先进计算与数据处理 • 上一篇    下一篇

一种磁盘历史数据库模型研究

令晓明1,2,郝玉胜1   

  1. (1. 兰州交通大学光电技术与智能控制教育部重点实验室,兰州 730070;2. 国家绿色镀膜技术与装备工程技术研究中心,兰州 730070)
  • 收稿日期:2013-09-24 出版日期:2014-05-15 发布日期:2014-05-14
  • 作者简介:令晓明(1975-),男,副教授,主研方向:计算机控制技术,实时操作系统,数据库技术;郝玉胜,硕士研究生。
  • 基金资助:
    国家“863”计划基金资助项目(2012AA04027)。

Research on a Disk History Database Model

LING Xiao-ming 1,2, HAO Yu-sheng 1   

  1. (1. Key Laboratory of Opto-Technology and Intelligent Control, Ministry of Education, Lanzhou Jiaotong University, Lanzhou 730070, China; 2. National Engineering Research Center of Green Coating Technology and Equipment, Lanzhou 730070, China)
  • Received:2013-09-24 Online:2014-05-15 Published:2014-05-14

摘要: 为解决流程工业中过程历史数据的存储以及大量数据的快速查询问题,提出一种基于关系数据库的磁盘历史数据库模型。在数据存储方案设计中,将关于位号和数据采集接口的静态信息存储在关系数据库中,历史数据以文件形式存放,采用三重二级缓存机制避免频繁访问磁盘,并使用经典的SDT算法对实时数据进行压缩存储,降低存储成本。数据查询方案采用三级索引文件结构,即总索引文件、二级索引文件和位号索引文件,提高查询效率。该磁盘历史数据库的第一版已经成功实现,应用结果表明,数据存储方案和查询方案的设计是合理的,100个位号的查询时间约为500 ms。

关键词: 实时数据库, 内存数据库, 过程历史数据, 位号数据, 三重二级缓存机制, SDT算法

Abstract: In order to solve the problem of storing process history data and fastly querying large amounts, this paper proposes a disk history database model based on relational database. In the storage design, static information about the tags and data collect interfaces are stored in relational database. History data is stored in files, and a mechanism named triple secondary cache is used in RAM, thus the frequency of disk access is reduced. Meanwhile, the SDT algorithm is also used in data processing to reduce storage cost. In order to improve the efficiency of query, three-level index file structure which consists of a total index file, secondary index file and tag number index file is adopted in the data query scheme. The first version of the model is implemented. Applications result shows that the storage and query scheme is reasonable, and it returns the results of 100 tag numbers in about 500 ms.

Key words: real-time database, memory database, process history data, tag number data, triple secondary cache mechanism, SDT algorithm

中图分类号: