DB-EnginesExtremeDB: hybrid in-memory and persistent storage based on a true IMDSEnglish
Deutsch
Knowledge Base of Relational and NoSQL Database Management Systemsprovided by solid IT

DBMS > Amazon Redshift vs. Amazon SimpleDB vs. BigchainDB

System Properties Comparison Amazon Redshift vs. Amazon SimpleDB vs. BigchainDB

Please select another system to include it in the comparison.

Editorial information provided by DB-Engines
NameAmazon Redshift  Xexclude from comparisonAmazon SimpleDB  Xexclude from comparisonBigchainDB  Xexclude from comparison
DescriptionLarge scale data warehouse service for use with business intelligence toolsHosted simple database service by Amazon, with the data stored in the Amazon Cloud. infoThere is an unrelated product called SimpleDB developed by Edward ScioreBigchainDB is scalable blockchain database offering decentralization, immutability and native assets
Primary database modelRelational DBMSKey-value storeDocument store
DB-Engines Ranking infomeasures the popularity of database management systemsranking trend
Trend Chart
Score23.64
Rank#32  Overall
#18  Relational DBMS
Score2.25
Rank#114  Overall
#22  Key-value stores
Score0.78
Rank#200  Overall
#31  Document stores
Websiteaws.amazon.com/­redshiftaws.amazon.com/­simpledbwww.bigchaindb.com
Technical documentationdocs.aws.amazon.com/­redshiftdocs.aws.amazon.com/­simpledbbigchaindb.readthedocs.io/­en/­latest
DeveloperAmazon (based on PostgreSQL)Amazon
Initial release201220072016
License infoCommercial or Open SourcecommercialcommercialOpen Source infoAGPL v3
Cloud-based only infoOnly available as a cloud serviceyesyesno
DBaaS offerings (sponsored links) infoDatabase as a Service

Providers of DBaaS offerings, please contact us to be listed.
Implementation languageCPython
Server operating systemshostedhostedLinux
Data schemeyesschema-freeschema-free
Typing infopredefined data types such as float or dateyesnono
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 indexesrestrictedyes infoAll columns are indexed automatically
SQL infoSupport of SQLyes infodoes not fully support an SQL-standardnono
APIs and other access methodsJDBC
ODBC
RESTful HTTP APICLI Client
RESTful HTTP API
Supported programming languagesAll languages supporting JDBC/ODBC.Net
C
C++
Erlang
Java
PHP
Python
Ruby
Scala
Go
Haskell
Java
JavaScript
Python
Ruby
Server-side scripts infoStored proceduresuser defined functions infoin Pythonno
Triggersnono
Partitioning methods infoMethods for storing different data on different nodesShardingnone infoSharding must be implemented in the applicationSharding
Replication methods infoMethods for redundantly storing data on multiple nodesyesyesselectable replication factor
MapReduce infoOffers an API for user-defined Map/Reduce methodsnonono
Consistency concepts infoMethods to ensure consistency in a distributed systemImmediate ConsistencyEventual Consistency
Immediate Consistency infocan be specified for read operations
Foreign keys infoReferential integrityyes infoinformational only, not enforced by the systemnono
Transaction concepts infoSupport to ensure data integrity after non-atomic manipulations of dataACIDno infoConcurrent data updates can be detected by the application
Concurrency infoSupport for concurrent manipulation of datayesyesyes
Durability infoSupport for making data persistentyesyesyes,with MongoDB ord RethinkDB
In-memory capabilities infoIs there an option to define some or all structures to be held in-memory only.yes
User concepts infoAccess controlfine grained access rights according to SQL-standardAccess rights for users and roles can be defined via the AWS Identity and Access Management (IAM)yes

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

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 RedshiftAmazon SimpleDBBigchainDB
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

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

Amazon - the rising star in the DBMS market
3 August 2015, Matthias Gelbmann

show all

Recent citations in the news

Merkle Achieves Amazon Redshift Service Delivery Designation
15 June 2021, Business Wire

Amazon Redshift ML Now Generally Available
2 June 2021, iProgrammer

Amazon AWS launches Redshift ML to let developers train models with SQL
27 May 2021, VentureBeat

Amazon Redshift ML available: train and operate machine learning models on Redshift data • DEVCLASS
28 May 2021, DevClass

news digest: Amazon Redshift ML, Microsoft's GPT-3 features, and OpenCilk 1.0 released - SD Times
28 May 2021, SDTimes.com

provided by Google News

NoSQL Databases Market is flourishing, taking several industries to top spot Know more about Industry: Accumulo, Aerospike, Amazon SimpleDB, Azure Table – The Manomet Current
11 June 2021, The Manomet Current

Global Database as a Service Market (2021-2026) | Latest COVID19 Impact Analysis | Know About Brand Players: Azure, Amazon, Zoho, Big Query, SimpleDB, etc. – Clark County Blog
19 May 2021, Clark County Blog

Introducing Amazon SimpleDB
18 August 2010, Database Journal

Amazon DynamoDB Serves Trillions Of Requests Per Month While Counterpart SimpleDB Is No Longer A Listed Product On AWS
13 November 2013, TechCrunch

Amazon SimpleDB 101 & Why It Matters – Gigaom
14 December 2007, GigaOm

provided by Google News

Blockchain for Enterprise Applications Market SWOT Analysis including key players Barclays, BigchainDB, Block Array – KSU | The Sentinel Newspaper
15 June 2021, KSU | The Sentinel Newspaper

Bosch, Ocean Protocol represented by BigchainDB, Fetch.ai Join Catena-X to Bring Expertise in Market, Mechanism, Token-based Incentive Design
20 May 2021, Crowdfund Insider

Blockchain for Enterprise Applications Market Future Scope including key players Barclays, BigchainDB, Block Array – The Courier
5 June 2021, The Courier

Smart Contract Platform Market Trends Shows a Rapid Growth by 2026 | ternity blockchain, AlphaPoint, AnChain.AI, BigchainDB – The Manomet Current
19 May 2021, The Manomet Current

Automotive Blockchain Market Impressive Gains including key players IBM Corporation, carVertical, ShiftMobility, BigchainDB, Helbiz – KSU | The Sentinel Newspaper
10 June 2021, KSU | The Sentinel Newspaper

provided by Google News

Job opportunities

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

Senior Data Engineer
Vacasa, Oregon

Business Intelligence Analyst
Arizona Coyotes, Glendale, AZ

Sales Engineer
Xenon Partners, Remote

Associate Data Intelligence Developer
CastleBranch, Wilmington, NC

9-1-1 and Emergency Communications Business Development Manager - US East
Amazon Web Services, Inc., United States

Sr. Partner Success Manager - Energy
Amazon Web Services, Inc., Houston, TX

AWS Partner Business Development Manager
Amazon Web Services, Inc., Seattle, WA

Sr. Partner Sales Manager - Global Accounts
Amazon Web Services, Inc., Dallas, TX

Sr. Proposal Manager, Federal
Amazon Web Services, Inc., Arlington, VA

jobs by Indeed




Share this page

Featured Products

Neo4j logo

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

MariaDB logo

SkySQL, the ultimate
MariaDB cloud, is here.

Get started with SkySQL today!

Couchbase logo

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

AllegroGraph logo

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

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