Open Access Open Access  Restricted Access Subscription Access

MySQL in Mobile Application Backend Systems

Akash Vijayan I V

Abstract


Database management solutions play a vital role in order to store, access and properly scale a growing amount of data in the constantly changing field of modern mobile applications. However, since MySQL is open source, highly reliable, and offers a broad set of features, it serves as the basis for many backends of mobile applications. To achieve the objectives of this study, a real life mobile application with actual mobile users and backend MySQL database will be analyzed and the findings will be primary in nature and the focus will be to determine the usability, scalability and performance of MySQL in mobile application backend systems. In this work the coordination of processes and still mus handing of multiple users at once and real-time data is examined, using sample datasets copied to the database and running SQL queries for the mobile app scenario. The finding will therefore compare the strengths and weaknesses of MySQL to arrive at recommendations on its appropriate use when considering mobile application designs.


Full Text:

PDF

References


Chaudhuri, S., & Narasayya, V. (2011). Indexing techniques for mobile applications. Proceedings of the ACM SIGMOD International Conference on Management of Data, 15-25.

Kettler, M., Landwehr, A., & Schmidt, S. (2008). MySQL in enterprise environments: Performance and scalability. Database Management Review, 21(3), 48-55.

Kumar, A., & Simmhan, Y. (2019). Distributed backend systems and MySQL scalability for mobile applications. Journal of Distributed Systems, 29(2), 122-135.

Leavitt, N. (2010). Database trade-offs: MySQL vs. NoSQL databases for mobile apps. Communications of the ACM, 53(7), 26-28.

Nguyen, T., Tran, D., & Li, C. (2017). Hybrid database environments: MySQL in real-time analytics for mobile applications. International Journal of Database Systems, 19(4), 101-115.

Oracle Corporation. (2015). MySQL scalability and replication improvements. MySQL White Papers.

Stonebraker, M. (2010). A comparison of relational databases: MySQL and beyond. Database Systems Journal, 27(1), 33-42.

Sadalage, P., & Fowler, M. (2012). NoSQL and relational databases: Choosing the right approach for mobile apps. O'Reilly Media.

Widenius, M., & Axmark, D. (2002). MySQL: The world's most popular open-source database. MySQL AB.

Zaitsev, M., Wang, H., & Zhang, Y. (2018). Optimizing MySQL queries for mobile application backends. Journal of Database Optimization, 14(3), 75-89.


Refbacks

  • There are currently no refbacks.