REAL

Analysis for an open-source library in database management systems

Hayek, Rama and Akkad, Mohammad Zaher (2024) Analysis for an open-source library in database management systems. POLLACK PERIODICA : AN INTERNATIONAL JOURNAL FOR ENGINEERING AND INFORMATION SCIENCES, 19 (2). pp. 30-35. ISSN 1788-1994 (print); 1788-3911 (online)

[img]
Preview
Text
606-article-p30.pdf - Published Version
Available under License Creative Commons Attribution.

Download (632kB) | Preview

Abstract

Spatial data management is crucial for applications like urban planning and environmental monitoring. While traditional relational databases are commonly used, they struggle with large and complex spatial data. NoSQL databases provide support for unstructured data and scalability. This article compares the performance and disk space usage of SQL Server (a relational database) and MongoDB (NoSQL database) using an open-source library. Experiments conducted with the OpenStreetMap dataset from Central America show that the MongoDB database outperformed the relational SQL Server database in most cases, offering practical advantages for spatial data management in Geographic Information System applications.

Item Type: Article
Uncontrolled Keywords: spatial data; relational database; NoSQL; OpenStreetMap
Subjects: Q Science / természettudomány > QA Mathematics / matematika > QA75 Electronic computers. Computer science / számítástechnika, számítógéptudomány
Q Science / természettudomány > QA Mathematics / matematika > QA76 Computer software / programozás
Depositing User: Emese Kató
Date Deposited: 09 Aug 2024 06:50
Last Modified: 09 Aug 2024 06:50
URI: https://real.mtak.hu/id/eprint/202124

Actions (login required)

Edit Item Edit Item