DB-EnginesInfluxDB download bannerEnglish
Deutsch
Knowledge Base of Relational and NoSQL Database Management Systemsprovided by solid IT

DBMS > c-treeEDGE vs. MySQL vs. NuoDB vs. Oracle

System Properties Comparison c-treeEDGE vs. MySQL vs. NuoDB vs. Oracle

Please select another system to include it in the comparison.

Editorial information provided by DB-Engines
Namec-treeEDGE  Xexclude from comparisonMySQL  Xexclude from comparisonNuoDB  Xexclude from comparisonOracle  Xexclude from comparison
DescriptionDatabase built for IoT edge computing, which runs natively on ARM or x86 processors and on major IoT operating systems.Widely used open source RDBMSNuoDB is a webscale distributed database that supports SQL and ACID transactionsWidely used RDBMS
Primary database modelKey-value store
Relational DBMS
Relational DBMS infoKey/Value like access via memcached APIRelational DBMSRelational DBMS
Secondary database modelsDocument storeDocument store
Graph DBMS infowith Oracle Spatial and Graph
RDF store infowith Oracle Spatial and Graph
DB-Engines Ranking infomeasures the popularity of database management systemsranking trend
Trend Chart
Score0.34
Rank#239  Overall
#41  Key-value stores
#113  Relational DBMS
Score1282.64
Rank#2  Overall
#2  Relational DBMS
Score0.93
Rank#156  Overall
#77  Relational DBMS
Score1345.44
Rank#1  Overall
#1  Relational DBMS
Websitewww.faircom.com/­-products/­-c-treeedgewww.mysql.comwww.nuodb.comwww.oracle.com/­database
Technical documentationlearn.faircomcorp.com/­developers/­documentation_directorydev.mysql.com/­docdoc.nuodb.comdocs.oracle.com/­en/­database
DeveloperFairCom CorporationOracle infosince 2010, originally MySQL AB, then SunNuoDB, Inc.Oracle
Initial release1979199520131980
Current releaseV1, Juni 20188.0.20, 202019c, February 2019
License infoCommercial or Open Sourcecommercial infoRestricted, free version availableOpen Source infoGPL version 2. Commercial licenses with extended functionallity are availablecommercial infolimited edition freecommercial inforestricted free version is available
Cloud-based only infoOnly available as a cloud servicenononono
DBaaS offerings (sponsored links) infoDatabase as a Service

Providers of DBaaS offerings, please contact us to be listed.
Azure Database for MySQL: A fully managed, scalable MySQL relational database with high availability and security built in at no extra cost
Implementation languageANSI C, C++C and C++C++C and C++
Server operating systemsAndroid
Linux
Raspbian
Windows infoeasily portable to other OSs
FreeBSD
Linux
OS X
Solaris
Windows
hosted infoAmazon EC2, Windows Azure, SoftLayer
Linux
OS X
Windows
AIX
HP-UX
Linux
OS X
Solaris
Windows
z/OS
Data schemeFlexible Schema (defined schema, partial schema, schema free)yesyesyes infoSchemaless in JSON and XML columns
Typing infopredefined data types such as float or dateyes, ANSI Standard SQL Typesyesyesyes
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.noyesnoyes
Secondary indexesyesyesyesyes
SQL infoSupport of SQLyes infoANSI SQL queriesyes infowith proprietary extensionsyesyes infowith proprietary extensions
APIs and other access methodsADO.NET
Direct SQL
IoT Microservice layer
JDBC
MQTT (Message Queue Telemetry Transport)
ODBC
RESTful HTTP API
ADO.NET
JDBC
ODBC
Proprietary native API
ADO.NET
JDBC
ODBC
JDBC
ODBC
ODP.NET
Oracle Call Interface (OCI)
Supported programming languages.Net
C
C#
C++
Java
JavaScript
PHP
Python
Visual Basic
Ada
C
C#
C++
D
Delphi
Eiffel
Erlang
Haskell
Java
JavaScript (Node.js)
Objective-C
OCaml
Perl
PHP
Python
Ruby
Scheme
Tcl
.Net
C
C++
Go
Java
JavaScript
JavaScript (Node.js)
PHP
Python
Ruby
C
C#
C++
Clojure
Cobol
Delphi
Eiffel
Erlang
Fortran
Groovy
Haskell
Java
JavaScript
Lisp
Objective C
OCaml
Perl
PHP
Python
R
Ruby
Scala
Tcl
Visual Basic
Server-side scripts infoStored proceduresyes info.Net, JavaScript, C/C++yes infoproprietary syntaxJava, SQLPL/SQL infoalso stored procedures in Java possible
Triggersyesyesyesyes
Partitioning methods infoMethods for storing different data on different nodesFile partitioning infoCustomizable business rules for partitioninghorizontal partitioning, sharding with MySQL Cluster or MySQL Fabricdata is dynamically stored/cached on the nodes where it is read/writtenhorizontal partitioning infowith the optional Oracle Partitioning
Replication methods infoMethods for redundantly storing data on multiple nodesyes infoSynchronous and asynchronous realtime replication based on transaction logsMaster-master replication
Master-slave replication
yes infoManaged transparently by NuoDBMaster-master replication
Master-slave replication
MapReduce infoOffers an API for user-defined Map/Reduce methodsnononono infocan be realized in PL/SQL
Consistency concepts infoMethods to ensure consistency in a distributed systemImmediate Consistency
Tunable Consistency
Immediate ConsistencyImmediate ConsistencyImmediate Consistency
Foreign keys infoReferential integrityyes infowhen using SQLyes infonot for MyISAM storage engineyesyes
Transaction concepts infoSupport to ensure data integrity after non-atomic manipulations of dataACIDACID infonot for MyISAM storage engineACID infotunable commit protocolACID infoisolation level can be parameterized
Concurrency infoSupport for concurrent manipulation of datayes infoacross SQL and NoSQLyes infotable locks or row locks depending on storage engineyes infoMVCCyes
Durability infoSupport for making data persistentyesyesyesyes
In-memory capabilities infoIs there an option to define some or all structures to be held in-memory only.yesyesyes infoTemporary tableyes infoVersion 12c introduced the new option 'Oracle Database In-Memory'
User concepts infoAccess controlFine grained user, group and file access rights managed across SQL (per ANSI standard) and NoSQL.Users with fine-grained authorization concept infono user groups or rolesStandard SQL roles/ privileges, Administrative Usersfine grained access rights according to SQL-standard
More information provided by the system vendor
c-treeEDGEMySQLNuoDBOracle
Specific characteristicsThe c-treeEDGE IoT Database is a fast, flexible solution with a robust architecture...
» more
Horizontal scale-out, continuous availability, multi-tenant support, ANSI SQL compatible,...
» more
Oracle Database (commonly referred to as Oracle RDBMS or simply as Oracle) is a multi-model...
» more
Competitive advantagesTop Features Micro footprint: As low as 37 MB IoT communication interfaces : MQTT,...
» more
NuoDB is a scale-out SQL RDBMS based on a Durable Distributed Caching (DDC) architecture....
» more
Typical application scenariosc-treeEDGE can be deployed at or near the data collection point (sensors) and used...
» more
Operational / OLTP database workloads in data centers or public clouds
» more
Key customersNew product
» more
Dassault Systemes, Santander, Temenos
» more
Market metricsNew product
» more
Fast growing commercial and enterprise customer base IDC Innovators: Dynamically...
» more
Licensing and pricing modelsJust as the technical aspects of c-treeEDGE are flexible to meet operation requirements,...
» more
Subscription-based pricing with free community edition and commercial enterprise...
» more
Oracle Database Cloud Services Customers can choose from a wide range of database...
» 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

Navicat for MySQL is the ideal solution for MySQL/MariaDB administration and development.
» more

SQLPro for MySQL: A simple but powerful MySQL database client available on iPhone and iPad as well as macOS.
» more

ScaleGrid: Fully managed MySQL-as-a-Service.
» more

General SQL Parser: Instantly adding parsing, decoding, analysis and rewrite SQL processing capability to your products.
» more

Azure Database for MySQL provides fully managed, enterprise-ready community MySQL database as a service
» more
DBHawk: Secure access to SQL, NoSQL and Cloud databases with an all-in-one solution.
» more

Navicat for Oracle improves the efficiency and productivity of Oracle developers and administrators with a streamlined working environment.
» more

General SQL Parser: Instantly adding parsing, decoding, analysis and rewrite SQL processing capability to your products.
» more

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

More resources
c-treeEDGEMySQLNuoDBOracle
DB-Engines blog posts

MySQL is the DBMS of the Year 2019
3 January 2020, Matthias Gelbmann, Paul Andlinger

MariaDB strengthens its position in the open source RDBMS market
5 April 2018, Matthias Gelbmann

The struggle for the hegemony in Oracle's database empire
2 May 2017, Paul Andlinger

show all

Meet some database management systems you are likely to hear more about in the future
4 August 2014, Paul Andlinger

show all

MySQL is the DBMS of the Year 2019
3 January 2020, Matthias Gelbmann, Paul Andlinger

The struggle for the hegemony in Oracle's database empire
2 May 2017, Paul Andlinger

Architecting eCommerce Platforms for Zero Downtime on Black Friday and Beyond
25 November 2016, Tony Branson (guest author)

show all

Recent citations in the news

FairCom to feature #ctreeEDGE IoT Database at LiveWorx19
4 June 2019, PRNewswire

FairCom names new senior sales director
27 January 2020, PRNewswire

FairCom joins INCITS committee that defines GQL, SQL standards
21 January 2020, Yahoo Finance

FairCom and Software AG sign new contract for c-treeACE Database
22 March 2019, PRNewswire

Hdac Technology Unveils the World's First Enterprise Solution Combining Blockchain and Iot at Iot Blockchain Summit 2018
2 November 2018, AiThority

provided by Google News

How to populate MySQL tables with data using phpMyAdmin
15 May 2020, TechRepublic

PlanetScale scales out MySQL
4 May 2020, ZDNet

Devart Presents Dramatically Improved dbForge Studio for MySQL v.9.0
21 May 2020, PR.com

Multi-cloud and Multi-database Deployments – the Need of the Hour
26 May 2020, EnterpriseTalk

Percona users detail open source database challenges
20 May 2020, TechTarget

provided by Google News

DATABASE AUTOMATION MARKET MAY SET NEW GROWTH STORY WITH SEVERALNINES (SWEDEN), QUEST SOFTWARE (US), IDERA (US), SAP (GERMANY), CHEF (US), REDIS LABS (US), NUODB (US), TESTINGWHIZ (US), PUPPET (US), CLUSTRIX AND MORE
18 May 2020, 3rd Watch News

Global Database Automation Market 2020 Feature Scenario – Oracle, Datavail, BMC Software, Microsoft, AWS, Broadcom, Dbmaestro, IBM
21 May 2020, Bandera County Courier

Global SQL Server Transformation Market Outlook 2020 | Oracle, Actian Corporation, Microsoft, IBM, Alphabet, SAP SE, NuoDB, Inc.
28 April 2020, Cole of Duty

Digital Banking And The Power Of The Hybrid Cloud
28 April 2020, pymnts.com

NuoDB set to improve distributed SQL performance
7 January 2020, TechTarget

provided by Google News

Liquibase, formerly Datical, updates database devops tools
26 May 2020, InfoWorld

Oracle Database Administration Certifications: What Are They And How To Prepare?
14 May 2020, Analytics India Magazine

Santa Clara-based Oracle database rival scores $105M funding
21 May 2020, New York Business Journal

Kakao switches to Rimini Street support for Oracle Database
15 May 2020, InfotechLead.com

Oracle's open-source alter ego behind some of its most popular products
26 May 2020, SiliconANGLE News

provided by Google News

Job opportunities

Business Development Representative
FairCom, Salt Lake City, UT

Linux Administrator
HOSTCOPPER, Remote

Database Administrator (Remote)
Paylocity, Remote

PHP/MySQL Developers
Webmasters.com, Tampa, FL

Jr. QA Analyst Trainee
SQA², Los Alamitos, CA

Online Coding Instructor
CodeWizardsHQ, San Francisco, CA

Oracle Database Administrator (DBA)
C3 Business Solutions, Newport Beach, CA

System Database Administrator - Oracle
IBM, United States

Database Administrator (Remote)
Paylocity, Remote

Junior Database Administrator - Jr DBA
C3 Business Solutions, Newport Beach, CA

Associate Database Administrator (3rd Shift)
Navisite, Andover, MA

jobs by Indeed




Share this page

Featured Products

MariaDB logo

SkySQL, the ultimate
MariaDB cloud, is here.

Get started with SkySQL today!

Datastax Luna logo

Simple, subscription-based support for open source
Apache Cassandra™ from the Cassandra experts.
Learn more.

Couchbase logo

SQL + JSON + NoSQL.
Power, flexibility & scale.
All open source.
Get started now.

Neo4j logo

Get your free copy of the new O'Reilly book Graph Algorithms with 20+ examples for
machine learning, graph analytics and more.

RavenDB logo

Setup a fully managed RavenDB Cloud Database in minutes. Enjoy hosting, management, backups all in one place.
Grab a Free Instance

Present your product here