DB-EnginesExtremeDB: the embedded DBMS for embedded systemsEnglish
Deutsch
Knowledge Base of Relational and NoSQL Database Management Systemsprovided by solid IT

DBMS > Amazon Redshift vs. Teradata Aster vs. TigerGraph

System Properties Comparison Amazon Redshift vs. Teradata Aster vs. TigerGraph

Please select another system to include it in the comparison.

Editorial information provided by DB-Engines
NameAmazon Redshift  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.
DescriptionLarge scale data warehouse service for use with business intelligence toolsPlatform 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 DBMSRelational DBMSGraph DBMS
DB-Engines Ranking infomeasures the popularity of database management systemsranking trend
Trend Chart
Score22.42
Rank#33  Overall
#19  Relational DBMS
Score1.57
Rank#132  Overall
#10  Graph DBMS
Websiteaws.amazon.com/­redshiftwww.tigergraph.com
Technical documentationdocs.aws.amazon.com/­redshiftdocs.tigergraph.com
DeveloperAmazon (based on PostgreSQL)Teradata
Initial release201220052017
License infoCommercial or Open Sourcecommercialcommercialcommercial
Cloud-based only infoOnly available as a cloud serviceyesnono
DBaaS offerings (sponsored links) infoDatabase as a Service

Providers of DBaaS offerings, please contact us to be listed.
Implementation languageCC++
Server operating systemshostedLinuxLinux
Data schemeyesFlexible 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 dateyesyesyes
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.noyes infoin Aster File Storeno
Secondary indexesrestrictedyes
SQL infoSupport of SQLyes infodoes not fully support an SQL-standardyesSQL-like query language (GSQL)
APIs and other access methodsJDBC
ODBC
ADO.NET
JDBC
ODBC
OLE DB
GSQL (TigerGraph Query Language)
Kafka
RESTful HTTP/JSON API
Supported programming languagesAll languages supporting JDBC/ODBCC
C#
C++
Java
Python
R
C++
Java
Server-side scripts infoStored proceduresuser defined functions infoin PythonR packagesyes
Triggersnonono
Partitioning methods infoMethods for storing different data on different nodesShardingSharding
Replication methods infoMethods for redundantly storing data on multiple nodesyesyes 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 methodsnoyes infoSQL Map-Reduce Frameworkyes
Consistency concepts infoMethods to ensure consistency in a distributed systemImmediate ConsistencyImmediate Consistency or Eventual Consistency depending on configuration
Foreign keys infoReferential integrityyes infoinformational only, not enforced by the systemnoyes infoRelationships in graphs
Transaction concepts infoSupport to ensure data integrity after non-atomic manipulations of dataACIDACIDACID
Concurrency infoSupport for concurrent manipulation of datayesyesyes
Durability infoSupport for making data persistentyesyesyes
In-memory capabilities infoIs there an option to define some or all structures to be held in-memory only.yesnono
User concepts infoAccess controlfine grained access rights according to SQL-standardfine grained access rights according to SQL-standardRole-based access control
More information provided by the system vendor
Amazon RedshiftTeradata AsterTigerGraph
Specific characteristicsTigerGraph is a native graph database, with massively parallel processing and fully...
» more
Competitive advantagesTigerGraph is the fastest and most scalable graph platform, powered by a native parallel...
» more
Typical application scenariosAnti Money Laundering Real-Time Fraud Detection Customer 360 Real-Time Personalized...
» more
Key customersFour out of the top five global banks use TigerGraph for real-time fraud detection....
» more
Market metricsANALYST RESEARCH Nov 2020: TigerGraph Named A Leader For Graph Data Platforms - TigerGraph...
» more
Licensing and pricing modelsTry 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
3rd partiesCData: Connect to Big Data & NoSQL through standard Drivers.
» more

DBHawk: Secure access to SQL, NoSQL and Cloud databases with an all-in-one solution.
» more

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

More resources
Amazon RedshiftTeradata AsterTigerGraph
DB-Engines blog posts

Cloud-based DBMS's popularity grows at high rates
12 December 2019, Paul Andlinger

The popularity of cloud-based DBMSs has increased tenfold in four years
7 February 2017, Matthias Gelbmann

Increased popularity for consuming DBMS services out of the cloud
2 October 2015, Paul Andlinger

show all

Recent citations in the news

Amazon Redshift Data Sharing Now Generally Available
20 March 2021, InfoQ.com

Domo Expands AWS Relationship
24 March 2021, TechDecisions

Amazon Launches Lookout For Metrics
26 March 2021, Forbes

AWS Graviton2 Chips A 'Big Savings Over Intel': Flickr CEO
17 March 2021, CRN

MarkLogic Adds AWS Glue Connector for Simpler Cloud Data Integration
7 April 2021, StreetInsider.com

provided by Google News

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

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

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

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

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

provided by Google News

TigerGraph's Graph + AI Summit 2021 to Feature 40+ Sessions, Live Workshops and Speakers from JPMorgan Chase, NewDay, Pinterest, Jaguar Land Rover and More
12 April 2021, The Korea Bizwire

Technical University of Denmark Uses TigerGraph to Help Find More Effective Treatments for Acute Lymphoblastic Leukemia
29 March 2021, The Korea Bizwire

The 7 Best Graph Databases to Consider for 2021
29 March 2021, Solutions Review

Graph Database Market 2021 by Technology Advancements – Fluree, IBM, Tigergraph, Oracle, Tibco Software, Franz, Arangodb, Cray, Sparcity Technologies, Orientdb, OpenLink Software, Neo4j
31 March 2021, The Courier

TigerGraph raises $105M Series C for its enterprise graph database
17 February 2021, TechCrunch

provided by Google News

Job opportunities

Data Analyst
Amazon Advertising LLC, New York, NY

Data Specialist
Springfield Empowerment Zone Partnership (SEZP), Springfield, MA

Senior SQL Data Analyst - JO3554
Moorecroft Systems, Remote

Business Intelligence (BI) Engineer - Entry Level
HelioCampus, Inc., Chapel Hill, NC

Sr. Database Engineer - AWS, Amazon Redshift
Amazon Web Services, Inc., New York, NY

Supervisor - Digital Operations
MAXIMUS, Remote

Data Scientists – Machine Learning
Brielle Technologies, Alpharetta, GA

Data Analytics Consultant
Verizon, Lake Mary, FL

Data Analytics Consultant
Verizon, Basking Ridge, NJ

Director, Data Analytics and Business Intelligence
Bio-Reference Laboratories, Inc., Elmwood Park, NJ

Technical Support Eng. (East Coast) -Remote
TigerGraph, California

Commercial Account Executive
TigerGraph, Illinois

Sales Director, West
TigerGraph, Redwood City, CA

Cloud Sales Specialist
TigerGraph, Illinois

Enterprise Account Executive
TigerGraph, Illinois

jobs by Indeed




Share this page

Featured Products

Vertica logo

The fastest unified analytical warehouse at extreme scale with in-database Machine Learning. Try Vertica for free with no time limit.

Neo4j logo

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

Datastax Astra logo

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

Couchbase logo

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

MariaDB logo

SkySQL, the ultimate
MariaDB cloud, is here.

Get started with SkySQL today!

Present your product here