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.
Properties
|
Microsoft SQL
Server
|
MySQL
|
Oracle
|
|||||||||||||||||
Description
|
Microsoft RDBMS
|
Widely used and open source RDBMS
|
Widely used RDBMS
|
|||||||||||||||||
Ranking
|
|
|
|
|||||||||||||||||
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