DB-EnginesExtremeDB: the first and only COTS deterministic embedded database management system for mission- and safety-critical hard real-time applicationsEnglish
Deutsch
Knowledge Base of Relational and NoSQL Database Management Systemsprovided by solid IT

DBMS > AllegroGraph vs. Couchbase vs. Datastax Enterprise vs. MySQL vs. Trafodion

System Properties Comparison AllegroGraph vs. Couchbase vs. Datastax Enterprise vs. MySQL vs. Trafodion

Editorial information provided by DB-Engines
NameAllegroGraph  Xexclude from comparisonCouchbase infoOriginally called Membase  Xexclude from comparisonDatastax Enterprise  Xexclude from comparisonMySQL  Xexclude from comparisonTrafodion  Xexclude from comparison
DescriptionHigh performance, persistent RDF store with additional support for Graph DBMSJSON-based document store derived from CouchDB with a Memcached-compatible interfaceDataStax Enterprise (DSE) is the always-on, scalable data platform built on Apache Cassandra and designed for hybrid Cloud. DSE integrates graph, search, analytics, administration, developer tooling, and monitoring into a unified platform.Widely used open source RDBMSTransactional SQL-on-Hadoop DBMS
Primary database modelDocument store infowith version 6.5
Graph DBMS
RDF store
Document storeWide column storeRelational DBMS infoKey/Value like access via memcached APIRelational DBMS
Secondary database modelsSpatial DBMSKey-value store infooriginating from the former Membase product and supporting the Memcached protocol
Spatial DBMS infousing the Geocouch extension
Document store
Graph DBMS
Spatial DBMS
Search engine
Document store
Spatial DBMS
DB-Engines Ranking infomeasures the popularity of database management systemsranking trend
Trend Chart
Score1.23
Rank#159  Overall
#28  Document stores
#14  Graph DBMS
#7  RDF stores
Score29.87
Rank#28  Overall
#4  Document stores
Score9.70
Rank#49  Overall
#4  Wide column stores
Score1211.52
Rank#2  Overall
#2  Relational DBMS
Score0.46
Rank#243  Overall
#116  Relational DBMS
Websiteallegrograph.comwww.couchbase.comwww.datastax.com/­products/­datastax-enterprisewww.mysql.comtrafodion.apache.org
Technical documentationfranz.com/­agraph/­support/­documentation/­current/­agraph-introduction.htmldocs.couchbase.comdocs.datastax.comdev.mysql.com/­doctrafodion.apache.org
DeveloperFranz Inc.Couchbase, Inc.DataStaxOracle infosince 2010, originally MySQL AB, then SunApache Software Foundation, originally developed by HP
Initial release20042011201119952014
Current release7.2, October 2021Server: 6.5, January 2020; Mobile: 2.7, January 2020; Couchbase Autonomous Operator: 1.2, May 20196.8, April 20208.0.27, October 20212.3.0, February 2019
License infoCommercial or Open Sourcecommercial infoLimited community edition freeOpen Source infoApache version 2; Commercial licenses also availablecommercialOpen Source infoGPL version 2. Commercial licenses with extended functionallity are availableOpen 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.
Couchbase Cloud: Deploy, manage, and operate Couchbase in a few clicksScaleGrid for MySQL: Fully managed MySQL hosting on AWS, Azure and DigitalOcean with high availability and SSH access on the #1 multi-cloud DBaaS.
Implementation languageC, C++, Go and ErlangJavaC and C++C++, Java
Server operating systemsLinux
OS X
Windows
Linux
OS X
Windows
Linux
OS X
FreeBSD
Linux
OS X
Solaris
Windows
Linux
Data schemeyes infoRDF schemasschema-freeschema-freeyesyes
Typing infopredefined data types such as float or dateyesyes infoString, Boolean, Numberyesyesyes
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.no infobulk load of XML files possiblenoyesno
Secondary indexesyesyesyesyesyes
SQL infoSupport of SQLSPARQL is used as query languageDeclarative query language (N1QL) that extends ANSI SQL to JSON. First commercial implementation of SQL++.SQL-like DML and DDL statements (CQL); Spark SQLyes infowith proprietary extensionsyes
APIs and other access methodsRESTful HTTP API
SPARQL
Native language bindings for CRUD, Query, Search and Analytics APIsProprietary protocol infoCQL (Cassandra Query Language)
TinkerPop Gremlin infowith DSE Graph
ADO.NET
JDBC
ODBC
Proprietary native API
ADO.NET
JDBC
ODBC
Supported programming languagesC#
Clojure
Java
Lisp
Perl
Python
Ruby
Scala
.Net
C
Clojure
ColdFusion
Erlang
Go
Java
JavaScript infoNode.js
Perl
PHP
Python
Ruby
Scala
Tcl
C
C#
C++
Java
JavaScript (Node.js)
PHP
Python
Ruby
Ada
C
C#
C++
D
Delphi
Eiffel
Erlang
Haskell
Java
JavaScript (Node.js)
Objective-C
OCaml
Perl
PHP
Python
Ruby
Scheme
Tcl
All languages supporting JDBC/ODBC/ADO.Net
Server-side scripts infoStored proceduresyes infoJavaScript or Common LispFunctions and timers in JavaScriptnoyes infoproprietary syntaxJava Stored Procedures
Triggersyesyes infovia the TAP protocolyesyesno
Partitioning methods infoMethods for storing different data on different nodeswith FederationShardingSharding infono "single point of failure"horizontal partitioning, sharding with MySQL Cluster or MySQL FabricSharding
Replication methods infoMethods for redundantly storing data on multiple nodesMulti-source replication
Source-replica replication
Multi-source replication infoincluding cross data center replication
Source-replica replication
configurable replication factor, datacenter aware, advanced replication for edge computingMulti-source replication
Source-replica replication
yes, via HBase
MapReduce infoOffers an API for user-defined Map/Reduce methodsnoyesyesnoyes infovia user defined functions and HBase
Consistency concepts infoMethods to ensure consistency in a distributed systemImmediate Consistency or Eventual Consistency depending on configurationEventual Consistency
Immediate Consistency infoselectable on a per-operation basis
Immediate Consistency
Tunable Consistency infoconsistency level can be individually decided with each write operation
Immediate ConsistencyImmediate Consistency
Foreign keys infoReferential integritynononoyes infonot for MyISAM storage engineyes
Transaction concepts infoSupport to ensure data integrity after non-atomic manipulations of dataACIDACIDno infoAtomicity and isolation are supported for single operationsACID infonot for MyISAM storage engineACID
Concurrency infoSupport for concurrent manipulation of datayesyesyesyes infotable locks or row locks depending on storage engineyes
Durability infoSupport for making data persistentyesyesyesyesyes
In-memory capabilities infoIs there an option to define some or all structures to be held in-memory only.noyes infoEphemeral bucketsyesyesno
User concepts infoAccess controlUsers with fine-grained authorization concept, user roles and pluggable authenticationUser and Administrator separation with password-based and LDAP integrated AuthenticationAccess rights for users can be defined per objectUsers with fine-grained authorization concept infono user groups or rolesfine grained access rights according to SQL-standard
More information provided by the system vendor
AllegroGraphCouchbase infoOriginally called MembaseDatastax EnterpriseMySQLTrafodion
Specific characteristicsKnowledge Graph Platform Leader FedShard - Designed for Entity-Event Knowledge Graph...
» more
Developed as an alternative to traditionally inflexible relational databases, Couchbase...
» more
DataStax Enterprise is scale-out data infrastructure for enterprises that need to...
» more
Competitive advantagesAllegroGraph is uniquely suited to support adhoc queries through SPARQL, Prolog and...
» more
Couchbase was architected with several differentiated capabilities: Shared-nothing,...
» more
Supporting the following application requirements: Zero downtime - Built on Apache...
» more
Typical application scenariosCustomer 360 for user profile, session store and data aggregation (Comcast, Equifax,...
» more
Applications that must be massively and linearly scalable with 100% uptime and able...
» more
Key customersAmadeus, AT&T, BD (Becton, Dickinson and Company), Carrefour, Cisco, Comcast, Disney,...
» more
Capital One, Cisco, Comcast, eBay, McDonald's, Microsoft, Safeway, Sony, UBS, and...
» more
Market metricsNamed a leader in the Forrester Wave™: Big Data NoSQL, Q1 2019 Over 10M downloads...
» more
Among the Forbes 100 Most Innovative Companies, DataStax is trusted by 5 of the top...
» more
Licensing and pricing modelsThe Community Edition (CE) of Couchbase Server and Couchbase Mobile are available...
» more
Annual subscription
» more
News

Franz’s AllegroGraph Name “Best Knowledge Graph” by KMWorld Readers’ Choice
8 November 2021

AllegroGraph v7.2 – Now Available (GNN, Virtual Graphs, Spark, and Kafka)
25 October 2021

Fuse Graph Neural Networks with Semantic Reasoning to Produce Complimentary Predictions
25 September 2021

Essilor’s Knowledge Graph for Global Supply Chain Risk Management
14 September 2021

No-Code Queries Can Accelerate AI and Data Analytics
1 September 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
3rd partiesCData: Connect to Big Data & NoSQL through standard Drivers.
» more
ClusterControl: the only management system you’ll ever need to take control of your open source database infrastructure.
» more

CData: Connect to Big Data & NoSQL through standard Drivers.
» more

Navicat for MySQL is the ideal solution for MySQL/MariaDB administration and development.
» more

SQLFlow: Provides a visual representation of the overall flow of data. Automated SQL data lineage analysis across Databases, ETL, Business Intelligence, Cloud and Hadoop environments by parsing SQL Script and stored procedure.
» more

Fivetran: Quickly and easily centralize your on-premise and cloud databases.
» more

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

More resources
AllegroGraphCouchbase infoOriginally called MembaseDatastax EnterpriseMySQLTrafodion
DB-Engines blog posts

Couchbase climbs up the DB-Engines Ranking, increasing its popularity by 10% every month
2 June 2014, Matthias Gelbmann

show all

MySQL is the DBMS of the Year 2019
3 January 2020, Matthias Gelbmann, Paul Andlinger

MariaDB strengthens its position in the open source RDBMS market
5 April 2018, Matthias Gelbmann

The struggle for the hegemony in Oracle's database empire
2 May 2017, Paul Andlinger

show all

Recent citations in the news

Knowledge graph insights from KMWorld Connect 2021
24 November 2021, KMWorld Magazine

Franz’s AllegroGraph Name “Best Knowledge Graph” by KMWorld Readers’ Choice
9 November 2021, EIN News

AiThority Interview with Dr. Jans Aasman, CEO at Franz
1 July 2021, AiThority

Verint Speakers Explore How AI and Digital-First Engagement are Driving Innovation in the Contact Center
1 November 2021, Business Wire

2022 Trends in Artificial Intelligence and Machine Learning: Reasoning Meets Learning
5 November 2021, insideBIGDATA

provided by Google News

Couchbase Introduces Hosted Database On AWS
15 November 2021, iProgrammer

Couchbase Offers New Hosted Database-As-A-Service Option On AWS
29 October 2021, CRN

How Does Couchbase Inc (BASE) Stock Rank on Wall Street Wednesday?
24 November 2021, InvestorsObserver

Stocks Showing Improving Market Leadership: Couchbase Inc Earns 83 RS Rating
29 October 2021, Investor's Business Daily

Pembroke Management, LTD Buys
8 November 2021, GuruFocus.com

provided by Google News

DataStax Further Expands in Asia-Pacific with New Office and General Manager in China
3 November 2021, Business Wire

New gRPC API for Apache Cassandra Boosts Performance for Multi-Cloud, Microservices Applications
16 November 2021, Business Wire

DataStax Shows Strong Momentum with New Customers, Partners and Products
26 May 2021, Business Wire

DataStax Collaborates With IBM to Help Enterprises Accelerate Modern, Multi-Cloud Data Applications
23 March 2021, Business Wire

DataStax Q2 Marked by Strong Growth with Leading Enterprises Including Barracuda Networks and Priceline
31 August 2021, Business Wire

provided by Google News

PlanetScale Scalable Serverless MySQL Database Now Generally Available
23 November 2021, Database Trends and Applications

How to install MySQL 8.0 Server on Debian 11 Bullseye
26 November 2021, H2S Media

Microsoft Announces the General Availability of Azure Database for MySQL - Flexible Server
5 November 2021, InfoQ.com

PlanetScale Introduces Managed Cloud to Scale MySQL Databases
11 November 2021, InfoQ.com

MySQL Database Compare Tools Overview: ApexSQL Data Diff vs dbForge Data Compare
8 November 2021, JAXenter

provided by Google News

Apache Trafodion becomes Top-Level Project
10 January 2018, SDTimes.com

The Apache® Software Foundation Announces Annual Report for
31 August 2021, GlobeNewswire

provided by Google News

Job opportunities

Modeling and Simulation / MBSE Systems Engineer
The GBS Group, Philadelphia, PA

Data Scientist with Java & Python Exp
The GBS Group, Philadelphia, PA

Sales Engineer/Senior Sales Engineer (West)
TigerGraph, Washington State

Senior Manager - Total Rewards
Couchbase, Remote

Sales Development Representative - Enterprise Software
Couchbase, Austin, TX

Enterprise Sales Rep - Florida
Couchbase, Miami, FL

Director, Product Documentation
Couchbase, Santa Clara, CA

Corporate Account Executive
Couchbase, Austin, TX

Datastax Engineer
M&T Bank, Buffalo, NY

Astra Enterprise Success Leader (Remote US)
DataStax, San Francisco Bay Area, CA

Marketing Operations (Remote US)
DataStax, San Francisco Bay Area, CA

Federal Account Executive
DataStax, Washington, DC

Customer Success Manager (Remote US)
DataStax, San Francisco Bay Area, CA

Executive Assistant
MindsDB, San Francisco, CA

SQL Server\MySQL Integration Developer - Fully Remote
MarketTime, Remote

MYSQL Database Developer
Exemplar ITS, Philadelphia, PA

MySQL DB Developer
Telus International, Remote

48338
Zachary Piper Solutions LLC, 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.

Couchbase logo

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

AllegroGraph logo

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

MariaDB logo

SkySQL, the ultimate
MariaDB cloud, is here.

Get started with SkySQL today!

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