Comparative analysis of the performance of relational and non-relational databases in applications implemented in C#
The article focuses on comparing relational and non-relational databases using applications written in C#. The aim of the study is to understand in which cases relational databases are preferred and when it is worth considering the use of non-relational databases. The research examines the speed of...
Saved in:
| Main Authors: | , , |
|---|---|
| Format: | Article |
| Language: | English |
| Published: |
Lublin University of Technology
2025-03-01
|
| Series: | Journal of Computer Sciences Institute |
| Subjects: | |
| Online Access: | https://ph.pollub.pl/index.php/jcsi/article/view/6688 |
| Tags: |
Add Tag
No Tags, Be the first to tag this record!
|
| _version_ | 1849387959016488960 |
|---|---|
| author | Patryk Baliński Łukasz Chudy Maria Skublewska-Paszkowska |
| author_facet | Patryk Baliński Łukasz Chudy Maria Skublewska-Paszkowska |
| author_sort | Patryk Baliński |
| collection | DOAJ |
| description |
The article focuses on comparing relational and non-relational databases using applications written in C#. The aim of the study is to understand in which cases relational databases are preferred and when it is worth considering the use of non-relational databases. The research examines the speed of data retrieval, updating, and deletion, in the context of five different databases, including relational ones like PostgreSQL, MySql, Oracle, and non-relational ones such as Neo4j and MongoDB. The data consists of 1,578,098 records. In the case of relational databases, a unified database model was applied, while in NoSQL databases, the data model was appropriately adjusted to the specific type of non-relational database. Differences in the execution time of database queries are analyzed based on indexing strategies and query complexity. Special attention is given to query performance efficiency in the context of using C# and libraries that facilitate the connection between the application and databases. The conducted research indicates that the PostgreSQL database achieves the lowest average query response times.
|
| format | Article |
| id | doaj-art-fa06b8b2f80e489b8e0701b57c53f79f |
| institution | Kabale University |
| issn | 2544-0764 |
| language | English |
| publishDate | 2025-03-01 |
| publisher | Lublin University of Technology |
| record_format | Article |
| series | Journal of Computer Sciences Institute |
| spelling | doaj-art-fa06b8b2f80e489b8e0701b57c53f79f2025-08-20T03:42:26ZengLublin University of TechnologyJournal of Computer Sciences Institute2544-07642025-03-013410.35784/jcsi.6688Comparative analysis of the performance of relational and non-relational databases in applications implemented in C#Patryk Baliński0Łukasz Chudy1Maria Skublewska-Paszkowska2Department of Computer Science, Lublin University of TechnologyDepartment of Computer Science, Lublin University of TechnologyDepartment of Computer Science, Lublin University of Technology The article focuses on comparing relational and non-relational databases using applications written in C#. The aim of the study is to understand in which cases relational databases are preferred and when it is worth considering the use of non-relational databases. The research examines the speed of data retrieval, updating, and deletion, in the context of five different databases, including relational ones like PostgreSQL, MySql, Oracle, and non-relational ones such as Neo4j and MongoDB. The data consists of 1,578,098 records. In the case of relational databases, a unified database model was applied, while in NoSQL databases, the data model was appropriately adjusted to the specific type of non-relational database. Differences in the execution time of database queries are analyzed based on indexing strategies and query complexity. Special attention is given to query performance efficiency in the context of using C# and libraries that facilitate the connection between the application and databases. The conducted research indicates that the PostgreSQL database achieves the lowest average query response times. https://ph.pollub.pl/index.php/jcsi/article/view/6688relational databasesnon-relational databasesperformance analysiscomparisonC# |
| spellingShingle | Patryk Baliński Łukasz Chudy Maria Skublewska-Paszkowska Comparative analysis of the performance of relational and non-relational databases in applications implemented in C# Journal of Computer Sciences Institute relational databases non-relational databases performance analysis comparison C# |
| title | Comparative analysis of the performance of relational and non-relational databases in applications implemented in C# |
| title_full | Comparative analysis of the performance of relational and non-relational databases in applications implemented in C# |
| title_fullStr | Comparative analysis of the performance of relational and non-relational databases in applications implemented in C# |
| title_full_unstemmed | Comparative analysis of the performance of relational and non-relational databases in applications implemented in C# |
| title_short | Comparative analysis of the performance of relational and non-relational databases in applications implemented in C# |
| title_sort | comparative analysis of the performance of relational and non relational databases in applications implemented in c |
| topic | relational databases non-relational databases performance analysis comparison C# |
| url | https://ph.pollub.pl/index.php/jcsi/article/view/6688 |
| work_keys_str_mv | AT patrykbalinski comparativeanalysisoftheperformanceofrelationalandnonrelationaldatabasesinapplicationsimplementedinc AT łukaszchudy comparativeanalysisoftheperformanceofrelationalandnonrelationaldatabasesinapplicationsimplementedinc AT mariaskublewskapaszkowska comparativeanalysisoftheperformanceofrelationalandnonrelationaldatabasesinapplicationsimplementedinc |