DB-EnginesEnglish
Deutsch
Knowledge Base of Relational and NoSQL Database Management Systemsprovided by Redgate Software

DBMS > EJDB vs. Faircom EDGE vs. Microsoft Azure SQL Database vs. Newts vs. Quasardb

System Properties Comparison EJDB vs. Faircom EDGE vs. Microsoft Azure SQL Database vs. Newts vs. Quasardb

Editorial information provided by DB-Engines
NameEJDB  Xexclude from comparisonFaircom EDGE infoformerly c-treeEDGE  Xexclude from comparisonMicrosoft Azure SQL Database infoformerly SQL Azure  Xexclude from comparisonNewts  Xexclude from comparisonQuasardb  Xexclude from comparison
DescriptionEmbeddable document-store database library with JSON representation of queries (in MongoDB style)FairCom EDGE is an Industry 4.0 solution built to integrate, collect, aggregate and synchronize mission-critical data in edge computing environmentsDatabase as a Service offering with high compatibility to Microsoft SQL ServerTime Series DBMS based on CassandraDistributed, high-performance timeseries database
Primary database modelDocument storeKey-value store
Relational DBMS
Relational DBMSTime Series DBMSTime Series DBMS
Secondary database modelsDocument store
Graph DBMS
Spatial DBMS
DB-Engines Ranking infomeasures the popularity of database management systemsranking trend
Trend Chart
Score0.14
Rank#331  Overall
#46  Document stores
Score0.02
Rank#366  Overall
#55  Key-value stores
#155  Relational DBMS
Score74.53
Rank#16  Overall
#11  Relational DBMS
Score0.00
Rank#388  Overall
#40  Time Series DBMS
Score0.15
Rank#325  Overall
#28  Time Series DBMS
Websitegithub.com/­Softmotions/­ejdbwww.faircom.com/­products/­faircom-edgeazure.microsoft.com/­en-us/­products/­azure-sql/­databaseopennms.github.io/­newtsquasar.ai
Technical documentationgithub.com/­Softmotions/­ejdb/­blob/­master/­README.mddocs.faircom.com/­docs/­en/­UUID-23d4f1fd-d213-f6d5-b92e-9b7475baa14e.htmldocs.microsoft.com/­en-us/­azure/­azure-sqlgithub.com/­OpenNMS/­newts/­wikidoc.quasar.ai/­master
DeveloperSoftmotionsFairCom CorporationMicrosoftOpenNMS Groupquasardb
Initial release20121979201020142009
Current releaseV3, October 2020V123.14.1, January 2024
License infoCommercial or Open SourceOpen Source infoGPLv2commercial infoRestricted, free version availablecommercialOpen Source infoApache 2.0commercial infoFree community edition, Non-profit organizations and non-commercial usage are eligible for free licenses
Cloud-based only infoOnly available as a cloud servicenonoyesnono
DBaaS offerings (sponsored links) infoDatabase as a Service

Providers of DBaaS offerings, please contact us to be listed.
Implementation languageCANSI C, C++C++JavaC++
Server operating systemsserver-lessAndroid
Linux infoARM, x86
Raspbian
Windows
hostedLinux
OS X
Windows
BSD
Linux
OS X
Windows
Data schemeschema-freeFlexible Schema (defined schema, partial schema, schema free)yesschema-freeschema-free
Typing infopredefined data types such as float or dateyes infostring, integer, double, bool, date, object_idyes, ANSI Standard SQL Typesyesyesyes infointeger and binary
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.yesyesnono
Secondary indexesnoyesyesnoyes infowith tags
SQL infoSupport of SQLnoyes infoANSI SQL queriesyesnoSQL-like query language
APIs and other access methodsin-process shared libraryADO.NET
Direct SQL
IoT Microservice layer
JDBC
MQTT (Message Queue Telemetry Transport)
ODBC
RESTful HTTP API
ADO.NET
JDBC
ODBC
HTTP REST
Java API
HTTP API
Supported programming languagesActionscript
C
C#
C++
Go
Java
JavaScript (Node.js)
Lua
Objective-C
Pike
Python
Ruby
C
C#
C++
Java
JavaScript
PHP
Python
VB.Net
.Net
C#
Java
JavaScript (Node.js)
PHP
Python
Ruby
Java.Net
C
C#
C++
Go
Java
JavaScript (Node.js)
PHP
Python
R
Server-side scripts infoStored proceduresnoyes info.Net, JavaScript, C/C++Transact SQLnono
Triggersnoyesyesnono
Partitioning methods infoMethods for storing different data on different nodesnoneFile partitioning infoCustomizable business rules for partitioningSharding infobased on CassandraSharding infoconsistent hashing
Replication methods infoMethods for redundantly storing data on multiple nodesnoneyes infoSynchronous and asynchronous realtime replication based on transaction logsyes, with always 3 replicas availableselectable replication factor infobased on CassandraSource-replica replication with selectable replication factor
MapReduce infoOffers an API for user-defined Map/Reduce methodsnonononowith Hadoop integration
Consistency concepts infoMethods to ensure consistency in a distributed systemImmediate Consistency
Tunable Consistency
Immediate ConsistencyEventual Consistency infobased on Cassandra
Immediate Consistency infobased on Cassandra
Immediate Consistency
Foreign keys infoReferential integrityno infotypically not needed, however similar functionality with collection joins possibleyes infowhen using SQLyesnono
Transaction concepts infoSupport to ensure data integrity after non-atomic manipulations of datanoACIDACIDnoACID
Concurrency infoSupport for concurrent manipulation of datayes infoRead/Write Lockingyes infoacross SQL and NoSQLyesyesyes
Durability infoSupport for making data persistentyesyesyesyesyes infoby using LevelDB
In-memory capabilities infoIs there an option to define some or all structures to be held in-memory only.yesnoyes infoTransient mode
User concepts infoAccess controlnoFine grained user, group and file access rights managed across SQL (per ANSI standard) and NoSQL.fine grained access rights according to SQL-standardnoCryptographically strong user authentication and audit trail

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
EJDBFaircom EDGE infoformerly c-treeEDGEMicrosoft Azure SQL Database infoformerly SQL AzureNewtsQuasardb
DB-Engines blog posts

PostgreSQL is the DBMS of the Year 2020
4 January 2021, Paul Andlinger, Matthias Gelbmann

Cloud-based DBMS's popularity grows at high rates
12 December 2019, Paul Andlinger

The popularity of cloud-based DBMSs has increased tenfold in four years
7 February 2017, Matthias Gelbmann

show all

Recent citations in the news

Data Technology Company FairCom Expands The Edge with 2 New Releases of its Edge Computing Products
19 April 2023, Business Wire

Brokers, Protocols, Platform Move Manufacturing Data
26 July 2023, EE Times

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

How To Collect, Store, and Query IoT Data With MQTT + SQL
16 June 2022, IoT For All

Trend-Setting Products in Data and Information Management for 2023
8 December 2022, Database Trends and Applications

provided by Google News

Public Preview: New Azure SQL Database skills introduced to Microsoft Copilot in Azure
21 May 2024, azure.microsoft.com

Public Preview: Azure SQL updates for late-May 2024
21 May 2024, azure.microsoft.com

General availability: Azure SQL updates for late-May 2024
21 May 2024, azure.microsoft.com

Modernize your database with the consolidation and retirement of Azure Database Migration tools
12 September 2024, Microsoft

Copilot in Azure SQL Database in Private Preview
27 March 2024, InfoQ.com

provided by Google News

NVIDIA to Present Innovations at Hot Chips That Boost Data Center Performance and Energy Efficiency
23 August 2024, NVIDIA Blog

Exploring secular variation of the gravitational constant from high-resolution quasar spectra
6 July 2024, Nature.com

Namecheap VPS and Shared Hosting Review
9 September 2024, Tom's Hardware

France Brings Top Tech Companies to Detroit, Silicon Valley
22 May 2024, Ward's Auto

Multiplex analysis of intratumoural immune infiltrate and prognosis in patients with stage II–III colorectal cancer from the SCOT and QUASAR 2 trials: a retrospective analysis
29 January 2024, The Lancet

provided by Google News



Share this page

Featured Products

Milvus logo

Vector database designed for GenAI, fully equipped for enterprise implementation.
Try Managed Milvus for Free

Neo4j logo

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

SingleStore logo

The data platform to build your intelligent applications.
Try it 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

RaimaDB logo

RaimaDB, embedded database for mission-critical applications. When performance, footprint and reliability matters.
Try RaimaDB for free.

Present your product here