Editorial information provided by DB-Tools |
System |
Name |
Amazon DynamoDB |
Microsoft SQL Server |
Version |
released Jan 2012 |
Sqlserver 2017 |
Drawbacks |
Very few features when compared to other key-value stores |
high license costs. Applicable for transaction systems in large enterprises |
Advantages |
Managed Database Service provided by a leading cloud provider |
ACID compliant. Easy to use User Interface |
Languages Supported |
Java, Node.js, Go, C# .NET, Perl, PHP, Python, Ruby, Haskell and Erlang. |
C#
C++
Delphi
Go
Java
JavaScript (Node.js)
PHP
Python
R (Microsoft R)
Ruby
Visual Basic |
Website |
aws.amazon.com/dynamodb |
www.microsoft.com/en-us/sql-server |
XML Support |
no |
yes |
JSON Support |
yes |
yes |
Brief description |
Amazon DynamoDB is a fully managed proprietary NoSQL database service that supports key-value and document data structures[2] and is offered by Amazon.com as part of the Amazon Web Services portfolio |
As a database server, it is a software product with the primary function of storing and retrieving data as requested by other software applications—which may run either on the same computer or on another computer across a network (including the Internet). |
Database Model |
Key Value Model |
Primarily a relational database |
Technical Documentation |
aws.amazon.com/documentation/dynamodb |
docs.microsoft.com/en-ie/sql/sql-server/sql-server-technical-documentation |
License |
commercial on aws cloud. |
Commercial |
Cloud-based / SaaS |
Yes but you can download dynamod db locally as well. Local installation does not have vendor support |
Available in AWS, Azure Clouds. Available as a SaaS option in Microsoft Cloud |
Implementation Language |
C++ |
C,C++ |
Operating System Supported |
Linux , OS X, Windows |
Linux
Windows
|
Options for Integration / Access API |
Rest API |
OLE DB,
Tabular Data Stream (TDS),
ADO.NET,
JDBC,
ODBC |
Consistency |
Immediate consistency |
Highly Consistent |
Foreign Keys |
No |
Yes |
Streaming Support |
No |
No |
Analytics Support |
NA |
Need to buy SQLServer Analytics Pack (SSAS) |
Data Storage Schema |
Key Value Model |
Relational Database |
Notable Users |
As per Amazon the solution has been deployed by around 100,000 customers |
Most of the Fortune 500 Companies |
Key Differentiator |
Amazon allows developers to purchase a service based on throughput, rather than storage. |
Highly reliable as a transactional database |
Concurrency |
Yes |
Yes |
Partitioning |
Sharding |
No |
Replication |
Multi Data Center Replication supported |
Yes |
Secondary Indexes |
Yes |
Yes |
SchemaLess |
Yes |
No |
SQL Query |
No |
Yes |