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 > Faircom EDGE vs. Microsoft Azure Cosmos DB vs. Microsoft Azure Data Explorer vs. TinkerGraph

System Properties Comparison Faircom EDGE vs. Microsoft Azure Cosmos DB vs. Microsoft Azure Data Explorer vs. TinkerGraph

Please select another system to include it in the comparison.

Editorial information provided by DB-Engines
NameFaircom EDGE infoformerly c-treeEDGE  Xexclude from comparisonMicrosoft Azure Cosmos DB infoformer name was Azure DocumentDB  Xexclude from comparisonMicrosoft Azure Data Explorer  Xexclude from comparisonTinkerGraph  Xexclude from comparison
DescriptionFairCom EDGE is an Industry 4.0 solution built to integrate, collect, aggregate and synchronize mission-critical data in edge computing environmentsGlobally distributed, horizontally scalable, multi-model database serviceFully managed big data interactive analytics platformA lightweight, in-memory graph engine that serves as a reference implementation of the TinkerPop3 API
Primary database modelKey-value store
Relational DBMS
Document store
Graph DBMS
Key-value store
Wide column store
Relational DBMS infocolumn orientedGraph DBMS
Secondary database modelsSpatial DBMSDocument store infoIf 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 infothis 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)
Search engine infosupport 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 infosee docs.microsoft.com/­en-us/­azure/­data-explorer/­time-series-analysis
DB-Engines Ranking infomeasures the popularity of database management systemsranking trend
Trend Chart
Score0.22
Rank#285  Overall
#42  Key-value stores
#133  Relational DBMS
Score40.04
Rank#26  Overall
#3  Document stores
#2  Graph DBMS
#3  Key-value stores
#3  Wide column stores
Score6.59
Rank#60  Overall
#34  Relational DBMS
Score0.12
Rank#306  Overall
#29  Graph DBMS
Websitewww.faircom.com/­products/­faircomedge-iot-databaseazure.microsoft.com/­services/­cosmos-dbazure.microsoft.com/­services/­data-explorertinkerpop.apache.org/­docs/­current/­reference/­#tinkergraph-gremlin
Technical documentationlearn.faircomcorp.com/­developers/­documentation_directorydocs.microsoft.com/­azure/­cosmos-dbdocs.microsoft.com/­en-us/­azure/­data-explorer
DeveloperFairCom CorporationMicrosoftMicrosoft
Initial release1979201420192009
Current releaseV3, October 2020cloud service with continuous releases
License infoCommercial or Open Sourcecommercial infoRestricted, free version availablecommercialcommercialOpen Source infoApache 2.0
Cloud-based only infoOnly available as a cloud servicenoyesyesno
DBaaS offerings (sponsored links) infoDatabase as a Service

Providers of DBaaS offerings, please contact us to be listed.
Implementation languageANSI C, C++Java
Server operating systemsAndroid
Linux infoARM, x86
Raspbian
Windows
hostedhosted
Data schemeFlexible Schema (defined schema, partial schema, schema free)schema-freeFixed schema with schema-less datatypes (dynamic)schema-free
Typing infopredefined data types such as float or dateyes, ANSI Standard SQL Typesyes infoJSON typesyes infobool, datetime, dynamic, guid, int, long, real, string, timespan, double: docs.microsoft.com/­en-us/­azure/­kusto/­query/­scalar-data-typesyes
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.yesyesno
Secondary indexesyesyes infoAll properties auto-indexed by defaultall fields are automatically indexedno
SQL infoSupport of SQLyes infoANSI SQL queriesSQL-like query languageKusto Query Language (KQL), SQL subsetno
APIs and other access methodsADO.NET
Direct SQL
IoT Microservice layer
JDBC
MQTT (Message Queue Telemetry Transport)
ODBC
RESTful HTTP API
DocumentDB API
Graph API (Gremlin)
MongoDB API
RESTful HTTP API
Table API
Microsoft SQL Server communication protocol (MS-TDS)
RESTful HTTP API
TinkerPop 3
Supported programming languagesC
C#
C++
Java
JavaScript
PHP
Python
VB.Net
.Net
C#
Java
JavaScript
JavaScript (Node.js)
MongoDB client drivers written for various programming languages
Python
.Net
Go
Java
JavaScript (Node.js)
PowerShell
Python
R
Groovy
Java
Server-side scripts infoStored proceduresyes info.Net, JavaScript, C/C++JavaScriptYes, possible languages: KQL, Python, Rno
TriggersyesJavaScriptyes infosee docs.microsoft.com/­en-us/­azure/­kusto/­management/­updatepolicyno
Partitioning methods infoMethods for storing different data on different nodesFile partitioning infoCustomizable business rules for partitioningSharding infoImplicit feature of the cloud serviceSharding infoImplicit feature of the cloud servicenone
Replication methods infoMethods for redundantly storing data on multiple nodesyes infoSynchronous and asynchronous realtime replication based on transaction logsyes infoImplicit feature of the cloud serviceyes infoImplicit feature of the cloud service. Replication either local, cross-facility or geo-redundant.none
MapReduce infoOffers an API for user-defined Map/Reduce methodsnowith Hadoop integration infoIntegration with Hadoop/HDInsight on Azure*nono
Consistency concepts infoMethods to ensure consistency in a distributed systemImmediate Consistency
Tunable Consistency
Bounded Staleness
Consistent Prefix
Eventual Consistency
Immediate Consistency infoConsistency level configurable on request level
Session Consistency
Eventual Consistency
Immediate Consistency
none
Foreign keys infoReferential integrityyes infowhen using SQLnonoyes infoRelationships in graphs
Transaction concepts infoSupport to ensure data integrity after non-atomic manipulations of dataACIDMulti-item ACID transactions with snapshot isolation within a partitionnono
Concurrency infoSupport for concurrent manipulation of datayes infoacross SQL and NoSQLyesyesno
Durability infoSupport for making data persistentyesyesyesoptional
In-memory capabilities infoIs there an option to define some or all structures to be held in-memory only.yesnoyes
User concepts infoAccess controlFine grained user, group and file access rights managed across SQL (per ANSI standard) and NoSQL.Access rights can be defined down to the item levelAzure Active Directory Authenticationno
More information provided by the system vendor
Faircom EDGE infoformerly c-treeEDGEMicrosoft Azure Cosmos DB infoformer name was Azure DocumentDBMicrosoft Azure Data ExplorerTinkerGraph
Specific characteristicsAzure Data Explorer is a fast and highly scalable data exploration service for log...
» more
Competitive advantagesKusto Query Language (innovative query language, optimized for high performance data...
» more
Typical application scenariosIoT applications IoT devices generate billions of sensor readings. Normalizing and...
» more
Key customersMicrosoft, DocuSign, Taboola, Bosch, Siemens Healthineers, Bühler, Ecolab, Zoomd
» more
Market metricsAzure Data Explorer is the data service for Azure Monitor, Azure Time Series Insights,...
» 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 partiesCData: Connect to Big Data & NoSQL through standard Drivers.
» more

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

More resources
Faircom EDGE infoformerly c-treeEDGEMicrosoft Azure Cosmos DB infoformer name was Azure DocumentDBMicrosoft Azure Data ExplorerTinkerGraph
Recent citations in the news

FairCom lives 2021 on the 'edge' with IoT data management solution
20 December 2021, PRNewswire

FairCom Joins IoT Evolution Expo 2022 as a Platinum Sponsor
7 December 2021, IoT Evolution World

World's First Converged IIoT Hub to be Showcased at IoT Tech Expo
3 September 2021, Automation.com

FairCom Announces New and Rebranded Data Products
23 November 2020, Database Trends and Applications

Winners of the 2021 IoT Evolution Product of the Year Awards Announced
6 July 2021, IoT Evolution World

provided by Google News

NoSQL Databases Software Market Size By 2029 | MongoDB, Amazon, ArangoDB, Azure Cosmos DB – The Oxford Spokesman
26 January 2022, The Oxford Spokesman

NoSQL Software Market Is Likely to Experience a Tremendous Growth in Near Future | MongoDB, Amazon, ArangoDB, Azure Cosmos DB, Couchbase
10 January 2022, Digital Journal

Researchers discover critical flaw in Azure Cosmos DB
27 August 2021, TechTarget

Microsoft Azure Cosmos DB Incident Underscores the Need to Closely Watch Cloud Data
30 August 2021, Dark Reading

Document Databases Software Market Outlook By 2029 | MongoDB, Amazon, ArangoDB, Azure Cosmos DB – The Oxford Spokesman
26 January 2022, The Oxford Spokesman

provided by Google News

Azure Data Explorer gets new engine, numerous enhancements and Synapse integration
14 October 2020, ZDNet

Pave the way for a sustainable future with data and smart mobility solutions - Microsoft Industry Blogs
4 January 2022, Microsoft

Microsoft's Azure Data Share: How to use this big data tool
9 August 2021, TechRepublic

Microsoft Azure Data Lake Storage Is Now Generally Available
20 February 2019, eWeek

Fastly, Microsoft partner on real-time analytics with Azure Data Explorer
29 January 2019, ZDNet

provided by Google News

Job opportunities

Sales Operations Manager
FairCom, Salt Lake City, UT

QA Engineer (Hybrid)
FairCom, Salt Lake City, UT

Sales Development Representative (SDR)
FairCom, Columbia, MO

Software Engineer
FairCom, Sandy, UT

Account Executive (Hybrid)
FairCom, Salt Lake City, UT

Support Engineer - Cosmos DB
Microsoft, Las Colinas, TX

Cloud Solution Architecture - Cosmos DB/OSS
Microsoft, Redmond, WA

Sr. Data Engineer
GoPuff, United States

Technical Support Engineering - Cosmos DB and Azure Data Explorer
Microsoft, Charlotte, NC

Sr. Marketing Manager, Azure Cosmos DB
Microsoft, Bellevue, WA

Data Engineer
Sunixa Solutions, Remote

Data & Applied Scientist
Microsoft, Atlanta, GA

Azure Data Engineer
Agama Solutions, Houston, TX

Data Engineer
Valorem, Remote

Technical Support Engineering - Cosmos DB and Azure Data Explorer
Microsoft, Charlotte, NC

jobs by Indeed



Share this page

Featured Products

AllegroGraph logo

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

Neo4j logo

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

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.

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.

Present your product here