基于SQLite数据库的车载收费机的设计与开发

Design and development of vehicle-embedded POS machine based on SQLite

介绍了运用32位ARM处理器和SQLite数据库来设计车载收费机的一种方案.通过32位ARM处理器取代8位单片机处理器,构建ARM-Linux系统,增加了车载收费机的程序空间和数据存储空间,增加了防范黑名单的数量.利用ARM-SQLite数据库在车载收费机上实现分时段计费和各类统计查询,得到不同时段的客流量信息.同时采用无线网络实现营运数据的采集,减轻了管理人员的工作量和失误率.

The paper introduces a solution that uses 32bit ARM processor and SQLite database to design a POS machine.By using ARM 32 bit ARM processor to replace 8 bit single chip processor and constructing ARM-Linux,the program space and data storage volume of the vehicle-embedded POS machine were increased and the number of blacklist prevention was also raised.By using ARM-SQLite database,time-period billing was realized at vehile-embedded POS machine;various counting and inquiring services were made possible,and the passenger volume in different time periods can be analyzed.Besides,wireless network was adopted to collect operation data,which reduces the operator＇s workload and his/her error rate.