Comparison of the possible uses and performance analysis of databases on mobile operating systems Mateusz Grudzień*, Konrad Korgol*, Dariusz Gutek


Abstract

This publication presents chosen forms of data persistence such as: Local Storage, Shared Preferences, flat files and SQLite in the context of two widely used mobile operating systems – Android and Windows Mobile. It also describes ways to connect to external database engines such as Microsoft SQL Server, PostgreSQL or MySQL and tries to answer the question which one of these data persistence forms makes the most sense and when. The arguments are based on performance tests that all of the described solutions were participants of.


Keywords

Android; Windows Mobile; database; mobile device

[1] Hengming F., Jia Ch., Bin X.; The Interaction Mechanism based on JSON for Android Database Application, Academic Journal, 2013 – JSON.
[2] Lee S.; Creating and Using Databases for Android Applications, International Journal of Database Theory and Application Vol. 5 No. 2, 2012.
[3] H.V. Leong and A. Si, Database Caching Over the Air-Storage, The Computer Journal 40(7) , 1997.
[4] Nurseitow N., Paulson M., Reynolds R., Izurieta C.; Comparison of JSON and XML Data Interchange Formats: A Case Study; Montana State University – Bozeman.
[5] Si A., Leong H. L., The Hung Kong Polytechnic University Query optimization for broadcast database, 1998.
[6] Wei J.; Android Database Programming, Packt Publishing Ltd., 2012.
[7] Klasa Cursor, Android Developers, https://developer.android.com/reference/android/database/Cursor.html, dostęp: październik 2016r.
[8] Klasa FileOutputStream, Oracle Help Center, https://docs.oracle.com/javase/7/docs/api/java/io/FileOutputStream.html, [01.09.2016]
[9] Klasa FileInputStream, Oracle Help Center, https://docs.oracle.com/javase/7/docs/api/java/io/FileInputStream.html, [01.09.2016]
[10] Klasa SharedPreferences, Android Developers, https://developer.android.com/reference/android/content/SharedPreferences.html, [01.09.2016].
[11] Klasa SQLiteDatabase, Android Developers, https://developer.android.com/reference/android/database/sqlite/SQLiteDatabase.html, [01.10.2016].
[12] Klasa SQLiteOpenHelper, Android Developers, https://developer.android.com/reference/android/database/sqlite/SQLiteOpenHelper.html, [01.09.2016].
[13] Save a File on External Storage, Android Developers, https://developer.android.com/training/basics/datastorage/files.html#WriteExternalStorage, [01.09.2016].
[14] Save a File on Internal Storage, Android Developers, https://developer.android.com/training/basics/datastorage/files.html#WriteInternalStorage, [01.09.2016].

Published : 2016-12-30


Grudzień, M., Korgol, K., & Gutek, D. (2016). Comparison of the possible uses and performance analysis of databases on mobile operating systems Mateusz Grudzień*, Konrad Korgol*, Dariusz Gutek . Journal of Computer Sciences Institute, 2, 133-139. https://doi.org/10.35784/jcsi.129

Mateusz Grudzień 
Lublin University of Technology  Poland
Konrad Korgol  konrad.korgol@gmail.com
Lublin University of Technology  Poland
Dariusz Gutek 
Lublin University of Technology  Poland