Drop Down MenusCSS Drop Down MenuPure CSS Dropdown Menu

Oracle VS Mysql Vs Informix comparison

Name
Informix  X
MySQL  X
Oracle  X
Description
An RDBMS by IBM, which is positioned besides DB2 as relatively low-cost and embeddable product
Widely used open source RDBMS
Widely used RDBMS
Primary database model
Relational DBMS 
Relational DBMS 
Relational DBMS
Additional database models
Document store
Key-value store
Document store
Key-value store
Document store
Key-value store
DB-Engines Ranking 


Score
28.68
Rank
#24
  Overall
#14
  Relational DBMS
Score
1299.71
Rank
#2
  Overall
#2
  Relational DBMS
Score
1341.94
Rank
#1
  Overall
#1
  Relational DBMS
Website
www.ibm.com/­analytics/­informix
www.mysql.com
www.oracle.com/­database/­index.html
Technical documentation
dev.mysql.com/­doc
docs.oracle.com/­en/­database
Developer
IBM, HCL Technologies 
Oracle 
Oracle
Initial release
1984
1995
1980
Current release
12.10.xC7, June 2016
5.7.20, October 2017
12 Release 2 (12.2.0.1), March 2017
License 
commercial 
Open Source 
commercial 
Cloud-based 
no
no
no
Implementation language
C and C++
C and C++
C and C++
Server operating systems
AIX
HP-UX
Linux
OS X
Solaris
Windows
FreeBSD
Linux
OS X
Solaris
Windows
AIX
HP-UX
Linux
OS X
Solaris
Windows
z/OS
Data scheme
yes
yes
yes 
Typing 
yes 
yes
yes
XML support 
yes
yes
Secondary indexes
yes
yes
yes
SQL 
yes
yes 
yes
APIs and other access methods
JSON style queries
JDBC
ODBC
ADO.NET
JDBC
ODBC
ODP.NET
Oracle Call Interface (OCI)
JDBC
ODBC
.Net
C
C++
Java
PHP
Ruby
Ada
C
C#
C++
D
Delphi
Eiffel
Erlang
Haskell
Java
JavaScript (Node.js)
Objective-C
OCaml
Perl
PHP
Python
Ruby
Scheme
Tcl
C
C#
C++
Clojure
Cobol
Delphi
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 
PL/SQL 
Triggers
yes
yes
yes
Partitioning methods 
yes 
horizontal partitioning, sharding with MySQL Cluster or MySQL Fabric
horizontal partitioning 
Replication methods 
Master-master replication
Master-slave replication
Master-master replication
Master-slave replication
Master-master replication
Master-slave replication
MapReduce 
no
no
no 
Consistency concepts 
Immediate Consistency
Supported programming languageImmediate Consistency
Foreign keys 
yes
yes 
yes
Transaction concepts 
ACID
ACID 
ACID 
Concurrency 
yes
yes 
yes
Durability 
yes
yes
yes
In-memory capabilities 
yes
yes 
User concepts 
Users with fine-grained authorization concept
Users with fine-grained authorization concept 
fine grained access rights according to SQL-standard

Comments

Popular posts from this blog

Oracle DBMS SCHEDULER Examples

How to find the server is whether standby (slave) or primary(master) in Postgresql replication ?

7 Steps to configure BDR replication in postgresql

How to Get Table Size, Database Size, Indexes Size, schema Size, Tablespace Size, column Size in PostgreSQL Database

vacuumlo - removing large objects orphans from a database PostgreSQL