DBMS > Ehcache vs. Sphinx vs. Tibero
System Properties Comparison Ehcache vs. Sphinx vs. Tibero
Please select another system to include it in the comparison.
|Editorial information provided by DB-Engines|
|Name||Ehcache Xexclude from comparison||Sphinx Xexclude from comparison||Tibero Xexclude from comparison|
|Description||A widely adopted Java cache with tiered storage options||Open source search engine for searching in data from different sources, e.g. relational databases||A secure RDBMS, designed for easy portability from Oracle|
|Primary database model||Key-value store||Search engine||Relational DBMS|
|Developer||Terracotta Inc, owned by Software AG||Sphinx Technologies Inc.||TmaxSoft|
|Current release||3.10.0, March 2022||3.4.1, July 2021||6, April 2015|
|License Commercial or Open Source||Open Source Apache Version 2; commercial licenses available||Open Source GPL version 2, commercial licence available||commercial|
|Cloud-based only Only available as a cloud service||no||no||no|
|DBaaS offerings (sponsored links) Database as a Service|
Providers of DBaaS offerings, please contact us to be listed.
|Implementation language||Java||C++||C and Assembler|
|Server operating systems||All OS with a Java VM||FreeBSD|
|Typing predefined data types such as float or date||yes||no||yes|
|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|
|Secondary indexes||no||yes full-text index on all search fields||yes|
|SQL Support of SQL||no||SQL-like query language (SphinxQL)||yes|
|APIs and other access methods||JCache||Proprietary protocol||JDBC|
Oracle Call Interface (OCI)
|Supported programming languages||Java||C++ unofficial client library|
Perl unofficial client library
Ruby unofficial client library
|Server-side scripts Stored procedures||no||no||Persistent Stored Procedure (PSM)|
|Triggers||yes Cache Event Listeners||no||yes|
|Partitioning methods Methods for storing different data on different nodes||Sharding by using Terracotta Server||Sharding Partitioning is done manually, search queries against distributed index is supported||horizontal partitioning by range, hash, list or composite|
|Replication methods Methods for redundantly storing data on multiple nodes||yes by using Terracotta Server||none||Multi-source replication|
|MapReduce Offers an API for user-defined Map/Reduce methods||no||no||no|
|Consistency concepts Methods to ensure consistency in a distributed system||Tunable Consistency (Strong, Eventual, Weak)||Immediate Consistency|
|Foreign keys Referential integrity||no||no||yes|
|Transaction concepts Support to ensure data integrity after non-atomic manipulations of data||yes supports JTA and can work as an XA resource||no||ACID|
|Concurrency Support for concurrent manipulation of data||yes||yes||yes|
|Durability Support for making data persistent||yes using a tiered cache-storage approach||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.||yes||no planned for next version|
|User concepts Access control||no||no||fine grained access rights according to SQL-standard (SQL 92, SQL 99)|
More information provided by the system vendor
We invite representatives of system vendors to contact us for updating and extending the system information,
Related products and services
We invite representatives of vendors of related products to contact us for presenting information about their offerings here.
|DB-Engines blog posts|
The DB-Engines ranking includes now search engines
|Recent citations in the news|
Jira Data Center user? Here's a critical Ehcache vulnerability to spoil your day
Warning over Java libraries and deserialization security weaknesses
Setting Up Distributed Infinispan Cache with Hibernate and Spring
Java News Roundup: JEP Updates, GraalVM Code to OpenJDK ...
Java deserialization vulnerabilities explained and how to defend against them
provided by Google News
Pure Color | James Romm
The Pirate Bay was recently down for over a week due to a DDoS attack
Land art megasculpture built on stolen Indigenous land in Nevada
Best Full-Text Search Engines to Maximize Search Experience for ...
Germans experiment with integrated motor and electronics for ...
provided by Google News
Tmax deploys advanced database management system at UITM's disaster recovery...
Open-source DBMS becoming battleground of public cloud
CTOS strengthens its database management system with TmaxSoft
Hyundai and Kia Say Good-bye to Oracle and Choose Tmax as ...
Daegu Government Integrated Data Center to Propose Open ...
provided by Google News
Director of Software Engineering
Full Stack Developer
Software Engineer Staff
Backend Developer -GB4371
Principal Platform Developer (Remote)
Share this page