DB-EnginesInfluxDB download bannerEnglish
Deutsch
Knowledge Base of Relational and NoSQL Database Management Systemsprovided by solid IT

DBMS > Amazon Redshift vs. HBase vs. Sqrrl

System Properties Comparison Amazon Redshift vs. HBase vs. Sqrrl

Please select another system to include it in the comparison.

Editorial information provided by DB-Engines
NameAmazon Redshift  Xexclude from comparisonHBase  Xexclude from comparisonSqrrl  Xexclude from comparison
Sqrrl has been acquired by Amazon and became a part of Amazon Web Services. It has been removed from the DB-Engines ranking.
DescriptionLarge scale data warehouse service for use with business intelligence toolsWide-column store based on Apache Hadoop and on concepts of BigTableAdaptable, secure NoSQL built on Apache Accumulo
Primary database modelRelational DBMSWide column storeDocument store
Graph DBMS
Key-value store
Wide column store
DB-Engines Ranking infomeasures the popularity of database management systemsranking trend
Trend Chart
Score22.37
Rank#30  Overall
#17  Relational DBMS
Score49.11
Rank#22  Overall
#2  Wide column stores
Websiteaws.amazon.com/­redshifthbase.apache.orgsqrrl.com
Technical documentationdocs.aws.amazon.com/­redshifthbase.apache.org
DeveloperAmazon (based on PostgreSQL)Apache Software Foundation infoApache top-level project, originally developed by PowersetAmazon infooriginally Sqrrl Data, Inc.
Initial release201220082012
Current release2.2.0, June 2019
License infoCommercial or Open SourcecommercialOpen Source infoApache version 2commercial
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 languageCJavaJava
Server operating systemshostedLinux
Unix
Windows infousing Cygwin
Linux
Data schemeyesschema-free, schema definition possibleschema-free
Typing infopredefined data types such as float or dateyesoptions to bring your own types, AVROyes
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.nono
Secondary indexesrestrictednoyes
SQL infoSupport of SQLyes infodoes not fully support an SQL-standardnono
APIs and other access methodsJDBC
ODBC
Java API
RESTful HTTP API
Thrift
Accumulo Shell
Java API
JDBC
ODBC
RESTful HTTP API
Thrift
Supported programming languagesAll languages supporting JDBC/ODBCC
C#
C++
Groovy
Java
PHP
Python
Scala
Actionscript
C infousing GLib
C#
C++
Cocoa
Delphi
Erlang
Go
Haskell
Java
JavaScript
OCaml
Perl
PHP
Python
Ruby
Smalltalk
Server-side scripts infoStored proceduresuser defined functions infoin Pythonyes infoCoprocessors in Javano
Triggersnoyesno
Partitioning methods infoMethods for storing different data on different nodesShardingShardingSharding infomaking use of Hadoop
Replication methods infoMethods for redundantly storing data on multiple nodesyesMulti-source replication
Source-replica replication
selectable replication factor infomaking use of Hadoop
MapReduce infoOffers an API for user-defined Map/Reduce methodsnoyesyes
Consistency concepts infoMethods to ensure consistency in a distributed systemImmediate ConsistencyImmediate Consistency or Eventual ConsistencyImmediate Consistency infoDocument store kept consistent with combination of global timestamping, row-level transactions, and server-side consistency resolution.
Foreign keys infoReferential integrityyes infoinformational only, not enforced by the systemnono
Transaction concepts infoSupport to ensure data integrity after non-atomic manipulations of dataACIDSingle row ACID (across millions of columns)Atomic updates per row, document, or graph entity
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.yesyes
User concepts infoAccess controlfine grained access rights according to SQL-standardAccess Control Lists (ACL) for RBAC, integration with Apache Ranger for RBAC & ABACCell-level Security, Data-Centric Security, Role-Based Access Control (RBAC), Attribute-Based Access Control (ABAC)

More information provided by the system vendor

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

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

More resources
Amazon RedshiftHBaseSqrrl
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

Why is Hadoop not listed in the DB-Engines Ranking?
13 May 2013, Paul Andlinger

show all

Recent citations in the news

Datacoral Achieves Amazon Redshift Ready Designation
3 August 2020, PRNewswire

Manage and control your cost with Amazon Redshift Concurrency Scaling and Spectrum
28 July 2020, idk.dev

Federate access to your Amazon Redshift cluster with Active Directory Federation Services (AD FS): Part 2
23 July 2020, idk.dev

Develop an application migration methodology to modernize your data warehouse with Amazon Redshift
13 July 2020, idk.dev

AWS Powers Moderna's Digital Biotechnology Platform to Develop New Class of Vaccines and Therapeutics
5 August 2020, Business Wire

provided by Google News

Splicing a Pause Button into Cloud Machines
4 August 2020, Datanami

The Apache Software Foundation Announces the 10th Anniversary of Apache® HBase™
13 May 2020, GlobeNewswire

HBase vs Cassandra: Which is The Best NoSQL Database
20 January 2020, Appinventiv

HADOOP AND C# BASICS: PROGRAMMING FOR BEGINNERS – 2 BOOKS IN 1 – Learn Coding Fast! HADOOP AND C# Crash Course, A QuickStart Guide, Tutorial Book by Program Examples, In Easy Steps!
8 August 2020, Digital Market News

ExeVir Bio Secures $27M Series A To See If Llama-derived Antibodies Work On COVID-19
28 July 2020, Crunchbase News

provided by Google News

User and Entity Behavior Analytics Market will touch a new level in upcoming year with top key players like Veriato Inc., Sqrrl Data, Securonix, Dtex Systems, Exabeam, Rapid7, Splunk Inc., Varonis systems, Niara
31 July 2020, Owned

Amazon's cloud business acquires Sqrrl, a security start-up with NSA roots
23 January 2018, CNBC

[Tech30] These industry veterans’ startup encourages millennials to save and invest money smartly
28 October 2019, YourStory

AWS acquires threat hunting startup Sqrrl
24 January 2018, CyberScoop

Sqrrl ferrets out network traffic anomalies to find hidden threats
28 September 2017, CSO Online

provided by Google News

Job opportunities

Associate Cloud Developer
Amazon Web Services, Inc., Atlanta, GA

Amazon Redshift Development Manager
Amazon.com Services LLC, Arlington, VA

Marketing Operations Analyst
Amazon Web Services, Inc., United States

Junior Digital Analyst
empirical path, Atlanta, GA

Director, Engineering Redshift
Amazon Web Services, Inc., Remote

Software Engineer - Entry Level
HubSpot: Students, Cambridge, MA

Data Scientist
Source Enterprises, New York, NY

Engineering Lead
HASH, Remote

Data Scientist - Manufacturing Quality Systems
Tesla, Fremont, CA

Data Scientist
UST Global, Richmond, VA

Network Security Engineer
Cambium Learning Group, Washington, DC

Cyber Hunt SME
XOR Security, Washington, DC

Sr. Cyber Security Analyst
XOR Security, Arlington County, VA

Cyber Security Engineer
XOR Security, Springfield, VA

Senior Security Engineer
XOR Security, Washington, DC

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!

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

Cassandra made easy in the cloud. Build cloud-native applications faster with CQL, REST and GraphQL APIs.
Try for Free.

Present your product here