一种高效内存数据库设计  

Design Method for Effective Main Memory Database

作　　者：陆宏[1] 

机构地区：[1]中国电子科技集团公司第二十八研究所,南京210007

出　　处：《指挥信息系统与技术》2012年第1期81-84,共4页Command Information System and Technology

摘　　要：针对工业控制实时性要求,提出了一种内存数据库设计方法,并对数据库的结构进行了设计。为了提高内存利用率,给出了基于页的内存组织与管理方法。采用基于T树的索引生成技术提高数据查询速度,同时针对并发控制要求,利用Windows同步机制设计了一个锁对象。试验结果表明,性能上,该内存数据库比SQLite内存数据库提高了2.4倍,比Microsoft SQL Sever提高了500多倍。A design method for the memory database is presented for real-time requirements in in- dustry control field. Firstly, the framework of the memory is designed. Secondly, a memory or- ganizing and managing method based on Web is put forward to improve the memory utilization ra- tio. The index generating technique based on T tree is adopted to improve the data query speed. A lock object using Windows synehronization mechanism is designed. Experimental results show that the operational speed of the memory database is 2.4 times higher than that of SQLite database and 500 times higher than that of Microsoft SQL Sever.

关 键 词：内存数据库 内存组织与管理 索引服务 

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