DB-EnginesExtremeDB: mitigate connectivity issues in a DBMSEnglish
Deutsch
Knowledge Base of Relational and NoSQL Database Management Systemsprovided by solid IT

DBMS > Dragonfly vs. Faircom DB vs. SAP IQ vs. SiriDB vs. STSdb

System Properties Comparison Dragonfly vs. Faircom DB vs. SAP IQ vs. SiriDB vs. STSdb

Editorial information provided by DB-Engines
NameDragonfly  Xexclude from comparisonFaircom DB infoformerly c-treeACE  Xexclude from comparisonSAP IQ infoformer name: Sybase IQ  Xexclude from comparisonSiriDB  Xexclude from comparisonSTSdb  Xexclude from comparison
DescriptionA drop-in Redis replacement that scales vertically to support millions of operations per second and terabyte sized workloads, all on a single instanceNative high-speed multi-model DBMS for relational and key-value store data simultaneously accessible through SQL and NoSQL APIs.Columnar RDBMS optimized for Big Data analyticsOpen Source Time Series DBMSKey-Value Store with special method for indexing infooptimized for high performance using a special indexing method
Primary database modelKey-value storeKey-value store
Relational DBMS
Relational DBMS infocolumn-orientedTime Series DBMSKey-value store
DB-Engines Ranking infomeasures the popularity of database management systemsranking trend
Trend Chart
Score0.49
Rank#261  Overall
#38  Key-value stores
Score0.29
Rank#304  Overall
#43  Key-value stores
#136  Relational DBMS
Score2.64
Rank#108  Overall
#52  Relational DBMS
Score0.07
Rank#378  Overall
#42  Time Series DBMS
Score0.10
Rank#357  Overall
#51  Key-value stores
Websitegithub.com/­dragonflydb/­dragonfly
www.dragonflydb.io
www.faircom.com/­products/­faircom-dbwww.sap.com/­products/­technology-platform/­sybase-iq-big-data-management.htmlsiridb.comgithub.com/­STSSoft/­STSdb4
Technical documentationwww.dragonflydb.io/­docsdocs.faircom.com/­docs/­en/­UUID-7446ae34-a1a7-c843-c894-d5322e395184.htmlhelp.sap.com/­docs/­SAP_IQdocs.siridb.com
DeveloperDragonflyDB team and community contributorsFairCom CorporationSAP, formerly SybaseCesbitSTS Soft SC
Initial release20231979199420172011
Current release1.0, March 2023V12, November 202016.1 SPS04, April 20194.0.8, September 2015
License infoCommercial or Open SourceOpen Source infoBSL 1.1commercial infoRestricted, free version availablecommercialOpen Source infoMIT LicenseOpen Source infoGPLv2, commercial license available
Cloud-based only infoOnly available as a cloud servicenonononono
DBaaS offerings (sponsored links) infoDatabase as a Service

Providers of DBaaS offerings, please contact us to be listed.
Implementation languageC++ANSI C, C++CC#
Server operating systemsLinuxAIX
FreeBSD
HP-UX
Linux
NetBSD
OS X
QNX
SCO
Solaris
VxWorks
Windows infoeasily portable to other OSs
AIX
HP-UX
Linux
Solaris
Windows
LinuxWindows
Data schemescheme-freeschema free, schema optional, schema required, partial schema,yesyesyes
Typing infopredefined data types such as float or datestrings, hashes, lists, sets, sorted sets, bit arraysyes, ANSI SQL Types, JSON, typed binary structuresyesyes infoNumeric datayes infoprimitive types and user defined types (classes)
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.nononono
Secondary indexesnoyesyesyesno
SQL infoSupport of SQLnoyes, ANSI SQL with proprietary extensionsyesnono
APIs and other access methodsProprietary protocol infoRESP - REdis Serialization ProtocolADO.NET
Direct SQL
JDBC
JPA
ODBC
RESTful HTTP/JSON API
RESTful MQTT/JSON API
RPC
ADO.NET
JDBC
ODBC
RESTful HTTP API
HTTP API.NET Client API
Supported programming languagesC
C#
C++
Clojure
D
Dart
Elixir
Erlang
Go
Haskell
Java
JavaScript (Node.js)
Lisp
Lua
Objective-C
Perl
PHP
Python
R
Ruby
Rust
Scala
Swift
Tcl
.Net
C
C#
C++
Java
JavaScript (Node.js and browser)
PHP
Python
Visual Basic
C
C#
C++
Java
Perl
PHP
Python
Ruby
C
C++
Go
Java
JavaScript (Node.js)
PHP
Python
R
C#
Java
Server-side scripts infoStored proceduresLuayes info.Net, JavaScript, C/C++yesnono
Triggerspublish/subscribe channels provide some trigger functionalityyesyesnono
Partitioning methods infoMethods for storing different data on different nodesFile partitioning, horizontal partitioning, sharding infoCustomizable business rules for table partitioningshared disk or shared nothing architectures with SAP IQ MultiplexerShardingnone
Replication methods infoMethods for redundantly storing data on multiple nodesSource-replica replicationyes, configurable to be parallel or serial, synchronous or asynchronous, uni-directional or bi-directional, ACID-consistent or eventually consistent (with custom conflict resolution).SAP/Sybase Replication Serveryesnone
MapReduce infoOffers an API for user-defined Map/Reduce methodsnonoHadoop integrationnono
Consistency concepts infoMethods to ensure consistency in a distributed systemEventual ConsistencyEventual Consistency
Immediate Consistency
Tunable consistency per server, database, table, and transaction
Immediate Consistency
Foreign keys infoReferential integritynoyesyesnono
Transaction concepts infoSupport to ensure data integrity after non-atomic manipulations of dataAtomic execution of command blocks and scriptstunable from ACID to Eventually ConsistentACIDnono
Concurrency infoSupport for concurrent manipulation of datayes, strict serializability by the serveryesyesyesyes
Durability infoSupport for making data persistentyesYes, 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.yesyesnoyes
User concepts infoAccess controlPassword-based authenticationFine grained access rights according to SQL-standard with additional protections for filesfine grained access rights according to SQL-standardsimple rights management via user accountsno

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
DragonflyFaircom DB infoformerly c-treeACESAP IQ infoformer name: Sybase IQSiriDBSTSdb
Recent citations in the news

DragonflyDB Announces $21m in New Funding and General Availability
21 March 2023, Business Wire

DragonflyDB reels in $21M for its speedy in-memory database
21 March 2023, SiliconANGLE News

DragonflyDB Raises $21M in Funding
21 March 2023, FinSMEs

Dragonfly 1.0 Released For What Claims To Be The World's Fastest In-Memory Data Store
20 March 2023, Phoronix

Intel Linux Kernel Optimizations Show Huge Benefit For High Core Count Servers
29 March 2023, Phoronix

provided by Google 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

New Services for SAP HANA Cloud Database
7 April 2021, SAP News

SAP Products & Services Data Portfolio
2 July 2021, Datamation

SAP Scales Out HANA In-Memory For Clouds
6 March 2014, EnterpriseAI

Using SAP Hana as a data warehouse
17 August 2015, ComputerWeekly.com

2021 SAP Data and Analytics Virtual Forum
27 April 2021, SAP News

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

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

Neo4j logo

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

Present your product here