DB-EnginesExtremeDB: is hard real time possible with a dbms?English
Deutsch
Knowledge Base of Relational and NoSQL Database Management Systemsprovided by solid IT

DBMS > AlaSQL vs. H2 vs. Rockset vs. SQream DB vs. TerminusDB

System Properties Comparison AlaSQL vs. H2 vs. Rockset vs. SQream DB vs. TerminusDB

Editorial information provided by DB-Engines
NameAlaSQL  Xexclude from comparisonH2  Xexclude from comparisonRockset  Xexclude from comparisonSQream DB  Xexclude from comparisonTerminusDB infoformer name was DataChemist  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 scalable, reliable search and analytics service in the cloud, built on RocksDBa GPU-based, columnar RDBMS for big data analytics workloadsScalable Graph Database platform making enterprise data available by exploiting inferred entities and relationships
Primary database modelDocument store
Relational DBMS
Relational DBMSDocument storeRelational DBMSGraph DBMS
Secondary database modelsSpatial DBMSRelational DBMS
Search engine
Document store
RDF store
DB-Engines Ranking infomeasures the popularity of database management systemsranking trend
Trend Chart
Score0.55
Rank#235  Overall
#37  Document stores
#112  Relational DBMS
Score9.99
Rank#47  Overall
#30  Relational DBMS
Score0.56
Rank#231  Overall
#36  Document stores
Score0.59
Rank#226  Overall
#110  Relational DBMS
Score0.22
Rank#287  Overall
#24  Graph DBMS
Websitealasql.orgwww.h2database.comrockset.comsqream.comterminusdb.com
Technical documentationgithub.com/­agershun/­alasqlwww.h2database.com/­html/­main.htmldocs.rockset.comdocs.sqream.comterminusdb.github.io/­terminusdb/­#
DeveloperAndrey Gershun & Mathias R. WulffThomas MuellerRocksetSQream TechnologiesDataChemist Ltd.
Initial release20142005201920142018
Current release2.1.210, January 20222021.2, September 202110.0.3, September 2021
License infoCommercial or Open SourceOpen Source infoMIT-LicenseOpen Source infodual-licence (Mozilla public license, Eclipse public license)commercialcommercialOpen Source infoGPL V3
Cloud-based only infoOnly available as a cloud servicenonoyesnono
DBaaS offerings (sponsored links) infoDatabase as a Service

Providers of DBaaS offerings, please contact us to be listed.
Implementation languageJavaScriptJavaC++C++, CUDA, Haskell, Java, ScalaProlog, Rust
Server operating systemsserver-less, requires a JavaScript environment (browser, Node.js)All OS with a Java VMhostedLinuxLinux
Data schemeschema-freeyesschema-freeyesyes
Typing infopredefined data types such as float or datenoyesdynamic typingyes, ANSI Standard SQL Typesyes
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.nonono infoingestion from XML files supportedno
Secondary indexesnoyesall fields are automatically indexedyes
SQL infoSupport of SQLClose to SQL99, but no user access control, stored procedures and host language bindings.yesRead-only SQL queries, including JOINsyesSQL-like query language (WOQL)
APIs and other access methodsJavaScript APIJDBC
ODBC
HTTP REST.Net
JDBC
ODBC
OWL
RESTful HTTP API
WOQL (Web Object Query Language)
Supported programming languagesJavaScriptJavaGo
Java
JavaScript (Node.js)
Python
C++
Java
JavaScript (Node.js)
Python
JavaScript
Python
Server-side scripts infoStored proceduresnoJava Stored Procedures and User-Defined Functionsnouser defined functions in Pythonyes
Triggersyesyesnonoyes
Partitioning methods infoMethods for storing different data on different nodesnonenoneAutomatic shardinghorizontal and vertical partitioningGraph Partitioning
Replication methods infoMethods for redundantly storing data on multiple nodesnoneWith clustering: 2 database servers on different computers operate on identical copies of a databaseyesnoneJournaling Streams
MapReduce infoOffers an API for user-defined Map/Reduce methodsnonononono
Consistency concepts infoMethods to ensure consistency in a distributed systemnoneImmediate ConsistencyEventual ConsistencyImmediate Consistency
Foreign keys infoReferential integrityyesyesnonoyes
Transaction concepts infoSupport to ensure data integrity after non-atomic manipulations of datayes infoonly for local storage and DOM-storageACIDnoACIDACID
Concurrency infoSupport for concurrent manipulation of datayes, multi-version concurrency control (MVCC)yesyesyes
Durability infoSupport for making data persistentyes infoby using IndexedDB, SQL.JS or proprietary FileStorageyesyesyesyes infoin-memory journaling
In-memory capabilities infoIs there an option to define some or all structures to be held in-memory only.yesyes
User concepts infoAccess controlnofine grained access rights according to SQL-standardAccess rights for users and organizations can be defined via Rockset consoleRole-based access control
More information provided by the system vendor
AlaSQLH2RocksetSQream DBTerminusDB infoformer name was DataChemist
Specific characteristicsDue to exponentially growing data, organizations today are facing slowdowns, with...
» more
Competitive advantagesMuch faster time to insight Analyze significantly more data Achieve previously unobtainable...
» more
Typical application scenariosWhat can you do with 100x faster SQL analytics? Better and more timely decision making...
» more
Key customersSome of our customers include: LG Uplus, AIS (Advanced Info Service), ACL Mobile,...
» more
News

Trend-Setting Products in Data and Information Management for 2022
4 January 2022

SQream Snaps Up Panoply to Supercharge its Cloud Offerings
19 December 2021

SQream acquires Israel’s Panoply in $60-70 million deal
16 December 2021

SQream acquires no-code data platform Panoply
16 December 2021

SQream acquires no-code data platform Panoply
16 December 2021

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
AlaSQLH2RocksetSQream DBTerminusDB infoformer name was DataChemist
Recent citations in the news

Meet AlaSQL, a speedy SQL database for JavaScript
15 January 2019, JAXenter

provided by Google News

Real-time analytics in 2022: What to expect?
31 December 2021, VentureBeat

The Upcoming Year in Big Data: A 2022 Preview
10 January 2022, Datanami

Did Rockset Just Solve Real-Time Analytics?
25 August 2021, Datanami

Your complete guide to the AWS Startup Showcase, presented by theCUBE
23 January 2022, SiliconANGLE News

Rockset Wins Coveted 2021 Datanami Readers' Choice Award
15 December 2021, GlobeNewswire

provided by Google News

SQream Technologies raises $39.4 million for GPU-accelerated databases
24 June 2020, VentureBeat

Next-Gen Database Company SQream Raises $39.4M In Funding
24 June 2020, CRN: Technology news for channel partners and solution providers

Alibaba Group leads $26.4M Series B in GPU database provider SQream
30 May 2018, TechCrunch

SQream Raises $39.4 Million in Series B+ Financing Round to Accelerate its Deep Tech Product Innovation for the Rapid Analytics of Massive Data Stores
24 June 2020, PRNewswire

Accelerated Databases In The Fast Lane
25 June 2020, The Next Platform

provided by Google News

Job opportunities

Developer
Axle Informatics, Rockville, MD

Applications Developer
Axle Informatics, Rockville, MD

Risk Analyst
Fast AF, Remote

Developer Advocate
rockset, San Mateo, CA

UX Designer
rockset, San Mateo, CA

Product Manager- New MBA Grad
rockset, Remote

Account Executive
rockset, Remote

jobs by Indeed



Share this page

Featured Products

MariaDB logo

SkySQL, the ultimate
MariaDB cloud, is here.

Get started with SkySQL today!

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.

Couchbase logo

The modern database for enterprise applications. Build fast. Scale Big. Save more.
Get started today.

Neo4j logo

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

Present your product here