DB-EnginesDo you need a hard real time database?English
Deutsch
Knowledge Base of Relational and NoSQL Database Management Systemsprovided by solid IT

DBMS > BigObject vs. CrateDB vs. Microsoft Azure Synapse Analytics

System Properties Comparison BigObject vs. CrateDB vs. Microsoft Azure Synapse Analytics

Please select another system to include it in the comparison.

Editorial information provided by DB-Engines
NameBigObject  Xexclude from comparisonCrateDB  Xexclude from comparisonMicrosoft Azure Synapse Analytics infopreviously named Azure SQL Data Warehouse  Xexclude from comparison
DescriptionAnalytic DBMS for real-time computations and queriesDistributed Date Store based on LuceneElastic, large scale data warehouse service leveraging the broad eco-system of SQL Server
Primary database modelRelational DBMS infoa hierachical model (tree) can be imposedRelational DBMS
Search engine
Relational DBMS
Secondary database modelsDocument store
Time Series DBMS
DB-Engines Ranking infomeasures the popularity of database management systemsranking trend
Trend Chart
Score0.04
Rank#334  Overall
#151  Relational DBMS
Score1.00
Rank#176  Overall
#86  Relational DBMS
#13  Search engines
Score21.33
Rank#36  Overall
#22  Relational DBMS
Websitebigobject.iocrate.ioazure.microsoft.com/­services/­synapse-analytics
Technical documentationdocs.bigobject.iocrate.io/­docsdocs.microsoft.com/­azure/­synapse-analytics
DeveloperBigObject, Inc.CrateMicrosoft
Initial release201520132016
License infoCommercial or Open Sourcecommercial infofree community edition availableOpen Sourcecommercial
Cloud-based only infoOnly available as a cloud servicenonoyes
DBaaS offerings (sponsored links) infoDatabase as a Service

Providers of DBaaS offerings, please contact us to be listed.
Implementation languageJavaC++
Server operating systemsLinux infodistributed as a docker-image
OS X infodistributed as a docker-image (boot2docker)
Windows infodistributed as a docker-image (boot2docker)
All OS with a Java 7 (and higher) VMhosted
Data schemeyesFlexible Schema (defined schema, partial schema, schema free)yes
Typing infopredefined data types such as float or dateyesyesyes
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.nonono
Secondary indexesyesyesyes
SQL infoSupport of SQLSQL-like DML and DDL statementsyes, but no triggers and constraintsyes
APIs and other access methodsfluentd
ODBC
RESTful HTTP API
ADO.NET infocommunity maintained client
JDBC
MQTT (Message Queue Telemetry Transport)
PostgreSQL wire protocol
Prometheus Remote Read/Write
RESTful HTTP API
ADO.NET
JDBC
ODBC
Supported programming languagesErlang
Go infocommunity maintained client
Java
JavaScript (Node.js) infocommunity maintained client
Perl infocommunity maintained client
PHP
Python
Ruby infocommunity maintained client
Scala infocommunity maintained client
C#
Java
PHP
Server-side scripts infoStored proceduresLuauser defined functionsTransact SQL
Triggersnonono
Partitioning methods infoMethods for storing different data on different nodesnoneShardingSharding, horizontal partitioning
Replication methods infoMethods for redundantly storing data on multiple nodesnoneselectable replication factoryes
MapReduce infoOffers an API for user-defined Map/Reduce methodsnonono
Consistency concepts infoMethods to ensure consistency in a distributed systemnoneEventual Consistency
Read Your Own Writes Consistency infofor primary key lookups
Immediate Consistency
Foreign keys infoReferential integrityyes infoautomatically between fact table and dimension tablesnono infodocs.microsoft.com/­en-us/­azure/­synapse-analytics/­sql-data-warehouse/­sql-data-warehouse-table-constraints
Transaction concepts infoSupport to ensure data integrity after non-atomic manipulations of datanono infounique row identifiers can be used for implementing an optimistic concurrency control strategyACID
Concurrency infoSupport for concurrent manipulation of datayes infoRead/write lock on objects (tables, trees)yesyes
Durability infoSupport for making data persistentyesyesyes
In-memory capabilities infoIs there an option to define some or all structures to be held in-memory only.yesno
User concepts infoAccess controlnorights management via user accountsyes
More information provided by the system vendor
BigObjectCrateDBMicrosoft Azure Synapse Analytics infopreviously named Azure SQL Data Warehouse
Specific characteristicsCrateDB is an open source distributed SQL database that spreads data and processing...
» more
Competitive advantagesCrateDB is typically used in operational analytics applications, particularly those...
» more
Typical application scenariosCrateDB is ideal for integrating and analyzing streams of data--often machine-generated--in...
» more
Key customersCrateDB customers include McAfee, Qualtrics , Nokia, NBC Golfnow , Digital Domain...
» more
Market metricsThe CrateDB open source project was started in 2014. CrateDB was the winner of TechCrunch...
» more
Licensing and pricing modelsCrateDB pricing CrateDB Community Edition is open source and free to use under the...
» 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
BigObjectCrateDBMicrosoft Azure Synapse Analytics infopreviously named Azure SQL Data Warehouse
Recent citations in the news

CrateDB 4.5 takes distributed SQL database open source
24 March 2021, TechTarget

Exec Q&A with Crate.io CEO Eva Schönleitner
31 May 2022, Technology Magazine

Crate.io Expands CrateDB Cloud with the Launch of CrateDB Edge
15 April 2021, GlobeNewswire

Crate.io extends database service offering to Google Cloud
13 April 2022, VentureBeat

Crate.io raises $10M to grow its database platform
15 June 2021, VentureBeat

provided by Google News

SynLapse: Orca Security Publishes Details for Critical Azure Synapse Vulnerability
25 June 2022, InfoQ.com

Microsoft takes months to fix critical Azure Synapse bug
15 June 2022, TechTarget

A New Microsoft Platform in Town: the Microsoft Intelligent Data Platform
8 June 2022, InfoQ.com

6 'nightmare' cloud security flaws were found in Azure in the last year. Does Microsoft have work to do?
1 June 2022, Protocol

CoreTech System joins hands with Microsoft Azure and creates new values for application of molding analysis
27 June 2022, DIGITIMES

provided by Google News

Job opportunities

Database Architect
Aptos, Atlanta, GA

Senior Cloud Operations Engineer
Aptos, Atlanta, GA

Azure Administrator / Data Engineer
Agama Solutions, Las Vegas, NV

Azure Data Engineer
Agama Solutions, Houston, TX

Support Engineer - Azure Synapse
Microsoft, Issaquah, WA

Data Engineer - Azure
Intone Networks, Remote

Azure Architect
Triune Infomatics Inc, Oakland, CA

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.

MariaDB logo

SkySQL, the ultimate
MariaDB cloud, is here.

Get started with SkySQL today!

Vertica logo

Vertica Accelerator. The fastest analytics and machine learning, delivered as SaaS, with automated setup, administration, and management. Free trial.

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.

Redis logo

The world’s most loved real‑time data platform.
Try free

Present your product here