DBMS > Ehcache vs. Interbase vs. Manticore Search
System Properties Comparison Ehcache vs. Interbase vs. Manticore Search
Please select another system to include it in the comparison.
|Editorial information provided by DB-Engines|
|Name||Ehcache Xexclude from comparison||Interbase Xexclude from comparison||Manticore Search Xexclude from comparison|
|Description||A widely adopted Java cache with tiered storage options||Light-weight proven RDBMS originally from Borland||Multi-storage database for search, including full-text search.|
|Primary database model||Key-value store||Relational DBMS||Search engine|
|Secondary database models||Time Series DBMS using the Manticore Columnar Library|
|Developer||Terracotta Inc, owned by Software AG||Embarcadero||Manticore Software|
|Current release||3.10.0, March 2022||InterBase 2020, December 2019||6.0, February 2023|
|License Commercial or Open Source||Open Source Apache Version 2; commercial licenses available||commercial||Open Source GPL version 2|
|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.
|Server operating systems||All OS with a Java VM||Android|
|Data scheme||schema-free||yes||Fixed schema|
|Typing predefined data types such as float or date||yes||yes||Int, Bigint, Float, Timestamp, Bit, Int array, Bigint array, JSON, Boolean|
|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||no export as XML data possible||Can index from XML|
|Secondary indexes||no||yes||yes full-text index on all search fields|
|SQL Support of SQL||no||yes||SQL-like query language|
|APIs and other access methods||JCache||ADO.NET|
RESTful HTTP/JSON API
RESTful HTTP/SQL API
SQL over MySQL
|Supported programming languages||Java||.Net|
|Server-side scripts Stored procedures||no||yes Interbase procedure and trigger language||user defined functions|
|Triggers||yes Cache Event Listeners||yes||no|
|Partitioning methods Methods for storing different data on different nodes||Sharding by using Terracotta Server||none||Sharding Partitioning is done manually, search queries against distributed index is supported|
|Replication methods Methods for redundantly storing data on multiple nodes||yes by using Terracotta Server||Interbase Change Views||Synchronous replication based on Galera library|
|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||yes||no|
|Transaction concepts Support to ensure data integrity after non-atomic manipulations of data||yes supports JTA and can work as an XA resource||ACID||yes isolated transactions for atomic changes and binary logging for safe writes|
|Concurrency Support for concurrent manipulation of data||yes||yes Multiversion concurreny control||yes|
|Durability Support for making data persistent||yes using a tiered cache-storage approach||yes||yes The original contents of fields are not stored in the Manticore index.|
|In-memory capabilities Is there an option to define some or all structures to be held in-memory only.||yes||yes|
|User concepts Access control||no||fine grained access rights according to SQL-standard||no|
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.
|Recent citations in the news|
Security Bulletin 20 Sep 2023
Ehcache 3.0 Released with Revamped API and Off-Heap Storage
API Monitoring: Why It's Important and How to Do It Right
How to Work on an Unfamiliar Codebase
Critical Jira Flaw in Atlassian Could Lead to RCE
provided by Google News
Embarcadero Announces InterBase 2020, Flagship Database ...
BASEBALL SUPERCOPPA PIEMONTE U18/23 – Sconiftta per lo ...
Federazione Italiana Baseball Softball
Die Zukunft der Datenbanksysteme
L'Under 12 conquista il concentramento di finale di Coppa Toscana ...
provided by Google News
76 Stories To Learn About China
8 Google Alternatives: How to Search Crypto, the Dark Web, More
How To Develop Your Custom Autocorrect Implementation with ...
Highlighting in Search Results
Ordinals Surprise Bitcoin Community with NFT-like Addition to ...
provided by Google News
Sr. Microservices Developer
SENIOR SPECIALIST, Full-Stack Developer
Sr. Software Developer(Applications)
Tech Lead Microservices Developer
IT Development Manager
Share this page