Drop Down MenusCSS Drop Down MenuPure CSS Dropdown Menu

Oracle VS Informix comparison

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

DB-Engines Ranking 


Score
28.68
Rank
#24
  Overall
#14
  Relational DBMS

Score
1341.94
Rank
#1
  Overall
#1
  Relational DBMS
Website
Technical documentation
Developer
IBM, HCL Technologies 
Oracle
Initial release
1984
1980
Current release
12.10.xC7, June 2016
12 Release 2 (12.2.0.1), March 2017
License 
commercial 
commercial 
Cloud-based 
no
no
Implementation language
C and C++
C and C++
Server operating systems
AIX
HP-UX
Linux
OS X
Solaris
Windows
AIX
HP-UX
Linux
OS X
Solaris
Windows
z/OS
Data scheme
yes
yes 
Typing 
yes 





yes
XML support 
yes
Secondary indexes
yes
yes
SQL 
yes
yes
APIs and other access methods
JSON style queries 
JDBC
ODBC
ODP.NET
Oracle Call Interface (OCI)
JDBC
ODBC
Supported programming languages
.Net
C
C++
Java
PHP
Ruby
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
PL/SQL 
Triggers
yes
yes
Partitioning methods 
yes 
horizontal partitioning 
Replication methods 
Master-master replication
Master-slave replication
Master-master replication
Master-slave replication
MapReduce 
no
no 
Consistency concepts 
Immediate Consistency
Foreign keys 
yes
yes
Transaction concepts 
ACID
ACID 
Concurrency
yes
yes
Durability
yes
yes




In-memory capabilities 
yes 
User concepts
Users with fine-grained authorization concept
fine grained access rights according to SQL-standard


Comments

Popular posts from this blog

PostgreSQL pgBadger

PostgreSQL Pgbadger Installation On Linux

How to configure Replication Manager (repmgr) ?

What's is the difference between streaming replication Vs hot standby vs warm standby ?

Script to kill ALL IDLE Connection In postgreSQL