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 > CrateDB vs. Elasticsearch vs. GraphDB vs. Teradata Aster vs. TigerGraph

System Properties Comparison CrateDB vs. Elasticsearch vs. GraphDB vs. Teradata Aster vs. TigerGraph

Editorial information provided by DB-Engines
NameCrateDB  Xexclude from comparisonElasticsearch  Xexclude from comparisonGraphDB infoformer name: OWLIM  Xexclude from comparisonTeradata Aster  Xexclude from comparisonTigerGraph  Xexclude from comparison
Teradata Aster has been integrated into other Teradata systems and therefore will be removed from the DB-Engines ranking.
DescriptionDistributed Date Store based on LuceneA distributed, RESTful modern search and analytics engine based on Apache Lucene infoElasticsearch lets you perform and combine many types of searches such as structured, unstructured, geo, and metricEnterprise-ready RDF and graph database with efficient reasoning, cluster and external index synchronization support. It supports also SQL JDBC access to Knowledge Graph and GraphQL over SPARQL.Platform for big data analytics on multistructured data sources and typesA complete, distributed, parallel graph computing platform supporting web-scale data analytics in real-time
Primary database modelRelational DBMS
Search engine
Search engineGraph DBMS
RDF store
Relational DBMSGraph DBMS
Secondary database modelsDocument store
Time Series DBMS
Document store
Spatial DBMS
DB-Engines Ranking infomeasures the popularity of database management systemsranking trend
Trend Chart
Score0.97
Rank#179  Overall
#87  Relational DBMS
#12  Search engines
Score160.75
Rank#8  Overall
#1  Search engines
Score2.86
Rank#103  Overall
#6  Graph DBMS
#3  RDF stores
Score2.02
Rank#120  Overall
#9  Graph DBMS
Websitecrate.iowww.elastic.co/­elasticsearchwww.ontotext.comwww.tigergraph.com
Technical documentationcrate.io/­docswww.elastic.co/­guide/­en/­elasticsearch/­reference/­current/­index.htmlgraphdb.ontotext.com/­documentationdocs.tigergraph.com
DeveloperCrateElasticOntotextTeradata
Initial release20132010200020052017
Current release7.8.0, June 20209.8, June 2021
License infoCommercial or Open SourceOpen SourceOpen Source infoApache Version 2; Elastic Licensecommercial infoSome plugins of GraphDB Workbench are open sourcedcommercialcommercial
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 languageJavaJavaJavaC++
Server operating systemsAll OS with a Java 7 (and higher) VMAll OS with a Java VMAll OS with a Java VM
Linux
OS X
Windows
LinuxLinux
Data schemeFlexible Schema (defined schema, partial schema, schema free)schema-free infoFlexible type definitions. Once a type is defined, it is persistentschema-free and OWL/RDFS-schema support; RDF shapesFlexible 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 dateyesyesyesyesyes
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 Storeno
Secondary indexesyesyes infoAll search fields are automatically indexedyes, supports real-time synchronization and indexing in SOLR/Elastic search/Lucene and GeoSPARQL geometry data indexesyes
SQL infoSupport of SQLyes, but no triggers and constraintsSQL-like query languagestored SPARQL accessed as SQL using Apache Calcite through JDBC/ODBCyesSQL-like query language (GSQL)
APIs and other access methodsADO.NET infocommunity maintained client
JDBC
MQTT (Message Queue Telemetry Transport)
PostgreSQL wire protocol
Prometheus Remote Read/Write
RESTful HTTP API
Java API
RESTful HTTP/JSON API
GeoSPARQL
GraphQL
GraphQL Federation
Java API
JDBC
RDF4J API
RDFS
RIO
Sail API
Sesame REST HTTP Protocol
SPARQL 1.1
ADO.NET
JDBC
ODBC
OLE DB
GSQL (TigerGraph Query Language)
Kafka
RESTful HTTP/JSON API
Supported programming languagesErlang
Go infocommunity maintained client
Java
JavaScript (Node.js) infocommunity maintained client
Perl infocommunity maintained client
PHP
Python
Ruby infocommunity maintained client
Scala infocommunity maintained client
.Net
Groovy
Community Contributed Clients
Java
JavaScript
Perl
PHP
Python
Ruby
.Net
C#
Clojure
Java
JavaScript (Node.js)
PHP
Python
Ruby
Scala
C
C#
C++
Java
Python
R
C++
Java
Server-side scripts infoStored proceduresuser defined functionsyeswell-defined plugin interfaces; JavaScript server-side extensibilityR packagesyes
Triggersnoyes infoby using the 'percolation' featurenonono
Partitioning methods infoMethods for storing different data on different nodesShardingShardingnoneSharding
Replication methods infoMethods for redundantly storing data on multiple nodesselectable replication factoryesMulti-source replicationyes infoDimension tables are replicated across all nodes in the cluster. The number of replicas for the file store can be configured.
MapReduce infoOffers an API for user-defined Map/Reduce methodsnoES-Hadoop Connectornoyes infoSQL Map-Reduce Frameworkyes
Consistency concepts infoMethods to ensure consistency in a distributed systemEventual Consistency
Read Your Own Writes Consistency infofor primary key lookups
Eventual Consistency infoSynchronous doc based replication. Get by ID may show delays up to 1 sec. Configurable write consistency: one, quorum, allImmediate Consistency, Eventual consistency (configurable in cluster mode per master or individual client request)Immediate Consistency or Eventual Consistency depending on configuration
Foreign keys infoReferential integritynonoyes infoConstraint checkingnoyes infoRelationships in graphs
Transaction concepts infoSupport to ensure data integrity after non-atomic manipulations of datano infounique row identifiers can be used for implementing an optimistic concurrency control strategynoACIDACIDACID
Concurrency infoSupport for concurrent manipulation of datayesyesyesyesyes
Durability infoSupport for making data persistentyesyesyesyesyes
In-memory capabilities infoIs there an option to define some or all structures to be held in-memory only.noMemcached and Redis integrationnono
User concepts infoAccess controlrights management via user accountsDefault Basic authentication through RDF4J client, or via Java when run with cURL, default token-based in the Workbench or via Rest API, optional access through OpenID or Kerberos single sign-on.fine grained access rights according to SQL-standardRole-based access control
More information provided by the system vendor
CrateDBElasticsearchGraphDB infoformer name: OWLIMTeradata AsterTigerGraph
Specific characteristicsCrateDB is an open source distributed SQL database that spreads data and processing...
» more
GraphDB Enterprise is a high-performance semantic repository created by Ontotext....
» more
TigerGraph is a native graph database, with massively parallel processing and fully...
» more
Competitive advantagesCrateDB is typically used in operational analytics applications, particularly those...
» more
GraphDB allows you to link text and data in big knowledge graphs. It’s easy to experiment...
» more
TigerGraph is the fastest and most scalable graph platform, powered by a native parallel...
» more
Typical application scenariosCrateDB is ideal for integrating and analyzing streams of data--often machine-generated--in...
» more
Metadata enrichment and management, linked open data publishing, semantic inferencing...
» more
Anti Money Laundering Real-Time Fraud Detection Customer 360 Real-Time Personalized...
» more
Key customersCrateDB customers include McAfee, Qualtrics , Nokia, NBC Golfnow , Digital Domain...
» more
BBC, Press Association, Financial Times, DK, Euromoney, The British Museum, Getty...
» more
Four out of the top five global banks use TigerGraph for real-time fraud detection....
» more
Market metricsThe CrateDB open source project was started in 2014. CrateDB was the winner of TechCrunch...
» more
GraphDB is the most utilized semantic triplestore for mission-critical enterprise...
» more
ANALYST RESEARCH Nov 2020: TigerGraph Named A Leader For Graph Data Platforms - TigerGraph...
» more
Licensing and pricing modelsCrateDB pricing CrateDB Community Edition is open source and free to use under the...
» more
GraphDB-Free is free to use. SE and Enterprise are licensed per CPU-Core used. Perpetual...
» more
Try TigerGraph for Free in the Cloud or On Prem https://www.tigergraph.com/get-tigergraph/...
» 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
CrateDBElasticsearchGraphDB infoformer name: OWLIMTeradata AsterTigerGraph
DB-Engines blog posts

PostgreSQL is the DBMS of the Year 2017
2 January 2018, Paul Andlinger, Matthias Gelbmann

Elasticsearch moved into the top 10 most popular database management systems
3 July 2017, Matthias Gelbmann

MySQL, PostgreSQL and Redis are the winners of the March ranking
2 March 2016, Paul Andlinger

show all

Recent citations in the news

Crate.io Expands CrateDB Cloud with the Launch of CrateDB Edge
15 April 2021, GlobeNewswire

CrateDB 4.5 takes distributed SQL database open source
24 March 2021, TechTarget

Crate.io Announces CrateDB Will Switch to an Elasticsearch Fork Following License Change
11 February 2021, GlobeNewswire

Crate.io raises $10M to grow its database platform
15 June 2021, VentureBeat

Crate.io Releases New Version of CrateDB – the Database Built to Support IoT and IIoT Businesses
5 September 2019, GlobeNewswire

provided by Google News

Elastic CEO reflects on Amazon spat, license switch, and the principles of open source
27 December 2021, VentureBeat

Elastic shares drop after co-founder of Banon steps down as CEO of software company
12 January 2022, CNBC

Qbox Joins Instaclustr, the Platform for Open Source Data
11 January 2022, GlobeNewswire

How to install Kibana Dashboard on Ubuntu 22.04 | 20.04 LTS
13 January 2022, Linux Shout

Walgreens moves to AI-driven search experience with Algolia
17 January 2022, VentureBeat

provided by Google News

Ontotext GraphDB 9.4 Enables SQL Access to Knowledge Graphs and Visual Mapping of Tabular Data to RDF
11 September 2020, PRNewswire

GraphDB 9.8 Brings Text Mining and Kafka Connectivity
2 June 2021, PRNewswire

Ontotext's GraphDB 9.0 Open-sources its Front-end and Engine Plugins to Empower Knowledge Graph Solutions
3 October 2019, PRNewswire

Ontotext Platform 3.4 Brings Better Search and Aggregation in Knowledge Graphs
15 April 2021, PRNewswire

What are graph database query languages?
3 September 2021, VentureBeat

provided by Google News

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

Big Data Analytics: Teradata Launches Aster Discovery Platform
9 October 2013, Data Center Knowledge

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

How to Select the Right Database for Time-Series Data – The New Stack
2 December 2021, thenewstack.io

provided by Google News

An Exclusive Interview with Kushal Bhanshali, India Country Manager of TigerGraph
31 December 2021, Analytics Insight

TigerGraph seeks to democratize graph databases
5 October 2021, VentureBeat

TigerGraph Appoints Pekka Kostamaa as Vice President of
9 December 2021, GlobeNewswire

TigerGraph expands its graph data library with 20 new algorithms
11 November 2021, VentureBeat

TigerGraph, Hewlett Packard Enterprise, and Xilinx Announce
19 October 2021, GlobeNewswire

provided by Google News

Job opportunities

Data Pipeline Engineer III, Search Engineering
Mailchimp, California

Data Engineer - Python & Agile required - Remote
Vesper Wave, Remote

Splunk Administrator
DP Professional, Remote

Front End Developer
Springhead Technologies, Remote

devops with aws elasticsearch
Formac Inc, Sunnyvale, CA

Elasticsearch - Director of Product Management
Referral Board, California

ElasticSearch Administrator
AMCHES, INC, Annapolis Junction, MD

Knowledge Graph and Semantics SME
CAPCO, Remote

Ontologist/Global Relationship Lead for Knowledge Management (USA Remote)
Dell Technologies, Round Rock, TX

Senior Advisor, Project/Program Management
Dell Technologies, Texas

Graph Databases Infrastructure Manager
JPMorgan Chase Bank, N.A., Jersey City, NJ

Analyst, Navigation & Digital Taxonomy - Remote
Lowe's, Mooresville, NC

Lead-Risk Management
Verizon, Alpharetta, GA

BI Analyst
Crackle Plus, Santa Monica, CA

Manager, Product and Business Intelligence
Social Native, Remote

Data Scientists – Machine Learning
Brielle Technologies, Alpharetta, GA

Jr. Software Engineer, Query Language - Remote
TigerGraph, California

Vice President of Marketing
TigerGraph, California

Knowledge Graph Consultant (USA Remote or Round Rock, TX)
Dell Technologies, Round Rock, TX

Software Manager, Relationship Engineering
vArmour Networks, Remote

Sr SW Engineer
Intuit, Los Angeles, CA

jobs by Indeed



Share this page

Featured Products

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.

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.

Vertica logo

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

Couchbase logo

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

Present your product here