Performance analysis of selected database systems: MySQL, MS SQL, PostgerSQL in the context of web applications

Lachewicz, Katarzyna

doi:10.35784/jcsi.1583

Cited by 7 publications

(5 citation statements)

References 3 publications

Supporting

Mentioning

Contrasting

Order By: Relevance

“…Analising query execution with obiect-relational mapping, operations were performed even several times faster using the PostgreSQL system. That confirmed the results obtained in the article [16], in which, the PostgreSQL system performed the operations the fastest using additional technology.…”

Section: Discussionsupporting

confidence: 89%

“…Another article presents the analysis of MySQL, MS SQL and PostgreSQL database systems in the context of web applications using the Spring framework, the Hibernate library and the JDBC interface [16]. In the case of database cooperation with a web application, Post-greSQL turned out to be the most efficient system for complicated operations on joined tables, using both the Hibernate library and the JDBC interface.…”

Section: Related Workmentioning

confidence: 99%

“…In most studies one model to build the database was used for each tested system. Some researchers used an additional application [11] or technology [15,16], but few studies were related to the cooperation of databases with Doctrine libraries.…”

Section: Related Workmentioning

confidence: 99%

See 2 more Smart Citations

Performance analysis of relational databases MySQL, PostgreSQL and Oracle using Doctrine libraries

Choina¹,

Skublewska‐Paszkowska

2022

jcsi

View full text Add to dashboard Cite

In modern applications, databases perform a very important function but the choice of a database system and additional libraries may affect the speed of the operations. The paper presents a time analysis concerning the performing of insert, update, delete and select operations on three database systems, MySQL 8.0, PostgreSQL 14.1 and Oracle 21c, cooperating with an application using Doctrine libraries. The obtained results showed differences between performing operations with and without object-relational mapping. In cooperation with the application, the operations were carried out the fastest using the PostgreSQL system. The Oracle system performed data selection faster without mapping on a large data set.

show abstract

Section: Discussionsupporting

confidence: 89%

Section: Related Workmentioning

confidence: 99%

See 1 more Smart Citation

Performance analysis of relational databases MySQL, PostgreSQL and Oracle using Doctrine libraries

Choina¹,

Skublewska‐Paszkowska

2022

jcsi

View full text Add to dashboard Cite

show abstract

“…Make sure the cellphone number and data entered are correct. If you have registered, the system will register the cellphone number and ready for use [8]. Figure 1 explains the Sipitung topology.…”

Section: Resultsmentioning

confidence: 99%

Analisis Penerapan Pilkada Berbasis Global System for Mobile (GSM)

Aulia

Dora

Mega

2021

jisamar

View full text Add to dashboard Cite

Penelitian ini dilakukan untuk memudahkan pemantauan hasil calon kepala daerah dengan menerapkan aplikasi Sipitung dalam pemilihan kepala daerah serentak. Studi literatur, observasi, dan simulasi aplikasi dilakukan sebagai metode penelitian ini. Dengan cara ini, kita bisa mencegah terjadinya perpindahan suara di pilkada serentak secara real-time. Hasil dari penelitian ini berupa halaman lengkap informasi dan data komparatif untuk level set. Aplikasi ini sangat penting karena dapat memberikan informasi mengenai aplikasi sipitung. Penelitian ini menerapkan sistem informasi bagi pengguna aplikasi Sipitung untuk mengirimkan suara calon kepala daerah di setiap TPS

show abstract

“…This approach combines MADS and BPMN at the conceptual level and PostgreSQL/ PostGIS for implementation. PostgreSQL/PostGIS [45] is one of the most widely used and powerful spatial open-source SQL-based DBMS [46]. It is an object-relational database system combined with many features that safely stores and scales data workloads.…”

Section: Mapping Mads To Logical Modelmentioning

confidence: 99%

Merging Spatio-Temporal Objects and Business Processes: Land Reform Process Case Study

Zaki,

Claramunt,

Nasser

et al. 2023

Applied Sciences

View full text Add to dashboard Cite

Although significant progress has been achieved in the development of spatio-temporal models that capture real-world phenomena, more interaction between phenomenon-based and business-based modeling approaches is still required. This represents a much-needed step forward in balancing the management and scientific aspects of many urban applications. The main goal of this paper is to provide an integrated modeling framework that combines MADS (Modeling of Application Data with Spatio-temporal Features), a specific conceptual spatiotemporal model that successfully represents geographical data, with BPMN (Business Process Model Notation), which models and determines how business processes interact with geographic objects. The integration of MADS and BPMN guarantees clarity, extensibility, and autonomy between data and management operations, as it portrays spatio-temporal abstractions on a conceptual level. This integration offers a unique opportunity to accurately represent, understand, and explain the rationale behind the changes occurring in space and time. The approach has been implemented within a PostgreSQL/PostGIS database management system. A case study implementation shows the practical applicability and potential of this modeling approach.

show abstract

Performance analysis of selected database systems: MySQL, MS SQL, PostgerSQL in the context of web applications

Cited by 7 publications

References 3 publications

Performance analysis of relational databases MySQL, PostgreSQL and Oracle using Doctrine libraries

Performance analysis of relational databases MySQL, PostgreSQL and Oracle using Doctrine libraries

Analisis Penerapan Pilkada Berbasis Global System for Mobile (GSM)

Merging Spatio-Temporal Objects and Business Processes: Land Reform Process Case Study

Contact Info

Product

Resources

About