The impact of relational and non-relational databases on application performance

The purpose of this study was to assess the performance of two database systems, PostgreSQL (relational) and MongoDB (non-relational), in handling data and their impact on application performance. The evaluation was conducted through a series of performance tests including read, write, delete, updat...

Full description

Saved in:
Bibliographic Details
Published inJournal of Computer Sciences Institute Vol. 35; pp. 184 - 190
Main Authors Olszak, Jakub, Skublewska-Paszkowska, Maria
Format Journal Article
LanguageEnglish
Published Lublin University of Technology 30.06.2025
Subjects
application performance
NoSQL
SQL
Online AccessGet full text
ISSN2544-0764
2544-0764
DOI10.35784/jcsi.7260

Cover

Abstract The purpose of this study was to assess the performance of two database systems, PostgreSQL (relational) and MongoDB (non-relational), in handling data and their impact on application performance. The evaluation was conducted through a series of performance tests including read, write, delete, update, and aggregation operations on small and large datasets. Key metrics such as task completion time, response times were used for comparisons. Based on the results obtained during the experiments, it is difficult to definitively conclude which database system performs better, as both systems demonstrated advantages in different scenarios depending on the specific use case.
AbstractList The purpose of this study was to assess the performance of two database systems, PostgreSQL (relational) and MongoDB (non-relational), in handling data and their impact on application performance. The evaluation was conducted through a series of performance tests including read, write, delete, update, and aggregation operations on small and large datasets. Key metrics such as task completion time, response times were used for comparisons. Based on the results obtained during the experiments, it is difficult to definitively conclude which database system performs better, as both systems demonstrated advantages in different scenarios depending on the specific use case.
Author Skublewska-Paszkowska, Maria
Olszak, Jakub
Author_xml – sequence: 1
  givenname: Jakub
  orcidid: 0009-0004-9930-7316
  surname: Olszak
  fullname: Olszak, Jakub
– sequence: 2
  givenname: Maria
  orcidid: 0000-0002-0760-7126
  surname: Skublewska-Paszkowska
  fullname: Skublewska-Paszkowska, Maria
BookMark eNpNkMtqwzAQRUVJoWmaTb9A64LTkSxb0rKEPgKBdpGuxViP1sGxjORN_75OUkpWd7gD58K5JbM-9p6QewarspJKPO5tbleS13BF5rwSogBZi9nFfUOWOe8BgCtZVaDm5GP37Wl7GNCONAaafIdjG3vsKPaOTgPFReVwxAazzzT2FIeha-3pRQefQkwH7K2_I9cBu-yXf7kgny_Pu_VbsX1_3ayftoVlpYTCOQ6aW6WUYKFWwJgTPIAKAqsauIbSSqGlqBvLFbIGeCWlRu654sJJWy7I5sx1EfdmSO0B04-J2JpTEdOXwTS2tvNG62C5EHwKFMxrraW2Tk6rtVbe48R6OLNsijknH_55DMxJrTmqNUe15S-4dmzy
Cites_doi 10.1109/CSICSSE.2015.7369245
10.1109/ICREST51555.2021.9331044
10.1109/PACRIM.2013.6625441
10.1109/ACIT53391.2021.9677042
10.1109/CSET58993.2023.10346657
10.1109/EIDWT.2012.32
10.3390/a16020078
10.2991/mbdasm-19.2019.14
ContentType Journal Article
DBID AAYXX
CITATION
DOA
DOI 10.35784/jcsi.7260
DatabaseName CrossRef
DOAJ Directory of Open Access Journals
DatabaseTitle CrossRef
DatabaseTitleList
CrossRef
Database_xml – sequence: 1
  dbid: DOA
  name: DOAJ Directory of Open Access Journals
  url: https://www.doaj.org/
  sourceTypes: Open Website
DeliveryMethod fulltext_linktorsrc
Discipline Computer Science
EISSN 2544-0764
EndPage 190
ExternalDocumentID oai_doaj_org_article_99fc24429fca41e99979cd7680698eea
10_35784_jcsi_7260
GroupedDBID AAYXX
ALMA_UNASSIGNED_HOLDINGS
ARCSS
CITATION
EN8
GROUPED_DOAJ
M~E
Y2W
ID FETCH-LOGICAL-c1370-dd2092c88841f68011d42f08f4a5602903c749746bc28a1b025779a2e2824d7c3
IEDL.DBID DOA
ISSN 2544-0764
IngestDate Wed Aug 27 01:20:25 EDT 2025
Thu Aug 07 15:32:54 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-c1370-dd2092c88841f68011d42f08f4a5602903c749746bc28a1b025779a2e2824d7c3
ORCID 0000-0002-0760-7126
0009-0004-9930-7316
OpenAccessLink https://doaj.org/article/99fc24429fca41e99979cd7680698eea
PageCount 7
ParticipantIDs doaj_primary_oai_doaj_org_article_99fc24429fca41e99979cd7680698eea
crossref_primary_10_35784_jcsi_7260
PublicationCentury 2000
PublicationDate 2025-06-30
PublicationDateYYYYMMDD 2025-06-30
PublicationDate_xml – month: 06
  year: 2025
  text: 2025-06-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 143486
143487
143484
143485
143479
143488
143482
143483
143480
143481
References_xml – ident: 143480
  doi: 10.1109/CSICSSE.2015.7369245
– ident: 143483
  doi: 10.1109/ICREST51555.2021.9331044
– ident: 143488
– ident: 143485
  doi: 10.1109/PACRIM.2013.6625441
– ident: 143487
  doi: 10.1109/ACIT53391.2021.9677042
– ident: 143486
  doi: 10.1109/CSET58993.2023.10346657
– ident: 143481
  doi: 10.1109/EIDWT.2012.32
– ident: 143484
  doi: 10.3390/a16020078
– ident: 143479
– ident: 143482
  doi: 10.2991/mbdasm-19.2019.14
SSID ssj0002875508
Score 2.295556
Snippet The purpose of this study was to assess the performance of two database systems, PostgreSQL (relational) and MongoDB (non-relational), in handling data and...
SourceID doaj
crossref
SourceType Open Website
Index Database
StartPage 184
SubjectTerms application performance
NoSQL
SQL
Title The impact of relational and non-relational databases on application performance
URI https://doaj.org/article/99fc24429fca41e99979cd7680698eea
Volume 35
hasFullText 1
inHoldings 1
isFullTextHit
isPrint
link http://utb.summon.serialssolutions.com/2.0.0/link/0/eLvHCXMwrV07T8MwED6hTiy8EeUlS7CaJrYb2yMgqgoJxEClbpGfEh3aqi3_n7OT0mwsTJGsxLLvYt_3JefvAO6NqjzngdPouKDCBkmtD4bKoQ_CcyNdrqLw9l6NJ-J1Opx2Sn2lnLBGHrgx3EDr6DAEMbwYUQbEM1I7jyC5qLQKIUOjQhcdMjXLn4wkQm_V6JEmQRcxmLn114NkWYtyF4E6Qv05ooyO4KCFguSxGcIx7IX5CRxuyyyQdtWdwge6kjSnGckiklWbvoaPmrknSN9ppyllfKbItCaLOen8nSbL3QmBM5iMXj6fx7QthEBdyWVBvccpModkVZQRZ16WXrBYqCgMAhamC-6kQGJQWceUKS3iGCm1YQH5lPDS8XPo4WjCBRAdQ8QNsHIKeVKqyMesxSWsU7aaU1r04W5rnHrZ6F3UyBOyCetkwjqZsA9PyW6_dySN6tyAnqtbz9V_ee7yPzq5gn2WKvLmDL5r6G1W3-EGYcLG3uY34gfC1bsi
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=The+impact+of+relational+and+non-relational+databases+on+application+performance&rft.jtitle=Journal+of+Computer+Sciences+Institute&rft.au=Olszak%2C+Jakub&rft.au=Skublewska-Paszkowska%2C+Maria&rft.date=2025-06-30&rft.issn=2544-0764&rft.eissn=2544-0764&rft.volume=35&rft.spage=184&rft.epage=190&rft_id=info:doi/10.35784%2Fjcsi.7260&rft.externalDBID=n%2Fa&rft.externalDocID=10_35784_jcsi_7260
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