DBMS > Alibaba Cloud Table Store vs. Hyprcubd vs. jBASE vs. Microsoft Azure Data Explorer

System Properties Comparison Alibaba Cloud Table Store vs. Hyprcubd vs. jBASE vs. Microsoft Azure Data Explorer

Please select another system to include it in the comparison.

Editorial information provided by DB-Engines
Name	Alibaba Cloud Table Store  Xexclude from comparison	Hyprcubd  Xexclude from comparison	jBASE  Xexclude from comparison	Microsoft Azure Data Explorer  Xexclude from comparison
		Hyprcubd seems to be discontinued. Therefore it is excluded from the DB-Engines ranking.
Description	A fully managed Wide Column Store for large quantities of semi-structured data with real-time access	Serverless Time Series DBMS	A robust multi-value DBMS comprising development tools and middleware	Fully managed big data interactive analytics platform
Primary database model	Wide column store	Time Series DBMS	Multivalue DBMS	Relational DBMS column oriented
Secondary database models				Document store If a column is of type dynamic docs.microsoft.com/­en-us/­azure/­kusto/­query/­scalar-data-types/­dynamic then it's possible to add arbitrary JSON documents in this cell Event Store this is the general usage pattern at Microsoft. Billing, Logs, Telemetry events are stored in ADX and the state of an individual entity is defined by the arg_max(timestamps) Spatial DBMS Search engine support for complex search expressions docs.microsoft.com/­en-us/­azure/­kusto/­query/­parseoperator FTS, Geospatial docs.microsoft.com/­en-us/­azure/­kusto/­query/­geo-point-to-geohash-function distributed search -> ADX acts as a distributed search engine Time Series DBMS see docs.microsoft.com/­en-us/­azure/­data-explorer/­time-series-analysis
DB-Engines Ranking measures the popularity of database management systems Trend Chart	Score 0.31 Rank #297   Overall #11   Wide column stores		Score 1.49 Rank #156   Overall #3   Multivalue DBMS	Score 3.80 Rank #81   Overall #43   Relational DBMS
Website	www.alibabacloud.com/­product/­table-store	hyprcubd.com (offline)	www.rocketsoftware.com/­products/­rocket-multivalue-application-development-platform/­rocket-jbase	azure.microsoft.com/­services/­data-explorer
Technical documentation	www.alibabacloud.com/­help/­en/­tablestore		docs.rocketsoftware.com/­bundle?labelkey=jbase_5.9	docs.microsoft.com/­en-us/­azure/­data-explorer
Developer	Alibaba	Hyprcubd, Inc.	Rocket Software (formerly Zumasys)	Microsoft
Initial release	2016		1991	2019
Current release			5.7	cloud service with continuous releases
License Commercial or Open Source	commercial	commercial	commercial	commercial
Cloud-based only Only available as a cloud service	yes	yes	no	yes
DBaaS offerings (sponsored links) Database as a Service Providers of DBaaS offerings, please contact us to be listed.
Implementation language		Go
Server operating systems	hosted	hosted	AIX Linux Windows	hosted
Data scheme	schema-free	yes	schema-free	Fixed schema with schema-less datatypes (dynamic)
Typing predefined data types such as float or date	yes	yes time, int, uint, float, string	optional	yes bool, datetime, dynamic, guid, int, long, real, string, timespan, double: docs.microsoft.com/­en-us/­azure/­kusto/­query/­scalar-data-types
XML support Some form of processing data in XML format, e.g. support for XML data structures, and/or support for XPath, XQuery or XSLT.	no	no	yes	yes
Secondary indexes	no	no		all fields are automatically indexed
SQL Support of SQL	no	SQL-like query language	Embedded SQL for jBASE in BASIC	Kusto Query Language (KQL), SQL subset
APIs and other access methods	HTTP API	gRPC (https)	JDBC ODBC Proprietary protocol RESTful HTTP API SOAP-based API	Microsoft SQL Server communication protocol (MS-TDS) RESTful HTTP API
Supported programming languages	Java Python		.Net Basic Jabbascript Java	.Net Go Java JavaScript (Node.js) PowerShell Python R
Server-side scripts Stored procedures	no	no	yes	Yes, possible languages: KQL, Python, R
Triggers	no	no	yes	yes see docs.microsoft.com/­en-us/­azure/­kusto/­management/­updatepolicy
Partitioning methods Methods for storing different data on different nodes	Sharding Implicit feature of the cloud service		Sharding	Sharding Implicit feature of the cloud service
Replication methods Methods for redundantly storing data on multiple nodes	yes Implicit feature of the cloud service		yes	yes Implicit feature of the cloud service. Replication either local, cross-facility or geo-redundant.
MapReduce Offers an API for user-defined Map/Reduce methods	no	no	no	Spark connector (open source): github.com/­Azure/­azure-kusto-spark
Consistency concepts Methods to ensure consistency in a distributed system	Immediate Consistency	Eventual Consistency		Eventual Consistency Immediate Consistency
Foreign keys Referential integrity	no	no	no	no
Transaction concepts Support to ensure data integrity after non-atomic manipulations of data	Atomic single-row operations	no	ACID	no
Concurrency Support for concurrent manipulation of data	yes	no	yes	yes
Durability Support for making data persistent	yes	yes	yes	yes
In-memory capabilities Is there an option to define some or all structures to be held in-memory only.	no	no	yes	no
User concepts Access control	Access rights based on subaccounts and tokens	token access	Access rights can be defined down to the item level	Azure Active Directory Authentication
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
	Alibaba Cloud Table Store	Hyprcubd	jBASE	Microsoft Azure Data Explorer
Recent citations in the news	Apache Software Foundation Announces New Top-Level Project Apache® Paimon 16 April 2024, GlobeNewswire Gartner’s Magic Quadrant for Cloud Database Management Systems 9 December 2020, CRN Top data analytics tools comparison: Alibaba Cloud, AWS, Azure, Google Cloud, IBM 5 December 2019, Wire19 Apache Software Foundation Announces New Top-Level Project Apache Paimon 19 April 2024, Datanami provided by Google News			We’re retiring Azure Time Series Insights on 7 July 2024 – transition to Azure Data Explorer | Azure updates 31 May 2024, Microsoft Azure Data Explorer: Log and telemetry analytics benchmark 16 August 2022, Microsoft Controlling costs in Azure Data Explorer using down-sampling and aggregation 11 February 2019, Microsoft Providing modern data transfer and storage service at Microsoft with Microsoft Azure - Inside Track Blog 13 July 2023, Microsoft Individually great, collectively unmatched: Announcing updates to 3 great Azure Data Services 7 February 2019, Microsoft provided by Google News

Share this page