Embedded Databases on Flash Memories: Performance and Lifetime Issues, the case of SQLite

Databases are more and more used in embedded system applications and especially in consumer electronics. This comes from the need to structure user and/or system data to be more efficiently managed and accessed. SQLite is one of the most used database applications. This paper presents a micro benchmarking methodology and results for SQLite database requests on embedded flash specific file systems. Indeed, flash file systems behavior are very specific to flash memory intricacies and the objective of this study is to highlight the interactions between flash memory, flash file systems, and SQLite based applications.