54
Image 2.16 SQLite File Structure
(Source: A recovery method of deleted record for SQLite database –
Jeon, Bang, Byun and Lee, 2012)
2.
Schema table
Schema table is located in Header Page which contains information
on table; index and trigger consisted in SQLite in an application
software.
3.
Table b-tree
The main function of table b-tree is to maintain storing actual data
and many complicated processes between tables.
4.
Page structure
Pages in SQLite file is constructed by a page header and followed
by several cells that are used to move sequence from bottom of the
page upward.
 |