DB-EnginesExtremeDB: the mission critical dbmsEnglish
Deutsch
Knowledge Base of Relational and NoSQL Database Management Systemsprovided by solid IT

DBMS > AlaSQL vs. Derby vs. LeanXcale vs. RavenDB

System Properties Comparison AlaSQL vs. Derby vs. LeanXcale vs. RavenDB

Please select another system to include it in the comparison.

Editorial information provided by DB-Engines
NameAlaSQL  Xexclude from comparisonDerby infooften called Apache Derby, originally IBM Cloudscape; contained in the Java SDK as JavaDB  Xexclude from comparisonLeanXcale  Xexclude from comparisonRavenDB  Xexclude from comparison
DescriptionJavaScript DBMS libraryFull-featured RDBMS with a small footprint, either embedded into a Java application or used as a database server.A highly scalable full ACID SQL database with fast NoSQL data ingestion and GIS capabilitiesOpen Source Operational and Transactional Enterprise NoSQL Document Database
Primary database modelDocument store
Relational DBMS
Relational DBMSKey-value store
Relational DBMS
Document store
Secondary database modelsGraph DBMS
Spatial DBMS
Time Series DBMS
DB-Engines Ranking infomeasures the popularity of database management systemsranking trend
Trend Chart
Score0.71
Rank#249  Overall
#35  Document stores
#117  Relational DBMS
Score6.14
Rank#68  Overall
#37  Relational DBMS
Score0.35
Rank#312  Overall
#44  Key-value stores
#142  Relational DBMS
Score4.21
Rank#95  Overall
#17  Document stores
Websitealasql.orgdb.apache.org/­derbywww.leanxcale.comravendb.net
Technical documentationgithub.com/­agershun/­alasqldb.apache.org/­derby/­manuals/­index.htmlravendb.net/­docs
DeveloperAndrey Gershun & Mathias R. WulffApache Software FoundationLeanXcaleHibernating Rhinos
Initial release2014199720152010
Current release10.16.1.1, May 20225.4, July 2022
License infoCommercial or Open SourceOpen Source infoMIT-LicenseOpen Source infoApache version 2commercialOpen Source infoAGPL version 3, commercial license available
Cloud-based only infoOnly available as a cloud servicenononono
DBaaS offerings (sponsored links) infoDatabase as a Service

Providers of DBaaS offerings, please contact us to be listed.
Implementation languageJavaScriptJavaC#
Server operating systemsserver-less, requires a JavaScript environment (browser, Node.js)All OS with a Java VMLinux
macOS
Raspberry Pi
Windows
Data schemeschema-freeyesyesschema-free
Typing infopredefined data types such as float or datenoyesno
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.noyes
Secondary indexesnoyesyes
SQL infoSupport of SQLClose to SQL99, but no user access control, stored procedures and host language bindings.yesyes infothrough Apache DerbySQL-like query language (RQL)
APIs and other access methodsJavaScript APIJDBCJDBC
Kafka Connector
ODBC
proprietary key/value interface
Spark Connector
.NET Client API
F# Client API
Go Client API
Java Client API
NodeJS Client API
PHP Client API
Python Client API
RESTful HTTP API
Supported programming languagesJavaScriptJavaC
Java
Scala
.Net
C#
F#
Go
Java
JavaScript (Node.js)
PHP
Python
Ruby
Server-side scripts infoStored proceduresnoJava Stored Proceduresyes
Triggersyesyesyes
Partitioning methods infoMethods for storing different data on different nodesnonenoneSharding
Replication methods infoMethods for redundantly storing data on multiple nodesnoneSource-replica replicationMulti-source replication
MapReduce infoOffers an API for user-defined Map/Reduce methodsnononoyes
Consistency concepts infoMethods to ensure consistency in a distributed systemnoneImmediate ConsistencyImmediate ConsistencyDefault ACID transactions on the local node (eventually consistent across the cluster). Atomic operations with cluster-wide ACID transactions. Eventual consistency for indexes and full-text search indexes.
Foreign keys infoReferential integrityyesyesyesno
Transaction concepts infoSupport to ensure data integrity after non-atomic manipulations of datayes infoonly for local storage and DOM-storageACIDACIDACID, Cluster-wide transaction available
Concurrency infoSupport for concurrent manipulation of datayesyesyes
Durability infoSupport for making data persistentyes infoby using IndexedDB, SQL.JS or proprietary FileStorageyesyesyes
In-memory capabilities infoIs there an option to define some or all structures to be held in-memory only.yesyesyes
User concepts infoAccess controlnofine grained access rights according to SQL-standardAuthorization levels configured per client per database
More information provided by the system vendor
AlaSQLDerby infooften called Apache Derby, originally IBM Cloudscape; contained in the Java SDK as JavaDBLeanXcaleRavenDB
Specific characteristicsFull ACID and full SQL operational database with analytical queries over operational...
» more
RavenDB is the pioneer NoSQL Document Database that is fully transactional (ACID)...
» more
Competitive advantagesLinear scalability upto 100s of nodes (tested with 100 nodes and TPC-C).
» more
RavenDB is easy to setup and secure. You can do it in a matter of minutes . Easy...
» more
Typical application scenariosHybrid Transactional-Analytical Processing (HTAP) requiring an operational database...
» more
IoT for Edge Deployments Fraud Detection Recommendation Engines Product Catalogs...
» more
Key customersbanking/finance/fintech, telco, insurance, traveltech, M2M/IoT, retail
» more
Toyota, Capgemini, Vodafone, Medicaid, Asos, Nomura, RMS Automotive, MSNBC, Pluralsight,...
» more
Market metrics15 beta testers
» more
2 million+ downloads 1000+ customers including Fortune 500 large enterprises
» more
Licensing and pricing modelsannual fee covering license and support based on number of physical cores
» more
RavenDB is available on-premise and in the cloud. RavenDB Cloud is available on AWS...
» 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
AlaSQLDerby infooften called Apache Derby, originally IBM Cloudscape; contained in the Java SDK as JavaDBLeanXcaleRavenDB
Recent citations in the news

NoSQL in the Enterprise
21 April 2010, InfoQ.com

Disclosure timeline for vulnerabilities under active attack – OSnews
1 June 2013, OS News

provided by Google News

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

Java News Roundup: JEP Updates, GraalVM Code to OpenJDK ...
24 October 2022, InfoQ.com

The Ultimate Open Source Database List Profiling 16 Software Tools
30 May 2019, Solutions Review

JDK 9 Is the End of the Road for Some Features
25 January 2017, dzone.com

Payara Foundation Releases Payara Server 5 and Payara Micro 5
30 March 2018, InfoQ.com

provided by Google News

Hunting For Disruption At Collision Conference
29 April 2016, Forbes

Red Hot: The 2021 Machine Learning, AI and Data (MAD) Landscape
28 September 2021, mattturck.com

Big Data Market: 2018-2030 - $65 Billion Opportunities, Challenges ...
22 June 2018, GlobeNewswire

Conoce las startups ganadoras de los verticales presentes en South ...
19 August 2020, El Referente

Llega a Madrid la sexta edición del South Summit
19 August 2020, El Referente

provided by Google News

Oren Eini on RavenDB, Including Consistency Guarantees and C# ...
23 May 2022, InfoQ.com

RavenDB, one of the world's most innovative NoSQL Database, is ...
24 March 2022, PR Newswire

NoSQL Market Size 2023 (New Report) is Booming Worldwide to ...
25 January 2023, Digital Journal

Designing for Concurrency: the Hilbert's Hotel Problem in Go
3 February 2023, InfoQ.com

How to create a new database with RavenDB
6 January 2021, TechRepublic

provided by Google News

Job opportunities

Applications Developer
Axle Informatics, Rockville, MD

Developer
Axle Informatics, Rockville, MD

Sitecore Developer
Optizm Global, Mexico, MO

IT Developer
Home Depot / THD, Houston, TX

Senior Software Developer
University of Colorado Boulder, Boulder, CO

Senior Sitecore Developer
Vettanna, Los Angeles, CA

DevOps Engineer
PARTSSOURCE, INC, Remote

jobs by Indeed



Share this page

Featured Products

Neo4j logo

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

MariaDB logo

SkySQL, the ultimate
MariaDB cloud, is here.

Get started with SkySQL today!

Redis logo

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

AllegroGraph logo

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

Datastax Astra logo

Build cloud-native apps fast with Astra, the open-source, multi-cloud stack for
modern data apps.
Get started with 80GB free.

Present your product here