DB-EnginesExtremeDB for everyone with an RTOSEnglish
Deutsch
Knowledge Base of Relational and NoSQL Database Management Systemsprovided by solid IT

DBMS > Axibase vs. MySQL vs. STSdb vs. TerminusDB vs. Vertica

System Properties Comparison Axibase vs. MySQL vs. STSdb vs. TerminusDB vs. Vertica

Editorial information provided by DB-Engines
NameAxibase  Xexclude from comparisonMySQL  Xexclude from comparisonSTSdb  Xexclude from comparisonTerminusDB infoformer name was DataChemist  Xexclude from comparisonVertica infoOpenText™ Vertica™  Xexclude from comparison
DescriptionScalable TimeSeries DBMS based on HBase with integrated rule engine and visualizationWidely used open source RDBMSKey-Value Store with special method for indexing infooptimized for high performance using a special indexing methodScalable Graph Database platform making enterprise data available by exploiting inferred entities and relationshipsCloud or off-cloud analytical database and query engine for structured and semi-structured streaming and batch data. Machine learning platform with built-in algorithms, data preparation capabilities, and model evaluation and management via SQL or Python.
Primary database modelTime Series DBMSRelational DBMS infoKey/Value like access via memcached APIKey-value storeGraph DBMSRelational DBMS infoColumn oriented
Secondary database modelsDocument store
Spatial DBMS
Document store
RDF store
Spatial DBMS
Time Series DBMS
DB-Engines Ranking infomeasures the popularity of database management systemsranking trend
Trend Chart
Score0.29
Rank#292  Overall
#25  Time Series DBMS
Score1083.74
Rank#2  Overall
#2  Relational DBMS
Score0.04
Rank#360  Overall
#52  Key-value stores
Score0.17
Rank#325  Overall
#29  Graph DBMS
Score10.68
Rank#43  Overall
#27  Relational DBMS
Websiteaxibase.com/­docs/­atsd/­financewww.mysql.comgithub.com/­STSSoft/­STSdb4terminusdb.comwww.vertica.com
Technical documentationdev.mysql.com/­docterminusdb.github.io/­terminusdb/­#vertica.com/­documentation
DeveloperAxibase CorporationOracle infosince 2010, originally MySQL AB, then SunSTS Soft SCDataChemist Ltd.OpenText infopreviously Micro Focus and Hewlett Packard
Initial release20131995201120182005
Current release155858.4.0, April 20244.0.8, September 201511.0.0, January 202312.0.3, January 2023
License infoCommercial or Open Sourcecommercial infoCommunity Edition (single node) is free, Enterprise Edition (distributed) is paidOpen Source infoGPL version 2. Commercial licenses with extended functionallity are availableOpen Source infoGPLv2, commercial license availableOpen Source infoGPL V3commercial infoLimited community edition free
Cloud-based only infoOnly available as a cloud servicenonononono infoon-premises, all major clouds - Amazon AWS, Microsoft Azure, Google Cloud Platform and containers
DBaaS offerings (sponsored links) infoDatabase as a Service

Providers of DBaaS offerings, please contact us to be listed.
Aiven for MySQL: Fully managed MySQL, deployable in the cloud of your choice, with seamless integrations and lightning-fast setup.
Implementation languageJavaC and C++C#Prolog, RustC++
Server operating systemsLinuxFreeBSD
Linux
OS X
Solaris
Windows
WindowsLinuxLinux
Data schemeyesyesyesyesYes, but also semi-structure/unstructured data storage, and complex hierarchical data (like Parquet) stored and/or queried.
Typing infopredefined data types such as float or dateyes infoshort, integer, long, float, double, decimal, stringyesyes infoprimitive types and user defined types (classes)yesyes
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.noyesnono
Secondary indexesnoyesnoNo Indexes Required. Different internal optimization strategy, but same functionality included.
SQL infoSupport of SQLSQL-like query languageyes infowith proprietary extensionsnoSQL-like query language (WOQL)Full 1999 standard plus machine learning, time series and geospatial. Over 650 functions.
APIs and other access methodsJDBC
Proprietary protocol (Network API)
RESTful HTTP API
ADO.NET
JDBC
ODBC
Proprietary native API
.NET Client APIOWL
RESTful HTTP API
WOQL (Web Object Query Language)
ADO.NET
JDBC
Kafka Connector
ODBC
RESTful HTTP API
Spark Connector
vSQL infocharacter-based, interactive, front-end utility
Supported programming languagesGo
Java
PHP
Python
R
Ruby
Ada
C
C#
C++
D
Delphi
Eiffel
Erlang
Haskell
Java
JavaScript (Node.js)
Objective-C
OCaml
Perl
PHP
Python
Ruby
Scheme
Tcl
C#
Java
JavaScript
Python
C#
C++
Go
Java
JavaScript (Node.js)
Perl
PHP
Python
R
Server-side scripts infoStored proceduresyesyes infoproprietary syntaxnoyesyes, PostgreSQL PL/pgSQL, with minor differences
Triggersyesyesnoyesyes, called Custom Alerts
Partitioning methods infoMethods for storing different data on different nodesShardinghorizontal partitioning, sharding with MySQL Cluster or MySQL FabricnoneGraph Partitioninghorizontal partitioning, hierarchical partitioning
Replication methods infoMethods for redundantly storing data on multiple nodesSource-replica replicationMulti-source replication
Source-replica replication
noneJournaling StreamsMulti-source replication infoOne, or more copies of data replicated across nodes, or object-store used for repository.
MapReduce infoOffers an API for user-defined Map/Reduce methodsyesnononono infoBi-directional Spark integration
Consistency concepts infoMethods to ensure consistency in a distributed systemImmediate ConsistencyImmediate Consistency
Foreign keys infoReferential integritynoyes infonot for MyISAM storage enginenoyesyes
Transaction concepts infoSupport to ensure data integrity after non-atomic manipulations of datanoACID infonot for MyISAM storage enginenoACIDACID
Concurrency infoSupport for concurrent manipulation of datayesyes infotable locks or row locks depending on storage engineyesyesyes
Durability infoSupport for making data persistentyesyesyesyes infoin-memory journalingyes
In-memory capabilities infoIs there an option to define some or all structures to be held in-memory only.yesno
User concepts infoAccess controlUsers with fine-grained authorization concept infono user groups or rolesnoRole-based access controlfine grained access rights according to SQL-standard; supports Kerberos, LDAP, Ident and hash
More information provided by the system vendor
AxibaseMySQLSTSdbTerminusDB infoformer name was DataChemistVertica infoOpenText™ Vertica™
Specific characteristicsDeploy-anywhere database for large-scale analytical deployments. Deploy off-cloud,...
» more
Competitive advantagesFast, scalable, and capable of high concurrency. Separation of compute/storage leverages...
» more
Typical application scenariosCommunication and network analytics, Embedded analytics, Fraud monitoring and Risk...
» more
Key customersAbiba Systems, Adform, adMarketplace, AmeriPride, Anritsu, AOL, Avito, Auckland Transport,...
» more
Licensing and pricing modelsCost-based models and subscription-based models are both available. One license is...
» 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 partiesNavicat for MySQL is the ideal solution for MySQL/MariaDB administration and development.
» more

Aiven for MySQL: Fully managed MySQL, deployable in the cloud of your choice, with seamless integrations and lightning-fast setup.
» more

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

Navicat Monitor is a safe, simple and agentless remote server monitoring tool for MySQL and many other database management systems.
» more

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

More resources
AxibaseMySQLSTSdbTerminusDB infoformer name was DataChemistVertica infoOpenText™ Vertica™
DB-Engines blog posts

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

The Ultimate ATV Test: Suzuki's King Quad 750 AXI Rugged Package vs. Alaska's Hunting Season
20 April 2021, Outdoor Life

provided by Google News

Amazon Aurora MySQL version 2 (with MySQL 5.7 compatibility) to version 3 (with MySQL 8.0 compatibility) upgrade ...
18 March 2024, AWS Blog

Enterprise Manager: How Comcast enhanced monitoring for MySQL InnoDB Clusters
22 April 2024, Oracle

Ultimate MySQL Workbench Installation Guide [2024 Edition]
15 February 2024, Simplilearn

Zendesk Moves from DynamoDB to MySQL and S3 to Save over 80% in Costs
29 December 2023, InfoQ.com

How to Create a MySQL 8 Database User With Remote Access
4 January 2024, TechRepublic

provided by Google News

How TerminusDB is commercializing its open source graph database
16 March 2021, VentureBeat

TerminusDB Takes on Data Collaboration with a git-Like Approach
1 December 2020, The New Stack

Dublin-based data collaboration tool TerminusDB raises €3.6 million in seed round
15 March 2021, Tech.eu

[MCR2030-CAMS-ARISE-UNDRR Webinar] Preventing cascading failures of critical assets: Using the Open-Source ...
12 April 2022, United Nations Office for Disaster Risk Reduction

Trinity College spinout TerminusDB secures €3.6m in investment
15 March 2021, The Irish Times

provided by Google News

Stonebraker Seeks to Invert the Computing Paradigm with DBOS
12 March 2024, Datanami

How Embedded Analytics Help ISVs Overcome Challenges
14 September 2023, Spiceworks News and Insights

OpenText expands enterprise portfolio with AI and Micro Focus integrations
25 July 2023, VentureBeat

Postgres pioneer Michael Stonebraker promises to upend the database once more
26 December 2023, The Register

OpenText integrates Micro Focus tech through Cloud Editions 23.3
26 July 2023, Techzine Europe

provided by Google News



Share this page

Featured Products

Neo4j logo

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

AllegroGraph logo

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

RaimaDB logo

RaimaDB, embedded database for mission-critical applications. When performance, footprint and reliability matters.
Try RaimaDB 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

Milvus logo

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

Present your product here