Embedded Internet of Things Applications of SQLite Based on WinCE Mobile Terminal

As we all know, embedded systems are becoming more and more widely used. All devices with digital interfaces, such as watches, microwave ovens, video recorders, automobiles, etc., use embedded systems, but most embedded systems are implemented by a single embedded application program to achieve the entire control logic.At present, embedded applications on the WinCE platform are extending towards microservices and miniaturization. More embedded device application data requires small, embedded database systems to organize, store, and manage. The embedded database SQLite has many advantages such as zero-configuration, lightweight, multiple interfaces, easy portability, readable source code, and open source. It is currently widely used in the WinCE embedded operating system. This article discusses the technical characteristics of the SQLite database in detail, SQLite data manipulation, SQLite transplantation under the WinCE platform, and finally implements SQLite data management on WinCE mobile terminal based on MFC programming.

Embedded Internet of Things Applications of SQLite Based on WinCE Mobile Terminal

At present, embedded applications on the WinCE platform are extending towards microservices and miniaturization. More embedded device application data requires small, embedded database systems to organize, store, and manage. The embedded database SQLite has many advantages such as zero-configuration, lightweight, multiple interfaces, easy portability, readable source code, and open source. It is currently widely used in the WinCE embedded operating system. This article discusses the technical characteristics of the SQLite database in detail, SQLite data manipulation, SQLite transplantation under the WinCE platform, and finally implements SQLite data management on WinCE mobile terminal based on MFC programming.

Taming Performance Variability of Healthcare Data Service Frameworks with Proactive and Coarse-Grained Memory Cleaning

This article explores the performance optimizations of an embedded database memory management system to ensure high responsiveness of real-time healthcare data frameworks. SQLite is a popular embedded database engine extensively used in medical and healthcare data storage systems. However, SQLite is essentially built around lightweight applications in mobile devices, and it significantly deteriorates when a large transaction is issued such as high resolution medical images or massive health dataset, which is unlikely to occur in embedded systems but is quite common in other systems. Such transactions do not fit in the in-memory buffer of SQLite, and SQLite enforces memory reclamation as they are processed. The problem is that the current SQLite buffer management scheme does not effectively manage these cases, and the naïve reclamation scheme used significantly increases the user-perceived latency. Motivated by this limitation, this paper identifies the causes of high latency during processing of a large transaction, and overcomes the limitation via proactive and coarse-grained memory cleaning in SQLite.The proposed memory reclamation scheme was implemented in SQLite 3.29, and measurement studies with a prototype implementation demonstrated that the SQLite operation latency decreases by 13% on an average and up to 17.3% with our memory reclamation scheme as compared to that of the original version.