DB-EnginesExtremeDB: the first and only COTS deterministic embedded database management system for mission- and safety-critical hard real-time applicationsEnglish
Deutsch
Knowledge Base of Relational and NoSQL Database Management Systemsprovided by solid IT

DBMS > Apache Drill vs. BoltDB vs. Heroic vs. Teradata Aster vs. Tibero

System Properties Comparison Apache Drill vs. BoltDB vs. Heroic vs. Teradata Aster vs. Tibero

Editorial information provided by DB-Engines
NameApache Drill  Xexclude from comparisonBoltDB  Xexclude from comparisonHeroic  Xexclude from comparisonTeradata Aster  Xexclude from comparisonTibero  Xexclude from comparison
Teradata Aster has been integrated into other Teradata systems and therefore will be removed from the DB-Engines ranking.
DescriptionSchema-free SQL Query Engine for Hadoop, NoSQL and Cloud StorageAn embedded key-value store for Go.Time Series DBMS built at Spotify based on Cassandra or Google Cloud Bigtable, and ElasticSearchPlatform for big data analytics on multistructured data sources and typesA secure RDBMS, designed for easy portability from Oracle
Primary database modelDocument store
Relational DBMS
Key-value storeTime Series DBMSRelational DBMSRelational DBMS
DB-Engines Ranking infomeasures the popularity of database management systemsranking trend
Trend Chart
Score2.97
Rank#105  Overall
#19  Document stores
#53  Relational DBMS
Score0.56
Rank#228  Overall
#33  Key-value stores
Score0.09
Rank#309  Overall
#27  Time Series DBMS
Score2.10
Rank#119  Overall
#58  Relational DBMS
Websitedrill.apache.orggithub.com/­boltdb/­boltspotify.github.io/­heroic/­#!/­indexwww.tmaxsoft.com/­products/­tibero
Technical documentationdrill.apache.org/­docsspotify.github.io/­heroic/­#!/­docs/­overviewtechnet.tmaxsoft.com/­upload/­download/­online/­tibero/­pver-20150504-000002/­index.html
DeveloperApache Software FoundationSpotifyTeradataTmaxSoft
Initial release20122013201420052003
Current release1.19.0, June 20216, April 2015
License infoCommercial or Open SourceOpen Source infoApache Version 2Open Source infoMIT LicenseOpen Source infoApache 2.0commercialcommercial
Cloud-based only infoOnly available as a cloud servicenonononono
DBaaS offerings (sponsored links) infoDatabase as a Service

Providers of DBaaS offerings, please contact us to be listed.
Implementation languageGoJavaC and Assembler
Server operating systemsLinux
OS X
Windows
BSD
Linux
OS X
Solaris
Windows
LinuxAIX
HP-UX
Linux
Solaris
Windows
Data schemeschema-freeschema-freeschema-freeFlexible Schema (defined schema, partial schema, schema free) infodefined schema within the relational store; partial schema or schema free in the Aster File Storeyes
Typing infopredefined data types such as float or dateyesnoyesyesyes
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.nononoyes infoin Aster File Storeyes
Secondary indexesnonoyes infovia Elasticsearchyesyes
SQL infoSupport of SQLSQL SELECT statement is SQL:2003 compliantnonoyesyes
APIs and other access methodsJDBC
ODBC
RESTful HTTP API
HQL (Heroic Query Language, a JSON-based language)
HTTP API
ADO.NET
JDBC
ODBC
OLE DB
JDBC
ODBC
ODP.NET
Oracle Call Interface (OCI)
Tibero CLI
Supported programming languagesC++GoC
C#
C++
Java
Python
R
C
C#
C++
Cobol
Java
Objective-C
Perl
PHP
Python
Ruby
Visual Basic
Server-side scripts infoStored proceduresuser defined functionsnonoR packagesPersistent Stored Procedure (PSM)
Triggersnonononoyes
Partitioning methods infoMethods for storing different data on different nodesShardingnoneShardingShardinghorizontal partitioning infoby range, hash, list or composite
Replication methods infoMethods for redundantly storing data on multiple nodesnoneyesyes infoDimension tables are replicated across all nodes in the cluster. The number of replicas for the file store can be configured.Multi-source replication
Source-replica replication
MapReduce infoOffers an API for user-defined Map/Reduce methodsyesnonoyes infoSQL Map-Reduce Frameworkno
Consistency concepts infoMethods to ensure consistency in a distributed systemnonenoneEventual Consistency
Immediate Consistency
Immediate Consistency or Eventual Consistency depending on configurationImmediate Consistency
Foreign keys infoReferential integritynonononoyes
Transaction concepts infoSupport to ensure data integrity after non-atomic manipulations of datanoyesnoACIDACID
Concurrency infoSupport for concurrent manipulation of datayesyesyesyesyes
Durability infoSupport for making data persistentDepending on the underlying data sourceyesyesyesyes
In-memory capabilities infoIs there an option to define some or all structures to be held in-memory only.Depending on the underlying data sourcenononono infoplanned for next version
User concepts infoAccess controlDepending on the underlying data sourcenofine grained access rights according to SQL-standardfine grained access rights according to SQL-standard (SQL 92, SQL 99)

More information provided by the system vendor

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 DrillBoltDBHeroicTeradata AsterTibero
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

What is Apache Hadoop? Understanding Hadoop Ecosystem & Architecture | ITBE
9 September 2021, IT Business Edge

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

SQL-on-Hadoop tech Apache Drill is ready to use and part of MapR's distro
16 September 2014, Gigaom

provided by Google News

An overview of the Teradata Aster Analytics platform
31 May 2017, TechTarget

Teradata platform helps big-data analysts ask the right questions
23 October 2013, GCN.com

Teradata puts Aster on Hadoop, adds 'Listener' For IoT
21 October 2015, ZDNet

Teradata Aster gets graph database, HDFS-compatible file store
8 October 2013, ZDNet

Teradata Aster Analytics Going Places: On Hadoop and AWS
24 August 2016, PR Newswire

provided by Google News

Daegu Government Integrated Data Center to Propose Open-Source Database Management Systems for Tenant Companies
14 April 2021, Etnews

TmaxData Succeeds in Applying Its Database Management System to ARM Server
3 May 2019, Etnews

Manage Your Database with TIBERO
24 October 2011, Korea IT Times

TmaxData to supply database management software to Hyundai, Kia
12 June 2019, Korea Times

Hyundai and Kia Say Good-bye to Oracle and Choose Tmax as DBMS Vendor
13 June 2019, BusinessKorea

provided by Google News

Job opportunities

Big Data/SQL Developer
LPL Financial, South Carolina

Jr. DevOps Engineer/ Database
OpenVPN Inc., Remote

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

Senior Engineering Manager, Data Product Development
Visa, Austin, TX

Data Scientists – Machine Learning
Brielle Technologies, Alpharetta, GA

Data Management and Analytics Director
Infipact, Jackson, MS

Data Management and Analytics Director
Eminence Consulting Services, Jackson, MS

Senior Director, Digital Strategy and Analytics
Bio-Reference Laboratories, Inc., Elmwood Park, NJ

DATA ANALYTICS AND REPORTING SPECIALIST
Montefiore Medical Center, Tarrytown, NY

jobs by Indeed



Share this page

Featured Products

Couchbase logo

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

MariaDB logo

SkySQL, the ultimate
MariaDB cloud, is here.

Get started with SkySQL today!

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.

Neo4j logo

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

AllegroGraph logo

Graph Database Leader for AI Knowledge Graph Applications - The Most Secure Graph Database Available.
Free Download

Present your product here