DBMS > H2GIS vs. Hypertable vs. TerarkDB
System Properties Comparison H2GIS vs. Hypertable vs. TerarkDB
Please select another system to include it in the comparison.
|Editorial information provided by DB-Engines|
|Name||H2GIS Xexclude from comparison||Hypertable Xexclude from comparison||TerarkDB Xexclude from comparison|
|Hypertable has stopped its further development with March 2016 and is removed from the DB-Engines ranking.|
|Description||Spatial extension of H2||An open source BigTable implementation based on distributed file systems such as Hadoop||A key-value store forked from RocksDB with advanced compression algorithms. It can be used standalone or as a storage engine for MySQL and MongoDB|
|Primary database model||Spatial DBMS||Wide column store||Key-value store|
|Secondary database models||Relational DBMS|
|Current release||0.9.8.11, March 2016|
|License Commercial or Open Source||Open Source LGPL 3.0||Open Source GNU version 3. Commercial license available||commercial restricted open source version available|
|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||Linux|
Windows an inofficial Windows port is available
|Typing predefined data types such as float or date||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||no|
|Secondary indexes||yes||restricted only exact value or prefix value scans||no|
|SQL Support of SQL||yes||no||no|
|APIs and other access methods||C++ API|
|Supported programming languages||Java||C++|
|Server-side scripts Stored procedures||yes based on H2||no||no|
|Partitioning methods Methods for storing different data on different nodes||none||Sharding||none|
|Replication methods Methods for redundantly storing data on multiple nodes||yes based on H2||selectable replication factor on file system level||none|
|MapReduce Offers an API for user-defined Map/Reduce methods||no||yes||no|
|Consistency concepts Methods to ensure consistency in a distributed system||Immediate Consistency||Immediate Consistency|
|Foreign keys Referential integrity||yes||no||no|
|Transaction concepts Support to ensure data integrity after non-atomic manipulations of data||ACID||no||no|
|Concurrency Support for concurrent manipulation of data||yes, multi-version concurrency control (MVCC)||yes||yes|
|Durability Support for making data persistent||yes||yes||yes|
|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||yes based on H2||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,
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|
NoSQL Database Market Growth and Key Dynamics 2023 ...
Why We Built Cloud Native Object Storage for PostgreSQL with ...
TimescaleDB goes distributed; implements ‘Chunking’ over ‘Sharding’ for scaling-out
NoSQL Basics: Features, Types, and Examples
NoSQL Market Size, Industry Share, Leading Players, Growth and ...
provided by Google News
Understand NVMe 2.0 specification and its related features
Terark, A Chinese Startup, May Have Just Revolutionized How Data Is Stored, Accessed & Analyzed
provided by Google News
Share this page