DB-EngineseXtremeDB: Active Replication Fabric for Reliable IoT Database ManagementEnglish
Deutsch
Knowledge Base of Relational and NoSQL Database Management Systemsprovided by solid IT

DBMS > Amazon DynamoDB vs. Ingres vs. Microsoft Azure Cosmos DB vs. Sequoiadb

System Properties Comparison Amazon DynamoDB vs. Ingres vs. Microsoft Azure Cosmos DB vs. Sequoiadb

Please select another system to include it in the comparison.

Editorial information provided by DB-Engines
NameAmazon DynamoDB  Xexclude from comparisonIngres  Xexclude from comparisonMicrosoft Azure Cosmos DB infoformer name was Azure DocumentDB  Xexclude from comparisonSequoiadb  Xexclude from comparison
DescriptionHosted, scalable database service by Amazon with the data stored in Amazons cloudWell established RDBMSGlobally distributed, horizontally scalable, multi-model database serviceNewSQL database with distributed OLTP and SQL
Primary database modelDocument store
Key-value store
Relational DBMSDocument store
Graph DBMS
Key-value store
Wide column store
Document store
Relational DBMS
DB-Engines Ranking infomeasures the popularity of database management systemsranking trend
Trend Chart
Score66.18
Rank#16  Overall
#2  Document stores
#2  Key-value stores
Score6.29
Rank#60  Overall
#33  Relational DBMS
Score31.67
Rank#25  Overall
#3  Document stores
#2  Graph DBMS
#3  Key-value stores
#3  Wide column stores
Score0.35
Rank#252  Overall
#34  Document stores
#115  Relational DBMS
Websiteaws.amazon.com/­dynamodbwww.actian.com/­data-management/­ingres-sql-rdbmsazure.microsoft.com/­services/­cosmos-dbwww.sequoiadb.com
Technical documentationdocs.aws.amazon.com/­dynamodbdocs.actian.com/­ingresdocs.microsoft.com/­azure/­cosmos-dbwww.sequoiadb.com/­en/­index.php?m=Files&a=index
DeveloperAmazonActian CorporationMicrosoftSequoiadb Ltd.
Initial release20121974 infooriginally developed at University Berkely in early 1970s20142013
Current release11.0, April 2017
License infoCommercial or Open Sourcecommercial infofree tier for a limited amount of database operationscommercialcommercialOpen Source infoServer: AGPL; Client: Apache V2
Cloud-based only infoOnly available as a cloud serviceyesnoyesno
DBaaS offerings (sponsored links) infoDatabase as a Service

Providers of DBaaS offerings, please contact us to be listed.
Implementation languageCC++
Server operating systemshostedAIX
HP Open VMS
HP-UX
Linux
Solaris
Windows
hostedLinux
Data schemeschema-freeyesschema-freeschema-free
Typing infopredefined data types such as float or dateyesyesyes infoJSON typesyes infooid, date, timestamp, binary, regex
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.no infobut tools for importing/exporting data from/to XML-files availableno
Secondary indexesyesyesyes infoAll properties auto-indexed by defaultyes
SQL infoSupport of SQLnoyesSQL-like query languageSQL-like query language
APIs and other access methodsRESTful HTTP API.NET Client API
JDBC
ODBC
proprietary protocol (OpenAPI)
DocumentDB API
Graph API (Gremlin)
MongoDB API
RESTful HTTP API
Table API
proprietary protocol using JSON
Supported programming languages.Net
ColdFusion
Erlang
Groovy
Java
JavaScript
Perl
PHP
Python
Ruby
.Net
C#
Java
JavaScript
JavaScript (Node.js)
MongoDB client drivers written for various programming languages
Python
.Net
C++
Java
PHP
Python
Server-side scripts infoStored proceduresnoyesJavaScriptJavaScript
Triggersyes infoby integration with AWS LambdayesJavaScriptno
Partitioning methods infoMethods for storing different data on different nodesShardinghorizontal partitioning infoIngres Star to access multiple databases simultaneouslySharding infoImplicit feature of the cloud serviceSharding
Replication methods infoMethods for redundantly storing data on multiple nodesyesIngres Replicatoryes infoImplicit feature of the cloud serviceSource-replica replication
MapReduce infoOffers an API for user-defined Map/Reduce methodsno infomay be implemented via Amazon Elastic MapReduce (Amazon EMR)nowith Hadoop integration infoIntegration with Hadoop/HDInsight on Azure*no
Consistency concepts infoMethods to ensure consistency in a distributed systemEventual Consistency
Immediate Consistency infocan be specified for read operations
Immediate ConsistencyBounded Staleness
Consistent Prefix
Eventual Consistency
Immediate Consistency infoConsistency level configurable on request level
Session Consistency
Eventual Consistency
Foreign keys infoReferential integritynoyesnono
Transaction concepts infoSupport to ensure data integrity after non-atomic manipulations of dataACID infoACID across one or more tables within a single AWS account and regionACIDMulti-item ACID transactions with snapshot isolation within a partitionDocument is locked during a transaction
Concurrency infoSupport for concurrent manipulation of datayesyes infoMVCCyesyes
Durability infoSupport for making data persistentyesyesyesyes
In-memory capabilities infoIs there an option to define some or all structures to be held in-memory only.nono
User concepts infoAccess controlAccess rights for users and roles can be defined via the AWS Identity and Access Management (IAM)fine grained access rights according to SQL-standardAccess rights can be defined down to the item levelsimple password-based access control

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 partiesDynobase: Professional DynamoDB GUI Client. Available for Mac, Windows & Linux.
» more

CData: Connect to Big Data & NoSQL through standard Drivers.
» more
CData: 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 DynamoDBIngresMicrosoft Azure Cosmos DB infoformer name was Azure DocumentDBSequoiadb
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

ScyllaDB Unveils One-Step Migration from Amazon DynamoDB to Scylla NoSQL Database
2 September 2020, GlobeNewswire

DynamoDB on-demand vs. provisioned capacity: Which is better?
9 September 2020, TechTarget

AWS DynamoDB Vs Apache Cassandra: Comparing The Two NoSQL Databases
21 September 2020, Analytics India Magazine

Introducing immutable class mapping for the Enhanced DynamoDB Client in AWS SDK for Java 2.x
15 September 2020, idk.dev

Using DAL For Migration From DynamoDB to Spanner and Bigtable
9 September 2020, hackernoon.com

provided by Google News

ONS turns to Diegesis for Ingres support -
2 September 2020, Enterprise Times

Diegesis secures two-year managed services deal with the ONS
29 August 2020, SME Magazine

A Dynamic Database: What Is PostgreSQL?
25 September 2020, Techkrest

Actian Avalanche Real-Time Connected Data Warehouse adds integration
28 April 2020, TechTarget

Do we need so many databases?
30 June 2020, ARNnet

provided by Google News

COVID-19 Update: Global NoSQL Software Market is Expected to Grow at a Healthy CAGR with Top players: MongoDB, Amazon, ArangoDB, Azure Cosmos DB, Couchbase, etc. | InForGrowth
25 September 2020, Crypto Daily

Top Announcements From Microsoft Ignite 2020 Conference
25 September 2020, Analytics India Magazine

The top Azure announcements from Microsoft Ignite 2020 - Cloud
22 September 2020, CRN Australia

Microsoft Announces a New Pricing Model Option for Azure Cosmos DB and More Capabilities
3 June 2020, InfoQ.com

Microsoft to introduce a free tier of its Cosmos DB NoSQL database
5 March 2020, ZDNet

provided by Google News

SequoiaDB 3.0 Released, New-Generation Multi-Model NewSQL Database
25 June 2018, PR Newswire

Rising demand for Operational Database Management Systems (OPDBMS) Software Market (2026)| Oracle, Microsoft, SAP SE, IBM, Amazon Web Services
27 September 2020, Crypto Daily

New Fund, New IPOs: The Era Of Successful China VC Investing Hasn't Ended Here
14 May 2020, Forbes

Top 25 IoT Startups To Watch In 2019
3 February 2019, Forbes

Cloud Native Computing Foundation Surpasses 375 Members
12 March 2019, PRNewswire

provided by Google News

Job opportunities

Product Development Manager
Eyewitness Surveillance, Hanover, MD

Cloud & Systems Engineer
TexasHost, Remote

Database Administrator
Ramsey Solutions, Franklin, TN

AWS SysOps Administrator
Northrop Grumman, Remote

Associate Platform Support Specialist - Associate DevOps
OneSpan, Manchester, NH

ASSISTANT DIRECTOR, INTEGRATION & DEVELOPMENT
University of Washington, Seattle, WA

Senior Program Analyst
American Mathematical Society, Ann Arbor, MI

Systems Engineer (Junior)
Enterprise Information Services, Inc., Elizabeth City, NC

Applications Systems Analyst/Programmer
McCall Communications Consulting LLC, Elizabeth City, NC

Software Developer - VAX
KG Lewis LLC, Colorado Springs, CO

Azure Cosmos DB-Lead
Wipro LTD, Chevy Chase, MD

Azure architect
Digital Dhara, Omaha, NE

Azure Cloud Engineer with IOT experience
Volto Consulting, Seattle, WA

Support Engineer
Microsoft, Charlotte, NC

Azure Data Engineer
Digital Dhara, Bentonville, AR

jobs by Indeed




Share this page

Featured Products

Datastax Astra logo

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

Neo4j logo

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

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.

Present your product here