MS SQL Server vs. PostgreSQL: An In-Depth Comparative Analysis Using Simulated Database Environments
Session
Computer Science and Communication Engineering
Description
This paper presents a comprehensive comparative analysis of Microsoft SQL Server and PostgreSQL, two widely adopted relational database management systems. Using simulated database environments, these systems are evaluated across critical dimensions including performance, scalability, security, cost of ownership, and support. The methodology involves executing a series of benchmarking tests under various workload scenarios—such as read-intensive, write-intensive, and balanced operations—while adjusting concurrency levels to simulate different user loads. The scalability mechanisms inherent to each database are examined, along with assessments of their security features and compliance with industry standards. The total cost of ownership is analyzed by considering factors like licensing, maintenance, and available support options. By providing an in-depth evaluation without disclosing the final results, this study aims to assist database administrators, developers, and organizations in making informed decisions when selecting the most appropriate database solution for their specific needs. The insights gained from this analysis offer practical guidance for optimizing database strategies in various organizational contexts.
Keywords:
MS SQL Server; PostgreSQL; Relational Database Management Systems; Performance Evaluation; Scalability; Security; Cost of Ownership; Database Comparison; Benchmarking; Support Resources
Proceedings Editor
Edmond Hajrizi
Location
UBT Kampus, Lipjan
Start Date
25-10-2024 9:00 AM
End Date
27-10-2024 6:00 PM
DOI
10.33107/ubt-ic.2024.408
Recommended Citation
Menxhiqi, Lavdim; Zylfiu, Blerim; Hajrizi, Edmond; Llumnica, Naim; and Haxhismajli, Behar, "MS SQL Server vs. PostgreSQL: An In-Depth Comparative Analysis Using Simulated Database Environments" (2024). UBT International Conference. 24.
https://knowledgecenter.ubt-uni.net/conference/2024UBTIC/CS/24
MS SQL Server vs. PostgreSQL: An In-Depth Comparative Analysis Using Simulated Database Environments
UBT Kampus, Lipjan
This paper presents a comprehensive comparative analysis of Microsoft SQL Server and PostgreSQL, two widely adopted relational database management systems. Using simulated database environments, these systems are evaluated across critical dimensions including performance, scalability, security, cost of ownership, and support. The methodology involves executing a series of benchmarking tests under various workload scenarios—such as read-intensive, write-intensive, and balanced operations—while adjusting concurrency levels to simulate different user loads. The scalability mechanisms inherent to each database are examined, along with assessments of their security features and compliance with industry standards. The total cost of ownership is analyzed by considering factors like licensing, maintenance, and available support options. By providing an in-depth evaluation without disclosing the final results, this study aims to assist database administrators, developers, and organizations in making informed decisions when selecting the most appropriate database solution for their specific needs. The insights gained from this analysis offer practical guidance for optimizing database strategies in various organizational contexts.