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

The Essential Guide to Cryptocurrency Exchange Platform Development for Beginners and Beyond

Introduction Cryptocurrencies took the world by storm, setting up a new financial system and breaking…

12 months ago

Top 20 System Administrator Interview Questions and answers

In my previous article I have given Top 20 technical support interview questions with its…

1 year ago

Desktop Support Scenario Based Interview Questions

In my previous articles I have given 15 most asked desktop support interview questions with…

1 year ago

How Do Business Analysts Use SQL for Their Needs?

A business analyst is someone who is versed in processes of data analysis used for…

1 year ago

Top 15 Control-M Interview Questions with Answers

In my previous article I have already given top questions and answers for Desktop support…

1 year ago

Top 20 SQL Interview Questions for Production Support

In my previous article I have given unix production support interview questions and answers. In…

1 year ago