DB-EnginesInfluxDB: Focus on building software with an easy-to-use serverless, scalable time series platformEnglish
Deutsch
Knowledge Base of Relational and NoSQL Database Management Systemsprovided by solid IT

DBMS > Apache Drill vs. Geode vs. Splice Machine vs. TerarkDB

System Properties Comparison Apache Drill vs. Geode vs. Splice Machine vs. TerarkDB

Please select another system to include it in the comparison.

Editorial information provided by DB-Engines
NameApache Drill  Xexclude from comparisonGeode  Xexclude from comparisonSplice Machine  Xexclude from comparisonTerarkDB  Xexclude from comparison
DescriptionSchema-free SQL Query Engine for Hadoop, NoSQL and Cloud StorageGeode is a distributed data container, pooling memory, CPU, network resources, and optionally local disk across multiple processesOpen-Source SQL RDBMS for Operational and Analytical use cases with native Machine Learning, powered by Hadoop and SparkA 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 modelDocument store
Relational DBMS
Key-value storeRelational DBMSKey-value store
DB-Engines Ranking infomeasures the popularity of database management systemsranking trend
Trend Chart
Score2.73
Rank#105  Overall
#19  Document stores
#54  Relational DBMS
Score1.69
Rank#132  Overall
#24  Key-value stores
Score0.86
Rank#185  Overall
#89  Relational DBMS
Score0.04
Rank#325  Overall
#50  Key-value stores
Websitedrill.apache.orggeode.apache.orgsplicemachine.comgithub.com/­Terark/­terarkdb
Technical documentationdrill.apache.org/­docsgeode.apache.org/­docsdoc.splicemachine.comgithub.com/­Terark/­terarkdb/­wiki
DeveloperApache Software FoundationOriginally developed by Gemstone. They outsourced the project to Apache in 2015 but still deliver a commercial version as Gemfire.Splice MachineTerark
Initial release2012200220142016
Current release1.19.0, June 20211.1, February 20173.1, March 2021
License infoCommercial or Open SourceOpen Source infoApache Version 2Open Source infoApache Version 2; commercial licenses available as GemfireOpen Source infoAGPL 3.0, commercial license availablecommercial inforestricted open source version available
Cloud-based only infoOnly available as a cloud servicenononono
DBaaS offerings (sponsored links) infoDatabase as a Service

Providers of DBaaS offerings, please contact us to be listed.
Implementation languageJavaJavaC++
Server operating systemsLinux
OS X
Windows
All OS with a Java VM infothe JDK (8 or later) is also requiredLinux
OS X
Solaris
Windows
Data schemeschema-freeschema-freeyesschema-free
Typing infopredefined data types such as float or dateyesyesyesno
XML support infoSome form of processing data in XML format, e.g. support for XML data structures, and/or support for XPath, XQuery or XSLT.nonono
Secondary indexesnonoyesno
SQL infoSupport of SQLSQL SELECT statement is SQL:2003 compliantSQL-like query language (OQL)yesno
APIs and other access methodsJDBC
ODBC
RESTful HTTP API
Java Client API
Memcached protocol
RESTful HTTP API
JDBC
Native Spark Datasource
ODBC
C++ API
Java API
Supported programming languagesC++.Net
All JVM based languages
C++
Groovy
Java
Scala
C#
C++
Java
JavaScript (Node.js)
Python
R
Scala
C++
Java
Server-side scripts infoStored proceduresuser defined functionsuser defined functionsyes infoJavano
Triggersnoyes infoCache Event Listenersyesno
Partitioning methods infoMethods for storing different data on different nodesShardingShardingShared Nothhing Auto-Sharding, Columnar Partitioningnone
Replication methods infoMethods for redundantly storing data on multiple nodesMulti-source replicationMulti-source replication
Source-replica replication
none
MapReduce infoOffers an API for user-defined Map/Reduce methodsyesnoYes, via Full Spark Integrationno
Consistency concepts infoMethods to ensure consistency in a distributed systemnoneEventual ConsistencyImmediate Consistency
Foreign keys infoReferential integritynonoyesno
Transaction concepts infoSupport to ensure data integrity after non-atomic manipulations of datanoyes, on a single nodeACIDno
Concurrency infoSupport for concurrent manipulation of datayesyesyes, multi-version concurrency control (MVCC)yes
Durability infoSupport for making data persistentDepending on the underlying data sourceyesyesyes
In-memory capabilities infoIs there an option to define some or all structures to be held in-memory only.Depending on the underlying data sourceyesyesyes
User concepts infoAccess controlDepending on the underlying data sourceAccess rights per client and object definableAccess rights for users, groups and roles according to SQL-standardno
More information provided by the system vendor
Apache DrillGeodeSplice MachineTerarkDB
News

How to Break Data Silos to Drive Enterprise-Wide AI
11 June 2021

Point-in-Time Correctness in Machine Learning
1 June 2021

The Compliance Nightmare Lurking in Your Data Science Team
6 May 2021

Whose Job Is It Anyway?
23 April 2021

How Optimizing MLOps Can Revolutionize Enterprise AI
15 April 2021

We invite representatives of system vendors to contact us for updating and extending the system information,
and for displaying vendor-provided information such as key customers, competitive advantages and market metrics.

Related products and services

We invite representatives of vendors of related products to contact us for presenting information about their offerings here.

More resources
Apache DrillGeodeSplice MachineTerarkDB
Recent citations in the news

Apache Drill improves big data SQL query engine
31 August 2021, TechTarget

Apache Drill Poised to Crack Tough Data Challenges
19 May 2015, Datanami

MapR Advances Support for Flexible and High Performance Analytics on JSON and S3 Data with Apache Drill
30 January 2019, Business Wire

Apache Drill Adds YARN Support
17 April 2018, iProgrammer

Google’s Real Time Big Data Tool Cloned By Apache Drill
17 August 2012, TechCrunch

provided by Google News

SD Times news digest: Google announces Prediction Framework; Flutter releases MIX; Apache news roundup
3 January 2022, SDTimes.com

Event-Driven Architectures with Apache Geode and Spring Integration
20 March 2019, InfoQ.com

Where Does Apache Geode Fit in CQRS Architectures?
18 December 2016, InfoQ.com

RDBMS and Apache Geode Data Movement: Low Latency ETL Pipeline by Using Cloud-Native Event Driven Microservices
30 June 2018, InfoQ.com

High-Performance Data Processing with Spring Cloud Data Flow and Geode
28 June 2020, InfoQ.com

provided by Google News

Splice Machine Announces New Capabilities to Support Real-Time AI with Version 3.1 of its Scale-Out SQL Database
9 March 2021, PRNewswire

Machine learning data pipeline outfit Splice Machine files for insolvency
26 August 2021, The Register

Splice Machine Launches the Splice Machine Feature Store to Simplify Feature Engineering and Democratize Machine Learning
19 January 2021, PRNewswire

Splice Machine database travels full circle to predictive application platform
25 September 2017, ZDNet

Splice Machine 3.0 Offers New and Improved SQL Updates
15 January 2020, Database Trends and Applications

provided by Google News

Understand NVMe 2.0 specification and its related features
4 January 2022, TechTarget

ByteDance eyes big data push with Terark acquisition EJINSIGHT - ejinsight.com
30 April 2019, EJ Insight

Terark, A Chinese Startup, May Have Just Revolutionized How Data Is Stored, Accessed & Analyzed
26 June 2017, Indiatimes.com

provided by Google News

Job opportunities

Big Data/SQL Developer
LPL Financial, South Carolina

Software Engineer (Back-end and Full-stack Development)
Concourse Labs, Texas

Senior Architect/Software Engineer (Back-end and Full-stack Development)
Concourse Labs, Texas

Data Solutions Engineer - Opportunity for Working Remotely New York City, NY
VMware, New York, NY

Data Solutions Engineer - Opportunity for Working Remotely New York, NY
VMware, New York, NY

Software Engineer - Tanzu Gemfire - Opportunity for Working Remotely New York, NY
VMware, New York, NY

Data Solutions Engineer - Opportunity for Working Remotely Washington, DC
VMware, Washington, DC

Data Solutions Engineer - Opportunity for Working Remotely Wichita, KS
VMware, Wichita, KS

jobs by Indeed



Share this page

Featured Products

Vertica logo

Vertica Accelerator. The fastest analytics and machine learning, delivered as SaaS, with automated setup, administration, and management. Free trial.

Datastax Astra logo

Build cloud-native apps fast with Astra, the open-source, multi-cloud stack for
modern data apps.
Get started with 80GB free.

MariaDB logo

SkySQL, the ultimate
MariaDB cloud, is here.

Get started with SkySQL today!

Neo4j logo

See for yourself how a graph database can make your life easier.
Use Neo4j online for free.

Couchbase logo

The modern database for enterprise applications. Build fast. Scale Big. Save more.
Get started today.

Present your product here