DB-EnginesExtremeDB: mitigate connectivity issues in a DBMSEnglish
Deutsch
Knowledge Base of Relational and NoSQL Database Management Systemsprovided by solid IT

DBMS > AlaSQL vs. Cassandra vs. Ehcache vs. LokiJS vs. OceanBase

System Properties Comparison AlaSQL vs. Cassandra vs. Ehcache vs. LokiJS vs. OceanBase

Editorial information provided by DB-Engines
NameAlaSQL  Xexclude from comparisonCassandra  Xexclude from comparisonEhcache  Xexclude from comparisonLokiJS  Xexclude from comparisonOceanBase  Xexclude from comparison
DescriptionJavaScript DBMS libraryWide-column store based on ideas of BigTable and DynamoDB infoOptimized for write accessA widely adopted Java cache with tiered storage optionsIn-memory JavaScript DBMSA distributed, high available RDBMS compatible with Oracle and MySQL
Primary database modelDocument store
Relational DBMS
Wide column storeKey-value storeDocument storeRelational DBMS
Secondary database modelsVector DBMS infostarting with release V5Document store
Wide column store
DB-Engines Ranking infomeasures the popularity of database management systemsranking trend
Trend Chart
Score0.46
Rank#260  Overall
#40  Document stores
#121  Relational DBMS
Score101.89
Rank#12  Overall
#1  Wide column stores
Score4.89
Rank#67  Overall
#8  Key-value stores
Score0.43
Rank#264  Overall
#42  Document stores
Score1.66
Rank#147  Overall
#68  Relational DBMS
Websitealasql.orgcassandra.apache.orgwww.ehcache.orggithub.com/­techfort/­LokiJSen.oceanbase.com
Technical documentationgithub.com/­AlaSQL/­alasqlcassandra.apache.org/­doc/­latestwww.ehcache.org/­documentationtechfort.github.io/­LokiJSen.oceanbase.com/­docs/­oceanbase-database
DeveloperAndrey Gershun & Mathias R. WulffApache Software Foundation infoApache top level project, originally developped by FacebookTerracotta Inc, owned by Software AGOceanBase infopreviously Alibaba and Ant Group
Initial release20142008200920142010
Current release4.1.3, July 20233.10.0, March 20224.3.0, April 2024
License infoCommercial or Open SourceOpen Source infoMIT-LicenseOpen Source infoApache version 2Open Source infoApache Version 2; commercial licenses availableOpen SourceOpen Source infoCommercial license available
Cloud-based only infoOnly available as a cloud servicenonononono
DBaaS offerings (sponsored links) infoDatabase as a Service

Providers of DBaaS offerings, please contact us to be listed.
Astra DB: Multi-cloud DBaaS built on Apache Cassandra.
Implementation languageJavaScriptJavaJavaJavaScriptC++
Server operating systemsserver-less, requires a JavaScript environment (browser, Node.js)BSD
Linux
OS X
Windows
All OS with a Java VMserver-less, requires a JavaScript environment (browser, Node.js)Linux
Data schemeschema-freeschema-freeschema-freeschema-freeyes
Typing infopredefined data types such as float or datenoyesyesnoyes
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.nonononoyes
Secondary indexesnorestricted infoonly equality queries, not always the best performing solutionnoyes infovia viewsyes
SQL infoSupport of SQLClose to SQL99, but no user access control, stored procedures and host language bindings.SQL-like SELECT, DML and DDL statements (CQL)nonoyes
APIs and other access methodsJavaScript APIProprietary protocol infoCQL (Cassandra Query Language, an SQL-like language)
Thrift
JCacheJavaScript APIJDBC
ODBC
ODP.NET
Oracle Call Interface (OCI)
Proprietary native API
Table API
Supported programming languagesJavaScriptC#
C++
Clojure
Erlang
Go
Haskell
Java
JavaScript infoNode.js
Perl
PHP
Python
Ruby
Scala
JavaJavaScriptAda infoin MySQL-compatible model
C infoin Oracle- and MySQL- compatible models
C++ infoin Oracle- and MySQL- compatible models
D infoin MySQL-compatible model
Delphi infoin MySQL-compatible model
Eiffel infoin MySQL-compatible model
Erlang infoin MySQL-compatible model
Haskell infoin MySQL-compatible model
Java infoin Oracle- and MySQL- compatible models
JavaScript (Node.js) infoin MySQL-compatible model
Objective-C infoin MySQL-compatible model
OCaml infoin MySQL-compatible model
Perl infoin MySQL-compatible model
PHP infoin MySQL-compatible model
Python infoin MySQL-compatible model
Ruby infoin MySQL-compatible model
Scheme infoin MySQL-compatible model
Tcl infoin MySQL-compatible model
Server-side scripts infoStored proceduresnononoView functions in JavaScriptPL/SQL in oracle-compatible mode, MySQL Stored Procedure in mysql-compatible mode
Triggersyesyesyes infoCache Event Listenersyesyes
Partitioning methods infoMethods for storing different data on different nodesnoneSharding infono "single point of failure"Sharding infoby using Terracotta Servernonehorizontal partitioning (by hash, key, range, range columns, list, and list columns)
Replication methods infoMethods for redundantly storing data on multiple nodesnoneselectable replication factor infoRepresentation of geographical distribution of servers is possibleyes infoby using Terracotta ServernoneMulti-source replication using Paxos
MapReduce infoOffers an API for user-defined Map/Reduce methodsnoyesnoyesno
Consistency concepts infoMethods to ensure consistency in a distributed systemnoneEventual Consistency
Immediate Consistency infocan be individually decided for each write operation
Tunable Consistency (Strong, Eventual, Weak)noneImmediate Consistency
Foreign keys infoReferential integrityyesnononoyes
Transaction concepts infoSupport to ensure data integrity after non-atomic manipulations of datayes infoonly for local storage and DOM-storageno infoAtomicity and isolation are supported for single operationsyes infosupports JTA and can work as an XA resourceno infoatomic operations within a single collection possibleACID
Concurrency infoSupport for concurrent manipulation of datayesyesyes
Durability infoSupport for making data persistentyes infoby using IndexedDB, SQL.JS or proprietary FileStorageyesyes infousing a tiered cache-storage approachyes infoSerialization of a DB in a Node.JS/Cordova/PhoneGap environment. Usage of the IndexedDB-API in a browser.yes
In-memory capabilities infoIs there an option to define some or all structures to be held in-memory only.yesnoyesyes
User concepts infoAccess controlnoAccess rights for users can be defined per objectnonoAccess rights for users, groups and roles according to SQL-standard
More information provided by the system vendor
AlaSQLCassandraEhcacheLokiJSOceanBase
Specific characteristicsApache Cassandra is the leading NoSQL, distributed database management system, well...
» more
OceanBase Database is the world’s only native distributed database that has set new...
» more
Competitive advantagesNo single point of failure ensures 100% availability . Operational simplicity for...
» more
High Availability : The five IDCs across three sites disaster recovery solution sets...
» more
Typical application scenariosInternet of Things (IOT), fraud detection applications, recommendation engines, product...
» more
Key customersApple, Netflix, Uber, ING,, Intuit,Fidelity, NY Times, Outbrain, BazaarVoice, Best...
» more
OceanBase Database has helped over 400 customers across industries upgrade their...
» more
Market metricsCassandra is used by 40% of the Fortune 100.
» more
TPC-C No.1 Performance , achieved a result of 707.35 million tpmC in the TPC-C benchmark...
» more
Licensing and pricing modelsApache license  Pricing for commercial distributions provided by DataStax and available...
» more
Mulan PubL v2 license for open source community edition. Commercial license for enterprise...
» 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
3rd partiesCData: Connect to Big Data & NoSQL through standard Drivers.
» more

Cassandra Forward event: Want to level up your Cassandra game? Watch now replays of the March 2023 sessions.
» more

We invite representatives of vendors of related products to contact us for presenting information about their offerings here.

More resources
AlaSQLCassandraEhcacheLokiJSOceanBase
DB-Engines blog posts

Cassandra keeps climbing the ranks of the DB-Engines Ranking
3 May 2016, Matthias Gelbmann

Oracle is the DBMS of the Year
5 January 2016, Paul Andlinger, Matthias Gelbmann

Winners, losers and an attractive newcomer in Novembers DB-Engines ranking
2 November 2015, Paul Andlinger

show all

New kids on the block: database management systems implemented in JavaScript
1 December 2014, Matthias Gelbmann

show all

Recent citations in the news

Create a Marvel Database with SQL and Javascript, the easy way
2 July 2019, Towards Data Science

HarperDB - How and Why We Built It From The Ground Up on NodeJS
28 February 2021, hackernoon.com

Multi faceted data exploration in the browser using Leaflet and amCharts
3 May 2020, Towards Data Science

provided by Google News

What Is Cassandra? Working, Features, and Uses - Spiceworks Inc
17 August 2023, Spiceworks News and Insights

Here's What to Know About Apache Cassandra 5.0
15 April 2024, hackernoon.com

How Uber Optimized Cassandra Operations At Scale
20 July 2023, Uber

Microsoft extends life support for aging Apache Cassandra 3.11 database
10 October 2023, The Register

Cassandra is the “best f*cking database for gen AI,” says DataStax CEO
13 December 2023, VentureBeat

provided by Google News

Jira Data Center user? Here's a critical Ehcache vulnerability to spoil your day
22 July 2021, The Register

Atlassian asks customers to patch critical Jira vulnerability
22 July 2021, BleepingComputer

Critical Jira Flaw in Atlassian Could Lead to RCE
22 July 2021, Threatpost

Migration From JBoss 5 to JBoss 7: All It Takes Is 11 Easy Steps
3 June 2021, hackernoon.com

DZone Coding Java JBoss 5 to 7 in 11 steps
9 January 2014, dzone.com

provided by Google News

LokiJS - A JavaScript Database
18 November 2014, iProgrammer

provided by Google News

OceanBase Inks Agreement with NTU Singapore in Database Optimization and Green Computing Advancements
31 January 2024, PR Newswire

Ant Group Will Cut Foreign Investors Out of Fast-Growing Database Business
22 August 2023, The Information

How Southeast Asia's Leading e-Wallets Saved Up to 40% in Database Costs - Fintech Singapore
25 March 2024, Fintech News Singapore

Haidilao’s 6-step recipe for successful digital transformation with OceanBase
4 August 2023, Tech in Asia

Alibaba's OceanBase distributed database aims at markets outside China
16 August 2022, InfoWorld

provided by Google News



Share this page

Featured Products

Milvus logo

Vector database designed for GenAI, fully equipped for enterprise implementation.
Try Managed Milvus for Free

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

Neo4j logo

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

SingleStore logo

Database for your real-time AI and Analytics Apps.
Try it today.

RaimaDB logo

RaimaDB, embedded database for mission-critical applications. When performance, footprint and reliability matters.
Try RaimaDB for free.

Present your product here