Study on Application of SQLite for Locomotive Fault Diagnosis System
Lide Wang · Railway Locomotive & Car · 2012
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.