TT-IPL Model – The Upgraded Version of the IPL Model in SQLite Setting
Hui-Jeong Ju, Sungje Cho · Advanced science and technology letters · 2015
SQLite is increasingly used for data processing in flash memories. Update-in-place cannot be conducted on flash memory, it causes performance degradation for mobile's SQLite during write operations. As a remedy for this performance degradation inevitably caused by frequent write operation from using SQLite in flash memory, the SQLite-IPL model was proposed. But this model uses B-Tree index structure in SQLite for write operation, which regresses transaction performance compared to the T-Tree index structure. Thus, this study proposes an improved model called T-IPL, which designed the T- T ree index in a separate section to improve performance.