DBMS > Hive vs. InfinityDB vs. TerminusDB
System Properties Comparison Hive vs. InfinityDB vs. TerminusDB
Please select another system to include it in the comparison.
|Editorial information provided by DB-Engines|
|Name||Hive Xexclude from comparison||InfinityDB Xexclude from comparison||TerminusDB former name was DataChemist Xexclude from comparison|
|Description||data warehouse software for querying and managing large distributed datasets, built on Hadoop||A Java embedded Key-Value Store which extends the Java Map interface||Scalable Graph Database platform making enterprise data available by exploiting inferred entities and relationships|
|Primary database model||Relational DBMS||Key-value store||Graph DBMS|
|Secondary database models||Document store|
|Developer||Apache Software Foundation initially developed by Facebook||Boiler Bay Inc.||DataChemist Ltd.|
|Current release||3.1.3, April 2022||4.0||11.0.0, January 2023|
|License Commercial or Open Source||Open Source Apache Version 2||commercial||Open Source GPL V3|
|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||Java||Prolog, Rust|
|Server operating systems||All OS with a Java VM||All OS with a Java VM||Linux|
|Data scheme||yes||yes nested virtual Java Maps, multi-value, logical â€˜tuple spaceâ€™ runtime Schema upgrade||yes|
|Typing predefined data types such as float or date||yes||yes all Java primitives, Date, CLOB, BLOB, huge sparse arrays||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||no|
|Secondary indexes||yes||no manual creation possible, using inversions based on multi-value capability|
|SQL Support of SQL||SQL-like DML and DDL statements||no||SQL-like query language (WOQL)|
|APIs and other access methods||JDBC|
|Access via java.util.concurrent.ConcurrentNavigableMap Interface|
Proprietary API to InfinityDB ItemSpace (boilerbay.com/docs/ItemSpaceDataStructures.htm)
RESTful HTTP API
WOQL (Web Object Query Language)
|Supported programming languages||C++|
|Server-side scripts Stored procedures||yes user defined functions and integration of map-reduce||no||yes|
|Partitioning methods Methods for storing different data on different nodes||Sharding||none||Graph Partitioning|
|Replication methods Methods for redundantly storing data on multiple nodes||selectable replication factor||none||Journaling Streams|
|MapReduce Offers an API for user-defined Map/Reduce methods||yes query execution via MapReduce||no||no|
|Consistency concepts Methods to ensure consistency in a distributed system||Eventual Consistency||Immediate Consistency READ-COMMITTED or SERIALIZED|
|Foreign keys Referential integrity||no||no manual creation possible, using inversions based on multi-value capability||yes|
|Transaction concepts Support to ensure data integrity after non-atomic manipulations of data||no||ACID Optimistic locking for transactions; no isolation for bulk loads||ACID|
|Concurrency Support for concurrent manipulation of data||yes||yes||yes|
|Durability Support for making data persistent||yes||yes||yes in-memory journaling|
|In-memory capabilities Is there an option to define some or all structures to be held in-memory only.||no|
|User concepts Access control||Access rights for users, groups and roles||no||Role-based access control|
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.
|Hive||InfinityDB||TerminusDB former name was DataChemist|
|DB-Engines blog posts|
Why is Hadoop not listed in the DB-Engines Ranking?
|Recent citations in the news|
Tabular, the 'independent data platform' from Apache Iceberg ...
Tabular, the vendor-neutral data store based on Apache Iceberg ...
Tabular's Iceberg vision goes from Netflix and chill to database thrill
Severe Azure HDInsight flaws highlight dangers of cross-site scripting
Azure HDInsight Flaws Allowed Data Access, Session Hijacking, Payload Delivery
provided by Google News
Databáze Redis (nejenom) pro vývojáře používající Python
provided by Google News
TerminusDB Introduces TerminusCMS, Brand Networks Acquired by ...
How TerminusDB is commercializing its open source graph database
Dublin-based data collaboration tool TerminusDB raises €3.6 million ...
Irish start-ups received €28m from Enterprise Ireland in 2021
Irish start-ups received €27m from Enterprise Ireland in 2022
provided by Google News
GCP-Apache Druid Engineer
GCP-Apache Druid engineer
Data Analyst (two positions)
Druid Data Engineer #23-00077
Share this page