SQLite数据库在调度集中系统中的应用研究  

Research on the Application of SQLite Database in CTC System

作　　者：盛凯 曾壹 王守韦 SHENG Kai;ZENG Yi;WANG Shouwei

机构地区：[1]中国铁道科学研究院集团有限公司通信信号研究所,北京100081 [2]北京华铁信息技术有限公司,北京100081

出　　处：《铁道通信信号》2024年第10期39-43,共5页Railway Signalling & Communication

基　　金：中国铁道科学研究院集团有限公司科研课题(2023YJ071,2023YJ210)。

摘　　要：为解决调度集中系统本地数据管理性能开销大、数据处理效率低下等问题,引入SQLite数据库研究数据管理的高效方式。通过在调度集中系统软件架构的本地数据管理组件中运用SQLite数据库设计数据访问接口,实现本地数据的增加、删除、修改、查询操作,以及操作事务管理机制、异常处理机制。为验证SQLite数据访问接口性能,以调度集中系统的阶段计划和调度命令正文为数据对象,设置大数据量测试的验证场景。试验结果表明,SQLite数据访问接口进行本地数据增、删、改、查的操作耗时下降到传统XML文件访问方式的8%~17%,验证了SQLite数据访问接口在处理大量调度集中系统业务数据时的可用性和高效性,对于维持调度集中系统高效稳定运行和降低系统负载具有重要意义。To address issues including high performance costs and low data processing efficiency in managing local data of the Centralized Traffic Control(CTC)system,SQLite database is introduced to study the efficient way for local data management.In the local data management components of the CTC system software architecture,SQLite database is used to design data access interface,which enables local data operations such as adding,deleting,modifying,and querying,as well as transaction management and exception handling mechanisms.To verify the performance of the SQLite data access interface,a test scenario with large data volume was set up with the phase plan and dispatching command text of the CTC system as the data objects.The test results show that the time required for local data operations such as adding,deleting,modifying,and querying through the SQLite data access interface has decreased to 8%~17%of that by the traditional XML file access method.This demonstrates the availability and efficiency of the SQLite data access interface for processing a large volume of data and its great significance in maintaining the efficient and stable operation of the CTC system while also reducing the system load.

关 键 词：SQLITE数据库 调度集中 本地数据管理 数据访问接口 数据库 

分 类 号：U284.59[交通运输工程—交通信息工程及控制]