Explore topic-wise InterviewSolutions in Current Affairs.

CURRENTLY, the Amazon DYNAMODB is incapable of removing the local secondary indexes from the table once they are CREATED, but it is POSSIBLE to DELETE the entire table.

Currently, the Amazon DynamoDB is incapable of removing the local secondary indexes from the table once they are created, but it is possible to delete the entire table.

Each table can CONSTITUTE up to FIVE LOCAL SECONDARY INDEXES.

Each table can constitute up to five local secondary indexes.

• When you create a table with local secondary indexes, you can create a local secondary index to USE it in future by defining a sort KEY element which is not used CURRENTLY.
• So, at this time it is probably not possible to ADD local secondary indexes in the existing table.

A Local secondary index needs to be created at the time of creating a table that can’t be added currently.

So, later when you create a local secondary index, try specifying the following two parameters.

Indexed Sort Key :

The attribute on which INDEXING and querying are performed.

Projected Attributes :

It is the LIST of attributes from the table that can directly be COPIED into the local secondary index. WITHOUT projected attributes, the local secondary index contains only primary KEYS and secondary keys.

A Local secondary index needs to be created at the time of creating a table that can’t be added currently.

So, later when you create a local secondary index, try specifying the following two parameters.

Indexed Sort Key :

The attribute on which indexing and querying are performed.

Projected Attributes :

It is the list of attributes from the table that can directly be copied into the local secondary index. Without projected attributes, the local secondary index contains only primary keys and secondary keys.

• Projections are the set of attributes that are COPIED or projected from the table to an index.
• They are in addition to the index KEY attributes and primary key attributes which are automatically projected.
• Whenever you define a local secondary index, it is required to specify the attributes that are projected into the index.

Each index consists of a MINIMUM of 3 attributes.

 They are:

• Table partition key VALUE
• Attribute to serve as the index sort key
• Table sort key value

Each index consists of a minimum of 3 attributes.

 They are:

• An INDEX with the same partition key as the table but DIFFERENT sort key is CALLED local SECONDARY index.
• A local secondary index is considered to be “local” because EVERY partition of a local secondary index is scaled to a table partition which contains the same partition key.

• A Global secondary index can be deleted from the console or through an API call.
• Select the table from which you want to delete the Global Secondary index on the console, select the “indexes” TAB under “Table items” and then click on the “Delete” button which is next to the delete index.
• A Global Secondary Index can ALSO be deleted USING the UPDATE Table API call.

“QUERY” and “SCAN” are the API calls that are supported by Global SECONDARY Index.

“Query” and “Scan” are the API calls that are supported by Global Secondary Index.

You are allowed to create a MAXIMUM of 5 GLOBAL secondary indexes PER table.

You are allowed to create a maximum of 5 global secondary indexes per table.

Two types of indexes are supported by Amazon DynamoDB.

They are:

Global Secondary index :

It is an index with a partition or a partition sort key that is different from those on the table. The global secondary index is CONSIDERED to be global because queries on the index can span all the items in a table, ACROSS all the partitions.

LOCAL secondary index :

An index that has the same partition key as that of the table but different sort key. It is considered to be “local” because every partition of the index is SCOPED to a table partition that has the same partition key.

Two types of indexes are supported by Amazon DynamoDB.

They are:

Global Secondary index :

It is an index with a partition or a partition sort key that is different from those on the table. The global secondary index is considered to be global because queries on the index can span all the items in a table, across all the partitions.

Local secondary index :

An index that has the same partition key as that of the table but different sort key. It is considered to be “local” because every partition of the index is scoped to a table partition that has the same partition key.

• An index with a different PARTITION and partition-and-sort key from those on the table is called global SECONDARY index.
• It is considered to be “global” in the sense that queries on the index can SPAN all the ITEMS in a table across, all the PARTITIONS.

DynamoDB is a SUPERINTENDENT FEATURE that scales up and down the read and WRITE capacity of a DynamoDB or a global SECONDARY INDEX automatically.

DynamoDB is a superintendent feature that scales up and down the read and write capacity of a DynamoDB or a global secondary index automatically.

It is a database service that provides and supports storing, updating and QUERYING the OBJECTS that are identified USING KEY and values that constitutes the actual CONTENT that is being stored.

It is a database service that provides and supports storing, updating and querying the objects that are identified using key and values that constitutes the actual content that is being stored.

• The Amazon DYNAMODB BatchWriteItem INSERTS, deletes and replaces MULTIPLE items across multiple tables in just ONE request, but not in one transaction.
• With maximum total request size of 16 MB, it supports BATCHES of up to 25 items to insert or delete.

• UpdateTable
• DeleteTable
• DescribeTable
• ListTables
• PutItem
• BatchWriteItem
• UpdateItem
• DeleteItem
• GetItem
• BatchGetItem.
• QUERY
• SCAN

Amazon DYNAMODB :

It is a fast and scalable NoSQL DATABASE Service that is designed for internet scale applications, to maintain predictably high performance and to be highly cost-effective for workloads of any scale, on the top of all it is highly RECOMMENDED.

Amazon SimpleDB :

It has scaling limitations and is a good fit for smaller workloads that requires query flexibility.It automatically INDEXES all item attributes and supports query flexibility at the cost of performance and scale.

Amazon DynamoDB :

It is a fast and scalable NoSQL Database Service that is designed for internet scale applications, to maintain predictably high performance and to be highly cost-effective for workloads of any scale, on the top of all it is highly recommended.

Amazon SimpleDB :

It has scaling limitations and is a good fit for smaller workloads that requires query flexibility.It automatically indexes all item attributes and supports query flexibility at the cost of performance and scale.

For an operation to be COMPLETED on an item, you have to specify a condition.You can define a ConditionExpression that can be constructed from the following:

Boolean functions:

ATTRIBUTE_EXIST, CONTAINS, and BEGINS_WITH

COMPARISON OPERATORS:

=, <>, <, >, <=, >=, BETWEEN, and IN
Logical operators:

NOT, AND, and OR.

You can also construct a free-form conditional expression that COMBINES multiple conditional clauses which also includes nested clauses.

For an operation to be completed on an item, you have to specify a condition.You can define a ConditionExpression that can be constructed from the following:

Boolean functions:

ATTRIBUTE_EXIST, CONTAINS, and BEGINS_WITH

Comparison operators:

=, <>, <, >, <=, >=, BETWEEN, and IN
Logical operators:

NOT, AND, and OR.

You can also construct a free-form conditional expression that combines multiple conditional clauses which also includes nested clauses.

• It supports GET/PUT operation using the user-defined PRIMARY key.
• It provides flexible querying by letting QUERY a non-primary key attribute using local secondary indexes and Global secondary indexes.
• It allows quick reads and writes data for an item ASSOCIATED with single attribute partition primary key.
• It allows you to use the Query API to retrieve all the items for a single composite partition-SORT key across a RANGE of sort keys.

Amazon DYNAMODB supports quick in-place ATOMIC UPDATES, were the numeric ATTRIBUTES increment and decrement can be DONE in arrow using just one API call or similarly, you can add or remove sets, lists, or maps.

Amazon DynamoDB supports quick in-place atomic updates, were the numeric attributes increment and decrement can be done in arrow using just one API call or similarly, you can add or remove sets, lists, or maps.

DYNAMODB supports four scalar data types, and they are:

• NUMBER
• STRING
• Binary
• Boolean

 DynamoDB supports collection data types such as:

• Number Set
• String Set
• Binary Set
• HETEROGENEOUS List
• Heterogeneous MAP

DynamoDB also supports Null values.

DynamoDB supports four scalar data types, and they are:

 DynamoDB supports collection data types such as:

DynamoDB also supports Null values.

It is the entry point to DYNAMODB.The DynamoDB Mapper CLASS provides access to a DynamoDB endpoint and ENABLES the user to access to their data in various tables, execute queries and scan against tables, and perform CRUD operations on items.

It is the entry point to DynamoDB.The DynamoDB Mapper class provides access to a DynamoDB endpoint and enables the user to access to their data in various tables, execute queries and scan against tables, and perform CRUD operations on items.

1. In Amazon DynamoDB you only pay for the resources you provision.
2. Get STARTED with free tier limits of DynamoDB on which many applications OPERATE.
3. In need of resources, the pricing per MONTH varies depending on which TYPE of resources you REQUIRE.

The Non-Relational DATABASES are NOSQL databases.

These databases are categorized into FOUR groups. 

They are:

• Key-value STORES
• Graph stores
• Column stores
• DOCUMENT stores 

The Non-Relational databases are NoSQL databases.

These databases are categorized into four groups. 

They are:

Here is the list of some of the benefits of using Amazon DynamoDB:

• It is a managed service where there is no need to hire the experts or worry about installation, setup, cluster ETC.,
• It is scalable.
• It provides the users high throughput at very low LATENCY.
• It is DURABLE and highly available.
• It is flexible and allows DYNAMIC tables creation that includes multi-valued attributes.
• It is cost-effective.

Here is the list of some of the benefits of using Amazon DynamoDB:

• It is a NoSQL database service which is superintendent and provides fast and INEVITABLE performance with seamless scalability.
• It also ENABLES the users to offload the operating and scaling distributed databases to AWS.
• So that the users don’t have to worry about setup and configuration, hardware provisions, replication, THROUGHPUT capacity planning, cluster scaling or SOFTWARE PATCHING.