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 > ArcadeDB vs. jBASE vs. Microsoft Azure Synapse Analytics vs. Teradata Aster

System Properties Comparison ArcadeDB vs. jBASE vs. Microsoft Azure Synapse Analytics vs. Teradata Aster

Please select another system to include it in the comparison.

Editorial information provided by DB-Engines
NameArcadeDB  Xexclude from comparisonjBASE  Xexclude from comparisonMicrosoft Azure Synapse Analytics infopreviously named Azure SQL Data Warehouse  Xexclude from comparisonTeradata Aster  Xexclude from comparison
Teradata Aster has been integrated into other Teradata systems and therefore will be removed from the DB-Engines ranking.
DescriptionFast and scalable multi-model DBMS, originally forked from OrientDB but most of the code has been rewrittenA robust multi-value DBMS comprising development tools and middlewareElastic, large scale data warehouse service leveraging the broad eco-system of SQL ServerPlatform for big data analytics on multistructured data sources and types
Primary database modelDocument store
Graph DBMS
Key-value store
Time Series DBMS infoin next version
Multivalue DBMSRelational DBMSRelational DBMS
DB-Engines Ranking infomeasures the popularity of database management systemsranking trend
Trend Chart
Score0.06
Rank#316  Overall
#40  Document stores
#31  Graph DBMS
#48  Key-value stores
#28  Time Series DBMS
Score1.62
Rank#136  Overall
#3  Multivalue DBMS
Score18.49
Rank#38  Overall
#23  Relational DBMS
Websitearcadedb.comwww.jbase.comazure.microsoft.com/­services/­synapse-analytics
Technical documentationdocs.arcadedb.comdocs.zumasys.com/­jbasedocs.microsoft.com/­azure/­synapse-analytics
DeveloperArcade DataZumasysMicrosoftTeradata
Initial release2021199120162005
Current releaseSeptember 20215.7
License infoCommercial or Open SourceOpen Source infoApache Version 2.0commercialcommercialcommercial
Cloud-based only infoOnly available as a cloud servicenonoyesno
DBaaS offerings (sponsored links) infoDatabase as a Service

Providers of DBaaS offerings, please contact us to be listed.
Implementation languageJavaC++
Server operating systemsAll OS with a Java VMAIX
Linux
Windows
hostedLinux
Data schemeschema-freeschema-freeyesFlexible Schema (defined schema, partial schema, schema free) infodefined schema within the relational store; partial schema or schema free in the Aster File Store
Typing infopredefined data types such as float or dateyesoptionalyesyes
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.noyesnoyes infoin Aster File Store
Secondary indexesyesyesyes
SQL infoSupport of SQLSQL-like query language, no joinsEmbedded SQL for jBASE in BASICyesyes
APIs and other access methodsJDBC
MongoDB API
OpenCypher
PostgreSQL wire protocol
Redis API
RESTful HTTP/JSON API
TinkerPop Gremlin
JDBC
ODBC
Proprietary protocol
RESTful HTTP API
SOAP-based API
ADO.NET
JDBC
ODBC
ADO.NET
JDBC
ODBC
OLE DB
Supported programming languagesJava.Net
Basic
Jabbascript
Java
C#
Java
PHP
C
C#
C++
Java
Python
R
Server-side scripts infoStored proceduresyesTransact SQLR packages
Triggersyesnono
Partitioning methods infoMethods for storing different data on different nodesShardingSharding, horizontal partitioningSharding
Replication methods infoMethods for redundantly storing data on multiple nodesSource-replica replicationyesyesyes infoDimension tables are replicated across all nodes in the cluster. The number of replicas for the file store can be configured.
MapReduce infoOffers an API for user-defined Map/Reduce methodsnononoyes infoSQL Map-Reduce Framework
Consistency concepts infoMethods to ensure consistency in a distributed systemImmediate ConsistencyImmediate ConsistencyImmediate Consistency or Eventual Consistency depending on configuration
Foreign keys infoReferential integrityyes inforelationship in graphsnono infodocs.microsoft.com/­en-us/­azure/­synapse-analytics/­sql-data-warehouse/­sql-data-warehouse-table-constraintsno
Transaction concepts infoSupport to ensure data integrity after non-atomic manipulations of dataACIDACIDACIDACID
Concurrency infoSupport for concurrent manipulation of datayesyesyesyes
Durability infoSupport for making data persistentyesyesyesyes
In-memory capabilities infoIs there an option to define some or all structures to be held in-memory only.yesno
User concepts infoAccess controlAccess rights can be defined down to the item levelyesfine 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
ArcadeDBjBASEMicrosoft Azure Synapse Analytics infopreviously named Azure SQL Data WarehouseTeradata Aster
Recent citations in the news

Zumasys Acquires jBASE Database
5 January 2015, Business Wire

Zumasys, Inc
5 March 2019, International Spectrum Magazine

provided by Google News

Doing supply chain differently: strategies to support production
28 January 2022, Technology Record

Building resiliency and spurring innovation: customers are using the Microsoft Cloud to advance industries and keep business moving forward - The Official Microsoft Blog
24 January 2022, Microsoft

SAS Viya is living large on Azure
24 January 2022, ZDNet

Why Microsoft's product volatility creates security risk in Azure
26 January 2022, SC Media

Data platform modernization delivering richer insights and powering dynamic digital experiences for TD customers
26 January 2022, Yahoo Canada Finance

provided by Google News

An overview of the Teradata Aster Analytics platform
31 May 2017, TechTarget

Big Data Analytics: Teradata Launches Aster Discovery Platform
9 October 2013, Data Center Knowledge

How to Select the Right Database for Time-Series Data – The New Stack
2 December 2021, thenewstack.io

Teradata puts Aster on Hadoop, adds 'Listener' For IoT
21 October 2015, ZDNet

Teradata Aster gets graph database, HDFS-compatible file store
8 October 2013, ZDNet

provided by Google News

Job opportunities

Support Escalation Engineer - Azure Synapse
Microsoft, Charlotte, NC

Support Engineer - Azure Synapse
Microsoft, Issaquah, WA

Azure Synapse Analyst
NR Consulting LLC, Dallas, TX

BSA - Azure
Capgemini, Seattle, WA

Azure Analyst
SolTech Inc., United States

Analyst, Navigation & Digital Taxonomy - Remote
Lowe's, Mooresville, NC

Senior Risk Analyst, Operations
Podium Infotech, Lehi, UT

Lead-Risk Management
Verizon, Basking Ridge, NJ

Data Scientists – Machine Learning
Brielle Technologies, Alpharetta, GA

Sr Analyst, DACI Analytics - Loyalty Analytics
Lowe's, Charlotte, NC

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.

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!

Couchbase logo

The modern database for enterprise applications. Build fast. Scale Big. Save more.
Get started 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