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 > Alibaba Cloud Table Store vs. EsgynDB vs. Microsoft Azure Synapse Analytics vs. Oracle NoSQL vs. Weaviate

System Properties Comparison Alibaba Cloud Table Store vs. EsgynDB vs. Microsoft Azure Synapse Analytics vs. Oracle NoSQL vs. Weaviate

Editorial information provided by DB-Engines
NameAlibaba Cloud Table Store  Xexclude from comparisonEsgynDB  Xexclude from comparisonMicrosoft Azure Synapse Analytics infopreviously named Azure SQL Data Warehouse  Xexclude from comparisonOracle NoSQL  Xexclude from comparisonWeaviate  Xexclude from comparison
DescriptionA fully managed Wide Column Store for large quantities of semi-structured data with real-time accessEnterprise-class SQL-on-Hadoop solution, powered by Apache TrafodionElastic, large scale data warehouse service leveraging the broad eco-system of SQL ServerA multi-model, scalable, distributed NoSQL database, designed to provide highly reliable, flexible, and available data management across a configurable set of storage nodesAn AI-native realtime vector database engine that integrates scalable machine learning models.
Primary database modelWide column storeRelational DBMSRelational DBMSDocument store
Key-value store
Relational DBMS
Vector DBMS
DB-Engines Ranking infomeasures the popularity of database management systemsranking trend
Trend Chart
Score0.31
Rank#297  Overall
#11  Wide column stores
Score0.25
Rank#312  Overall
#138  Relational DBMS
Score19.93
Rank#31  Overall
#19  Relational DBMS
Score3.05
Rank#97  Overall
#17  Document stores
#16  Key-value stores
#50  Relational DBMS
Score1.52
Rank#153  Overall
#6  Vector DBMS
Websitewww.alibabacloud.com/­product/­table-storewww.esgyn.cnazure.microsoft.com/­services/­synapse-analyticswww.oracle.com/­database/­nosql/­technologies/­nosqlgithub.com/­weaviate/­weaviate
weaviate.io
Technical documentationwww.alibabacloud.com/­help/­en/­tablestoredocs.microsoft.com/­azure/­synapse-analyticsdocs.oracle.com/­en/­database/­other-databases/­nosql-database/­index.htmlweaviate.io/­developers/­weaviate
DeveloperAlibabaEsgynMicrosoftOracleWeaviate B.V.
Initial release20162015201620112019
Current release24.1, May 20241.19, May 2023
License infoCommercial or Open SourcecommercialcommercialcommercialOpen Source infoProprietary for Enterprise Edition (Oracle Database EE license has Oracle NoSQL database EE covered: details)Open Source infocommercial license available with Weaviate Enterprise
Cloud-based only infoOnly available as a cloud serviceyesnoyesnono
DBaaS offerings (sponsored links) infoDatabase as a Service

Providers of DBaaS offerings, please contact us to be listed.
Implementation languageC++, JavaC++JavaGo
Server operating systemshostedLinuxhostedLinux
Solaris SPARC/x86
Data schemeschema-freeyesyesSupport Fixed schema and Schema-less deployment with the ability to interoperate between them.yes, maps to GraphQL interface
Typing infopredefined data types such as float or dateyesyesyesoptionalyes infostring, int, float, geo point, date, cross reference, fuzzy references
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.nonononono
Secondary indexesnoyesyesyesyes infoall data objects are indexed in a semantic vector space (the Contextionary), all primitive fields are indexed
SQL infoSupport of SQLnoyesyesSQL-like DML and DDL statementsGraphQL is used as query language
APIs and other access methodsHTTP APIADO.NET
JDBC
ODBC
ADO.NET
JDBC
ODBC
RESTful HTTP APIGraphQL query language
RESTful HTTP/JSON API
Supported programming languagesJava
Python
All languages supporting JDBC/ODBC/ADO.NetC#
Java
PHP
C
C#
Go
Java
JavaScript (Node.js)
Python
JavaScript / TypeScript
Python
Server-side scripts infoStored proceduresnoJava Stored ProceduresTransact SQLnono
Triggersnonononono
Partitioning methods infoMethods for storing different data on different nodesSharding infoImplicit feature of the cloud serviceShardingSharding, horizontal partitioningShardingSharding
Replication methods infoMethods for redundantly storing data on multiple nodesyes infoImplicit feature of the cloud serviceMulti-source replication between multi datacentersyesElectable source-replica replication per shard. Support distributed global deployment with Multi-region table featureyes
MapReduce infoOffers an API for user-defined Map/Reduce methodsnoyesnowith Hadoop integrationno
Consistency concepts infoMethods to ensure consistency in a distributed systemImmediate ConsistencyImmediate ConsistencyImmediate ConsistencyEventual Consistency
Immediate Consistency infodepending on configuration
Eventual Consistency
Foreign keys infoReferential integritynoyesno infodocs.microsoft.com/­en-us/­azure/­synapse-analytics/­sql-data-warehouse/­sql-data-warehouse-table-constraintsnono
Transaction concepts infoSupport to ensure data integrity after non-atomic manipulations of dataAtomic single-row operationsACIDACIDconfigurable infoACID within a storage node (=shard)no
Concurrency infoSupport for concurrent manipulation of datayesyesyesyesyes
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.nonoyes infooff heap cacheyes
User concepts infoAccess controlAccess rights based on subaccounts and tokensfine grained access rights according to SQL-standardyesAccess rights for users and rolesAPI Keys
OpenID Connect Discovery
More information provided by the system vendor
Alibaba Cloud Table StoreEsgynDBMicrosoft Azure Synapse Analytics infopreviously named Azure SQL Data WarehouseOracle NoSQLWeaviate
Specific characteristicsWeaviate is an open source vector database that is robust, scalable, cloud-native,...
» more
Competitive advantagesFlexible deployment - Free, open source or fully-managed cloud vector database service...
» more
Typical application scenariosAs a database supporting the development of generative AI and semantic search applications...
» more
Key customersAll companies that have data. ​
» more
Market metricsAs of mid 2023: Over 2 million open source downloads 3500+ Weaviate Slack community...
» more
Licensing and pricing modelsWeaviate is open-source, and free to use. Weaviate is also available as a fully managed...
» 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

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

More resources
Alibaba Cloud Table StoreEsgynDBMicrosoft Azure Synapse Analytics infopreviously named Azure SQL Data WarehouseOracle NoSQLWeaviate
DB-Engines blog posts

Weaviate, an ANN Database with CRUD support
2 February 2021,  Etienne Dilocker, SeMI Technologies (sponsor) 

show all

Recent citations in the news

Getting Started with Alibaba Cloud
30 May 2024, O'Reilly Media

Apache Software Foundation Announces New Top-Level Project Apache Paimon
16 April 2024, Datanami

Top data analytics tools comparison: Alibaba Cloud, AWS, Azure, Google Cloud, IBM
5 December 2019, Wire19

Gartner’s Magic Quadrant for Cloud Database Management Systems
9 December 2020, CRN

25 Best Cloud Service Providers (Public and Private) in 2024
4 June 2023, CybersecurityNews

provided by Google News

General Available: Azure Synapse Runtime for Apache Spark 3.4 is now GA | Azure updates
8 April 2024, azure.microsoft.com

Azure Synapse Runtime for Apache Spark 3.2 End of Support | Azure updates
22 March 2024, azure.microsoft.com

Azure Synapse Analytics: Everything you need to know about Microsoft's cloud analytics platform
24 September 2023, DataScientest

Migrate Microsoft Azure Synapse Analytics to Amazon Redshift using AWS SCT | Amazon Web Services
18 October 2023, AWS Blog

Azure Synapse vs. Databricks: Data Platform Comparison 2024
26 March 2024, eWeek

provided by Google News

Oracle Beefs Up Its NoSQL Database Offering
31 May 2024, Data Center Knowledge

OpenWorld 2013: Oracle NoSQL Database On the Rise?
13 December 2023, Channel Futures

Blog Theme - Details
21 August 2023, Oracle

We built a geo-distributed, serverless modern app using the Oracle NoSQL Database Cloud Service
18 November 2021, Oracle

Oracle NoSQL database comes to the cloud
2 April 2020, TechTarget

provided by Google News

Build enterprise-ready generative AI solutions with Cohere foundation models in Amazon Bedrock and Weaviate vector ...
24 January 2024, AWS Blog

Weaviate Partners with Snowflake to Bring Secure GenAI to Snowpark Container Services
8 February 2024, Datanami

Weaviate Partners with Snowflake to Bring Secure GenAI to Snowpark Container Services
9 February 2024, AiThority

Foley Represents Cortical Ventures in $50M Series B Round for Weaviate
17 December 2023, Foley & Lardner LLP

Getting Started with Weaviate: A Beginner's Guide to Search with Vector Databases
18 July 2023, Towards Data Science

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.

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