Comparative analysis of databases working under the control of Windows system

The aim of this paper is to conduct research on the most popular database management systems such as MySQL, PostgreSQL and Firebird in terms of query performance, CPU load and disk usage. At the first stage, the analysis of the popularity of databases was carried out. In the second stage an applicat...

Full description

Saved in:
Bibliographic Details
Published in:Journal of Computer Sciences Institute Vol. 13; pp. 298 - 301
Main Authors: Stets, Serhii, Kozieł, Grzegorz
Format: Journal Article
Language:English
Published: Lublin University of Technology 30.12.2019
Subjects:
analysis; MySQL; postgresql; firebird
ISSN:2544-0764, 2544-0764
Online Access:Get full text
Tags: Add Tag
No Tags, Be the first to tag this record!
Abstract The aim of this paper is to conduct research on the most popular database management systems such as MySQL, PostgreSQL and Firebird in terms of query performance, CPU load and disk usage. At the first stage, the analysis of the popularity of databases was carried out. In the second stage an application was created that allows for communication with selected databases. At the third stage, tests were carried out using a written application and analysis of results.
AbstractList The aim of this paper is to conduct research on the most popular database management systems such as MySQL, PostgreSQL and Firebird in terms of query performance, CPU load and disk usage. At the first stage, the analysis of the popularity of databases was carried out. In the second stage an application was created that allows for communication with selected databases. At the third stage, tests were carried out using a written application and analysis of results.
Author Stets, Serhii
Kozieł, Grzegorz
Author_xml – sequence: 1
  givenname: Serhii
  surname: Stets
  fullname: Stets, Serhii
– sequence: 2
  givenname: Grzegorz
  surname: Kozieł
  fullname: Kozieł, Grzegorz
BookMark eNptkE1LAzEQhoNUsNZe_AU5C1uT3WSTPUrxo1DxongMs_moqdtNSVZL_727rYiIpxmG930GnnM0akNrEbqkZFZwIdn1Wic_o0VenKBxzhnLiCjZ6Nd-hqYprQkhuRScEzlGj_Ow2UKEzn9aDC00--QTDg4b6KCGZBPehfju2xX-aI2NuHuzWIe2i6EZYq--NWGXcNqnzm4u0KmDJtnp95ygl7vb5_lDtny6X8xvlpmmQhYZpbKCWufGGes448A1CElKy3XFaguMGG6k08ToopZMal0IkctcS-rq2shighZHrgmwVtvoNxD3KoBXh0OIKwWx87qxShYlA2dN1X9jJcmrUhLJBRVca8co9KyrI0vHkFK07odHiTp4VYNXNXjtw-RPWPuulzcIAd_8V_kCpRx-0A
CitedBy_id crossref_primary_10_35784_jcsi_2026
crossref_primary_10_35784_jcsi_3086
ContentType Journal Article
DBID AAYXX
CITATION
DOA
DOI 10.35784/jcsi.1323
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 301
ExternalDocumentID oai_doaj_org_article_8364afed92df46029680857175ccf41a
10_35784_jcsi_1323
GroupedDBID AAYXX
ALMA_UNASSIGNED_HOLDINGS
CITATION
GROUPED_DOAJ
M~E
Y2W
ID FETCH-LOGICAL-c1783-1189abc2dfdef545a5ca7806e5c94bea40d5d8fc0dc3b848cc377282c81fbbd83
IEDL.DBID DOA
ISSN 2544-0764
IngestDate Mon Nov 03 22:00:03 EST 2025
Tue Nov 18 22:15:20 EST 2025
Sat Nov 29 03:00:55 EST 2025
IsDoiOpenAccess true
IsOpenAccess true
IsPeerReviewed true
IsScholarly true
Language English
License https://creativecommons.org/licenses/by-sa/4.0
LinkModel DirectLink
MergedId FETCHMERGED-LOGICAL-c1783-1189abc2dfdef545a5ca7806e5c94bea40d5d8fc0dc3b848cc377282c81fbbd83
OpenAccessLink https://doaj.org/article/8364afed92df46029680857175ccf41a
PageCount 4
ParticipantIDs doaj_primary_oai_doaj_org_article_8364afed92df46029680857175ccf41a
crossref_primary_10_35784_jcsi_1323
crossref_citationtrail_10_35784_jcsi_1323
PublicationCentury 2000
PublicationDate 2019-12-30
PublicationDateYYYYMMDD 2019-12-30
PublicationDate_xml – month: 12
  year: 2019
  text: 2019-12-30
  day: 30
PublicationDecade 2010
PublicationTitle Journal of Computer Sciences Institute
PublicationYear 2019
Publisher Lublin University of Technology
Publisher_xml – name: Lublin University of Technology
SSID ssj0002875508
Score 2.0901616
Snippet The aim of this paper is to conduct research on the most popular database management systems such as MySQL, PostgreSQL and Firebird in terms of query...
SourceID doaj
crossref
SourceType Open Website
Enrichment Source
Index Database
StartPage 298
SubjectTerms analysis; MySQL; postgresql; firebird
Title Comparative analysis of databases working under the control of Windows system
URI https://doaj.org/article/8364afed92df46029680857175ccf41a
Volume 13
hasFullText 1
inHoldings 1
isFullTextHit
isPrint
journalDatabaseRights – providerCode: PRVAON
  databaseName: DOAJ Directory of Open Access Journals
  customDbUrl:
  eissn: 2544-0764
  dateEnd: 99991231
  omitProxy: false
  ssIdentifier: ssj0002875508
  issn: 2544-0764
  databaseCode: DOA
  dateStart: 20160101
  isFulltext: true
  titleUrlDefault: https://www.doaj.org/
  providerName: Directory of Open Access Journals
– providerCode: PRVHPJ
  databaseName: ROAD: Directory of Open Access Scholarly Resources
  customDbUrl:
  eissn: 2544-0764
  dateEnd: 99991231
  omitProxy: false
  ssIdentifier: ssj0002875508
  issn: 2544-0764
  databaseCode: M~E
  dateStart: 20160101
  isFulltext: true
  titleUrlDefault: https://road.issn.org
  providerName: ISSN International Centre
link http://cvtisr.summon.serialssolutions.com/2.0.0/link/0/eLvHCXMwrV09T8MwELVQxcDCN-JblmBhCHViO7ZHqFqxtGIA0S1y_CG1Qi1qCt347ZydtBQJiYUlQ3SKkrsk9551fg-h61I7p4gOczgpEBSTqUTLlCfQvLnhNOfMk2g2IQYDORyqxzWrrzATVssD14lrS5oz7Z1VmfUsJ5kKXhEcSAg3xrM0QiMi1BqZGsclIwHQW9Z6pEHQhbXHphrdAveiPzrQmlB_7Ci9XbTdQEF8V9_CHtpwk320s7RZwM1Xd4D6nW-FbqwbERE89ThMd4YuVOFFveSNw46wGQZMh5sR9BD2ArR7uqhwLdp8iJ573afOQ9K4ICQmFZImwACULg08vnUe8I7mRgtJcseNYqXTjFhupTfEGlpKJo2hgJhlZmTqy9JKeoRak-nEHSOcpU4AxMs8E5R5Bv9cb8ucC-F08KnSJ-hmmZnCNBLhwanitQCqELNYhCwWIYsn6GoV-1YLY_wadR8SvIoIYtbxBJS4aEpc_FXi0_-4yBnaAqwTrR8oOUet-ezdXaBN8zEfVbPL-PbAsf_Z_QLgj8yq
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+databases+working+under+the+control+of+Windows+system&rft.jtitle=Journal+of+Computer+Sciences+Institute&rft.au=Serhii+Stets&rft.au=Grzegorz+Kozie%C5%82&rft.date=2019-12-30&rft.pub=Lublin+University+of+Technology&rft.eissn=2544-0764&rft.volume=13&rft_id=info:doi/10.35784%2Fjcsi.1323&rft.externalDBID=DOA&rft.externalDocID=oai_doaj_org_article_8364afed92df46029680857175ccf41a
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