{"title":"Analysis for an open-source library in database management systems","authors":"Rama Hayek, M. Akkad","doi":"10.1556/606.2024.00990","DOIUrl":null,"url":null,"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.","PeriodicalId":35003,"journal":{"name":"Pollack Periodica","volume":null,"pages":null},"PeriodicalIF":0.0000,"publicationDate":"2024-05-13","publicationTypes":"Journal Article","fieldsOfStudy":null,"isOpenAccess":false,"openAccessPdf":"","citationCount":"0","resultStr":null,"platform":"Semanticscholar","paperid":null,"PeriodicalName":"Pollack Periodica","FirstCategoryId":"1085","ListUrlMain":"https://doi.org/10.1556/606.2024.00990","RegionNum":0,"RegionCategory":null,"ArticlePicture":[],"TitleCN":null,"AbstractTextCN":null,"PMCID":null,"EPubDate":"","PubModel":"","JCR":"Q3","JCRName":"Engineering","Score":null,"Total":0}
引用次数: 0
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.
期刊介绍：
Pollack Periodica is an interdisciplinary, peer-reviewed journal that provides an international forum for the presentation, discussion and dissemination of the latest advances and developments in engineering and informatics. Pollack Periodica invites papers reporting new research and applications from a wide range of discipline, including civil, mechanical, electrical, environmental, earthquake, material and information engineering. The journal aims at reaching a wider audience, not only researchers, but also those likely to be most affected by research results, for example designers, fabricators, specialists, developers, computer scientists managers in academic, governmental and industrial communities.
京公网安备 11010802042870号
京ICP备2023020795号-1
分享
求助内容：
应助结果提醒方式：
扫码关注我们
