数据库管理系统开放源代码库分析

Q3 Engineering

Pollack Periodica Pub Date : 2024-05-13 DOI:10.1556/606.2024.00990

Rama Hayek, M. Akkad

{"title":"数据库管理系统开放源代码库分析","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":"119 15","pages":""},"PeriodicalIF":0.0000,"publicationDate":"2024-05-13","publicationTypes":"Journal Article","fieldsOfStudy":null,"isOpenAccess":false,"openAccessPdf":"","citationCount":"0","resultStr":"{\"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\":\"119 15\",\"pages\":\"\"},\"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}","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

摘要

空间数据管理对于城市规划和环境监测等应用至关重要。虽然传统的关系数据库很常用，但在处理大型复杂空间数据时却很吃力。NoSQL 数据库支持非结构化数据和可扩展性。本文使用一个开源库，比较了 SQL Server（关系型数据库）和 MongoDB（NoSQL 数据库）的性能和磁盘空间使用情况。使用中美洲 OpenStreetMap 数据集进行的实验表明，MongoDB 数据库在大多数情况下都优于关系型 SQL Server 数据库，为地理信息系统应用中的空间数据管理提供了实际优势。

本文章由计算机程序翻译，如有差异，请以英文原文为准。

查看原文本刊更多论文

Analysis for an open-source library in database management systems

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 Engineering-Civil and Structural Engineering

CiteScore

1.50

自引率

0.00%

发文量

期刊介绍： 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.