DBMS > 4D vs. Derby vs. Riak KV vs. TimesTen

System Properties Comparison 4D vs. Derby vs. Riak KV vs. TimesTen

Please select another system to include it in the comparison.

Editorial information provided by DB-Engines
Name	4D former name: 4th Dimension  Xexclude from comparison	Derby often called Apache Derby, originally IBM Cloudscape; contained in the Java SDK as JavaDB  Xexclude from comparison	Riak KV  Xexclude from comparison	TimesTen  Xexclude from comparison
Description	Application development environment with integrated database management system	Full-featured RDBMS with a small footprint, either embedded into a Java application or used as a database server.	Distributed, fault tolerant key-value store	In-Memory RDBMS compatible to Oracle
Primary database model	Relational DBMS	Relational DBMS	Key-value store with links between data sets and object tags for the creation of secondary indexes	Relational DBMS
DB-Engines Ranking measures the popularity of database management systems Trend Chart	Score 2.83 Rank #106   Overall #55   Relational DBMS	Score 4.97 Rank #78   Overall #42   Relational DBMS	Score 6.52 Rank #65   Overall #9   Key-value stores	Score 1.69 Rank #138   Overall #68   Relational DBMS
Website	www.4d.com	db.apache.org/­derby	riak.com/­products/­riak-kv	www.oracle.com/­database/­technologies/­related/­timesten.html
Technical documentation	livedoc.4d.com	db.apache.org/­derby/­manuals/­index.html		docs.oracle.com/­database/­timesten-18.1
Developer	4D, Inc	Apache Software Foundation	Basho Technologies	Oracle, TimesTen Performance Software, HP originally founded in HP Labs it was acquired by Oracle in 2005
Initial release	1984	1997	2009	1998
Current release	v18 R5, January 2021	10.15.2.0, March 2020	2.1.0, April 2015	11 Release 2 (11.2.2.8.0)
License Commercial or Open Source	commercial	Open Source Apache version 2	Open Source Apache version 2, commercial enterprise edition	commercial
Cloud-based only Only available as a cloud service	no	no	no	no
DBaaS offerings (sponsored links) Database as a Service Providers of DBaaS offerings, please contact us to be listed.
Implementation language		Java	Erlang
Server operating systems	OS X Windows	All OS with a Java VM	Linux OS X	AIX HP-UX Linux OS X Solaris SPARC/x86 Windows
Data scheme	yes	yes	schema-free	yes
Typing predefined data types such as float or date	yes	yes	no	yes
XML support Some form of processing data in XML format, e.g. support for XML data structures, and/or support for XPath, XQuery or XSLT.	yes	yes	no	no
Secondary indexes	yes	yes	restricted	yes
SQL Support of SQL	yes close to SQL 92	yes	no	yes
APIs and other access methods	ODBC RESTful HTTP API by using 4D Mobile SOAP webservices	JDBC	HTTP API Native Erlang Interface	JDBC ODBC ODP.NET Oracle Call Interface (OCI)
Supported programming languages	4D proprietary IDE PHP	Java	C unofficial client library C# C++ unofficial client library Clojure unofficial client library Dart unofficial client library Erlang Go unofficial client library Groovy unofficial client library Haskell unofficial client library Java JavaScript unofficial client library Lisp unofficial client library Perl unofficial client library PHP Python Ruby Scala unofficial client library Smalltalk unofficial client library	C C++ Java PL/SQL
Server-side scripts Stored procedures	yes	Java Stored Procedures	JavaScript and Erlang	PL/SQL
Triggers	yes	yes	yes pre-commit hooks and post-commit hooks	no
Partitioning methods Methods for storing different data on different nodes	none	none	Sharding no "single point of failure"	none
Replication methods Methods for redundantly storing data on multiple nodes	Multi-source replication	Source-replica replication	selectable replication factor	Multi-source replication Source-replica replication
MapReduce Offers an API for user-defined Map/Reduce methods	no	no	yes	no
Consistency concepts Methods to ensure consistency in a distributed system	Immediate Consistency	Immediate Consistency	Eventual Consistency	Immediate Consistency or Eventual Consistency depending on configuration
Foreign keys Referential integrity	yes	yes	no links between data sets can be stored	yes
Transaction concepts Support to ensure data integrity after non-atomic manipulations of data	ACID	ACID	no	ACID
Concurrency Support for concurrent manipulation of data	yes	yes	yes	yes
Durability Support for making data persistent	yes	yes	yes	yes by means of logfiles and checkpoints
In-memory capabilities Is there an option to define some or all structures to be held in-memory only.	no	yes		yes
User concepts Access control	Users and groups	fine grained access rights according to SQL-standard	no	fine grained access rights according to SQL-standard
More information provided by the system vendor We invite representatives of system vendors to contact us for updating and extending the system information, and for displaying vendor-provided information such as key customers, competitive advantages and market metrics.
Related products and services We invite representatives of vendors of related products to contact us for presenting information about their offerings here.
More resources
	4D former name: 4th Dimension	Derby often called Apache Derby, originally IBM Cloudscape; contained in the Java SDK as JavaDB	Riak KV	TimesTen
DB-Engines blog posts	MySQL, PostgreSQL and Redis are the winners of the March ranking 2 March 2016, Paul Andlinger show all