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 > GridDB vs. InfluxDB vs. SAP IQ vs. Sphinx vs. Tarantool

System Properties Comparison GridDB vs. InfluxDB vs. SAP IQ vs. Sphinx vs. Tarantool

Editorial information provided by DB-Engines
NameGridDB  Xexclude from comparisonInfluxDB  Xexclude from comparisonSAP IQ infoformer name: Sybase IQ  Xexclude from comparisonSphinx  Xexclude from comparisonTarantool  Xexclude from comparison
DescriptionScalable in-memory time series database optimized for IoT and Big DataDBMS for storing time series, events and metricsColumnar RDBMS optimized for Big Data analyticsOpen source search engine for searching in data from different sources, e.g. relational databasesIn-memory computing platform with a flexible data schema for efficiently building high-performance applications
Primary database modelTime Series DBMSTime Series DBMSRelational DBMS infocolumn-orientedSearch engineDocument store
Key-value store
Relational DBMS
Secondary database modelsKey-value store
Relational DBMS
Spatial DBMS infowith GEO packageSpatial DBMS infowith Tarantool/GIS extension
DB-Engines Ranking infomeasures the popularity of database management systemsranking trend
Trend Chart
Score2.00
Rank#137  Overall
#11  Time Series DBMS
Score26.89
Rank#28  Overall
#1  Time Series DBMS
Score3.58
Rank#93  Overall
#48  Relational DBMS
Score6.06
Rank#61  Overall
#6  Search engines
Score1.88
Rank#146  Overall
#24  Document stores
#25  Key-value stores
#68  Relational DBMS
Websitegriddb.netwww.influxdata.com/­products/­influxdb-overviewwww.sap.com/­products/­technology-platform/­sybase-iq-big-data-management.htmlsphinxsearch.comwww.tarantool.io
Technical documentationdocs.griddb.netdocs.influxdata.com/­influxdbhelp.sap.com/­docs/­SAP_IQsphinxsearch.com/­docswww.tarantool.io/­en/­doc
DeveloperToshiba CorporationSAP, formerly SybaseSphinx Technologies Inc.VK
Initial release20132013199420012008
Current release5.1, August 20222.7.5, January 202416.1 SPS04, April 20193.5.1, February 20232.10.0, May 2022
License infoCommercial or Open SourceOpen Source infoAGPL version 3 and Apache License, version 2.0 , commercial license (standard and advanced editions) also availableOpen Source infoMIT-License; commercial enterprise version availablecommercialOpen Source infoGPL version 2, commercial licence availableOpen Source infoBSD-2, source-available extensions (modules), commercial licenses for Tarantool Enterprise
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++GoC++C and C++
Server operating systemsLinuxLinux
OS X infothrough Homebrew
AIX
HP-UX
Linux
Solaris
Windows
FreeBSD
Linux
NetBSD
OS X
Solaris
Windows
BSD
Linux
macOS
Data schemeyesschema-freeyesyesFlexible data schema: relational definition for tables with ability to store json-like documents in columns
Typing infopredefined data types such as float or dateyes infonumerical, string, blob, geometry, boolean, timestampNumeric data and Stringsyesnostring, double, decimal, uuid, integer, blob, boolean, datetime
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 indexesyesnoyesyes infofull-text index on all search fieldsyes
SQL infoSupport of SQLSQL92, SQL-like TQL (Toshiba Query Language)SQL-like query languageyesSQL-like query language (SphinxQL)Full-featured ANSI SQL support
APIs and other access methodsJDBC
ODBC
Proprietary protocol
RESTful HTTP/JSON API
HTTP API
JSON over UDP
ADO.NET
JDBC
ODBC
RESTful HTTP API
Proprietary protocolOpen binary protocol
Supported programming languagesC
C++
Go
Java
JavaScript (Node.js)
Perl
PHP
Python
Ruby
.Net
Clojure
Erlang
Go
Haskell
Java
JavaScript
JavaScript (Node.js)
Lisp
Perl
PHP
Python
R
Ruby
Rust
Scala
C
C#
C++
Java
Perl
PHP
Python
Ruby
C++ infounofficial client library
Java
Perl infounofficial client library
PHP
Python
Ruby infounofficial client library
C
C#
C++
Erlang
Go
Java
JavaScript
Lua
Perl
PHP
Python
Rust
Server-side scripts infoStored proceduresnonoyesnoLua, C and SQL stored procedures
Triggersyesnoyesnoyes, before/after data modification events, on replication events, client session events
Partitioning methods infoMethods for storing different data on different nodesShardingSharding infoin enterprise version onlyshared disk or shared nothing architectures with SAP IQ MultiplexerSharding infoPartitioning is done manually, search queries against distributed index is supportedSharding, partitioned with virtual buckets by user defined affinity key. Live resharding for scale up and scale down without maintenance downtime.
Replication methods infoMethods for redundantly storing data on multiple nodesSource-replica replicationselectable replication factor infoin enterprise version onlySAP/Sybase Replication ServernoneAsynchronous replication with multi-master option
Configurable replication topology (full-mesh, chain, star)
Synchronous quorum replication (with Raft)
MapReduce infoOffers an API for user-defined Map/Reduce methodsConnector for using GridDB as an input source and output destination for Hadoop MapReduce jobsnoHadoop integrationno
Consistency concepts infoMethods to ensure consistency in a distributed systemImmediate consistency within container, eventual consistency across containersImmediate ConsistencyCasual consistency across sharding partitions
Eventual consistency within replicaset partition infowhen using asyncronous replication
Immediate Consistency within single instance
Sequential consistency including linearizable read within replicaset partition infowhen using Raft
Foreign keys infoReferential integritynonoyesnoyes
Transaction concepts infoSupport to ensure data integrity after non-atomic manipulations of dataACID at container levelnoACIDnoACID, with serializable isolation and linearizable read (within partition); Configurable MVCC (within partition); No cross-shard distributed transactions
Concurrency infoSupport for concurrent manipulation of datayesyesyesyesyes, cooperative multitasking
Durability infoSupport for making data persistentyesyesyesyes infoThe original contents of fields are not stored in the Sphinx index.yes, write ahead logging
In-memory capabilities infoIs there an option to define some or all structures to be held in-memory only.yesyes infoDepending on used storage enginenoyes, full featured in-memory storage engine with persistence
User concepts infoAccess controlAccess rights for users can be defined per databasesimple rights management via user accountsfine grained access rights according to SQL-standardnoAccess Control Lists
Mutual TLS authentication for Tarantol Enterprise
Password based authentication
Role-based access control (RBAC) and LDAP for Tarantol Enterprise
Users and Roles
More information provided by the system vendor
GridDBInfluxDBSAP IQ infoformer name: Sybase IQSphinxTarantool
Specific characteristicsGridDB is a highly scalable, in-memory time series database optimized for IoT and...
» more
InfluxData is the creator of InfluxDB , the open source time series database. It...
» more
Competitive advantages1. Optimized for IoT Equipped with Toshiba's proprietary key-container data model...
» more
Time to Value InfluxDB is available in all the popular languages and frameworks,...
» more
Typical application scenariosFactory IoT, Automative Industry, Energy, BEMS, Smart Community, Monitoring system.
» more
IoT & Sensor Monitoring Developers are witnessing the instrumentation of every available...
» more
Key customersDenso International [see use case ] An Electric Power company [see use case ] Ishinomaki...
» more
InfluxData has more than 1,900 paying customers, including customers include MuleSoft,...
» more
Market metricsGitHub trending repository
» more
Fastest-growing database to drive 27,500 GitHub stars Over 750,000 daily active instances
» more
Licensing and pricing modelsOpen Source license (AGPL v3 & Apache v2) Commercial license (subscription)
» more
Open source core with closed source clustering available either on-premise or on...
» more
News

Time Series, InfluxDB, and Vector Databases
26 March 2024

Machine Learning and Infrastructure Monitoring: Tools and Justification
20 March 2024

Making Most Recent Value Queries Hundreds of Times Faster
18 March 2024

Telegraf 1.30 Release Notes
15 March 2024

Tale of the Tape: Data Historians vs Time Series Databases
13 March 2024

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
GridDBInfluxDBSAP IQ infoformer name: Sybase IQSphinxTarantool
DB-Engines blog posts

Why Build a Time Series Data Platform?
20 July 2017, Paul Dix (guest author)

Time Series DBMS are the database category with the fastest increase in popularity
4 July 2016, Matthias Gelbmann

Time Series DBMS as a new trend?
1 June 2015, Paul Andlinger

show all

The DB-Engines ranking includes now search engines
4 February 2013, Paul Andlinger

show all

Data processing speed and reliability: in-memory synchronous replication
9 November 2021,  Vladimir Perepelytsya, Tarantool (sponsor) 

show all

Recent citations in the news

General Availability of GridDB 5.3 Enterprise Edition ~ Major Enhancement in IoT and Time Series Data Analysis ...
16 May 2023, global.toshiba

Toshiba launches cloudy managed IoT database service running its own GridDB
8 April 2021, The Register

Toshiba's Distributed Database GridDB(R) Now Features Scale-Out and Scale-Up combo for Petabyte-scale Data ...
3 December 2019, global.toshiba

General Availability of GridDB 5.1 Enterprise Edition ~ Continuous database usage in the event of data center failure ...
19 August 2022, global.toshiba

Leveraging Open Source Tools for IoT - open source for you
19 February 2020, Open Source For You

provided by Google News

Run and manage open source InfluxDB databases with Amazon Timestream | Amazon Web Services
14 March 2024, AWS Blog

Amazon Timestream: Managed InfluxDB for Time Series Data
14 March 2024, The New Stack

How the FDAP Stack Gives InfluxDB 3.0 Real-Time Speed, Efficiency
15 March 2024, Datanami

InfluxData Collaborating with AWS to Bring InfluxDB and Time Series Analytics to Developers Around the World
15 March 2024, Business Wire

How Apache Arrow accelerates InfluxDB
21 November 2023, InfoWorld

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 HANA Cloud Offers High-Performance Management of Data for Users
20 April 2021, InsideSAP

Congrats, HCL, on your £1.5m contract to upgrade a county council's ERP system to SAP S4/HANA within a year
5 November 2020, The Register

Arcion CTO on building effective data pipelines – Blocks and Files
28 June 2022, Blocks & Files

provided by Google News

Switching From Sphinx to MkDocs Documentation — What Did I Gain and Lose
2 February 2024, Towards Data Science

Manticore is a Faster Alternative to Elasticsearch in C++
25 July 2022, hackernoon.com

Perplexity AI: From Its Use To Operation, Everything You Need To Know About Googles Newest Challenger
11 January 2024, Free Press Journal

The Pirate Bay was recently down for over a week due to a DDoS attack
29 October 2019, The Hacker News

How to Build 600+ Links in One Month
4 September 2020, Search Engine Journal

provided by Google News

TaranHouse: New Big Data Warehouse Announced by Tarantool
4 April 2018, Newswire

In-Memory Showdown: Redis vs. Tarantool
1 September 2021, Хабр

Deploying Tarantool Cartridge applications with zero effort (Part 1)
16 December 2019, Хабр

Deploying Tarantool Cartridge applications with zero effort (Part 2)
13 April 2020, Хабр

Тarantool Cartridge: Sharding Lua Backend in Three Lines
9 October 2019, Хабр

provided by Google News



Share this page

Featured Products

Ontotext logo

GraphDB allows you to link diverse data, index it for semantic search and enrich it via text analysis to build big knowledge graphs. Get 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

AllegroGraph logo

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

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.

Present your product here