DB-EnginesInfluxDB: Focus on building software with an easy-to-use serverless, scalable time series platformEnglish
Deutsch
Knowledge Base of Relational and NoSQL Database Management Systemsprovided by solid IT

DBMS > Faircom DB vs. FoundationDB vs. Sadas Engine vs. Teradata

System Properties Comparison Faircom DB vs. FoundationDB vs. Sadas Engine vs. Teradata

Please select another system to include it in the comparison.

Editorial information provided by DB-Engines
NameFaircom DB infoformerly c-treeACE  Xexclude from comparisonFoundationDB  Xexclude from comparisonSadas Engine  Xexclude from comparisonTeradata  Xexclude from comparison
Created as commercial project in 2013, FoundationDB has been acquired by Apple in March 2015 and was withdrawn from the market. As a consequence, the product was removed from the DB-Engines ranking. In April 2018, Apple open-sourced FoundationDB and it therefore reappears in the ranking.
DescriptionNative high-speed multi-model DBMS for relational and key-value store data simultaneously accessible through SQL and NoSQL APIs.Ordered key-value store. Core features are complimented by layers.SADAS Engine is a columnar DBMS specifically designed for high performance in data warehouse environmentsA hybrid cloud data analytics software platform (Teradata Vantage)
Primary database modelKey-value store
Relational DBMS
Document store infosupported via specific layer
Key-value store
Relational DBMS infosupported via specific SQL-layer
Relational DBMSRelational DBMS
Secondary database modelsDocument store
Graph DBMS
Spatial DBMS
Time Series DBMS
DB-Engines Ranking infomeasures the popularity of database management systemsranking trend
Trend Chart
Score0.29
Rank#304  Overall
#43  Key-value stores
#136  Relational DBMS
Score1.06
Rank#185  Overall
#31  Document stores
#28  Key-value stores
#85  Relational DBMS
Score0.07
Rank#373  Overall
#157  Relational DBMS
Score44.87
Rank#22  Overall
#15  Relational DBMS
Websitewww.faircom.com/­products/­faircom-dbgithub.com/­apple/­foundationdbwww.sadasengine.comwww.teradata.com
Technical documentationdocs.faircom.com/­docs/­en/­UUID-7446ae34-a1a7-c843-c894-d5322e395184.htmlapple.github.io/­foundationdbwww.sadasengine.com/­en/­sadas-engine-download-free-trial-and-documentation/­#documentationdocs.teradata.com
DeveloperFairCom CorporationFoundationDBSADAS s.r.l.Teradata
Initial release1979201320061984
Current releaseV12, November 20206.2.28, November 20208.0Teradata Vantage 1.0 MU2, January 2019
License infoCommercial or Open Sourcecommercial infoRestricted, free version availableOpen Source infoApache 2.0commercial infofree trial version availablecommercial
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.
Implementation languageANSI C, C++C++C++
Server operating systemsAIX
FreeBSD
HP-UX
Linux
NetBSD
OS X
QNX
SCO
Solaris
VxWorks
Windows infoeasily portable to other OSs
Linux
OS X
Windows
AIX
Linux
Windows
hosted
Linux
Data schemeschema free, schema optional, schema required, partial schema,schema-free infosome layers support schemasyesyes
Typing infopredefined data types such as float or dateyes, ANSI SQL Types, JSON, typed binary structuresno infosome layers support typingyesyes
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.nonoyes
Secondary indexesyesnoyesyes infoJoin-index to prejoin tables, aggregate index, sparse index, hash index
SQL infoSupport of SQLyes, ANSI SQL with proprietary extensionssupported in specific SQL layer onlyyesyes infoSQL 2016 + extensions
APIs and other access methodsADO.NET
Direct SQL
JDBC
JPA
ODBC
RESTful HTTP/JSON API
RESTful MQTT/JSON API
RPC
JDBC
ODBC
Proprietary protocol
.NET Client API
HTTP REST
JDBC
JMS Adapter
ODBC
OLE DB
Supported programming languages.Net
C
C#
C++
Java
JavaScript (Node.js and browser)
PHP
Python
Visual Basic
.Net
C
C++
Go
Java
JavaScript infoNode.js
PHP
Python
Ruby
Swift
.Net
C
C#
C++
Groovy
Java
PHP
Python
C
C++
Cobol
Java (JDBC-ODBC)
Perl
PL/1
Python
R
Ruby
Server-side scripts infoStored proceduresyes info.Net, JavaScript, C/C++in SQL-layer onlynoyes infoUDFs, stored procedures, table functions in parallel
Triggersyesnonoyes
Partitioning methods infoMethods for storing different data on different nodesFile partitioning, horizontal partitioning, sharding infoCustomizable business rules for table partitioningShardinghorizontal partitioningSharding infoHashing
Replication methods infoMethods for redundantly storing data on multiple nodesyes, configurable to be parallel or serial, synchronous or asynchronous, uni-directional or bi-directional, ACID-consistent or eventually consistent (with custom conflict resolution).yesnoneMulti-source replication
Source-replica replication
MapReduce infoOffers an API for user-defined Map/Reduce methodsnononono
Consistency concepts infoMethods to ensure consistency in a distributed systemEventual Consistency
Immediate Consistency
Tunable consistency per server, database, table, and transaction
Linearizable consistencyImmediate ConsistencyImmediate Consistency
Foreign keys infoReferential integrityyesin SQL-layer onlyyesyes
Transaction concepts infoSupport to ensure data integrity after non-atomic manipulations of datatunable from ACID to Eventually ConsistentACIDACID
Concurrency infoSupport for concurrent manipulation of datayesyesyesyes
Durability infoSupport for making data persistentYes, tunable from durable to delayed durability to in-memoryyesyesyes
In-memory capabilities infoIs there an option to define some or all structures to be held in-memory only.yesyes infomanaged by 'Learn by Usage'yes
User concepts infoAccess controlFine grained access rights according to SQL-standard with additional protections for filesnoAccess rights for users, groups and roles according to SQL-standardfine grained access rights according to SQL-standard

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
Faircom DB infoformerly c-treeACEFoundationDBSadas EngineTeradata
DB-Engines blog posts

Teradata is the most popular data warehouse DBMS
2 April 2013, Paul Andlinger

show all

Recent citations in the news

FairCom Unveils New Look, FairCom DB v13: Introducing 'DB Made Simple'
4 June 2024, Business Wire

FairCom kicks off new era of database technology USA - English
10 November 2020, PR Newswire

provided by Google News

FoundationDB team's new venture, Antithesis, raises $47M to enhance software testing
13 February 2024, SiliconANGLE News

Stonebraker Seeks to Invert the Computing Paradigm with DBOS
12 March 2024, Datanami

Antithesis raises $47M to launch an automated testing platform for software
13 February 2024, TechCrunch

FoundationDB, a very interesting NoSQL database owned by Apple, is now an open-source project
19 April 2018, GeekWire

Apple Open Sources FoundationDB
19 April 2018, MacRumors

provided by Google News

SHAREHOLDER ALERT: Pomerantz Law Firm Reminds Shareholders with Losses on their Investment in Teradata ...
15 June 2024, PR Newswire

TERADATA ALERT: Bragar Eagel & Squire, P.C. Announces that a Class Action Lawsuit Has Been Filed Against ...
15 June 2024, GlobeNewswire

Teradata Stock: Much More Enticing Now Than Last Year, But Uncertainty Lingers (NYSE:TDC)
14 June 2024, Seeking Alpha

Is There Now An Opportunity In Teradata Corporation (NYSE:TDC)?
11 June 2024, Simply Wall St

Teradata Stock Analysis: Don't Let the Amazon News Fool You Into Buying Now
10 June 2024, InvestorPlace

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.

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

Present your product here