Automated recommendation backend web database tier architecture benchmarking

Hassan, Govan Anwar; Faraj, Kamaran Hama Ali; Sidqi, Haval

doi:10.22075/ijnaa.2023.28139.4207

Automated recommendation backend web database tier architecture benchmarking

Document Type : Research Paper

Authors

Govan Anwar Hassan ¹

Kamaran Hama Ali Faraj ²^{, 3}

Haval Sidqi ⁴

¹ Department of Applied Computer, College of Informatics, Polytechnic University, Sulaymaniyah, Iraq

² Department of Computer, College of Science, Sulamani university, Sulamani, KRI

³ Department of Computer Engineering, College of Engineering and Computer Science, Lebanese French University, Erbil, Iraq

⁴ Technical College of informatics, Sulaimani Polytechnic University, Iraq

10.22075/ijnaa.2023.28139.4207

Abstract

The database management system (DBMS) for any application is crucial for developers because each application needs high performance to run efficiently. Therefore, database Benchmarking is the process of performing several Defined tests on those databases to evaluate their performance. The electronic benchmarking System (EBS) facilitates and improves human resource management (HRM) in all aspects of real life. EBS designed by four different database backends and three different web technology. This paper presents a comparative evaluation of the performance of the top DBMS systems namely (MySQL, SQL Server, Oracle, and MS Access). The middleware is designed using three dynamic web technologies (PHP, ASP, and PYTHON). In order to evaluate the backend performance for the four mentioned databases system by using two Parameters Response Time (RT) and Throughput (TT) over different Tire Architectures namely: One-Tier Architecture (1TA), Two-Tier Architecture (2TA). This paper will show which of the database has a better Response time (RT) and Throughput (TT).

Keywords

SQL Server

Oracle

MYSQL

MS-Access

[1] J. Babovic, V. Raicevic and M. Caric, Benchmarking as a function of competitiveness and efficiency in business, Ekonomika poǉoprivrede 59 (2012), no. 1, 115–127.

[2] Y. Bassil, A comparative study on the performance of the top DBMS systems, arXiv preprint arXiv:1205.2889, (2012), 20–31.

[3] B. Bulger, J. Greenspan and D. Wall, MySQL/PHP database applications, John Wiley & Sons, 2003.

[4] J. Darmont, Database benchmarks, Database Technologies: Concepts, Methodologies, Tools, and Applications, IGI Global, 2009, pp. 1226–1233.

[5] J. Duraes, M. Vieira and H. Madeira, Dependability benchmarking of web-servers dependability benchmarking of web-servers, Int. Conf. Comput. Safety Reliab. Secur., Springer, Berlin, Heidelberg, 2004, pp. 297–310.

[6] M. Ilic, D.M. Zlatkovic and M. Trajkovic, Microsoft SQL server and oracle: comparative performance Microsoft SQL server and oracle: comparative, Book of Proc. 7th Int. Conf. Knowledge Manag. Inf., Vrnjaˇcka Banja, 2021.

[7] O.H. Jader, S.R.M. Zeebaree and R.R. Zebari, A state of art survey for web server performance measurement and load balancing mechanisms, Int. J. Sci. Technol. Res. 8 (2019), no. 12, 535–543.

[8] K. Lei, Y. Ma and Z. Tan, Performance comparison and evaluation of web development technologies in PHP, Python and node. js, IEEE 17th Int. Conf. Comput. Sci. Engin., 2014, pp. 661–668.

[9] M. Malik and T. Patel, Database security–attacks and control methods, Int. J. Inf. Sci. Tech. 6 (2016), no. 1/2, 175–183.

[10] H.J. Mohammed and K.H.A. Faraj, A python-WSGI and PHP-apache web server performance analysis by search page generator (SPG), UKH J. Sci. Eng. 5 (2021), no. 1, 132–138.

[11] M. Naik, Database management system performance analysis and comparison, PhD diss. California State University, Sacramento, 2011.

[12] A.H. Odeh, Analytical and comparison study of main web programming languages-ASP and PHP, TEM J. 8 (2019), no. 4, 1517—1522.

[13] P.D.F. Pack, Python–the fastest growing programming language, Int. Res. J. Eng. Technol. 4 (2017), no. 12.

[14] K.I. Satoto, R.R. Isnanto, R. Kridalukmana and K.T. Martono, Optimizing MySQL database system on information systems research, publications and community service, 3rd Int. Conf. Inf. Technol. Comput. Electrical Engin. (ICITACEE), IEEE, 2016, pp. 1–5.

[15] S. Trent, M. Tatsubori, T. Suzumura, A. Tozawa and T. Onodera, Performance comparison of PHP and JSP as server-side scripting languages, ACM/IFIP/USENIX Int. Conf. Distributed Syst. Platforms Open Distributed Process., Springer, Berlin, Heidelberg, 2008, pp. 164–182.

[16] G.M.O. Zebari, K. Faraj and S.R.M. Zeebaree, Handwriting code-PHP or wire shark ready application over tier architecture with Windows servers operating systems or Linux server operating systems, Int. J. Comput. Sci. Eng. 4 (2016), no. 6, 142–149.