DB-EnginesInfluxDB: Focus on building software with an easy-to-use serverless, scalable time series platformEnglish
Deutsch
Knowledge Base of Relational and NoSQL Database Management Systemsprovided by solid IT

DBMS > Aerospike vs. Derby vs. EXASOL

System Properties Comparison Aerospike vs. Derby vs. EXASOL

Please select another system to include it in the comparison.

Editorial information provided by DB-Engines
NameAerospike infopreviously called Citrusleaf  Xexclude from comparisonDerby infooften called Apache Derby, originally IBM Cloudscape; contained in the Java SDK as JavaDB  Xexclude from comparisonEXASOL  Xexclude from comparison
DescriptionFlash-optimized In-memory NoSQL DatabaseFull-featured RDBMS with a small footprint, either embedded into a Java application or used as a database server.High-performance, in-memory, MPP database specifically designed for in-memory analytics.
Primary database modelDocument store
Key-value store
Spatial DBMS
Relational DBMSRelational DBMS
DB-Engines Ranking infomeasures the popularity of database management systemsranking trend
Trend Chart
Score6.85
Rank#60  Overall
#11  Document stores
#7  Key-value stores
#2  Spatial DBMS
Score6.84
Rank#61  Overall
#35  Relational DBMS
Score2.85
Rank#118  Overall
#61  Relational DBMS
Websiteaerospike.comdb.apache.org/­derbywww.exasol.com
Technical documentationdocs.aerospike.comdb.apache.org/­derby/­manuals/­index.htmlwww.exasol.com/­resources
Social network pagesLinkedInTwitterFacebook
DeveloperAerospikeApache Software FoundationExasol
Initial release201219972000
Current release6.0.0.0, April 202210.16.1.1, May 2022
License infoCommercial or Open SourceOpen Source infoApache and AGPL Licenses; open sourced in June 2014; commercial Enterprise Edition availableOpen Source infoApache version 2commercial
Cloud-based only infoOnly available as a cloud servicenonono
DBaaS offerings (sponsored links) infoDatabase as a Service

Providers of DBaaS offerings, please contact us to be listed.
Implementation languageCJava
Server operating systemsLinuxAll OS with a Java VM
Data schemeschema-freeyesyes
Typing infopredefined data types such as float or dateyesyesyes
XML support infoSome form of processing data in XML format, e.g. support for XML data structures, and/or support for XPath, XQuery or XSLT.noyesno
Secondary indexesyesyesyes
SQL infoSupport of SQLnoyesyes
APIs and other access methodsJDBC
Proprietary protocol
JDBC.Net
JDBC
ODBC
WebSocket
Supported programming languages.Net
C
C#
C++
Erlang
Go
Java
JavaScript (Node.js)
Lua
Perl
PHP
Python
Ruby
JavaJava
Lua
Python
R
Server-side scripts infoStored proceduresuser defined functions infowith LuaJava Stored Proceduresuser defined functions
Triggersnoyesyes
Partitioning methods infoMethods for storing different data on different nodesShardingnoneSharding
Replication methods infoMethods for redundantly storing data on multiple nodesselectable replication factorSource-replica replication
MapReduce infoOffers an API for user-defined Map/Reduce methodsyes infoAerospike Aggregation Framework is similar to Map/Reducenoyes infoHadoop integration
Consistency concepts infoMethods to ensure consistency in a distributed systemEventual Consistency in cross-datacenter configuration and Immediate Consistency in local cluster configurationImmediate ConsistencyImmediate Consistency
Foreign keys infoReferential integritynoyesyes
Transaction concepts infoSupport to ensure data integrity after non-atomic manipulations of dataAtomic execution of operationsACIDACID
Concurrency infoSupport for concurrent manipulation of datayesyesyes
Durability infoSupport for making data persistentyesyesyes
In-memory capabilities infoIs there an option to define some or all structures to be held in-memory only.yesyesyes
User concepts infoAccess controlAccess rights for users and roles infowith Enterprise Edition onlyfine grained access rights according to SQL-standardAccess rights for users, groups and roles according to SQL-standard
More information provided by the system vendor
Aerospike infopreviously called CitrusleafDerby infooften called Apache Derby, originally IBM Cloudscape; contained in the Java SDK as JavaDBEXASOL
Specific characteristicsAerospike is an enterprise-class, NoSQL database solution delivering predictable...
» more
Competitive advantagesOptimized for use with SSDs (solid-state hard drives) Scales horizontally and vertically...
» more
Typical application scenariosAerospike excels in mission-critical applications that have mixed read/write workloads...
» more
Key customersNielsen, Williams-Sonoma, Inmobi, AppNexus, Telco (confidential), Financial Services...
» more
Market metricsAerospike's combination of speed, scalability, and reliability delivers 10x performance...
» more
Licensing and pricing modelsSubscription-based Enterprise Edition and free, open-source Community Edition
» more

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
Aerospike infopreviously called CitrusleafDerby infooften called Apache Derby, originally IBM Cloudscape; contained in the Java SDK as JavaDBEXASOL
DB-Engines blog posts

Evaluating Hbase and Aerospike Solutions for Real-time System of Record
17 March 2020,  Srini Srinivasan, Aerospike (sponsor) 

show all

Recent citations in the news

Aerospike Announces Availability of Developer-ready, Real-time ...
28 August 2023, GlobeNewswire

Implementing High-Performance Ad Tech Demand-Side Platforms ...
19 September 2023, The New Stack

[Latest News] NoSQL Database Market Size, Share, Growth | Forecast, 2030
24 September 2023, Benzinga

Storage news ticker – September 4 – Blocks and Files
4 September 2023, Blocks & Files

Data Management News for the Week of September 1; Updates from ...
31 August 2023, Solutions Review

provided by Google News

IBM Acquires StepZen to Help Enterprises Get More Business Value ...
8 February 2023, IBM Newsroom

Pentesting mit Legion, sqlmap, ZAP, OpenSCAP, Karkinos und ...
5 September 2023, Security-Insider

Six free databases with commercial-quality features
3 December 2012, Network World

Top Tools for ERP Enterprise Resource Planning
26 January 2023, Investopedia

Why you should use SQLite
13 February 2019, InfoWorld

provided by Google News

How APIs Are Shaping the Next Wave of Secure Data Interoperability
30 August 2023, CDOTrends

In-Memory Database Market Size, Research Report 2023-2031
19 September 2023, Benzinga

How Strategic CFOs Can Become More Effective Data Storytellers
20 September 2023, The Financial Brand

Exasol Reimagines In-Memory Analytics with Major Database Update
30 May 2023, Datanami

In-Memory Database Market Outlook for Forecast Period (2023 to 2030)
25 September 2023, Benzinga

provided by Google News

Job opportunities

Federal Technical Support Engineer (East Coast)
Aerospike, Mountain View, CA

Sr Manager, Software Development & Engineering Senior
Charles Schwab, Austin, TX

Senior Cloud Engineer - Data Platforms
Fidelity Investments, Durham, NC

React JS Developer
Virtualware Innovations, Dallas, TX

Principal, Full Stack Engineer
Fidelity Investments, Durham, NC

ArchivesSpace Technical Lead
LYRASIS, Georgia

DEV OPS ENGINEER
Esperanto.ai, Mountain View, CA

Software Developer
Grant Street Group, Remote

Senior Software Developer – Flex Schedule
Grant Street Group, Remote

Solutions Engineer
Exasol, United States

Head of Revenue Operations & Commercial Delivery (f/m/d)
Exasol, United States

Enterprise Account Executive
Exasol, United States

jobs by Indeed



Share this page

Featured Products

Datastax Astra logo

Bring all your data to Generative AI applications with vector search enabled by the most scalable
vector database available.
Try for Free

Redis logo

The world’s most loved real‑time data platform.
Try free

MariaDB logo

SkySQL, the ultimate
MariaDB cloud, is here.

Get started with SkySQL today!

Neo4j logo

See for yourself how a graph database can make your life easier.
Use Neo4j online for free.

AllegroGraph logo

Graph Database Leader for AI Knowledge Graph Applications - The Most Secure Graph Database Available.
Free Download

Present your product here