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

DBMS > AllegroGraph vs. Faircom DB vs. GridDB vs. IBM Db2 warehouse

System Properties Comparison AllegroGraph vs. Faircom DB vs. GridDB vs. IBM Db2 warehouse

Please select another system to include it in the comparison.

Editorial information provided by DB-Engines
NameAllegroGraph  Xexclude from comparisonFaircom DB infoformerly c-treeACE  Xexclude from comparisonGridDB  Xexclude from comparisonIBM Db2 warehouse infoformerly named IBM dashDB  Xexclude from comparison
DescriptionHigh performance, persistent RDF store with additional support for Graph DBMSNative high-speed multi-model DBMS for relational and key-value store data simultaneously accessible through SQL and NoSQL APIs.Scalable in-memory time series database optimized for IoT and Big DataCloud-based data warehousing service
Primary database modelDocument store infowith version 6.5
Graph DBMS
RDF store
Key-value store
Relational DBMS
Time Series DBMSRelational DBMS
Secondary database modelsSpatial DBMSKey-value store
Relational DBMS
DB-Engines Ranking infomeasures the popularity of database management systemsranking trend
Trend Chart
Score1.35
Rank#144  Overall
#23  Document stores
#12  Graph DBMS
#7  RDF stores
Score0.53
Rank#228  Overall
#34  Key-value stores
#111  Relational DBMS
Score0.98
Rank#173  Overall
#10  Time Series DBMS
Score1.56
Rank#134  Overall
#66  Relational DBMS
Websiteallegrograph.comwww.faircom.com/­products/­faircom-dbgriddb.netwww.ibm.com/­products/­db2-warehouse
Technical documentationfranz.com/­agraph/­support/­documentation/­current/­agraph-introduction.htmllearn.faircomcorp.com/­developers/­documentation_directorydocs.griddb.net
DeveloperFranz Inc.FairCom CorporationToshiba CorporationIBM
Initial release2004197920132014
Current release7.0.0, April 2020V12, November 20204.5, June 2020
License infoCommercial or Open Sourcecommercial infoLimited community edition freecommercial infoRestricted, free version availableOpen Source infoAGPL version 3 and Apache License, version 2.0 , commercial license (standard and advanced editions) also availablecommercial
Cloud-based only infoOnly available as a cloud servicenononoyes
DBaaS offerings (sponsored links) infoDatabase as a Service

Providers of DBaaS offerings, please contact us to be listed.
Implementation languageANSI C, C++C++
Server operating systemsLinux
OS X
Windows
AIX
FreeBSD
HP-UX
Linux
NetBSD
OS X
QNX
SCO
Solaris
VxWorks
Windows infoeasily portable to other OSs
Linuxhosted
Data schemeyes infoRDF schemasschema free, schema optional, schema required, partial schema,yesyes
Typing infopredefined data types such as float or dateyesyes, ANSI SQL Types, JSON, typed binary structuresyes infonumerical, string, blob, geometry, boolean, timestampyes
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.no infobulk load of XML files possiblenonono infoImport/export of XML data possible
Secondary indexesyesyesyesyes
SQL infoSupport of SQLSPARQL is used as query languageyes, ANSI SQL with proprietary extensionsSQL92, SQL-like TQL (Toshiba Query Language)yes
APIs and other access methodsRESTful HTTP API
SPARQL
ADO.NET
Direct SQL
JDBC
JPA
ODBC
RESTful HTTP/JSON API
RESTful MQTT/JSON API
RPC
Proprietary protocol.NET Client API
JDBC
ODBC
OLE DB
Supported programming languagesC#
Clojure
Java
Lisp
Perl
Python
Ruby
Scala
.Net
C
C#
C++
Java
JavaScript (Node.js and browser)
PHP
Python
Visual Basic
C
C++
Go
Java
JavaScript (Node.js)
Perl
PHP
Python
Ruby
Java
JavaScript (Node.js)
Perl
PHP
Python
R
Ruby
Server-side scripts infoStored proceduresyes infoJavaScript or Common Lispyes info.Net, JavaScript, C/C++noPL/SQL, SQL PL
Triggersyesyesyesyes
Partitioning methods infoMethods for storing different data on different nodeswith FederationFile partitioning, horizontal partitioning, sharding infoCustomizable business rules for table partitioningShardingSharding
Replication methods infoMethods for redundantly storing data on multiple nodesMulti-source replication
Source-replica replication
yes, configurable to be parallel or serial, synchronous or asynchronous, uni-directional or bi-directional, ACID-consistent or eventually consistent (with custom conflict resolution).Source-replica replicationyes
MapReduce infoOffers an API for user-defined Map/Reduce methodsnonoConnector for using GridDB as an input source and output destination for Hadoop MapReduce jobsno
Consistency concepts infoMethods to ensure consistency in a distributed systemImmediate Consistency or Eventual Consistency depending on configurationEventual Consistency
Immediate Consistency
Tunable consistency per server, database, table, and transaction
Immediate consistency within container, eventual consistency across containersImmediate Consistency
Foreign keys infoReferential integritynoyesnoyes
Transaction concepts infoSupport to ensure data integrity after non-atomic manipulations of dataACIDtunable from ACID to Eventually ConsistentACID at container levelACID
Concurrency infoSupport for concurrent manipulation of datayesyesyesyes
Durability infoSupport for making data persistentyesYes, tunable from durable to delayed durability to in-memoryyesyes
In-memory capabilities infoIs there an option to define some or all structures to be held in-memory only.noyesyesyes
User concepts infoAccess controlUsers with fine-grained authorization concept, user roles and pluggable authenticationFine grained access rights according to SQL-standard with additional protections for filesAccess rights for users can be defined per databasefine grained access rights according to SQL-standard
More information provided by the system vendor
AllegroGraphFaircom DB infoformerly c-treeACEGridDBIBM Db2 warehouse infoformerly named IBM dashDB
Specific characteristicsKnowledge Graph Platform Leader FedShard - Designed for Entity-Event Knowledge Graph...
» more
Achieve Hundreds of Thousands of Transactions Per Second on A Single Database Server...
» more
GridDB is a highly scalable, in-memory time series database optimized for IoT and...
» more
Competitive advantagesAllegroGraph is uniquely suited to support adhoc queries through SPARQL, Prolog and...
» more
Top Features SQL Key-value store and navigational NoSQL API Indexed binary objects...
» more
1. Optimized for IoT Equipped with Toshiba's proprietary key-container data model...
» more
Typical application scenariosReal-time transaction processing solutions leverage FairCom DB because its NoSQL...
» more
Factory IoT, Automative Industry, Energy, BEMS, Smart Community, Monitoring system.
» more
Key customersMicrosoft, UPS, Verizon, Motorola, Commvault, Thomson Reuters, ACI, BNY Mellon, Rockwell...
» more
Denso International [see use case ] An Electric Power company [see use case ] Ishinomaki...
» more
Market metricsFrom banking and financial transactions, transportation, warehouse automation, package...
» more
GitHub trending repository
» more
Licensing and pricing modelsJust as the technical aspects of FairCom DB are flexible to meet operation requirements,...
» more
Open Source license (AGPL v3 & Apache v2) Commercial license (subscription)
» more
News

Gartner Case Study: Entity-Event Knowledge Graph for Powering AI Solutions (Montefiore)
15 March 2021

Understanding What Matters With Text Analytics and NLP
9 March 2021

KMWorld 100 Companies that Matter Most – Franz Inc.
9 March 2021

Maximizing Your Data Fabric’s ROI via Entity Data Modeling
24 February 2021

Data-Centric Architecture Forum – DCAF 2021
1 February 2021

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
AllegroGraphFaircom DB infoformerly c-treeACEGridDBIBM Db2 warehouse infoformerly named IBM dashDB
Recent citations in the news

Franz Inc. Named a 2021 KMWorld 100 Company that Matters in Knowledge Management
22 March 2021, Business Wire

Franz's AllegroGraph 7 Gains Broad Recognition in 2020 as a Leading Knowledge Graph Solution
9 December 2020, Business Wire

Franz Expands with Introduction of Gruff 8
13 May 2020, Database Trends and Applications

AllegroGraph v7 Powers First Distributed Semantic Knowledge Graph Solution with Federated-Sharding
26 May 2020, Business Wire

Ubiquitous AI Demands A New Type Of Database Sharding
1 May 2020, Forbes

provided by Google News

CGM signs new agreement to use FairCom DB
18 February 2021, PR Newswire UK

FairCom kicks off new era of database technology USA - English Brazil - Português
10 November 2020, PRNewswire

provided by Google News

Trend-Setting Products in Data and Information Management for 2020
4 December 2019, Database Trends and Applications

FYI: You can trick image-recog AI into, say, mixing up cats and dogs – by abusing scaling code to poison training data
21 March 2020, The Register

provided by Google News

Cloud Data Warehousing: Understanding Your Options
1 April 2021, Datanami

IBM Db2 - The AI Database
15 May 2020, Express Computer

IBM Positioned as a Leader In 2020 Gartner Magic Quadrant for Cloud Database Management Systems
3 December 2020, AiThority

8 databases supporting in-database machine learning
17 February 2021, InfoWorld

Top Vendors of Database Management Software for 2021 | eWEEK
9 January 2021, eWeek

provided by Google News

Job opportunities

Data Analyst
Ai.io Incorporated, Tampa, FL

Sales Director, Channel Sales
TigerGraph, California

Software Engineer - Manufacturing AI
Ford Motor Company, Dearborn, MI

Sales Director, Partner Success
TigerGraph, California

Modeling and Simulation Computer Engineer
The GBS Group, Philadelphia, PA

Receptionist
FairCom, Salt Lake City, UT

Account Executive
FairCom, Salt Lake City, UT

Director of Sales
FairCom, Salt Lake City, UT

Software Engineer
FairCom, Salt Lake City, UT

Administrative Assistant
FairCom, Salt Lake City, UT

Middleware Administrator
Snap IT Solutions, Houston, TX

Data Engineer with Linux
Integral, Annapolis Junction, MD

Data Science Platform Administrator
Guidehouse, Washington, DC

jobs by Indeed




Share this page

Featured Products

Datastax Astra logo

Build cloud-native apps fast with Astra, the open-source, multi-cloud stack for
modern data apps.
Get started with 5 GB free..

Couchbase logo

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

MariaDB logo

SkySQL, the ultimate
MariaDB cloud, is here.

Get started with SkySQL today!

AllegroGraph logo

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

Neo4j logo

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

Present your product here