A Brief Comparison of Two Enterprise-Class RDBMSs
Andrew Figueroa, Steven Rollo, Sean Murthy

TL;DR
This paper compares Microsoft SQL Server and PostgreSQL by implementing schemas, analyzing activities, and assessing support, providing insights into their similarities, differences, and enterprise suitability.
Contribution
It offers a practical comparison of two enterprise RDBMSs through implementation and activity analysis, highlighting support levels and standards adherence.
Findings
Identified 26 common activities in schema implementation
Compared support levels for activities between systems
Provided a ranking of system implementations
Abstract
This paper is an extended version of a report from a student-developed study to compare Microsoft SQL Server and PostgreSQL, two widely-used enterprise-class relational database management systems (RDBMSs). The study followed an introductory undergraduate course in relational systems and was designed to help gain practical understanding of specific DBMSs. During this study, we implemented three non-trivial schemas in each system, identified 26 common database design, development, and administration activities while implementing the schemas, and compared the support each system offers to carry out the identified activities. Where relevant, we also compared each system against the SQL standard. In this report, we present a summary of the similarities and differences we found between the two systems, and we provide a quantitative measure ranking both systems' implementations of the 26…
Peer Reviews
No public reviews on file for this paper yet. If you reviewed it on a platform where reviews are public (OpenReview, ICLR, NeurIPS, ICML), you can paste yours below so the community can read it here.
Code & Models
Videos
No videos yet. Explain this paper in a talk, walkthrough, or lecture? Add one.
Taxonomy
TopicsService-Oriented Architecture and Web Services · Advanced Database Systems and Queries · Cloud Computing and Resource Management
