Performance Optimization for Flash Memory Database in Mobile Embedded System

The trend of recent technological in flash media have made it an attractive choice for non-volatile data storage in a wide spectrum of computing devices, such as PDA' s, mobile phones, MP3 players, embedded sensors, etc. Compared with the disk drivers, the success of flash media for those devices is mainly due to its superior merits for smaller size, lighter weight, better shock resistance, lower electric consumption, less noise, and faster read performance. At present, one of the most popular embedded databases is SQLITE, which has been widely applied in mobile phones. In this paper, we will optimize for commit strategy and parameters configuration for SQLITE on a real application in mobile phone, which utilizes SQLITE as its embedded database library. We focused on providing different suitable parameter configurations and commit strategy for SQLITE to generate the different Portable flash packages (such as secure digital (SD) cards, mini SD cards, and micro SD cards) according to the special requirement of the middleware applications. Through this way, make such flash memory management database perform more suitable and efficiency to the middleware application in the embedded device which it is exactly implemented on.