In the previous examples, we didn't use a relational data store for local data. In most cases, especially if we are dealing with a NoSQL database, the relational data paradigm loses its appeal and data denormalization replaces the data consistency concerns in favor of performance. Nevertheless, in certain scenarios, in order to find the optimal compromise between the two, we might need to resort to relational data mappings.

In the relational data management world, the most popular data management system for mobile applications is without a doubt SQLite. SQLite is, at its core, a relational database management system contained in a C programming library. What differentiates SQLite from other relational data management systems is the fact that the SQLite engine does not use or require a standalone process that the consuming application communicates...