Description: The Android operating system is based on the Linux kernel and Google’s own Java Virtual Machine implementation. For most mobile applications, especially business applications, a local relational database is used for data storage. The most common technology for organizing interaction with the database is ORM (Object-Relational Mapping) - a programming technology that connects the database with the concepts of object-oriented programming languages, creating a “virtual object database”. ORM solutions are used to optimize the work of writing software code when creating a database. The issue to be research in the article is the development process of the data-driven mobile applications for android platform. Also the article dealt with the detailed analysis of the modern database management techniques for Android. The ORM analysis focuses on the efficiency evaluation of the different libraries that provide the database and application interaction. Under the publication, the following tasks are carried out: the analysis of the most widely used ORM-libraries, built by the third-party developers for OS Android, namely: ActiveAndroid, ORMLite, GreenDAO and SugarORM. The essence of the study is a comparison of the most common ORM-libraries and the results of its performance. To compare the considered ORM solutions for database management in Android, the results of tests conducted by Sebbia are used. For the basic evaluation, when testing libraries, not the features of each ORM were taken, but the speed of performing similar tasks assigned to each of them.The following results have been achieved: It was examined the usage complexity of API-libraries with software implementation of the ORM model and studied the operating speed of the application’s CRUD-operations with the ORM above mentioned as well. The best results for the performance of standard CRUD database operations, which corresponds to the use of standard Android tools, are shown by the GreenDAO library. Each ORM solution is convenient in its own way, but has its disadvantages, so each programmer has the right to choose exactly which ORM solution to use it. Conclusions: the analysis allows to improve the efficiency of the development and scaling of mobile applications in terms of database management for the Android platform.
Keywords: database, Android, ORM, ORM-library, ActiveAndroid, ORMLite, GreenDAO, SugarORM
1. Sommerhoff, Peter (2018), Kotlin for Android App Development, Addison-Wesley Professional, 432 p.
2. Späth, Peter (2018), Pro Android with Kotlin: Developing Modern Mobile Apps, Apress, 485 p.
3. Stroud, Adam (2016), Android Database Best Practices, Addison-Wesley Professional, 288 p.
4. Save data in a local database using Room, available at: https://developer.android.com/training/data-storage/room/.
5. ActiveAndroid Guide, available at: https://guides.codepath.com/android/activeandroid-guide.
6. Introduction to GreenDAO, available at: http://greendao-orm.com/documentation/introduction/.
7. Eshin, S.S. (2015), “Sravnytelnyi analyz API ORM-byblyotek dlia platformy Android” [Comparative analysis of API ORM-libraries for the Android platform], Informatyka: problemy, metodolohyia, tekhnolohyy.
8. Titze, D. and Schutte, J. (2015), Preventing Library Spoofing on Android, 2015 IEEE Trustcom/BigDataSE/ISPA. https://doi.org/10.1109/trustcom.2015.494.
9. Petrucha, J. (2016), Design of database applications in mobile devices with OS Android, 16th International Multidisciplinary Scientific GeoConference SGEM2016, Informatics, Geoinformatics and Remote Sensing. https://doi.org/10.5593/sgem2016/b21/s07.023.
10. Esin, V.I. (2012), “Vozmozhnosti razlichnykh skhem baz dannykh po predstavleniiu i rabote s dannymi” [Possibilities of various schemes of databases on presentation and work with data], Information Processing Systems, Vol. 2(100), pp. 195-198.
11. Tretiak, V.F., Kuzhel, I.E. and Prikhodko, V.M. (2010), “Ispolzovanie tekhnologii replikatsii v sisteme upravleniia raspredelennymi bazami dannykh” [Use of technology of replication in control the system by the distributed databases], Scientific Works of Kharkiv National Air Force University, Vol. 2(24), pp. 109-114.
12. Tanianskii, S.S. (2012), “Usloviia sokhraneniia korrektnogo sostoianiia bazy dannykh pri modifikatsii struktury otnoshenii” [Tanianskii, S.S. (2012), “Usloviia sokhraneniia korrektnogo sostoianiia bazy dannykh pri modifikatsii struktury otnoshenii”, Information Processing Systems, Vol. 9(107), pp. 211-214.], Information Processing Systems, Vol. 9(107), pp. 211-214.
13. Nooh Taha Nasif, (2017), Development of a hybrid mobile application for android with the function of processing and scanning of bar-codes, Systems of Arms and Military Equipment, No. 2(50), pp. 159-167.
14. Dubrovskii, M.S. and Semenov, S.G. (2016), Comparative overview of basic cybervulnerabilities of mobile applications for Android operating system, Information Processing Systems, Vol. 3(140), pp. 18-20.
15. Ilina, I.V. and Petlenko, O.S. (2015), “Analiz mozhlyvostei vprovadzhennia spetsialnoho prohramnoho zabezpechennia v OS Android” [Analysis of the possibility of introducing special software in the OS Android], Systems of Arms and Military Equipment, No. 2(42), pp. 90-91.