Erbil Polytechnic University
Erbil Technical Engineering College
Dept of Information System Engineering
Stage: 3rd
Databases in Mobile Application
Development
Prepared By:
Shalaw hoshyar
Muhammad chalak
Muhammad qadr
Mahdi Ali
Asaad aso
Supervisid By:
Mrs.khadija Al_khashab
Contents
Introduction ..................................................................................................................... 1
1. Types of Databases for Mobile Applications: ................................................................... 2
2. Database Examples for Android Studio: .......................................................................... 2
3. Effects of Using Databases in Mobile Apps: ..................................................................... 3
4. Choosing the Best Database for Your Mobile App: ........................................................... 3
References ....................................................................................................................... 4
2
Introduction
Many of the apps you use store data directly on the device. The Clock app
stores your recurring alarms, the Google Maps app saves a list of your
recent searches, and the Contacts app lets you add, edit, and remove your
contacts' information.
1
1. Types of Databases for Mobile Applications:
Mobile app databases play a crucial role in storing and managing data.
Here are the general types:
1. Relational Databases:
o Data is stored in tables with primary and foreign keys to
form relationships.
o Common mobile example: SQLite1.
2. Key-Value Databases:
o Stores information using keys as identifiers with associated
values.
o Used for small bits of data (e.g., UserDefaults in iOS,
SharedPreferences in Android).
3. Object-Oriented Databases:
o Works with complex data objects (as in Swift or Kotlin).
o Executes fast queries with complex data.
o Example: Atlas Device SDKs1.
2. Database Examples for Android Studio:
• When developing Android apps, consider these databases:
o SQLite: Lightweight, embedded, and widely used for local
storage.
o Room Persistence Library: An abstraction layer over
SQLite, simplifying database operations.
o Firebase Realtime Database: Cloud-based, real-time
synchronization.
o Realm: Object-oriented, efficient, and easy to use.
o Couchbase Lite: NoSQL, mobile-first database.
2
3. Effects of Using Databases in Mobile Apps:
• Good Effects:
o Data Persistence: Store user preferences, profiles, and
cached data.
o Efficient Searches: Organized data enables quick retrieval.
o Security: Safeguard sensitive user and business data.
o Error Detection: Identify inconsistencies and conflicts.
• Bad Effects:
o Complexity: Low-level database APIs require effort and
manual query updates.
o Maintenance Overhead: Updates to data structure can be
time-consuming.
o Boilerplate Code: Conversion between SQL queries and
data objects.
o Performance Impact: Poorly optimized databases can
affect app responsiveness.
4. Choosing the Best Database for Your Mobile App:
• Consider:
o Latency: How quickly data can be accessed.
o Caching Capability: Reduce load on the main server.
o Security: Protect sensitive data.
o Scalability: Ability to handle growth.
o Performance: Efficient queries and indexing.
3
References
• Negoita, J. (2022, June 22). Types of Databases for Mobile
Applications. Coding Dude. https://www.coding-
dude.com/wp/databases/database-for-mobile-applications/
• Top 7 Databases for Mobile App Development in 2024. (2024, March
12). GeeksforGeeks. https://www.geeksforgeeks.org/databases-for-
mobile-app-development/
• Which database to use with android application. (n.d.). Stack
Overflow. Retrieved May 3, 2024, from
https://stackoverflow.com/questions/11153924/which-database-to-
use-with-android-application
• Debug your database with the Database Inspector. (n.d.). Android
Developers. https://developer.android.com/studio/inspect/database
• Patel, P. (2023, August 18). Mobile App Development: The Role of
Databases in the Process.
https://www.sapphiresolutions.net/blog/mobile-app-development-
role-of-databases-in-the-process
• Databases for Mobile Apps: Why They Matter and How to Choose
the Right One. (n.d.). Www.orientsoftware.com.
https://www.orientsoftware.com/blog/database-for-mobile-apps/
• Top tips to select the best mobile app database. (n.d.). Third Rock
Techkno. Retrieved May 3, 2024, from
https://www.thirdrocktechkno.com/blog/mobile-app-database/
• Intersog. (2017, September 27). 8 Factors to Consider When
Choosing a Database for Your Mobile App. Medium.
https://medium.com/@Intersog/8-factors-to-consider-when-
choosing-a-database-for-your-mobile-app-42889ca9c4da
