Module 8 - Section 2

Amazon DynamoDB

relational database

works with structured data that is organized by tables, records, and columns

relational database

establish a well-defined relationship between database tables

relational database

use structured query language (SQL), which is a standard user application that provides a programming interface for database interaction

relational database

might have difficulties scaling out horizontally or working with semistructured data, and might also require many joins for normalized data.

non-relational database

any database that does not follow the relational model that is provided by traditional relational database management systems (RDBMS)

non-relational database

scale out horizontally, and they can work with unstructured and semistructured data.

• rows and columns

• key-value, document, graph

data storage

relational > ___ ::: non-relational > ___

• fixed

• dynamic

schema

relational > ___ ::: non-relational > ___

• vertical

• horizontal

scalability

relational > ___ ::: non-relational > ___

DynamoDB

a fast and flexible NoSQL database service for all applications that need consistent, single-digit-millisecond latency at any scale.

NoSQL database tables

Virtually unlimited storage

Items can have differing attributes

Low-latency queries

Scalable read/write throughput

DynamoDB features (?):

different attributes

One of the benefits of a NoSQL database is that items in the same table can have ___. This gives you the flexibility to add attributes as your application evolves. You can

schema migrations

In NoSQL databases, you can store newer format items side by side with older format items in the same table without needing to perform ___.

solid state drives (SSDs)

All the data in DynamoDB is stored on ___ and its simple query language enables consistent low-latency query performance

read or write throughput

In addition to scaling storage, DynamoDB also enables you to provision the amount of ___ that you need for your table

manual provisioning

As the number of application users grows, DynamoDB tables can be scaled to handle the increased numbers of read/write requests with ___

automatic scaling

Alternatively, you can enable ____ so that DynamoDB monitors the load on the table and automatically increases or decreases the provisioned throughput.

• tables

• items

• attributes

DynamoDB core components:

table

DynamoDB core component: a collection of data

items

DynamoDB core component: a group of attributes that is uniquely identifiable among all the other items

attribute

DynamoDB core component: a fundamental data element

• partition key

• partition key and sort key (aka composite primary key)

DynamoDB supports two different kinds of primary keys:

partition key

DynamoDB primary key: a simple primary key, which is composed of one attribute called the sort key.

sort key

The partition key is a simple primary key, which is composed of one attribute called the ___.

partition key and sort key (aka composite primary key)

DynamoDB primary key: composed of two attributes

primary key

As data grows, table data is partitioned and indexed by the ___

In the first method, the query operation takes advantage of partitioning to effectively locate items by using the primary key.

The second method is via a scan, which enables you to locate items in the table by matching conditions on non-key attributes. The second method gives you the flexibility to locate items by other attributes. However, the operation is less efficient because DynamoDB will scan through all the items in the table to find the ones that match your criteria.

You can retrieve data from a DynamoDB table in two different ways:

partitioning

__ allows large tables to be scanned and queried quickly

Globally Unique Identifier (GUID)

You can set up a simple primary key that is based on a single attribute of the data values with a uniform distribution, such as the ___ or other random identifiers.

key

Items in a table must have a ___

single key

A ___ means the data is identified by an item in the data that uniquely identifies each record

compound key

A ___ is made up of a partition key and a second key that can be used for sorting data