Categories: Hadoop

What are attributes in DynamoDB with Advantages and disadvantages?

In my previous article I have given the information about the DynamoDB database with its core concepts. I have also tried to give the multiple limitations using DynamoDB as well. In this article I would like to cover topic which gives you information about attributes in DynamoDB with examples. These attributes of DynamoDB are most important attributes helps to improve the performance of the database. Now a days the performance tuning of database is more required in real industry. Using these attributes one can fasten up the database by default.

What is DynamoDB and attributes in DynamoDB ?

A fully managed NoSQL database service, Amazon DynamoDB offers quick and reliable performance along with seamless scaling. The administrative costs of running and maintaining a distributed database can be offloaded thanks to DynamoDB, so you no longer have to worry about hardware provisioning, setup, replication, software patching, or cluster growth. The attributes in DynamoBD helps to improve performance of database transactions.

What are attributes in DynamoDB ?

In this section I would like to give you different key attributes in DynamoDB which helps to improve the performance of overall database. There are slight changes in the architecture part of DynamoDB.

1.Primary Key :

Secondary indexes offer query flexibility, and Primary Keys act as the way of ensuring that each database item may be uniquely identified. By making changes to the table data, DynamoDB streams capture events.

Two types of primary keys:
Partition Key – The “partition key” is the only property that makes up this straightforward primary key. In order to select storage, DynamoDB internally uses the key value as input for a hash function.
Partition Key and Sort Key – The “Composite Primary Key” is the other name of this key, which has two attributes ( Primary Key and Sort Key ).

2.Secondary Indexes :

We can use an alternative key to query table data thanks to these indexes. DynamoDB does not need their use, however they do improve queries. There are two types of secondary key.
Global Secondary Index – Partition and sort keys for this index can be different from table keys.
Local Secondary Index – This index has a partition key that is the same as the table’s, but it has a different sort key.

API
DynamoDB provides API operations for the control plane, data plane (such as creation, reading, updating, and deleting), and streams. We can create and manage tables by the following tools – Create, List, Describe, Update and Delete Tables.

Advantages of DynamoDB :

  1. Unstructured or partially structured data can be handled by DynamoDB.
  2. High Performance.
  3. Resource usage and performance indicators can be observed using the AWS Management Console.
  4. The use case is more on-demand-based.
  5. Highly automated

Disadvantages of DynamoDB :

  1. Cannot use Table Joins
  2. Any data archiving for an endpoint is complicated.
  3. Lack of some functionalities will force extra data to be loaded from the drive and in-memory operations. It will cause the database to lag.
  4. DynamoDB is not preferred to store financial data.
  5. The absence of a transaction mechanism may compromise crucial data.

I hope you like this article on Attributes in DynamoDB with advantages and disadvantages of the same. If you like this article or if you have any issues with the same kindly comment in comments section.

Amit S

Oracle Consultant with vast experience in Oracle BI and PL/SQL Development. Amiet is the admin head of this website who contributes by preparing tutorials and articles related to database technologies. He is responsible to manage the content and front-end of the website.

Share
Published by
Amit S

Recent Posts

What is Root Cause Analysis (RCA) With real examples

In my previous article I have given details about application support engineer day to day…

4 weeks ago

Application Support Engineer Day to day responsibilities

In my previous articles I have given the roles and responsibilities of L1,L2 and L3…

4 weeks ago

What is mean by SLA ( Service Level Agreement) with Examples?

In my previous articles i have given the hierarchy of production support in real company…

1 month ago

What is Production support Hierarchy in organization?

In this article i would like to provide information about production support organization structure or…

1 month ago

What are roles and responsibilities for L3 Support Engineer?

In my previous article I have given roles for L1 and L2 support engineer with…

1 month ago

What are roles and responsibilities of L2 Engineer?

I have started this new series of how to become application support engineer. This article…

1 month ago