基于RTX的实时数据库系统关键技术研究

Crucial technology research of real-time database system based on RTX

针对半实物仿真实时数据管理需求和传统实时数据库的不足,基于windows+RTX构架设计了一种新型实时数据库系统。实时数据库系统由RTX下的内存数据库和Windows下的外存数据库组成,结合了RTX实时系统的高精度实时性能与关系型数据库SQL Server数据存储安全性能。采用RTX内存锁定技术,避免了因内存块被windows置换所引起的数据丢帧。采用高精度定时采集技术,克服了因windows定时不准所导致的数据误码。采用IPC数据传递技术,实现了将高速度大容量实时数据刷新到windows下的外存数据库的存储任务。测试结果表明,普通数据采集频率可达2 000 Hz,图像数据采集速率可达60 MB/s,并且没有丢帧现象发生。

Aiming at the request of aircraft hardware in the loop simulation and disadvantages of commercial real-time database, a new Real-time Database System （RTDBS） based on Windows＋ RTX frame was designed in this paper. Made up of RTX memory database and windows disk database, RTDBS combined real-time characteristic of RTX and data security performance of SQL Server. RTX memory locking technique was used to avoid frame dropping owing to memory replacement of windows. High precision timing technique was used to overcome misdate collection due to windows inaccurate timer. IPC data transmission technique was used to refresh data into windows disk database in a large scale with high speed. Experimental results showed that RTDBS achieved 2000 Hz for common data, 60MB/s for image data without frame dropping.