摘要
针对工业控制实时性要求,提出了一种内存数据库设计方法,并对数据库的结构进行了设计。为了提高内存利用率,给出了基于页的内存组织与管理方法。采用基于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.
出处
《指挥信息系统与技术》
2012年第1期81-84,共4页
Command Information System and Technology
关键词
内存数据库
内存组织与管理
索引服务
main memory database
memory organization and management
index service