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...

Full description

Saved in:
Bibliographic Details
Published inJournal of Computer Sciences Institute Vol. 34; pp. 44 - 53
Main Authors Baliński, Patryk, Chudy, Łukasz, Skublewska-Paszkowska, Maria
Format Journal Article
LanguageEnglish
Published Lublin University of Technology 30.03.2025
Subjects
comparison
non-relational databases
performance analysis
relational databases
Online AccessGet full text
ISSN2544-0764
2544-0764
DOI10.35784/jcsi.6688

Cover

Abstract 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.
AbstractList 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.
Author Baliński, Patryk
Skublewska-Paszkowska, Maria
Chudy, Łukasz
Author_xml – sequence: 1
  givenname: Patryk
  surname: Baliński
  fullname: Baliński, Patryk
– sequence: 2
  givenname: Łukasz
  surname: Chudy
  fullname: Chudy, Łukasz
– sequence: 3
  givenname: Maria
  surname: Skublewska-Paszkowska
  fullname: Skublewska-Paszkowska, Maria
BookMark eNpNkE9LxDAQxYOs4LruxU9Q8CZ0TZOmSY9S_LOw4EXPZZJMNEvblKQI--3t7op4mpn3Hr-Bd00WQxiQkNuCbriQqnzYm-Q3VaXUBVkyUZY5lVW5-LdfkXVKe0opU1IIqpZkakI_QoTJf2MGA3SH5FMWXDZ9YTZidCH2MBg8ShG7ORfm0Jy02fw9_ydZmEBDwpT5IYNx7Lw5WfPdjx32OExoj15zd0MuHXQJ179zRT6en96b13z39rJtHne5KbhUuWVOSqF1Ja3lBS8rxiXTpqbAnBZlIQouFIIqBJOMzQlLGa1rK6qaGiOQr8j2zLUB9u0YfQ_x0Abw7UkI8bOFOHnTYeuAVlpp5hTFUtVaIZW00EIawZ2s3cy6P7NMDClFdH-8gran-ttj_e2xfv4DDaJ6oA
Cites_doi 10.1109/ICACCTech61146.2023.00067
10.33260/zictjournal.v1i1.8
10.35784/jcsi.693
10.14569/IJACSA.2015.061111
10.1007/978-3-031-27908-9
10.1109/TrustCom.2011.70
10.1109/CCBD.2016.030
10.51201/JUSST/21/08341
10.1016/j.future.2015.05.003
10.1109/SIST58284.2023.10223568
10.1016/j.cmpb.2012.10.018
10.35784/jcsi.3743
10.1504/IJBPIM.2015.073655
10.23919/SpliTech55088.2022.9854303
10.1145/2694730.2694731
10.1016/j.jss.2020.110633
ContentType Journal Article
DBID AAYXX
CITATION
DOA
DOI 10.35784/jcsi.6688
DatabaseName CrossRef
DOAJ Directory of Open Access Journals (ODIN)
DatabaseTitle CrossRef
DatabaseTitleList
CrossRef
Database_xml – sequence: 1
  dbid: DOA
  name: DOAJ
  url: https://www.doaj.org/
  sourceTypes: Open Website
DeliveryMethod fulltext_linktorsrc
Discipline Computer Science
EISSN 2544-0764
EndPage 53
ExternalDocumentID oai_doaj_org_article_fa06b8b2f80e489b8e0701b57c53f79f
10_35784_jcsi_6688
GroupedDBID AAYXX
ALMA_UNASSIGNED_HOLDINGS
ARCSS
CITATION
EN8
GROUPED_DOAJ
M~E
Y2W
ID FETCH-LOGICAL-c1378-d2f775bb67dd313462372bc90a2fb54151358ea8152722313d02099d5690cc5e3
IEDL.DBID DOA
ISSN 2544-0764
IngestDate Wed Aug 27 01:32:06 EDT 2025
Tue Jul 01 05:10:31 EDT 2025
IsDoiOpenAccess true
IsOpenAccess true
IsPeerReviewed true
IsScholarly true
Language English
License https://creativecommons.org/licenses/by/4.0
LinkModel DirectLink
MergedId FETCHMERGED-LOGICAL-c1378-d2f775bb67dd313462372bc90a2fb54151358ea8152722313d02099d5690cc5e3
OpenAccessLink https://doaj.org/article/fa06b8b2f80e489b8e0701b57c53f79f
PageCount 10
ParticipantIDs doaj_primary_oai_doaj_org_article_fa06b8b2f80e489b8e0701b57c53f79f
crossref_primary_10_35784_jcsi_6688
ProviderPackageCode CITATION
AAYXX
PublicationCentury 2000
PublicationDate 2025-03-30
PublicationDateYYYYMMDD 2025-03-30
PublicationDate_xml – month: 03
  year: 2025
  text: 2025-03-30
  day: 30
PublicationDecade 2020
PublicationTitle Journal of Computer Sciences Institute
PublicationYear 2025
Publisher Lublin University of Technology
Publisher_xml – name: Lublin University of Technology
References 130110
130111
130130
130114
130115
130112
130113
130118
130119
130116
130117
130121
130122
130120
130125
130126
130123
130124
130107
130129
130108
130105
130127
130106
130128
130109
References_xml – ident: 130112
  doi: 10.1109/ICACCTech61146.2023.00067
– ident: 130123
  doi: 10.33260/zictjournal.v1i1.8
– ident: 130115
– ident: 130125
– ident: 130120
  doi: 10.1109/ICACCTech61146.2023.00067
– ident: 130129
– ident: 130127
– ident: 130108
– ident: 130118
  doi: 10.35784/jcsi.693
– ident: 130122
  doi: 10.14569/IJACSA.2015.061111
– ident: 130105
  doi: 10.1007/978-3-031-27908-9
– ident: 130119
  doi: 10.1109/TrustCom.2011.70
– ident: 130114
  doi: 10.1109/CCBD.2016.030
– ident: 130121
  doi: 10.51201/JUSST/21/08341
– ident: 130113
  doi: 10.1016/j.future.2015.05.003
– ident: 130111
  doi: 10.1109/SIST58284.2023.10223568
– ident: 130116
– ident: 130107
  doi: 10.1016/j.cmpb.2012.10.018
– ident: 130117
  doi: 10.35784/jcsi.3743
– ident: 130106
  doi: 10.1504/IJBPIM.2015.073655
– ident: 130110
  doi: 10.23919/SpliTech55088.2022.9854303
– ident: 130128
– ident: 130109
  doi: 10.1145/2694730.2694731
– ident: 130126
– ident: 130130
– ident: 130124
  doi: 10.1016/j.jss.2020.110633
SSID ssj0002875508
Score 2.2912405
Snippet 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...
SourceID doaj
crossref
SourceType Open Website
Index Database
StartPage 44
SubjectTerms comparison
non-relational databases
performance analysis
relational databases
Title Comparative analysis of the performance of relational and non-relational databases in applications implemented in C#
URI https://doaj.org/article/fa06b8b2f80e489b8e0701b57c53f79f
Volume 34
hasFullText 1
inHoldings 1
isFullTextHit
isPrint
link http://utb.summon.serialssolutions.com/2.0.0/link/0/eLvHCXMwrV07a8MwEBYlU5e-S9MXgnRVI0uWJY9taAiFdmogm9ETEmgakvT_9852Gm9dup6NEHeS7jv79H2EPHCdkiqcZUIbx_KoM1Y65Zni1huA51LUdAxv78Vkmr_O1Kwj9YU9YQ09cOO4YbK8cMaJZHjMTelMhEWaOaW9kkmXCU9fXvJOMbWoPxlpgN6m4SNFQpd8uPCb-WPRSKzsM1CHqL_OKOMTctRCQfrUTOGUHMTlGTneySzQdtedk-1oz9BNbUsiQr8SBexGV_vGfzSt2942GNcuA4XannVM2A6KaWtD50va_XVN559tH3kM-Gw0uCDT8cvHaMJasQTmMwmVYBBJa-VcoUOQmcwB1mjhfMmtSE5Bms6kMtEalLEFSJDJwPHWbFBQHnuvorwkPZhUvCLUI6mYCUoWXuZJeycjwCqrYHtbHm3qk8HOgdWq4cSooJao3Vyhmyt0c588o29_30Ae69oA0a3a6FZ_Rff6Pwa5IYcCVXvxJiG_Jb3t-jveAZTYuvt61fwAojvIkA
linkProvider Directory of Open Access Journals
openUrl ctx_ver=Z39.88-2004&ctx_enc=info%3Aofi%2Fenc%3AUTF-8&rfr_id=info%3Asid%2Fsummon.serialssolutions.com&rft_val_fmt=info%3Aofi%2Ffmt%3Akev%3Amtx%3Ajournal&rft.genre=article&rft.atitle=Comparative+analysis+of+the+performance+of+relational+and+non-relational+databases+in+applications+implemented+in+C%23&rft.jtitle=Journal+of+Computer+Sciences+Institute&rft.au=Bali%C5%84ski%2C+Patryk&rft.au=Chudy%2C+%C5%81ukasz&rft.au=Skublewska-Paszkowska%2C+Maria&rft.date=2025-03-30&rft.issn=2544-0764&rft.eissn=2544-0764&rft.volume=34&rft.spage=44&rft.epage=53&rft_id=info:doi/10.35784%2Fjcsi.6688&rft.externalDBID=n%2Fa&rft.externalDocID=10_35784_jcsi_6688
thumbnail_l http://covers-cdn.summon.serialssolutions.com/index.aspx?isbn=/lc.gif&issn=2544-0764&client=summon
thumbnail_m http://covers-cdn.summon.serialssolutions.com/index.aspx?isbn=/mc.gif&issn=2544-0764&client=summon
thumbnail_s http://covers-cdn.summon.serialssolutions.com/index.aspx?isbn=/sc.gif&issn=2544-0764&client=summon