Thursday, May 8, 2014

Difference Between Oracle, MySQL and Sql Server

Introduction:


In 1980s, relational database management systems have become the standard database type for a variety of industries.  These systems are based on the relational model that organizes data into groups of tables referred to as relations. There are three popular RDBMS: Oracle, MySQL and SQL Server. The following comparison should help you understand the differences between these systems and provide you information that will help you to make a decision.

Difference Between Oracle, My Sql and Sql Server:

Properties
Microsoft SQL Server
MySQL
Oracle
Description
Microsoft RDBMS
Widely used and open source RDBMS
Widely used RDBMS
Ranking
Rank
3
Rank
2
Rank
1
Score
1207
1309
1502
Owner
Microsoft
Oracle
Oracle
Initial Release
1989
1995
1980
License
Commercial
Open Source
Commercial
Development Language
C++
C and C++
C and C++
Supported Operating Systems
Windows
Free BSD
Linux
OS X
Solaris
Windows
AIX
HP-UX
Linux
OS X
Solaris
Windows
Z/OS
Relational DBMS
Yes
Yes
Yes
Supports SQL
Yes
Yes
Yes
Access Methods
OLE DB
Tabular Data Stream
ADO.NET
JDBC
ODBC
ADO.NET
JDBC
ODBC
ODP.NET
Oracle Call Interface
JDBC
ODBC
Supported Programming Languages
.Net
Java
PHP
Python
Ruby
Visual Basic
Ada
C
C#
C++
D
Eiffel
Erlang
Haskell
Java
Objective-C
OCaml
Perl
PHP
Python
Ruby
Scheme
TCL
C
C#
C++
Clojure
Cobol
Eiffel
Erlang
Fortran
Groovy
Haskell
Java
JavaScript
Lisp
Objective C
OCaml
Perl
PHP
Python
R
Ruby
Scala
TCL
Visual Basic
Server-Side Scripts
Yes
Yes
Yes
Triggers
Yes
Yes
Yes
Partitioning Methods
Horizontal Partitioning
Horizontal Partitioning
Horizontal Partitioning
Replication Methods
Depending on the SQL-Server Edition
Master-Master Replication and
Master-Slave Replication
Master-Master Replication and
Master-Slave Replication
Concurrency
Yes
Yes
Yes
Durability
Yes
Yes
Yes


No comments:

Post a Comment