DB-EnginesExtremeDB: is hard real time possible with a dbms?English
Deutsch
Knowledge Base of Relational and NoSQL Database Management Systemsprovided by solid IT

DBMS > CrateDB vs. GraphDB vs. Teradata Aster vs. TigerGraph vs. Vertica

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

Editorial information provided by DB-Engines
NameCrateDB  Xexclude from comparisonGraphDB infoformer name: OWLIM  Xexclude from comparisonTeradata Aster  Xexclude from comparisonTigerGraph  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.
DescriptionDistributed Date Store based on LuceneEnterprise-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-timeColumnar relational DBMS designed to handle modern analytic workloads, enabling fast query performance
Primary database modelRelational DBMS
Search engine
Graph DBMS
RDF store
Relational DBMSGraph DBMSRelational 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
Score2.86
Rank#103  Overall
#6  Graph DBMS
#3  RDF stores
Score2.02
Rank#120  Overall
#9  Graph DBMS
Score19.90
Rank#35  Overall
#21  Relational DBMS
Websitecrate.iowww.ontotext.comwww.tigergraph.comwww.vertica.com
Technical documentationcrate.io/­docsgraphdb.ontotext.com/­documentationdocs.tigergraph.comwww.vertica.com/­docs/­10.0.x/­HTML/­Content/­Home.htm
DeveloperCrateOntotextTeradataVertica / Micro Focus infoprior to that Hewlett Packard
Initial release20132000200520172005
Current release9.8, June 2021Vertica 10.0 Software, May 2020
Vertica for SQL on Hadoop 10.0 Software, May 2020
License infoCommercial or Open SourceOpen Sourcecommercial infoSome plugins of GraphDB Workbench are open sourcedcommercialcommercialcommercial infoLimited community edition free
Cloud-based only infoOnly available as a cloud servicenonononono 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 languageJavaJavaC++
Server operating systemsAll OS with a Java 7 (and higher) VMAll OS with a Java VM
Linux
OS X
Windows
LinuxLinuxLinux
Data schemeFlexible Schema (defined schema, partial schema, schema free)schema-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 Storeyesyes infoUnstructured data can be stored in specific Flex-Tables
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.nonoyes infoin Aster File Storenoyes
Secondary indexesyesyes, supports real-time synchronization and indexing in SOLR/Elastic search/Lucene and GeoSPARQL geometry data indexesyesno infoThe concept of 'projections' can be used instead of indexes.
SQL infoSupport of SQLyes, but no triggers and constraintsstored SPARQL accessed as SQL using Apache Calcite through JDBC/ODBCyesSQL-like query language (GSQL)yes infonearly full SQL99 without support for indexes and triggers
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
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
ADO.NET
JDBC
Kafka
ODBC
Proprietary protocol
RESTful HTTP 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
C#
Clojure
Java
JavaScript (Node.js)
PHP
Python
Ruby
Scala
C
C#
C++
Java
Python
R
C++
Java
C++
Java
Perl
Python
R
Server-side scripts infoStored proceduresuser defined functionswell-defined plugin interfaces; JavaScript server-side extensibilityR packagesyesyes
Triggersnonononono
Partitioning methods infoMethods for storing different data on different nodesShardingnoneShardingSharding infoSegmentation, Projection Segmentation, Hash Segmentation
Replication methods infoMethods for redundantly storing data on multiple nodesselectable replication factorMulti-source replicationyes infoDimension tables are replicated across all nodes in the cluster. The number of replicas for the file store can be configured.Multi-source replication infoCluster level and Object level replication
MapReduce infoOffers an API for user-defined Map/Reduce methodsnonoyes infoSQL Map-Reduce Frameworkyesyes infowith Vertica Connector for Hadoop
Consistency concepts infoMethods to ensure consistency in a distributed systemEventual Consistency
Read Your Own Writes Consistency infofor primary key lookups
Immediate Consistency, Eventual consistency (configurable in cluster mode per master or individual client request)Immediate Consistency or Eventual Consistency depending on configurationImmediate Consistency
Foreign keys infoReferential integritynoyes infoConstraint checkingnoyes infoRelationships in graphsyes
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 strategyACIDACIDACIDACID
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.nonono
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 controlfine grained access rights according to SQL-standard; supports Kerberos, LDAP, Ident and hash
More information provided by the system vendor
CrateDBGraphDB infoformer name: OWLIMTeradata AsterTigerGraphVertica infoVertica Analytics Platform
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
Columnar storage, MPP, Hybrid storage model, Aggressive data compression, High availability,...
» 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
Performance at exabyte scale, Deploy anywhere, Open source innovation, Analysis in...
» 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
Communication and network analytics, Embedded analytics, Fraud monitoring and Risk...
» 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
Abiba Systems, Adform, adMarketplace, AmeriPride, Anritsu, AOL, Avito, Auckland Transport,...
» 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
Cost-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
CrateDBGraphDB infoformer name: OWLIMTeradata AsterTigerGraphVertica infoVertica Analytics Platform
Recent citations in the news

Smart Solution Digitalizes and Optimizes Operational Processes – Metrology and Quality News - Online Magazine
15 January 2022, "metrology 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

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 and Synaptica join forces with a shared product roadmap to speed up the development of Enterprise Knowledge Graphs.
16 November 2020, PRNewswire

Ontotext's GraphDB 9.0 Open-sources its Front-end and Engine Plugins to Empower Knowledge Graph Solutions
3 October 2019, 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

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

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

provided by Google News

TigerGraph roars into APAC
26 January 2022, ComputerWeekly.com

TigerGraph appoints Harry Powell as Head of Industry Solutions to develop targeted vertical solutions for customers and partners
19 January 2022, GlobeNewswire

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 expands its graph data library with 20 new algorithms
11 November 2021, VentureBeat

provided by Google News

Enterprise Database Management System (DBMS) Market larger companies list: Microsoft, IBM, Oracle, SAP, Teradata, Vertica, InterSystems, Alibaba Cloud, AWS, MarkLogic, MongoDB, Google Cloud, Cloudera, MariaDB Corporation, Knack, TeamDesk by F
27 January 2022, Construction News Portal

Enterprise Database Management System (DBMS) Market Is Booming Worldwide : Teradata, MongoDB, Google Cloud, MarkLogic
25 January 2022, Digital Journal

Data 2022 outlook, part one: Will data clouds get easier? Will streaming get off its own island?
3 January 2022, ZDNet

Top 5 elements needed for a successful data warehouse
30 December 2021, TechTarget

Vertica Accelerator is Now Available on AWS
28 September 2021, Database Trends and Applications

provided by Google News

Job opportunities

Data Pipeline Engineer III, Search Engineering
Mailchimp, California

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

Project Management Senior Advisor - Taxonomy (USA Remote)
Dell Technologies, Texas

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

BI Analyst
Crackle Plus, Santa Monica, CA

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

Data Scientists – Machine Learning
Brielle Technologies, Alpharetta, GA

Data Architect
Presidio, Orlando, FL

Consultant - Data Engineer
Insygnum, Chicago, IL

Technical Support Engneer. (East Coast) -Remote
TigerGraph, Georgia

Sales Development Representative I
TigerGraph, Colorado

Vice President of Marketing
TigerGraph, California

Global Controller
TigerGraph, California

Technical Support Engineer. (Central -Remote)
TigerGraph, Texas

QA Engineer - Database Server at Vertica
Vertica, Cambridge, MA

Systems Software Engineer at Vertica (REMOTE / WORK FROM HOME)
Vertica, Cambridge, MA

Remote Vertica DBA
Trova, Hire, NE

Data Engineer
GLOBAL SOFTWARE RESOURCES (GSR), Remote

Database Engineer - Vertica
The Trade Desk, Irvine, CA

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.

Neo4j logo

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

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.

AllegroGraph logo

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

Present your product here