DB-EnginesExtremeDB Active Replication featuresEnglish
Deutsch
Knowledge Base of Relational and NoSQL Database Management Systemsprovided by solid IT

DBMS > EXASOL vs. Google Cloud Firestore vs. Snowflake vs. TerarkDB vs. TimescaleDB

System Properties Comparison EXASOL vs. Google Cloud Firestore vs. Snowflake vs. TerarkDB vs. TimescaleDB

Editorial information provided by DB-Engines
NameEXASOL  Xexclude from comparisonGoogle Cloud Firestore  Xexclude from comparisonSnowflake  Xexclude from comparisonTerarkDB  Xexclude from comparisonTimescaleDB  Xexclude from comparison
DescriptionHigh-performance, in-memory, MPP database specifically designed for in-memory analytics.Cloud 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.Cloud-based data warehousing service for structured and semi-structured dataA key-value store forked from RocksDB with advanced compression algorithms. It can be used standalone or as a storage engine for MySQL and MongoDBA time series DBMS optimized for fast ingest and complex queries, based on PostgreSQL
Primary database modelRelational DBMSDocument storeRelational DBMSKey-value storeTime Series DBMS
Secondary database modelsRelational DBMS
DB-Engines Ranking infomeasures the popularity of database management systemsranking trend
Trend Chart
Score3.13
Rank#96  Overall
#48  Relational DBMS
Score8.05
Rank#51  Overall
#9  Document stores
Score18.22
Rank#35  Overall
#22  Relational DBMS
Score0.04
Rank#317  Overall
#50  Key-value stores
Score2.86
Rank#100  Overall
#6  Time Series DBMS
Websitewww.exasol.comfirebase.google.com/­products/­firestorewww.snowflake.comgithub.com/­Terark/­terarkdbwww.timescale.com
Technical documentationwww.exasol.com/­resourcesfirebase.google.com/­docs/­firestoredocs.snowflake.net/­manuals/­index.htmlgithub.com/­Terark/­terarkdb/­wikidocs.timescale.com
DeveloperExasolGoogleSnowflake Computing Inc.TerarkTimescale
Initial release20002017201420162017
License infoCommercial or Open Sourcecommercialcommercialcommercialcommercial inforestricted open source version availableOpen Source infoApache 2.0
Cloud-based only infoOnly available as a cloud servicenoyesyesnono
DBaaS offerings (sponsored links) infoDatabase as a Service

Providers of DBaaS offerings, please contact us to be listed.
Implementation languageC++C
Server operating systemshostedhostedLinux
OS X
Windows
Data schemeyesschema-freeyes infosupport of semi-structured data formats (JSON, XML, Avro)schema-freeyes
Typing infopredefined data types such as float or dateyesyesyesnonumerics, strings, booleans, arrays, JSON blobs, geospatial dimensions, currencies, binary data, other complex data types
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.nonoyesnoyes
Secondary indexesyesyesnoyes
SQL infoSupport of SQLyesnoyesnoyes infofull PostgreSQL SQL syntax
APIs and other access methods.Net
JDBC
ODBC
WebSocket
Android
gRPC (using protocol buffers) API
iOS
JavaScript API
RESTful HTTP API
CLI Client
JDBC
ODBC
C++ API
Java API
ADO.NET
JDBC
native C library
ODBC
streaming API for large objects
Supported programming languagesJava
Lua
Python
R
Go
Java
JavaScript
JavaScript (Node.js)
Objective-C
Python
JavaScript (Node.js)
Python
C++
Java
.Net
C
C++
Delphi
Java infoJDBC
JavaScript
Perl
PHP
Python
R
Ruby
Scheme
Tcl
Server-side scripts infoStored proceduresuser defined functionsyes, Firebase Rules & Cloud Functionsuser defined functionsnouser defined functions, PL/pgSQL, PL/Tcl, PL/Perl, PL/Python, PL/Java, PL/PHP, PL/R, PL/Ruby, PL/Scheme, PL/Unix shell
Triggersyesyes, with Cloud Functionsno infosimilar concept for controling cloud resourcesnoyes
Partitioning methods infoMethods for storing different data on different nodesShardingShardingyesnoneyes, across time and space (hash partitioning) attributes
Replication methods infoMethods for redundantly storing data on multiple nodesMulti-source replicationyesnoneSource-replica replication with hot standby and reads on replicas info
MapReduce infoOffers an API for user-defined Map/Reduce methodsyes infoHadoop integrationUsing Cloud Dataflownonono
Consistency concepts infoMethods to ensure consistency in a distributed systemImmediate ConsistencyImmediate ConsistencyImmediate ConsistencyImmediate Consistency
Foreign keys infoReferential integrityyesnoyesnoyes
Transaction concepts infoSupport to ensure data integrity after non-atomic manipulations of dataACIDyesACIDnoACID
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.yesnoyesno
User concepts infoAccess controlAccess rights for users, groups and roles 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.Users with fine-grained authorization concept, user roles and pluggable authenticationnofine grained access rights according to SQL-standard
More information provided by the system vendor
EXASOLGoogle Cloud FirestoreSnowflakeTerarkDBTimescaleDB
Specific characteristicsTimescale is the creator of TimescaleDB , the first open-source relational database...
» more
Competitive advantagesTimescaleDB is purpose-built to scale and handle time-series data workloads and is...
» more
Typical application scenariosDevOps and Infrastructure Monitoring All monitoring data is time-series data. Efficiently...
» more
Key customersTransferWise, Maersk, AppDynamics, Walmart, Comcast, LaunchDarkly, IBM, NOV, Cisco,...
» more
Market metricsWith over 9,000 GitHub stars and growing, 600,000 active databases, and an active...
» more
Licensing and pricing modelsTimescaleDB comes in 3 versions, including fully managed Cloud-hosted solutions*,...
» 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

General SQL Parser: Instantly adding parsing, decoding, analysis and rewrite SQL processing capability to your products.
» more
ClusterControl: the only management system you’ll ever need to take control of your open source database infrastructure.
» more

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

More resources
EXASOLGoogle Cloud FirestoreSnowflakeTerarkDBTimescaleDB
DB-Engines blog posts

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

show all

Recent citations in the news

Pharmascience to use Exasol database to improve reporting | Medical Devices & Pharma - Healthcare Global
16 February 2021, Healthcare News, Magazine and Website

Exasol Rated Best-in-Class Across 10 Measures in Dresner's ADI Report 2021
9 February 2021, Business Wire

A day in the life of… Deborah Thomas, CCO of analytics database firm Exasol
18 February 2021, Econsultancy

Exasol AG: Trading update for 2020 and outlook for 2021
23 February 2021, Yahoo Eurosport UK

In-memory OLAP Database Market, Top key players are- Altibase, IBM, Microsoft, Oracle, SAP SE, Exasol, Jedox, Kognitio, Mcobject, MemSQL, MicroStrategy, SAS Institute, Teradata, Terracotta, VoltDB – NeighborWebSJ
10 February 2021, NeighborWebSJ

provided by Google News

Google Cloud Supports Ruby on Cloud Functions
13 February 2021, InfoQ.com

Google Releases Eventarc into General Availability
31 January 2021, InfoQ.com

Google launches Cloud Firestore, a new document database for app developers
3 October 2017, TechCrunch

Google’s Cloud Firestore NoSQL database hits general availability
31 January 2019, TechCrunch

Google unveils Android Performance Tuner, Android GPU Inspector, and Cloud Firestore for game developers
23 March 2020, VentureBeat

provided by Google News

Paysafe Uses Snowflake to Power Cloud-based Approach to Data and Analytics
25 February 2021, MarTech Series

Snowflake, BlackRock forge partnership, connect Aladdin platform with Snowflake Data Cloud
22 February 2021, ZDNet

Alteryx, Snowflake Partner To Make Analytics & Data Science More Scalable, Accessible to 'Citizen' Analysts
23 February 2021, Integration Developers

Gluent Data Platform 4.1 Enables Migration to Snowflake without Rewriting Code
25 February 2021, PR Web

How Capital One Moved Its Data Analytics to the Cloud - SPONSOR CONTENT FROM SNOWFLAKE
23 February 2021, Harvard Business Review

provided by Google News

ByteDance eyes big data push with Terark acquisition EJINSIGHT
30 April 2019, EJ Insight

A Chinese company is making the cloud 200x faster
3 July 2017, TechNode

Terark, A Chinese Startup, May Have Just Revolutionized How Data Is Stored, Accessed & Analyzed
26 June 2017, Indiatimes.com

provided by Google News

QuestDB has built a lightning fast time series database. Can it build a business to match?
16 February 2021, TechRepublic

Timescale Brings Powerful Time-Series Data Analysis to Developers Worldwide, Now Available in 75+ Cloud Regions
12 August 2020, Business Wire

Timescale Launches Industry's First Multi-Node Relational Database for Time-Series Data, Giving Organizations Unprecedented Scale
29 October 2020, Business Wire

TimescaleDB Delivers Another Option for Time-Series Analytics
17 October 2019, Datanami

Timescale announces $15M investment and new enterprise version of TimescaleDB
29 January 2019, TechCrunch

provided by Google News

Job opportunities

Customer Success Manager
Exasol, Remote

Legal Counsel
Exasol, United States

Service Delivery Manager
Exasol, Atlanta, GA

Account Executive, US
Exasol, United States

Lead Product Designer
Exasol, San Francisco, CA

2021 Summer Intern - I.T. - Junior/Senior
UNITED PARCEL SERVICE, Lutherville-Timonium, MD

Principal Engineer
Grey Matter, Remote

Application Developer (JSx/GCP)
Cambria Solutions, Inc, Mississippi

Full Stack Developer Internship for Medical Start-up
Preventa Medical, Phoenix, AZ

Software Engineer
Descartes Labs, Remote

Data Analytics Mentor
Pathrise, Remote

Database Administrator - Remote
Dentsply Sirona, Pennsylvania

Database Administrator
Sciata, Phoenix, AZ

ETL Developer (Remote)
Trinity Logistics, Delaware

Certified Snowflake Developer
Data Meaning, Remote

Documentation Manager
Timescale, New York State

Director of Software Development
Apergy, The Woodlands, TX

Developer Marketing Manager
Timescale, New York State

Full Stack Engineer
Fox Robotics, Austin, TX

Sr. Software Engineer - Platforms
Armorblox, Oregon

jobs by Indeed




Share this page

Featured Products

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!

AllegroGraph logo

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

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..

Present your product here