Journal of Computer Sciences Institute

8-12

Authors: Tomasz Nowicki, Sebastian Tomczak, Grzegorz Kozieł

There are many computer applications in the world that use databases to store, process, and use data. That translates into many different ways of handling these databases. It is therefore difficult to choose a solution that meets the needs of the user. This article compares three C# solutions in terms of time efficiency: the Entity Framework Core application framework, pure SQL queries, and parameterized Prepared Statement queries. The results obtained in the course of the research has shown that the fastest solution is the use of non-parameterised SQL queries. The use of Entity Framework Core is the slowest of the three tested solutions.

18-25

Authors: Paulina Garbarz, Małgorzata Plechawska-Wójcik

This study aims to determine which of the analyzed PHP-based design patterns – Laravel or Symfony – is a better and more universal solution for a developer. For this purpose, a comparative analysis was carried out based on the available documentation, as well as a comparison of the static and dynamic metrics obtained in the research environment of both tested patterns. As a result of a series of experiments and studies, it was established that both design patterns are an optimal and efficient solution, but their best application depends on the developer's individual needs and project requirements.

35-39

Authors: Jakub Radomski

The article presents the result of comparing the performance of web applications written with the use of Laravel and Vaadin frameworks. The aim of the study was to identify which framework offers better performance in creating web applications and to verify the thesis presented in the article. A research method based on a comparative analysis was used to conduct the study. The study was carried out using two applications created for the purpose of the study and tools such as ApacheBench and Chrome DevTools were used for the study. Tests were carried out according to 13 research scenarios and the obtained results allowed to clearly verify the thesis. Finally, it was concluded that Vaadin is a much more efficient framework than Laravel.

46-50

Authors: Radosław Lipski, Dominik Lipski

The purpose of this article is to compare selected tools for modeling and simulating business processes. The comparative study concerned Bizagi, Adonis, Bonita Studio and Visual Paradigm tools. The analysis has the aim to identify the best tool according to the criteria. The article explains the concepts related to business processes and analyzes the existing literature. Research scenarios containing evaluation criteria will be created for the analysis. The conducted research indicated that the best tool among the considered: Bizagi, Adonis, Bonita Studio, Visual Paradigm is Bizagi.

59-65

Authors: Mateusz Połeć, Jakub Pitera, Grzegorz Kozieł

The paper concerns a performance evaluation of selected object-relational mapping tools. This work is intended to assist software architects in determining which of the analyzed libraries will be the optimal choice for use in a specific project. The work includes the comparison of Hibernate ORM, EclipseLink, Apache OpenJPA and DataNucleus libraries from the theoretical and practical point of view. Each of the examined tools has been described according to criteria allowing to distinguish the most important features influencing communication with relational databases. These features will then be compared on a practical level by examining the behavior of the test applications. In terms of performance, the Apache OpenJPA library turned out to be the best, but in terms of configuration and availability it significantly differs from other libraries. This was caused by an unintuitive configuration and poor documentation of the technology. In this respect, the Hibernate library definitely dominated, the configuration of which with the Spring programming framework was simple and intuitive, and the documentation was rich and supported by an extensive community of programmers using it.