Comparison of Different DBMS: Oracle, MySQL, Microsoft SQL Server, and PostgreSQL, Assignments of Database Programming

An overview of four popular database management systems (dbms): oracle, mysql, microsoft sql server, and postgresql. For each dbms, the document includes the name of the developer, key features and uses, and relevant resources for further learning.

Typology: Assignments

2020/2021

Uploaded on 05/29/2021

twentyfive25
twentyfive25 🇵🇭

3 documents

1 / 3

Toggle sidebar

This page cannot be seen from the preview

Don't miss anything!

bg1
Name of DBMS Developer Uses/Features
Oracle Oracle Corporation
- It is suitable for single-
server or highly branched
business applications with
limited features.
- It delivers all facilities
provided in Standard
Edition One. In addition, it
provides larger machine
support and Oracle Real
Application clustering
service.
- This edition is packed
with features like security,
performance, scalability,
and availability, required
for highly-critical
applications in which online
transaction processing is
involved.
- It is an entry-level edition
that is free to download,
install, manage, develop
and deploy.
MySQL Oracle Corporation
-A relational database
system.
-Communicate with the
server; that is, they query
data, save changes, etc.
- Supports as its database
language
-Standardized language for
querying and updating data
and for the administration
of a database.
Microsoft SQL Server Microsoft -Support tools SQL Server
Profiler, BI tools, SQL
Server Management Studio,
pf3

Partial preview of the text

Download Comparison of Different DBMS: Oracle, MySQL, Microsoft SQL Server, and PostgreSQL and more Assignments Database Programming in PDF only on Docsity!

Name of DBMS Developer Uses/Features Oracle Oracle Corporation

  • It is suitable for single- server or highly branched business applications with limited features.
  • It delivers all facilities provided in Standard Edition One. In addition, it provides larger machine support and Oracle Real Application clustering service.
  • This edition is packed with features like security, performance, scalability, and availability, required for highly-critical applications in which online transaction processing is involved.
  • It is an entry-level edition that is free to download, install, manage, develop and deploy. MySQL Oracle Corporation -A relational database system. -Communicate with the server; that is, they query data, save changes, etc.
  • Supports as its database language -Standardized language for querying and updating data and for the administration of a database. Microsoft SQL Server Microsoft -Support tools SQL Server Profiler, BI tools, SQL Server Management Studio,

and Database Tuning Advisor. -Offers online help and documentation, and live item support. -Provides advanced customization choice for datatype mappings and erase and rename objects. -Displays mistake, and cautioning messages about the relocation in an advanced window. -A single, coordinated condition for SQL Server Database Engine administration and approving. -Resizable discoursed enable access to different instruments when an exchange is open. -An action screen highlight with separating and programmed revive. -Importing and Exporting from SQL Server Management Studio. PostgreSQL PostgreSQL Global Development Group -It contains the various advanced data types and robust feature sets, which increase the extensibility, reliability, and data integrity of the software. -It supports multiple programming interfaces such asC/C++, JAVA, Python, Perl, Ruby, Tcl, and ODBC (Open Database Connectivity). -Runs on all major operating systems such as Microsoft Windows, Linux, MacOS X, UNIX (AIX, BSD, HP-UX, SGI IRIX, Solaris, and Tru64), etc. -It is open-source, and we can easily download it from