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 > Amazon Redshift vs. Google Cloud Firestore vs. TigerGraph vs. TinkerGraph vs. Vertica

System Properties Comparison Amazon Redshift vs. Google Cloud Firestore vs. TigerGraph vs. TinkerGraph vs. Vertica

Editorial information provided by DB-Engines
NameAmazon Redshift  Xexclude from comparisonGoogle Cloud Firestore  Xexclude from comparisonTigerGraph  Xexclude from comparisonTinkerGraph  Xexclude from comparisonVertica infoVertica Analytics Platform  Xexclude from comparison
DescriptionLarge scale data warehouse service for use with business intelligence toolsCloud Firestore is an auto-scaling document database for storing, syncing, and querying data for mobile and web apps. It offers seamless integration with other Firebase and Google Cloud Platform products.A complete, distributed, parallel graph computing platform supporting web-scale data analytics in real-timeA lightweight, in-memory graph engine that serves as a reference implementation of the TinkerPop3 APIColumnar relational DBMS designed to handle modern analytic workloads, enabling fast query performance
Primary database modelRelational DBMSDocument storeGraph DBMSGraph DBMSRelational DBMS
Secondary database modelsDocument store
Spatial DBMS
DB-Engines Ranking infomeasures the popularity of database management systemsranking trend
Trend Chart
Score25.85
Rank#31  Overall
#18  Relational DBMS
Score8.92
Rank#52  Overall
#9  Document stores
Score2.02
Rank#120  Overall
#9  Graph DBMS
Score0.12
Rank#306  Overall
#29  Graph DBMS
Score19.90
Rank#35  Overall
#21  Relational DBMS
Websiteaws.amazon.com/­redshiftfirebase.google.com/­products/­firestorewww.tigergraph.comtinkerpop.apache.org/­docs/­current/­reference/­#tinkergraph-gremlinwww.vertica.com
Technical documentationdocs.aws.amazon.com/­redshiftfirebase.google.com/­docs/­firestoredocs.tigergraph.comwww.vertica.com/­docs/­10.0.x/­HTML/­Content/­Home.htm
DeveloperAmazon (based on PostgreSQL)GoogleVertica / Micro Focus infoprior to that Hewlett Packard
Initial release20122017201720092005
Current releaseVertica 10.0 Software, May 2020
Vertica for SQL on Hadoop 10.0 Software, May 2020
License infoCommercial or Open SourcecommercialcommercialcommercialOpen Source infoApache 2.0commercial infoLimited community edition free
Cloud-based only infoOnly available as a cloud serviceyesyesnonono 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 languageCC++Java
Server operating systemshostedhostedLinuxLinux
Data schemeyesschema-freeyesschema-freeyes 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.nonononoyes
Secondary indexesrestrictedyesnono infoThe concept of 'projections' can be used instead of indexes.
SQL infoSupport of SQLyes infodoes not fully support an SQL-standardnoSQL-like query language (GSQL)noyes infonearly full SQL99 without support for indexes and triggers
APIs and other access methodsJDBC
ODBC
Android
gRPC (using protocol buffers) API
iOS
JavaScript API
RESTful HTTP API
GSQL (TigerGraph Query Language)
Kafka
RESTful HTTP/JSON API
TinkerPop 3ADO.NET
JDBC
Kafka
ODBC
Proprietary protocol
RESTful HTTP API
Supported programming languagesAll languages supporting JDBC/ODBCGo
Java
JavaScript
JavaScript (Node.js)
Objective-C
Python
C++
Java
Groovy
Java
C++
Java
Perl
Python
R
Server-side scripts infoStored proceduresuser defined functions infoin Pythonyes, Firebase Rules & Cloud Functionsyesnoyes
Triggersnoyes, with Cloud Functionsnonono
Partitioning methods infoMethods for storing different data on different nodesShardingShardingnoneSharding infoSegmentation, Projection Segmentation, Hash Segmentation
Replication methods infoMethods for redundantly storing data on multiple nodesyesMulti-source replicationnoneMulti-source replication infoCluster level and Object level replication
MapReduce infoOffers an API for user-defined Map/Reduce methodsnoUsing Cloud Dataflowyesnoyes infowith Vertica Connector for Hadoop
Consistency concepts infoMethods to ensure consistency in a distributed systemImmediate ConsistencyImmediate ConsistencynoneImmediate Consistency
Foreign keys infoReferential integrityyes infoinformational only, not enforced by the systemnoyes infoRelationships in graphsyes infoRelationships in graphsyes
Transaction concepts infoSupport to ensure data integrity after non-atomic manipulations of dataACIDyesACIDnoACID
Concurrency infoSupport for concurrent manipulation of datayesyesyesnoyes
Durability infoSupport for making data persistentyesyesyesoptionalyes
In-memory capabilities infoIs there an option to define some or all structures to be held in-memory only.yesnoyes
User concepts infoAccess controlfine grained access rights according to SQL-standardAccess rights for users, groups and roles based on Google Cloud Identity and Access Management. Security Rules for 3rd party authentication using Firebase Auth.Role-based access controlnofine grained access rights according to SQL-standard; supports Kerberos, LDAP, Ident and hash
More information provided by the system vendor
Amazon RedshiftGoogle Cloud FirestoreTigerGraphTinkerGraphVertica infoVertica Analytics Platform
Specific characteristicsTigerGraph 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 advantagesTigerGraph 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 scenariosAnti Money Laundering Real-Time Fraud Detection Customer 360 Real-Time Personalized...
» more
Communication and network analytics, Embedded analytics, Fraud monitoring and Risk...
» more
Key customersFour 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 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
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
3rd partiesSQLFlow: Provides a visual representation of the overall flow of data. Automated SQL data lineage analysis across Databases, ETL, Business Intelligence, Cloud and Hadoop environments by parsing SQL Script and stored procedure.
» more

CData: 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 RedshiftGoogle Cloud FirestoreTigerGraphTinkerGraphVertica infoVertica Analytics Platform
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

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

show all

Recent citations in the news

upGrad shifts majority of its IT infrastructure to Amazon Web Services
25 January 2022, Economic Times

Confluent partners with AWS to accelerate cloud adoption with real-time data for organizations
29 January 2022, Help Net Security

Serverless at re:Invent: Where should Amazon Redshift go?
6 December 2021, ZDNet

AWS Introduces Amazon Redshift Serverless
1 December 2021, InfoQ.com

DataSecOps Pioneer Satori Sees Six-Fold Increase in Users, Twenty-Five-Fold Increase in Queries, Joins AWS Partner Network
18 January 2022, Yahoo Finance

provided by Google News

Google Cloud is making changes to help startups grow
28 January 2022, TechRadar

Google Prediction Framework addresses data pipeline drudgery
5 January 2022, InfoWorld

Google Announces Framework For Data Science Predictions
13 January 2022, iProgrammer

SD Times news digest: Google adds Firebase extension for Google Pay; Facebook develops self-supervised algorithm; AppFire acquires Numbered Headings
21 January 2022, SDTimes.com

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

provided by Google News

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

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

provided by Google News

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

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

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

Database Management Software Market 2022 Growth Trends, Analysis By Future Demand – Oracle Inc., Couchbase Server, MongoDB, iWay Software, InterSystems, Informatica Corporation, etc – Construction News Portal
28 January 2022, Construction News Portal

provided by Google News

Job opportunities

Software Development Engineer - Amazon Redshift Query Processing, Query Processing
Amazon.com Services LLC, Boston, MA

Software Development Engineer - Amazon Redshift Query Processing
Amazon.com Services LLC, Seattle, WA

Amazon Redshift - Software Development Engineer
Amazon.com Services LLC, Austin, TX

Senior Business Analyst (Amazon Redshift)
Amazon Dev Center U.S., Inc., Bellevue, WA

Software Development Engineer - AWS, Amazon Redshift
Amazon.com Services LLC, Redmond, WA

IT Tech Specialist 1 - Remote
Mayo Clinic, Rochester, MN

Front End Developer
Kiswe, New Providence, NJ

Backend Engineer
Descartes Labs, Remote

Full-Stack Engineer
ManageXR, San Francisco, CA

Backend Developer
Kiswe, New Providence, NJ

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

ML Engineer - (San Diego - Remote)
TigerGraph, California

Data Scientist Consultant (East)- Remote
TigerGraph, Georgia

NLP Data Scientist
nwo.ai, New York, NY

Sales Development Representative II
TigerGraph, Minnesota

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

Database Administrator
Cotiviti, Inc., United States

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

Database Administrator
SYNNEX Corporation, Fremont, CA

Client Software Engineer at Vertica
Vertica, Cambridge, MA

jobs by Indeed



Share this page

Featured Products

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.

MariaDB logo

SkySQL, the ultimate
MariaDB cloud, is here.

Get started with SkySQL today!

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.

Vertica logo

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

Present your product here