DB-EnginesInfluxDB download bannerEnglish
Deutsch
Knowledge Base of Relational and NoSQL Database Management Systemsprovided by solid IT

DBMS > Ehcache vs. Ignite vs. Teradata Aster vs. Vertica

System Properties Comparison Ehcache vs. Ignite vs. Teradata Aster vs. Vertica

Please select another system to include it in the comparison.

Editorial information provided by DB-Engines
NameEhcache  Xexclude from comparisonIgnite  Xexclude from comparisonTeradata Aster  Xexclude from comparisonVertica infoVertica Analytics Platform  Xexclude from comparison
Teradata Aster has been integrated into other Teradata systems and therefore will be removed from the DB-Engines ranking.
DescriptionA widely adopted Java cache with tiered storage optionsApache Ignite is a memory-centric distributed database, caching, and processing platform for transactional, analytical, and streaming workloads, delivering in-memory speeds at petabyte scale.Platform for big data analytics on multistructured data sources and typesColumnar relational DBMS designed to handle modern analytic workloads, enabling fast query performance
Primary database modelKey-value storeKey-value store
Relational DBMS
Relational DBMSRelational DBMS
Secondary database modelsDocument store
DB-Engines Ranking infomeasures the popularity of database management systemsranking trend
Trend Chart
Score6.61
Rank#52  Overall
#8  Key-value stores
Score5.16
Rank#61  Overall
#10  Key-value stores
#34  Relational DBMS
Score22.20
Rank#30  Overall
#17  Relational DBMS
Websitewww.ehcache.orgignite.apache.orgwww.vertica.com
Technical documentationwww.ehcache.org/­documentationapacheignite.readme.io/­docswww.vertica.com/­documentation/­vertica/­9-3-x-documentation
DeveloperTerracotta Inc, owned by Software AGApache Software FoundationTeradataVertica / Micro Focus infoprior to that Hewlett Packard
Initial release2009201520052005
Current release3.8.0, July 2019Apache Ignite 2.6Vertica Analytics Platform 9.3.x, January 2020
License infoCommercial or Open SourceOpen Source infoApache Version 2; commercial licenses availableOpen Source infoApache 2.0commercialcommercial infoLimited community edition free
Cloud-based only infoOnly available as a cloud servicenononono infoAvailable on all major clouds - Amazon AWS, Microsoft Azure and Google Cloud Platform
DBaaS offerings (sponsored links) infoDatabase as a Service

Providers of DBaaS offerings, please contact us to be listed.
Implementation languageJavaC++, Java, .Net
Server operating systemsAll OS with a Java VMLinux
OS X
Solaris
Windows
LinuxLinux
Data schemeschema-freeyesFlexible Schema (defined schema, partial schema, schema free) infodefined schema within the relational store; partial schema or schema free in the Aster File Storeyes infoUnstructured data can be stored in specific Flex-Tables
Typing infopredefined data types such as float or dateyesyesyesyes
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.noyesyes infoin Aster File Storeyes
Secondary indexesnoyesyesno infoThe concept of 'projections' can be used instead of indexes.
SQL infoSupport of SQLnoANSI-99 for query and DML statements, subset of DDLyesyes infonearly full SQL99 without support for indexes and triggers
APIs and other access methodsJCacheHDFS API
Hibernate
JCache
JDBC
ODBC
Proprietary protocol
RESTful HTTP API
Spring Data
ADO.NET
JDBC
ODBC
OLE DB
ADO.NET
JDBC
Kafka
ODBC
Proprietary protocol
RESTful HTTP API
Supported programming languagesJavaC#
C++
Java
PHP
Python
Ruby
Scala
C
C#
C++
Java
Python
R
C++
Java
Perl
Python
R
Server-side scripts infoStored proceduresnoyes (compute grid and cache interceptors can be used instead)R packagesyes
Triggersyes infoCache Event Listenersyes (cache interceptors and events)nono
Partitioning methods infoMethods for storing different data on different nodesSharding infoby using Terracotta ServerShardingShardingSharding infoSegmentation, Projection Segmentation, Hash Segmentation
Replication methods infoMethods for redundantly storing data on multiple nodesyes infoby using Terracotta Serveryes (replicated cache)yes infoDimension tables are replicated across all nodes in the cluster. The number of replicas for the file store can be configured.Master-master replication infoCluster level and Object level replication
MapReduce infoOffers an API for user-defined Map/Reduce methodsnoyes (compute grid and hadoop accelerator)yes infoSQL Map-Reduce Frameworkyes infowith Vertica Connector for Hadoop
Consistency concepts infoMethods to ensure consistency in a distributed systemTunable Consistency (Strong, Eventual, Weak)Immediate ConsistencyImmediate Consistency or Eventual Consistency depending on configurationImmediate Consistency
Foreign keys infoReferential integritynononoyes
Transaction concepts infoSupport to ensure data integrity after non-atomic manipulations of datayes infosupports JTA and can work as an XA resourceACIDACIDACID
Concurrency infoSupport for concurrent manipulation of datayesyesyesyes
Durability infoSupport for making data persistentyes infousing a tiered cache-storage approachyesyesyes
In-memory capabilities infoIs there an option to define some or all structures to be held in-memory only.yesyesno
User concepts infoAccess controlnoSecurity Hooks for custom implementationsfine grained access rights according to SQL-standardfine grained access rights according to SQL-standard; supports Kerberos, LDAP, Ident and hash
More information provided by the system vendor
EhcacheIgniteTeradata AsterVertica infoVertica Analytics Platform
Specific characteristicsColumnar storage, MPP, Hybrid storage model, Aggressive data compression, High availability,...
» more
Competitive advantagesPerformance at exabyte scale, Deploy anywhere, Open source innovation, Analysis in...
» more
Typical application scenariosCommunication and network analytics, Embedded analytics, Fraud monitoring and Risk...
» more
Key customersAbiba Systems, Adform, adMarketplace, AmeriPride, Anritsu, AOL, Avito, Auckland Transport,...
» more
Licensing and pricing modelsCost-based models and subscription-based models are available
» more

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
EhcacheIgniteTeradata AsterVertica infoVertica Analytics Platform
Recent citations in the news

Ehcache 3.0 Released with Revamped API and Off-Heap Storage
2 May 2016, InfoQ.com

Memcached surpasses EhCache and Coherence in Java Job Demand
13 September 2011, InfoQ.com

Ehcache Joins Terracotta
18 August 2009, InfoQ.com

Hazelcast open source in-memory data grid secures $21.5 million funding, expands platform to real-time streaming data
20 June 2019, ZDNet

Open source Java caching vendors merge
20 August 2009, InfoWorld

provided by Google News

Apache Ignite team grants users' wish for better observability
12 March 2020, DevClass

GridGain Experts Share In-Memory Computing Strategies, Offer Practical Advice at Industry Events Around the World
2 March 2020, GlobeNewswire

news digest: .NET Core uninstall tool 1.0, Mozilla partners with KaiOS, and Apache Ignite 2.8 - SD Times
12 March 2020, SDTimes.com

news digest: Bill Gates steps down from Microsoft board of directors, Apache updates, and GitHub introduces new features for its teaching tools - SD Times
16 March 2020, SDTimes.com

GridGain Offers New Consulting Services Packages for Apache Ignite and GridGain Community Edition
1 August 2019, GlobeNewswire

provided by Google News

Chart-topper Neo4j makes connections in effort to nudge graph DBs into the mainstream
26 March 2020, The Register

Teradata ports Aster analytics to Hadoop
30 August 2016, ZDNet

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

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

Case study: Siemens reduces train failures with Teradata Aster
12 September 2016, RCR Wireless News

provided by Google News

Back with a bang: Vertica previews Big Data Conference's return after 4-year hiatus
27 March 2020, SiliconANGLE News

Octopai Announces Support of Tabular on Azure Analysis Services, Netezza, and Vertica
5 March 2020, Database Trends and Applications

The 28 Best Database Management Software Systems and Tools for 2020
13 March 2020, Solutions Review

Vertica in the Clouds
17 March 2020, Database Trends and Applications

Tech Conferences Are Being Canceled Due to Coronavirus
2 March 2020, Datanami

provided by Google News

Job opportunities

Full Stack Java Developer
IQ GATEWAY, Atlanta, GA

Backend Java Developer
USM Business Systems, Dallas, TX

Systems Specialist
otisitinc, Greenville, DE

Engineer, Software
T-Mobile, Atlanta, GA

Software Analyst/Developer
Verudix, Oak Brook, IL

Capital Markets Java Developer
Prutech Solutions, Charlotte, NC

Java J2EE Developer
Prutech Solutions, Charlotte, NC

Java/J2EE Developer
Tek Leaders, Charlotte, NC

Java Developer
Tek Leaders, Charlotte, NC

Full Stack Java Engineer
Nucleusteq, Phoenix, AZ

Data Scientists – Machine Learning
Brielle Technologies, Alpharetta, GA

Analytics Manager
JSToogood LLC, Austin, TX

Consultant - Data Engineer
Insygnum, Rolling Meadows, IL

Data Scientist
Spectrum, Stamford, CT

Data Engineer
Softvision - North America, Alpharetta, GA

Database Consultant
Amazon Web Services, Inc., Sunnyvale, CA

Database Migration Consultant
Amazon Web Services, Inc., Remote

Database Administrator
Domo, Inc., American Fork, UT

Database Administrator
MX, Lehi, UT

AMS Sales Director – Vertica
Micro Focus, Georgia

jobs by Indeed




Share this page

Featured Products

Datastax Luna logo

Simple, subscription-based support for open source
Apache Cassandra™ from the Cassandra experts.
Learn more.

AllegroGraph logo

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

MariaDB logo

How do MariaDB, Oracle MySQL and EnterpriseDB compare?
Get the white paper to
learn more.

Couchbase logo

SQL + JSON + NoSQL.
Power, flexibility & scale.
All open source.
Get started now.

Neo4j logo

Get your free copy of the new O'Reilly book Graph Algorithms with 20+ examples for
machine learning, graph analytics and more.

Present your product here