DBMS > GBase vs. Hyprcubd vs. Ignite vs. Sphinx vs. Tkrzw

System Properties Comparison GBase vs. Hyprcubd vs. Ignite vs. Sphinx vs. Tkrzw

Editorial information provided by DB-Engines
Name	GBase  Xexclude from comparison	Hyprcubd  Xexclude from comparison	Ignite  Xexclude from comparison	Sphinx  Xexclude from comparison	Tkrzw Successor of Tokyo Cabinet and Kyoto Cabinet  Xexclude from comparison
		Hyprcubd seems to be discontinued. Therefore it is excluded from the DB-Engines ranking.
Description	An analytical database for business intelligence with large customers in China.	Serverless Time Series DBMS	Apache Ignite is a memory-centric distributed database, caching, and processing platform for transactional, analytical, and streaming workloads, delivering in-memory speeds at petabyte scale.	Open source search engine for searching in data from different sources, e.g. relational databases	A concept of libraries, allowing an application program to store and query key-value pairs in a file. Successor of Tokyo Cabinet and Kyoto Cabinet
Primary database model	Relational DBMS	Time Series DBMS	Key-value store Relational DBMS	Search engine	Key-value store
DB-Engines Ranking measures the popularity of database management systems Trend Chart	Score 1.12 Rank #165   Overall #78   Relational DBMS	Score 0.00 Rank #363   Overall #34   Time Series DBMS	Score 7.09 Rank #62   Overall #7   Key-value stores #35   Relational DBMS	Score 7.23 Rank #61   Overall #8   Search engines	Score 0.00 Rank #363   Overall #57   Key-value stores
Website	www.gbase8a.com	hyprcubd.com/ (offline)	ignite.apache.org	sphinxsearch.com	dbmx.net/­tkrzw
Technical documentation			apacheignite.readme.io/­docs	sphinxsearch.com/­docs
Developer		Hyprcubd, Inc.	Apache Software Foundation	Sphinx Technologies Inc.	Mikio Hirabayashi
Initial release			2015	2001	2020
Current release	GBase 8a		Apache Ignite 2.6	3.4.1, July 2021	0.9.3, August 2020
License Commercial or Open Source	commercial	commercial	Open Source Apache 2.0	Open Source GPL version 2, commercial licence available	Open Source Apache Version 2.0
Cloud-based only Only available as a cloud service	no	yes	no	no	no
DBaaS offerings (sponsored links) Database as a Service Providers of DBaaS offerings, please contact us to be listed.
Implementation language		Go	C++, Java, .Net	C++	C++
Server operating systems		hosted	Linux OS X Solaris Windows	FreeBSD Linux NetBSD OS X Solaris Windows	Linux macOS
Data scheme		yes	yes	yes	schema-free
Typing predefined data types such as float or date		yes time, int, uint, float, string	yes	no	no
XML support Some form of processing data in XML format, e.g. support for XML data structures, and/or support for XPath, XQuery or XSLT.		no	yes		no
Secondary indexes		no	yes	yes full-text index on all search fields
SQL Support of SQL		SQL-like query language	ANSI-99 for query and DML statements, subset of DDL	SQL-like query language (SphinxQL)	no
APIs and other access methods		gRPC (https)	HDFS API Hibernate JCache JDBC ODBC Proprietary protocol RESTful HTTP API Spring Data	Proprietary protocol
Supported programming languages			C# C++ Java PHP Python Ruby Scala	C++ unofficial client library Java Perl unofficial client library PHP Python Ruby unofficial client library	C++ Java Python Ruby
Server-side scripts Stored procedures		no	yes (compute grid and cache interceptors can be used instead)	no	no
Triggers		no	yes (cache interceptors and events)	no	no
Partitioning methods Methods for storing different data on different nodes			Sharding	Sharding Partitioning is done manually, search queries against distributed index is supported	none
Replication methods Methods for redundantly storing data on multiple nodes			yes (replicated cache)	none	none
MapReduce Offers an API for user-defined Map/Reduce methods		no	yes (compute grid and hadoop accelerator)	no	no
Consistency concepts Methods to ensure consistency in a distributed system		Eventual Consistency	Immediate Consistency		Immediate Consistency
Foreign keys Referential integrity		no	no	no	no
Transaction concepts Support to ensure data integrity after non-atomic manipulations of data		no	ACID	no
Concurrency Support for concurrent manipulation of data		no	yes	yes	yes
Durability Support for making data persistent		yes	yes	yes The original contents of fields are not stored in the Sphinx index.	yes
In-memory capabilities Is there an option to define some or all structures to be held in-memory only.		no	yes		yes using specific database classes
User concepts Access control		token access	Security Hooks for custom implementations	no	no
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
	GBase	Hyprcubd	Ignite	Sphinx	Tkrzw Successor of Tokyo Cabinet and Kyoto Cabinet
DB-Engines blog posts