{"title":"Performance comparison of microservices written using reactive and imperative approaches","authors":"Kacper Mochniej, Marcin Badurowicz","doi":"10.35784/jcsi.3698","DOIUrl":"https://doi.org/10.35784/jcsi.3698","url":null,"abstract":"The purpose of this paper is to compare the performance of microservices based on reactive and imperative approaches. For this purpose, two microservice applications written in Java using the Spring programming framework were developed. The Spring Web and Spring Webflux modules were used for the conventional and reactive versions, respectively. During the tests, functionalities related to operations of retrieving and inserting records into the database, data processing, and file transfer were invoked. The Gatling tool was used to conduct the tests. The tests showed that reactive microservices can be more efficient in particular when there are delays in communication with services or the database. Otherwise, it depends on the complexity of the operations being performed. Microservices based on the reactive paradigm also use less RAM compared to conventional counterparts.","PeriodicalId":480604,"journal":{"name":"Journal of Computer Sciences Institute","volume":"24 1","pages":"0"},"PeriodicalIF":0.0,"publicationDate":"2023-09-30","publicationTypes":"Journal Article","fieldsOfStudy":null,"isOpenAccess":false,"openAccessPdf":"","citationCount":null,"resultStr":null,"platform":"Semanticscholar","paperid":"136337077","PeriodicalName":null,"FirstCategoryId":null,"ListUrlMain":null,"RegionNum":0,"RegionCategory":"","ArticlePicture":[],"TitleCN":null,"AbstractTextCN":null,"PMCID":"","EPubDate":null,"PubModel":null,"JCR":null,"JCRName":null,"Score":null,"Total":0}
{"title":"The comparative performance analysis of selected relational database systems","authors":"Szymon Schab","doi":"10.35784/jcsi.3767","DOIUrl":"https://doi.org/10.35784/jcsi.3767","url":null,"abstract":"The objective of this study was to carry out a performance analysis of the following database systems: MySQL, PostgreSQL and Microsoft SQL Server. For this purpose scripts were used to measure execution times of selecting, updating and inserting data. Furthermore, three data sets were utilized consisting of 100, 1000 and 10000 rows. The experiment included nine cases depending on the query type and the data set. For each case, thirty five test trials were conducted while first five trials were ignored i.a. because of cache storage. The statistical test was performed for the results and the trials in which the DBMS achieved best times were counted. For each case best systems were acknowledged and the most efficient system of the experiment was determined along with systems for each operation type.","PeriodicalId":480604,"journal":{"name":"Journal of Computer Sciences Institute","volume":"34 1","pages":"0"},"PeriodicalIF":0.0,"publicationDate":"2023-09-30","publicationTypes":"Journal Article","fieldsOfStudy":null,"isOpenAccess":false,"openAccessPdf":"","citationCount":null,"resultStr":null,"platform":"Semanticscholar","paperid":"136336775","PeriodicalName":null,"FirstCategoryId":null,"ListUrlMain":null,"RegionNum":0,"RegionCategory":"","ArticlePicture":[],"TitleCN":null,"AbstractTextCN":null,"PMCID":"","EPubDate":null,"PubModel":null,"JCR":null,"JCRName":null,"Score":null,"Total":0}
{"title":"The Examination of SQL Queries Efficiency in Chosen IT System","authors":"Krzysztof Barczak","doi":"10.35784/jcsi.3606","DOIUrl":"https://doi.org/10.35784/jcsi.3606","url":null,"abstract":"Optimization of SQL queries is an important part of any system using a database. Several different optimization methods have been selected and presented in this article, The research was conducted on the MS SQL database engine. The execution times of SQL queries were carefully examined according to defined criteria, then performance optimization was done, followed by repeated tests to obtain results after the optimization. Finally, the results were compared through which conclusions were drawn.","PeriodicalId":480604,"journal":{"name":"Journal of Computer Sciences Institute","volume":"1 1","pages":"0"},"PeriodicalIF":0.0,"publicationDate":"2023-09-30","publicationTypes":"Journal Article","fieldsOfStudy":null,"isOpenAccess":false,"openAccessPdf":"","citationCount":null,"resultStr":null,"platform":"Semanticscholar","paperid":"136336932","PeriodicalName":null,"FirstCategoryId":null,"ListUrlMain":null,"RegionNum":0,"RegionCategory":"","ArticlePicture":[],"TitleCN":null,"AbstractTextCN":null,"PMCID":"","EPubDate":null,"PubModel":null,"JCR":null,"JCRName":null,"Score":null,"Total":0}
{"title":"Usability analysis of banking service interfaces in Poland","authors":"Paulina Sułek, Aleksandra Walaszek","doi":"10.35784/jcsi.3688","DOIUrl":"https://doi.org/10.35784/jcsi.3688","url":null,"abstract":"This paper presents a comparative analysis of selected mobile banking applications: PKO BP, mBank, Pekao S.A., and Credit Agricole. The aim of the study is to obtain answers to the stated thesis and three specific research questions. In the initial stage, a review of scientific publications in the field of the topic was conducted. The research was carried out using an online survey and the cognitive walkthrough method with a modified list of usability testing. The obtained results revealed errors in the functioning of the analyzed service interfaces from the users' perspective and allowed for answering the research questions. The mobile applications of the discussed banks require minor modifications to maximize their usability.","PeriodicalId":480604,"journal":{"name":"Journal of Computer Sciences Institute","volume":"11 1","pages":"0"},"PeriodicalIF":0.0,"publicationDate":"2023-09-30","publicationTypes":"Journal Article","fieldsOfStudy":null,"isOpenAccess":false,"openAccessPdf":"","citationCount":null,"resultStr":null,"platform":"Semanticscholar","paperid":"136337093","PeriodicalName":null,"FirstCategoryId":null,"ListUrlMain":null,"RegionNum":0,"RegionCategory":"","ArticlePicture":[],"TitleCN":null,"AbstractTextCN":null,"PMCID":"","EPubDate":null,"PubModel":null,"JCR":null,"JCRName":null,"Score":null,"Total":0}
{"title":"Comparative analysis of Angular and React development frameworks","authors":"Sylwester Skrzypiec, Małgorzata Plechawska-Wójcik","doi":"10.35784/jcsi.3724","DOIUrl":"https://doi.org/10.35784/jcsi.3724","url":null,"abstract":"This thesis aimed to examine the Angular framework and React library in terms of performance on three popular web browsers. To achieve this, two similar test applications were implemented to create user interfaces, along with a server application for database communication and the aforementioned programming frameworks. Subsequently, tests were conducted to assess the time required for downloading and displaying images, records, and their deletion. In addition to performance results, a literature review was conducted to provide a better understanding of the current state of knowledge in the field, and individual features distinguishing the respective framework or library were described. Furthermore, the obtained data was analyzed for statistical differences using statistical tests.","PeriodicalId":480604,"journal":{"name":"Journal of Computer Sciences Institute","volume":"75 1","pages":"0"},"PeriodicalIF":0.0,"publicationDate":"2023-09-30","publicationTypes":"Journal Article","fieldsOfStudy":null,"isOpenAccess":false,"openAccessPdf":"","citationCount":null,"resultStr":null,"platform":"Semanticscholar","paperid":"136336484","PeriodicalName":null,"FirstCategoryId":null,"ListUrlMain":null,"RegionNum":0,"RegionCategory":"","ArticlePicture":[],"TitleCN":null,"AbstractTextCN":null,"PMCID":"","EPubDate":null,"PubModel":null,"JCR":null,"JCRName":null,"Score":null,"Total":0}
{"title":"Impact of changes in graphics setting on performance in selected video games","authors":"Kamil Szafran, Małgorzata Plechawska-Wójcik","doi":"10.35784/jcsi.3762","DOIUrl":"https://doi.org/10.35784/jcsi.3762","url":null,"abstract":"Computer games, especially more advanced ones, allow users to change graphic settings to improve the overall appearance of the game or to achieve smoother gameplay. The aim of the paper is conducting research to determine whether changes in graphic settings affect computer performance. Parameters such as temperature and usage of graphics cards and processors or frames per second were examined. Three different computer games and three different computer stations were used to conduct the tests. Two research hypotheses were formulated: \"Changing graphic settings in games affects computer performance\" and \"The change in shadow quality in games has the greatest impact on the tested parameters.\" The obtained results confirmed both of these hypotheses.","PeriodicalId":480604,"journal":{"name":"Journal of Computer Sciences Institute","volume":"32 1","pages":"0"},"PeriodicalIF":0.0,"publicationDate":"2023-09-30","publicationTypes":"Journal Article","fieldsOfStudy":null,"isOpenAccess":false,"openAccessPdf":"","citationCount":null,"resultStr":null,"platform":"Semanticscholar","paperid":"136337068","PeriodicalName":null,"FirstCategoryId":null,"ListUrlMain":null,"RegionNum":0,"RegionCategory":"","ArticlePicture":[],"TitleCN":null,"AbstractTextCN":null,"PMCID":"","EPubDate":null,"PubModel":null,"JCR":null,"JCRName":null,"Score":null,"Total":0}
Kacper Saweczko, Grzegorz Rożek, Małgorzata Plechawska-Wójcik
{"title":"A comparative analysis of non-relational databases in e-commerce applications","authors":"Kacper Saweczko, Grzegorz Rożek, Małgorzata Plechawska-Wójcik","doi":"10.35784/jcsi.3746","DOIUrl":"https://doi.org/10.35784/jcsi.3746","url":null,"abstract":"In this article, a comparative analysis of non-relational databases was conducted to determine the best database for e-commerce systems. Non-relational systems such as MongoDB and Apache Cassandra were used for the study and the results were compared with a relational PostgreSQL database. The main research criterion was performance testing of several types of queries based on execution time. To implement the research, typical e-commerce databases were created and then tested in a .NET test application created by authors. In addition, the difference in community support between non-relational and relational systems was determined. The research showed that MongoDB is best suited for e-commerce systems.","PeriodicalId":480604,"journal":{"name":"Journal of Computer Sciences Institute","volume":"12 1","pages":"0"},"PeriodicalIF":0.0,"publicationDate":"2023-09-30","publicationTypes":"Journal Article","fieldsOfStudy":null,"isOpenAccess":false,"openAccessPdf":"","citationCount":null,"resultStr":null,"platform":"Semanticscholar","paperid":"136337095","PeriodicalName":null,"FirstCategoryId":null,"ListUrlMain":null,"RegionNum":0,"RegionCategory":"","ArticlePicture":[],"TitleCN":null,"AbstractTextCN":null,"PMCID":"","EPubDate":null,"PubModel":null,"JCR":null,"JCRName":null,"Score":null,"Total":0}
{"title":"Analyze the effectiveness of ETL processes implemented using SQL and Apache HiveQL languages","authors":"Krzysztof Litka","doi":"10.35784/jcsi.3674","DOIUrl":"https://doi.org/10.35784/jcsi.3674","url":null,"abstract":"In the era of digitization, where data is collected in ever-increasing quantities, efficient processing is required. The article analyzes the performance of SQL and HiveQL, for scenarios of varying complexity, focusing on the execution time of individual queries. The tools used in the study are also discussed. The results of the study for each language are summarized and compared, highlighting their strengths and weaknesses, as well as identifying their possible areas of application.","PeriodicalId":480604,"journal":{"name":"Journal of Computer Sciences Institute","volume":"7 1","pages":"0"},"PeriodicalIF":0.0,"publicationDate":"2023-09-30","publicationTypes":"Journal Article","fieldsOfStudy":null,"isOpenAccess":false,"openAccessPdf":"","citationCount":null,"resultStr":null,"platform":"Semanticscholar","paperid":"136336626","PeriodicalName":null,"FirstCategoryId":null,"ListUrlMain":null,"RegionNum":0,"RegionCategory":"","ArticlePicture":[],"TitleCN":null,"AbstractTextCN":null,"PMCID":"","EPubDate":null,"PubModel":null,"JCR":null,"JCRName":null,"Score":null,"Total":0}
{"title":"Performance comparison of Flutter platform GUI in web and native environments","authors":"Juliusz Piskor, Marcin Badurowicz","doi":"10.35784/jcsi.3677","DOIUrl":"https://doi.org/10.35784/jcsi.3677","url":null,"abstract":"This article compares the performance of the Flutter framework's graphical user interface (GUI) in a Windows platform native environment and in a web environment on the same device. The purpose of the article is to make a comparative analysis of screen building and rebuilding times in both environments. For the purpose of the paper, a test application has been created in which screens of different types of complexity are included. The stated theses: \"The Flutter platform is less efficient in the web environment compared to the native environment in terms of view loading times.\" and \"The Flutter platform is less efficient in a web environment compared to a native environment in terms of view rebuilding time\" have been proven.","PeriodicalId":480604,"journal":{"name":"Journal of Computer Sciences Institute","volume":"59 1","pages":"0"},"PeriodicalIF":0.0,"publicationDate":"2023-09-30","publicationTypes":"Journal Article","fieldsOfStudy":null,"isOpenAccess":false,"openAccessPdf":"","citationCount":null,"resultStr":null,"platform":"Semanticscholar","paperid":"136336928","PeriodicalName":null,"FirstCategoryId":null,"ListUrlMain":null,"RegionNum":0,"RegionCategory":"","ArticlePicture":[],"TitleCN":null,"AbstractTextCN":null,"PMCID":"","EPubDate":null,"PubModel":null,"JCR":null,"JCRName":null,"Score":null,"Total":0}
{"title":"A comparative analysis of the performance of the relational database and the Hadoop environment in the context of analytical data processing","authors":"Michał Zadrąg","doi":"10.35784/jcsi.3675","DOIUrl":"https://doi.org/10.35784/jcsi.3675","url":null,"abstract":"The article presents a detailed comparative analysis of the performance of a Microsoft SQL Server relational database and an Apache Hadoop environment in the context of analytical data processing. The study was carried out by execut-ing more than a dozen research scenarios with different queries on datasets of varying sizes. For each research scenario, the average query execution time on different datasets was compared. Based on the results, it was found that the average execution time of queries from the presented scenarios is significantly shorter in MS SQL Server than in Apache Ha-doop.","PeriodicalId":480604,"journal":{"name":"Journal of Computer Sciences Institute","volume":"95 1","pages":"0"},"PeriodicalIF":0.0,"publicationDate":"2023-09-30","publicationTypes":"Journal Article","fieldsOfStudy":null,"isOpenAccess":false,"openAccessPdf":"","citationCount":null,"resultStr":null,"platform":"Semanticscholar","paperid":"136337076","PeriodicalName":null,"FirstCategoryId":null,"ListUrlMain":null,"RegionNum":0,"RegionCategory":"","ArticlePicture":[],"TitleCN":null,"AbstractTextCN":null,"PMCID":"","EPubDate":null,"PubModel":null,"JCR":null,"JCRName":null,"Score":null,"Total":0}