Comparison of the possible uses and performance analysis of databases on mobile operating systems Mateusz Grudzień*, Konrad Korgol*, Dariusz Gutek
Mateusz Grudzień
Lublin University of Technology (Poland)
Konrad Korgol
konrad.korgol@gmail.comLublin University of Technology (Poland)
Dariusz Gutek
Lublin University of Technology (Poland)
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 deviceReferences
[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].
[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].
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
Authors
Mateusz GrudzieńLublin University of Technology Poland
Authors
Dariusz GutekLublin University of Technology Poland
Statistics
Abstract views: 225PDF downloads: 55
License
This work is licensed under a Creative Commons Attribution-ShareAlike 4.0 International License.
