DBMS > 4D vs. Apache Phoenix vs. Geode
System Properties Comparison 4D vs. Apache Phoenix vs. Geode
Please select another system to include it in the comparison.
|Editorial information provided by DB-Engines|
|Name||4D former name: 4th Dimension Xexclude from comparison||Apache Phoenix Xexclude from comparison||Geode Xexclude from comparison|
|Description||Application development environment with integrated database management system||A scale-out RDBMS with evolutionary schema built on Apache HBase||Geode is a distributed data container, pooling memory, CPU, network resources, and optionally local disk across multiple processes|
|Primary database model||Relational DBMS||Relational DBMS||Key-value store|
|Developer||4D, Inc||Apache Software Foundation||Originally developed by Gemstone. They outsourced the project to Apache in 2015 but still deliver a commercial version as Gemfire.|
|Current release||v18 R5, January 2021||5.0-HBase2, July 2018 and 4.15-HBase1, December 2019||1.1, February 2017|
|License Commercial or Open Source||commercial||Open Source Apache Version 2.0||Open Source Apache Version 2; commercial licenses available as Gemfire|
|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||OS X|
|All OS with a Java VM the JDK (8 or later) is also required|
|Data scheme||yes||yes late-bound, schema-on-read capabilities||schema-free|
|Typing predefined data types such as float or date||yes||yes||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.||yes||no||no|
|SQL Support of SQL||yes close to SQL 92||yes||SQL-like query language (OQL)|
|APIs and other access methods||ODBC|
RESTful HTTP API by using 4D Mobile
|JDBC||Java Client API|
RESTful HTTP API
|Supported programming languages||4D proprietary IDE|
All JVM based languages
|Server-side scripts Stored procedures||yes||user defined functions||user defined functions|
|Triggers||yes||no||yes Cache Event Listeners|
|Partitioning methods Methods for storing different data on different nodes||none||Sharding||Sharding|
|Replication methods Methods for redundantly storing data on multiple nodes||Multi-source replication||Multi-source replication|
|MapReduce Offers an API for user-defined Map/Reduce methods||no||Hadoop integration||no|
|Consistency concepts Methods to ensure consistency in a distributed system||Immediate Consistency||Immediate Consistency or Eventual Consistency||Eventual Consistency|
|Foreign keys Referential integrity||yes||no||no|
|Transaction concepts Support to ensure data integrity after non-atomic manipulations of data||ACID||ACID||yes, on a single node|
|Concurrency Support for concurrent manipulation of data||yes||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.||no||yes||yes|
|User concepts Access control||Users and groups||Access Control Lists (using HBase ACL) for RBAC, integration with Apache Ranger for RBAC & ABAC, multi-tenancy||Access rights per client and object definable|
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.
|4D former name: 4th Dimension||Apache Phoenix||Geode|
|DB-Engines blog posts|
MySQL, PostgreSQL and Redis are the winners of the March ranking
Cloudera's HBase PaaS offering now supports Complex Transactions
|Recent citations in the news|
Fourth-dimension roller coaster
4th Dimension 4D Database Excessive CPU Utilization – Iowa City Technology Services
About 4D, Inc (Software Company)
ibrewster/p4d: Python database module for the 4D database system
Dimension IV Consulting, LLC
provided by Google News
phoenix-queryserver/CHANGES.md at master · apache/phoenix-queryserver
Bulk loading into Apache Phoenix using psql - Azure HDInsight
Apache Phoenix — A Conversation with PMC Chair James Taylor
Resolve the error "Cache of region boundaries are out of date" in Amazon EMR
PhoenixNonRetryableRuntimeException: Could not load/instantiate class org.apache.phoenix.query ...
provided by Google News
The Apache Software Foundation Welcomes VMware as its Newest ...
Where Does Apache Geode Fit in CQRS Architectures?
RDBMS and Apache Geode Data Movement: Low Latency ETL ...
Apache Geode Test Automation and Continuous Integration ...
HPE buys query acceleration platform Ampool to boost Ezmeral ...
provided by Google News
Home Remodeling Carpenter
Security Specialist 1
Senior Solutions Architect
Senior Full Stack Software Developer in Test
Sr. Big Data Consultant
Data Scientist, TRADOC G-2
Python Software Engineer
Share this page