Mail | BHV-Automation
Newsletter | BHV-Automation

Databases

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

 

NameAccessMS SQLMySQLOracle
DatabasesDatabasesDatabasesDatabases
Description
Combines a backend RDBMS (JET / ACE Engine) with a GUI frontend for data manipulation and queries
Microsofts relational DBMSWidely used open source RDBMSKey-value store based on Berkeley DB Java Edition
DeveloperMicrosoftMicrosoftOracleOracle
Initial release1992198919952011
Current release2013 (15.0.4420.1017),
Oktober 2012
SQL Server 2014,
April 2014
5.6.23,
Februar 2015
LicensecommercialcommercialOpen SourceOpen Source
Database as a
Service
nononono
Implementation
language
C++C++C and C++Java
Server
operating
systems
WindowsWindowsFreeBSD
Linux
OS X
Solaris
Windows
Linux
OS X
Windows
Database modelRelational DBMSRelational DBMSRelational DBMSKey-Value Store
Data schemeyesyesyesschema-free
Typingyesyesyesno
Secondary
indexes
yesyesyesno
SQLyesyesyesno
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
yesTransact-SQL
.NET languages
yes
Triggersyesyesyes
Partitioning
methods
nonetables can be distributed across several files (horizontal partitioning), but no shardinghorizontal partitioning in MySQL ClusterSharding (shard = partition)
Replication
methods
noneyes, but depending
on the
SQL-Server
Edition
Master-master replication
Master-slave replication
MySQL Cluster
Master-slave replication
MapReducenononono
Foreign keysyesyesyesno
Transaction
concepts
ACIDACIDACIDconfigurable
Concurrencyyesyesyesyes
Durabilityyesyesyesyes
User
concepts
noUsers with fine-grained authorization conceptUsers with fine-grained authorization conceptno

 

Source: db-engines.com/en/

[top]