ENHANCEMENTS TO SQLITE LIBRARY TO IMPROVE PERFORMANCE ON MOBILE PLATFORMS

This thesis aims to present solutions to improve the performance of SQLite library on mobile systems. In particular, two approaches are presented to add light-weight locking mechanisms to the SQLite library and improve concurrency of the SQLite library on Android operating system. The impact on performance is discussed after each section. Many applications on the Android operating system rely on the SQLite library to store ordered data. However, due to heavy synchronization primitives used by the library, it becomes a performance bottleneck for applications which push large amount of data into the database. Related work [1] in this area also points to SQLite [2] database as one of the factors for limiting performance. With increasing network speeds, the storage system can become a performance bottleneck, as applications download larger amounts of data. The following work in this thesis addresses these issues by providing approaches to increase concurrency and add light-weight locking mechanisms. The factors determining the performance of Application Programming Interfaces provided b