Concurrent Access Performance Comparison Between Relational Databases and Graph NoSQL Databases for Complex Algorithms

Databases are a fundamental element of contemporary software applications. The most widely used and recognized type in practice is the relational database, valued for its ability to store and organize data in tabular structures, its emphasis on data consistency and integrity, and its use of a standa...

Full description

Saved in:
Bibliographic Details
Published in:Applied sciences Vol. 14; no. 21; p. 9867
Main Authors: Lupu, Elena, Olteanu, Adriana, Ionita, Anca Daniela
Format: Journal Article
Language:English
Published: Basel MDPI AG 01.11.2024
Subjects:
Algorithms
Analysis
Architecture
Business metrics
complex queries
Data base management systems
Efficiency
graph database
Information management
Literature reviews
Navigation systems
Neo4j
Queries
Relational data bases
relational database
Servers
Social networks
Software
SQL Server
Technology application
Workloads
ISSN:2076-3417, 2076-3417
Online Access:Get full text
Tags: Add Tag
No Tags, Be the first to tag this record!
Description
Summary:Databases are a fundamental element of contemporary software applications. The most widely used and recognized type in practice is the relational database, valued for its ability to store and organize data in tabular structures, its emphasis on data consistency and integrity, and its use of a standardized query language, SQL. However, with the rapid increase in both the volume and complexity of data, relational databases have recently encountered challenges in effectively modeling this expanding information. To address performance challenges, new database systems have emerged, offering alternative approaches to data modeling—these are known as NoSQL databases. In this paper, we present an indoor navigation application designed to operate on both a relational database, Microsoft SQL Server, and a graph-based NoSQL database, Neo4j. We describe the algorithms implemented for testing and the performance metrics analyzed to draw our conclusions. The results revealed Neo4j’s strength in managing data with complex relationships but also exposed its limitations in handling concurrent access, where SQL Server demonstrated significantly greater stability.
Bibliography:ObjectType-Article-1
SourceType-Scholarly Journals-1
ObjectType-Feature-2
content type line 14
ISSN:2076-3417
2076-3417
DOI:10.3390/app14219867