Desoky Abdelqawy
Current Organizations / Institutes
The organizations/institutes from the scholar's latest article
Desoky Abdelqawy has a total of 5 co-authors. Here are the top co-authors by number of shared publications:
Abeer El-Korany
Faculty of Computers and Artificial Intelligence, Cairo University, 5 Dr. Ahmed Zewail Street, Giza 12613, Orman, Egypt
1 shared publicationAmr Kamel
Faculty of Computers and Artificial Intelligence, Cairo University, 5 Dr. Ahmed Zewail Street, Giza 12613, Orman, Egypt
1 shared publicationMahmoud Nasr
Cairo University
1 shared publication- Mohammad El-Ramly
Cairo University & University of London Branch (EUE)
1 shared publication Soha Makady
Faculty of Computers and Artificial Intelligence, Cairo University, 5 Dr. Ahmed Zewail Street, Giza 12613, Orman, Egypt
1 shared publication
Latest Publications
- Open Access
- 16 July 2025
- Published by Springer Nature in Research Square
Comparative Performance Analysis of Four RDBMS Systems Integrated with Django's ORM
Object--Relational Mapping (ORM) frameworks make it easier to develop applications but often incur a significant performance overhead. This paper presents a comprehensive experimental evaluation of four popular relational databases (MySQL, PostgreSQL, Oracle, and Microsoft SQL Server) accessed via Django's ORM. Using the TPC-H benchmark, we measured query execution time, throughput, and resource utilization under varying query complexities and concurrency levels. PostgreSQL delivered the best overall performance under complex queries via the ORM, whereas Oracle’s superior raw SQL speed was largely offset by high ORM overhead. SQL Server showed balanced results, and MySQL performed well on simple queries but struggled with complex ones. We quantify the ORM-induced slowdown---ranging from 2.6 times in PostgreSQL to 5 times in Oracle---and demonstrate that proper indexing can improve performance by over 60% across all systems. These statistically significant findings underscore important trade-offs when using ORM frameworks. Our study provides new insights and practical guidance for selecting and tuning ORM-database combinations to achieve optimal performance.
- 16 July 2025
- Published by Springer Nature in Research Square
Open AccessComparative Performance Analysis of Four RDBMS Systems Integrated with Django's ORM
Object--Relational Mapping (ORM) frameworks make it easier to develop applications but often incur a significant performance overhead. This paper presents a comprehensive experimental evaluation of four popular relational databases (MySQL, PostgreSQL, Oracle, and Microsoft SQL Server) accessed via Django's ORM. Using the TPC-H benchmark, we measured query execution time, throughput, and resource utilization under varying query complexities and concurrency levels. PostgreSQL delivered the best overall performance under complex queries via the ORM, whereas Oracle’s superior raw SQL speed was largely offset by high ORM overhead. SQL Server showed balanced results, and MySQL performed well on simple queries but struggled with complex ones. We quantify the ORM-induced slowdown---ranging from 2.6 times in PostgreSQL to 5 times in Oracle---and demonstrate that proper indexing can improve performance by over 60% across all systems. These statistically significant findings underscore important trade-offs when using ORM frameworks. Our study provides new insights and practical guidance for selecting and tuning ORM-database combinations to achieve optimal performance.
- Open Access
- 25 February 2022
- Published by Springer Nature in Journal of King Saud University Computer and Information Sciences
- Vol. 34 (4) , 1498-1510
Hub-OS: An interoperable IoT computing platform for resources utilization with real-time support
- 25 February 2022
- Published by Springer Nature in Journal of King Saud University Computer and Information Sciences
- Vol. 34 (4) , 1498-1510
Open AccessHub-OS: An interoperable IoT computing platform for resources utilization with real-time support