Skip to main content

Detecting performance issues in application-database interactions

Resource type
Thesis type
(Project) M.Sc.
Date created
2025-08-11
Authors/Contributors
Abstract
Modern software systems rely on database systems to store and manage data, and ORM frameworks are widely used to streamline database interactions. However, ORM frameworks can introduce subtle performance issues if not used carefully. These performance issues are exacerbated as the amount of data the applications store and process increase, thus making them difficult to detect during testing. This work introduces a novel approach to identify a set of four performance issues in applications that use ORMs. Our approach uses dynamic analysis to accommodate dynamic typing and be able to accurately track the data flow throughout the execution of the application. We also implement our approach, and tailor it to a widely used ORM for Python, Django ORM, which is part of the Django web framework. Finally, we evaluate our tool on a set of six open-source Django projects to demonstrate its effectiveness in identifying ORM antipatterns. Our results show that our approach can effectively identify ORM antipatterns in Django projects, and that it can be used to improve the performance of Django applications.
Document
Extent
48 pages.
Identifier
etd23973
Copyright statement
Copyright is held by the author(s).
Permissions
This thesis may be printed or downloaded for non-commercial research and scholarly purposes.
Academic Supervisor
Thesis advisor: Sumner, William
Language
English
Member of collection
Download file Size
etd23973.pdf 679.26 KB