Databases

See at a glance which features and benefits
the database systems have which we install and administrate!

Name	Access	MS SQL	MySQL	Oracle

Description	Combines a backend RDBMS (JET / ACE Engine) with a GUI frontend for data manipulation and queries	Microsofts relational DBMS	Widely used open source RDBMS	Key-value store based on Berkeley DB Java Edition
Developer	Microsoft	Microsoft	Oracle	Oracle
Initial release	1992	1989	1995	2011
Current release	2013 (15.0.4420.1017), Oktober 2012	SQL Server 2014, April 2014	5.6.23, Februar 2015
License	commercial	commercial	Open Source	Open Source
Database as a Service	no	no	no	no
Implementation language	C++	C++	C and C++	Java
Server operating systems	Windows	Windows	FreeBSD Linux OS X Solaris Windows	Linux OS X Windows
Database model	Relational DBMS	Relational DBMS	Relational DBMS	Key-Value Store
Data scheme	yes	yes	yes	schema-free
Typing	yes	yes	yes	no
Secondary indexes	yes	yes	yes	no
SQL	yes	yes	yes	no
APIs and other access methods	DAO OLE DB ADO.NET ODBC	OLE DB Tabular Data Stream (TDS) ADO.NET JDBC ODBC	ADO.NET JDBC ODBC	Java API
Supported programming languages	C C# C++ Java (JDBC-ODBC) VBA Visual Basic.NET	.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	Java
Server-side scripts	yes	Transact-SQL .NET languages	yes
Triggers	yes	yes	yes
Partitioning methods	none	tables can be distributed across several files (horizontal partitioning), but no sharding	horizontal partitioning in MySQL Cluster	Sharding (shard = partition)
Replication methods	none	yes, but depending on the SQL-Server Edition	Master-master replication Master-slave replication MySQL Cluster	Master-slave replication
MapReduce	no	no	no	no
Foreign keys	yes	yes	yes	no
Transaction concepts	ACID	ACID	ACID	configurable
Concurrency	yes	yes	yes	yes
Durability	yes	yes	yes	yes
User concepts	no	Users with fine-grained authorization concept	Users with fine-grained authorization concept	no