SQLite在机车故障诊断系统中的应用研究

将一种新型轻量级嵌入式数据库SQLite应用在机车故障诊断系统智能显示终端中,实现了对故障数据进行采集、存储、诊断及显示。通过对嵌入式数据库进行设计与建立,对数据库API函数的封装与调用及移植等技术手段完成数据库在系统中的集成与实现。认为该数据库以尺寸小、实时高效、零配置等诸多特点克服了一般数据库占用内存空间大、实时性差、访问过程复杂等缺点,解决了故障数据在显示终端非实时显示的问题。最后在定制的Windows CE平台上进行测试,并与SQL Server CE进行对比,证明其优越的性能。该数据库在提高系统终端故障信息的处理能力方面发挥了重要的作用。

Study on Application of SQLite for Locomotive Fault Diagnosis System

A novel type of lightweight SQLite embedded database is applied in the intelligent display unit of our locomotive fault diagnosis system,which achieves realization of the real-time collection,recording,diagnosis,and display of fault data on the embedded device.Firstly,the fault information database is designed and constructed.Then this database is integrated into the existing locomotive fault diagnosis system display unit by calling API functions,transplanting database,and so on.SQLite which is notable for its small core,high efficiency,zero-configuration overcomes common databases’ difficulties as occupying large memory space,poor real-time and accessing to the database complexly.And it also solves the problem of non-real-time displaying fault information.Finally the high efficiency of SQLite is attested by testing on customized Windows CE platform and compared with SQL Server CE.The results indicate that SQLite plays an important role in improving the diagnosis system on the ability of disposing fault information.