| Description |
Common in IBM host environments, 2 different versions for host and Windows/Linux |
Widely used open source RDBMS |
Widely used RDBMS |
Enhanced drop-in replacement for MySQL based on XtraDB storage engine with improved performance and additional diagnostic and management features. |
Distributed In-Memory NewSQL RDBMS |
| Database model |
Relational DBMS |
Relational DBMS |
Relational DBMS |
Relational DBMS |
Relational DBMS |
| License |
commercial, free version is available |
Open Source, GPL version 2. Commercial licenses with extended functionallity are available |
commercial, restricted free version is available |
Open Source, GPL version 2 |
Open Source, GPL version 3 for Community Edition, commercial license for Enterprise Edition |
| Implementation language |
C and C++ |
C and C++ |
C and C++ |
C and C++ |
Java |
| Server operating systems |
Linux,Unix,Windows,z/OS |
FreeBSD,Linux,OS X,Solaris,Windows |
AIX,HP-UX,Linux,OS X,Solaris,Windows,z/OS |
Linux |
Linux,OS X |
| Data scheme |
yes |
yes |
yes |
yes |
yes |
| Typing |
yes |
yes |
yes |
yes |
yes |
| Secondary indexes |
yes |
yes |
yes |
yes |
yes |
| SQL |
yes |
yes |
yes |
yes |
yes |
| APIs and other access methods |
JSON style queries,XQuery,ADO.NET,JDBC,ODBC |
ADO.NET,JDBC,ODBC |
ODP.NET,Oracle Call Interface (OCI),JDBC,ODBC |
ADO.NET,JDBC,ODBC,Java,API |
RESTful HTTP/JSON API,JDBC |
| Supported programming languages |
C,C#,C++,Cobol,Fortran,Java,Perl,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 |
Ada,C,C#,C++,D,Eiffel,Erlang,Haskell,Java,Objective-C,OCaml,Perl,,PHP,Python,Ruby,Scheme,Tcl |
C#,C++,Erlang,Java,JavaScript,PHP,Python,Ruby |
| Server-side scripts |
yes |
yes |
PL/SQL |
yes |
Java |
| Triggers |
yes |
yes |
yes |
yes |
no |
| Partitioning methods |
Sharding |
horizontal partitioning, sharding with MySQL Cluster or MySQL Fabric |
horizontal partitioning |
Sharding |
|
| Replication methods |
yes |
Master-master replication, Master-slave replication |
Master-master replication, Master-slave replication |
Master-master replication, Master-slave replication,XtraDB Cluster |
Master-slave replication |
| MapReduce |
no |
no |
no |
no |
no |
| Consistency concepts |
|
|
Immediate Consistency |
Immediate Consistency |
|
| Foreign keys |
yes |
yes |
yes |
yes |
|
| Transaction concepts |
ACID |
ACID |
ACID |
ACID |
ACID |
| Concurrency |
yes |
yes |
yes |
yes |
yes |
| In-memory capabilities |
|
yes |
yes |
|
|
| Durability |
yes |
yes |
yes |
yes |
yes => Snapshots and command logging |
| Horizontal scalable |
no |
yes |
yes |
yes |
yes |
| Value size max. |
10 B |
4 B |
2 EB |
|
|
| Memory minimum |
256 MB |
11 MB |
512 MB |
? |
4 GB |
| Data Storage |
File System, Volatile memory |
File System, Volatile memory |
ASM, File System |
File System |
Volatile memory, File System,Data Persisted to Disk |
