53
b.
Names of relationships.
c. Integrity constraints on the data.
d.
Names of authorized users who have the access to the data.
e. The data items that each user can access and the types of access
allowed; for example, insert, update, delete, or read access.
f. External, conceptual, and internal schemas and the mappings between
the schemas.
g.
Usage statistics, such as the frequencies of transactions and counts
on the number of accesses made to objects in the database.
2.2.4.2.
Database
According to Connoly and Begg
(2010), database is a single,
possibly large repository of data that can be used simultaneously by
many departments and users. Instead of being hold by only one
department or user, data is shared as corporate resource, therefore it is
very important to minimize amount of duplication among the data itself.
In order to achieve that goal, database holds not only the organization’s
operational data but also a description of the data which until further
notice will be known as self-describing collection of integrated records.
2.2.4.3.
SQLite
Based on Jeon, Bang, Byun and Lee (2012) SQLite is a small
factor of database which usually used by mobile and embedded devices
to store data. SQLite database is consisted of 4 main structures:
1.
SQLite database file
SQLite file structure is actually divided into 2 main parts, which are
Header Page that usually located in Page 1 and Root pages that
located in Page 2 and so on.
 |