一种面向实时数据库存储引擎的设计与实现  

Design and Implementation of Storage Engine for Real-Time Database

作　　者：刘波[1] 范士明[1] 刘华[1] 

机构地区：[1]北京卫星信息工程研究所,北京100086

出　　处：《计算机技术与发展》2011年第8期34-38,共5页Computer Technology and Development

基　　金：中国空间技术研究院cast创新基金(201008)

摘　　要：卫星地面设备监控中,需研究实时数据库技术来管理大量的分布式环境下的实时数据。为此文章设计了一种实时数据存储引擎。该引擎借助内存文件映射机制实现内存表,以LRU算法和页面缓冲池实现了磁盘表,通过位图方法管理数据库表的文件空间,以影子页面法实现了事务的提交与回滚,并设计了数据库表的逻辑结构。通过使内存表和磁盘表结构保持一致,确保了数据库运行时内存表和磁盘表的灵活转换,影子页面法确保了数据库具有实时的故障恢复速度。结果表明,该引擎适用于存储卫星地面设备监控中的大量实时数据。It is necessary to research real-time database to manage massive distributed real-time data in satellite ground device monitoring.In order to resolve the problem of storage of massive real-time data effectively,proposed one storage engine for real-time database.This engine accesses memory-resident table through memory map file mechanism.The converting of file address and linear address mutually is realized by page pool and LRU algorithm while accessing disk-resident table.The table＇s file space is managed by bitmap method and shadow page method is also introduced in designing of database table structure,based on this foundation,transaction committing and rollback is achieved.This engine can convert one table from disk-resident to memory-resident and vice versa when database is running.This storage engines also ensures the real-time database has the potential of real-time recovery when confronting table failure.The result shows that this engine is suitable to storage massive real time data in satellite ground device monitoring.

关 键 词：实时数据库 存储引擎 内存文件映射 LRU算法 页面缓冲池 影子页面法 

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