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 > AlaSQL vs. HBase vs. IBM Db2 Event Store vs. Stardog vs. Trafodion

System Properties Comparison AlaSQL vs. HBase vs. IBM Db2 Event Store vs. Stardog vs. Trafodion

Editorial information provided by DB-Engines
NameAlaSQL  Xexclude from comparisonHBase  Xexclude from comparisonIBM Db2 Event Store  Xexclude from comparisonStardog  Xexclude from comparisonTrafodion  Xexclude from comparison
Apache Trafodion has been retired in 2021. Therefore it is excluded from the DB-Engines Ranking.
DescriptionJavaScript DBMS libraryWide-column store based on Apache Hadoop and on concepts of BigTableDistributed Event Store optimized for Internet of Things use casesEnterprise Knowledge Graph platform and graph DBMS with high availability, high performance reasoning, and virtualizationTransactional SQL-on-Hadoop DBMS
Primary database modelDocument store
Relational DBMS
Wide column storeEvent Store
Time Series DBMS
Graph DBMS
RDF store
Relational DBMS
DB-Engines Ranking infomeasures the popularity of database management systemsranking trend
Trend Chart
Score0.53
Rank#258  Overall
#40  Document stores
#119  Relational DBMS
Score31.60
Rank#26  Overall
#2  Wide column stores
Score0.25
Rank#320  Overall
#2  Event Stores
#28  Time Series DBMS
Score2.03
Rank#136  Overall
#12  Graph DBMS
#6  RDF stores
Websitealasql.orghbase.apache.orgwww.ibm.com/­products/­db2-event-storewww.stardog.comtrafodion.apache.org
Technical documentationgithub.com/­AlaSQL/­alasqlhbase.apache.org/­book.htmlwww.ibm.com/­docs/­en/­db2-event-storedocs.stardog.comtrafodion.apache.org/­documentation.html
DeveloperAndrey Gershun & Mathias R. WulffApache Software Foundation infoApache top-level project, originally developed by PowersetIBMStardog-UnionApache Software Foundation, originally developed by HP
Initial release20142008201720102014
Current release2.3.4, January 20212.07.3.0, May 20202.3.0, February 2019
License infoCommercial or Open SourceOpen Source infoMIT-LicenseOpen Source infoApache version 2commercial infofree developer edition availablecommercial info60-day fully-featured trial license; 1-year fully-featured non-commercial use license for academics/studentsOpen Source infoApache 2.0
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.
Implementation languageJavaScriptJavaC and C++JavaC++, Java
Server operating systemsserver-less, requires a JavaScript environment (browser, Node.js)Linux
Unix
Windows infousing Cygwin
Linux infoLinux, macOS, Windows for the developer additionLinux
macOS
Windows
Linux
Data schemeschema-freeschema-free, schema definition possibleyesschema-free and OWL/RDFS-schema supportyes
Typing infopredefined data types such as float or datenooptions to bring your own types, AVROyesyesyes
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.nononono infoImport/export of XML data possibleno
Secondary indexesnononoyes infosupports real-time indexing in full-text and geospatialyes
SQL infoSupport of SQLClose to SQL99, but no user access control, stored procedures and host language bindings.noyes infothrough the embedded Spark runtimeYes, compatible with all major SQL variants through dedicated BI/SQL Serveryes
APIs and other access methodsJavaScript APIJava API
RESTful HTTP API
Thrift
ADO.NET
DB2 Connect
JDBC
ODBC
RESTful HTTP API
GraphQL query language
HTTP API
Jena RDF API
OWL
RDF4J API
Sesame REST HTTP Protocol
SNARL
SPARQL
Spring Data
Stardog Studio
TinkerPop 3
ADO.NET
JDBC
ODBC
Supported programming languagesJavaScriptC
C#
C++
Groovy
Java
PHP
Python
Scala
C
C#
C++
Cobol
Delphi
Fortran
Go
Java
JavaScript (Node.js)
Perl
PHP
Python
R
Ruby
Scala
Visual Basic
.Net
Clojure
Groovy
Java
JavaScript
Python
Ruby
All languages supporting JDBC/ODBC/ADO.Net
Server-side scripts infoStored proceduresnoyes infoCoprocessors in Javayesuser defined functions and aggregates, HTTP Server extensions in JavaJava Stored Procedures
Triggersyesyesnoyes infovia event handlersno
Partitioning methods infoMethods for storing different data on different nodesnoneShardingShardingnoneSharding
Replication methods infoMethods for redundantly storing data on multiple nodesnoneMulti-source replication
Source-replica replication
Active-active shard replicationMulti-source replication in HA-Clusteryes, via HBase
MapReduce infoOffers an API for user-defined Map/Reduce methodsnoyesnonoyes infovia user defined functions and HBase
Consistency concepts infoMethods to ensure consistency in a distributed systemnoneImmediate Consistency or Eventual ConsistencyEventual ConsistencyImmediate Consistency in HA-ClusterImmediate Consistency
Foreign keys infoReferential integrityyesnonoyes inforelationships in graphsyes
Transaction concepts infoSupport to ensure data integrity after non-atomic manipulations of datayes infoonly for local storage and DOM-storageSingle row ACID (across millions of columns)noACIDACID
Concurrency infoSupport for concurrent manipulation of datayesNo - written data is immutableyesyes
Durability infoSupport for making data persistentyes infoby using IndexedDB, SQL.JS or proprietary FileStorageyesYes - Synchronous writes to local disk combined with replication and asynchronous writes in parquet format to permanent shared storageyesyes
In-memory capabilities infoIs there an option to define some or all structures to be held in-memory only.yesyesyesyesno
User concepts infoAccess controlnoAccess Control Lists (ACL) for RBAC, integration with Apache Ranger for RBAC & ABACfine grained access rights according to SQL-standardAccess rights for users and rolesfine 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
AlaSQLHBaseIBM Db2 Event StoreStardogTrafodion
DB-Engines blog posts

Cloudera's HBase PaaS offering now supports Complex Transactions
11 August 2021,  Krishna Maheshwari (sponsor) 

Why is Hadoop not listed in the DB-Engines Ranking?
13 May 2013, Paul Andlinger

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

Best Practices from Rackspace for Modernizing a Legacy HBase/Solr Architecture Using AWS Services | Amazon Web ...
9 October 2023, AWS Blog

Newest trends at the 2024 HBASE Home Show
15 February 2024, KELOLAND.com

Less Components, Higher Performance: Apache Doris instead of ClickHouse, MySQL, Presto, and HBase
20 October 2023, hackernoon.com

Migrate data from Apache HBase to Amazon DynamoDB | Amazon Web Services
23 May 2023, AWS Blog

HBase: The database big data left behind
6 May 2016, InfoWorld

provided by Google News

Capture and Analyze XXL Data Streams with IBM Db2 Event Store 2.0
22 August 2019, IBM

IBM releases Cloud Private for Data
29 May 2018, ZDNet

IBM Builds New Ultra-Fast Platform for Hoovering Up and Analyzing Data from Anywhere
31 May 2018, Data Center Knowledge

Top Milvus Alternatives in 2024
4 October 2023, Slashdot

Best cloud databases of 2022
4 October 2022, ITPro

provided by Google News

HP Throws Trafodion Hat into OLTP Hadoop Ring
14 July 2014, Datanami

Evaluating HTAP Databases for Machine Learning Applications
2 November 2016, KDnuggets

Low-latency, distributed database architectures are critical for emerging fog applications
7 April 2022, Embedded Computing Design

provided by Google News



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

Neo4j logo

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

Milvus logo

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

AllegroGraph logo

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

Ontotext logo

GraphDB allows you to link diverse data, index it for semantic search and enrich it via text analysis to build big knowledge graphs. Get it free.

Present your product here