A Survey on the Use of MySQL and MongoDB in Data-Driven Applications for Small and Medium Enterprises

Rami Reddy Kothamaram; Dinesh Rajendran; Venkata Deepak Namburi; Vetrivelan Tamilmani; Aniruddha Arjun Singh; Vaibhav Maniar

Authors

Rami Reddy Kothamaram¹, Dinesh Rajendran², Venkata Deepak Namburi³, Vetrivelan Tamilmani⁴, Aniruddha Arjun Singh⁵, Vaibhav Maniar⁶
¹California University of Management and Science, MS in Computer Information Systems.
²Coimbatore Institute of Technology, MSc Software Engineering.
³University of Central Missouri, Department of Computer Science.
⁴Principal Service Architect, SAP America.
⁵ADP, Sr Implementation Project Manager.
⁶MBA / Product Management.

📄 Download PDF

Abstract

The rapid increase in the digitization of data has transformed how small and medium enterprises (SMEs) manage, analyze, and utilize information for decision-making and operational efficiency. Effective database systems play a crucial role in ensuring scalability, security, and performance in data-driven SME environments. This paper presents a comparative survey of relational and non-relational database management systems, focusing on MySQL and MongoDB, two widely adopted database technologies among SMEs. MySQL represents mature relational systems known for ACID compliance, structured schema enforcement, and reliability in transactional and financial applications. In contrast, MongoDB exemplifies NoSQL databases with flexible schema design, horizontal scalability, and high performance for handling semi-structured and unstructured data in modern applications such as social platforms, IoT systems, and web services. The study evaluates key SME database selection factors including cost-effectiveness, scalability, integration capability, transaction integrity, and data security. Findings indicate that MySQL provides consistency and robustness for structured enterprise workloads, whereas MongoDB offers flexibility and scalability for rapidly evolving and user-driven data environments. The choice between the two ultimately depends on SME operational requirements, technical resources, and anticipated growth.

Keywords

MySQL MongoDB Small and Medium Enterprises Database Management Systems Relational Database NoSQL Database SME Data Systems Scalable Databases Data-Driven Applications Enterprise Data Management

How to Cite This Article

APA Style:
Kothamaram, R. R., Rajendran, D., Namburi, V. D., Tamilmani, V., Singh, A. A., & Maniar, V. (2025). A survey on the use of MySQL and MongoDB in data-driven applications for small and medium enterprises. International Journal of Engineering & Tech Development, 2(2), 12–25.

References

[1] Llave, M. R. (2017). Business intelligence and analytics in small and medium-sized enterprises: A systematic literature review. Procedia Computer Science, 121, 194–205.

[2] Willetts, M., Atkins, A. S., & Stanier, C. (2020). Barriers to SMEs adoption of big data analytics for competitive advantage. IEEE ICDS.

[3] Park, H. J. (2017). A study of the InnoDB storage engine in MySQL 5.6. International Conference on Advanced Service Computing.

[4] Čerešňák, R., & Kvet, M. (2019). Comparison of query performance in relational and non-relational databases. Transportation Research Procedia, 40, 170–177.

[5] Stonebraker, M. (2010). SQL databases v. NoSQL databases. Communications of the ACM, 53(4), 10–11.

[6] Satoto, K. I., et al. (2016). Optimizing MySQL database system on information systems research. ICITACEE.

[7] Khasawneh, T. N., Al-Sahlee, M. H., & Safia, A. A. (2020). SQL, NewSQL, and NoSQL databases: A comparative survey. ICICS.

[8] Gyorodi, C., et al. (2015). A comparative study: MongoDB vs MySQL. EMES.

[9] Jose, B., & Abraham, S. (2020). Performance analysis of NoSQL and relational databases with MongoDB and MySQL. Materials Today Proceedings, 24, 2036–2043.

[10] Patel, S., et al. (2020). MongoDB vs MySQL: A comparative study based on performance.

[11] Karanjkar, D., Barve, K., & Metri, M. (2019). NoSQL over RDBMS in image storing using MongoDB.

[12] Kanoje, S., Powar, V., & Mukhopadhyay, D. (2015). Using MongoDB for social networking website.

[13] Naradda Gamage, S. K., et al. (2020). Global challenges and survival strategies of SMEs. Economies.

[14] Bocconcelli, R., et al. (2018). SMEs and marketing: A systematic literature review. International Journal of Management Reviews.

[15] Prabha, D., et al. (2018). Business enterprise and big data: Evolving database challenges and approaches. International Journal of Pure and Applied Mathematics.