Exploring AWS Database Resources

1. Exploring AWS Database Resources

Next, let's look at databases in AWS.

2. Introduction to Database as a Service (DBaas)

AWS provides various databases for different use cases, including relational databases.

3. Introduction to Database as a Service (DBaas)

NoSQL databases,

4. Introduction to Database as a Service (DBaas)

Memory-based databases,

5. Introduction to Database as a Service (DBaas)

and compute-hosted databases. Let's go through these in detail.

6. What are relational databases?

Relational databases structure data into tables, and build relationships to other tables using keys. They provide data integrity, consistency and scalability.

7. Relational databases in AWS

AWS supports relational database management through two services, Amazon RDS

8. Relational databases in AWS

and Amazon Aurora. Let's see when they are most suitable.

9. Amazon RDS

RDS offers managed relational databases by controlling setup, operation, and scaling. It supports various database engines and scales seamlessly in both cloud and on-premises environments.

10. AWS Aurora

Aurora on the other hand is a specialized database service for MySQL and PostgreSQL, that offers high performance at a fraction of on-premises costs. It performs continuous backups and multi-region deployments to ensure high availability.

11. NoSQL databases in AWS

NoSQL databases transcend the traditional tabular relational database model to accomodate data models like JSON and raw documents. They offer dynamic schema flexibility to deal with evolving data structures and scale horizontally to handle growing data. Let's look at AWS's two NoSQL database offerings, DynamoDB

12. NoSQL databases in AWS

and DocumentDB.

13. Amazon DynamoDB

DynamoDB is a managed NoSQL database built on a serverless architecture that provides high performance with limitless throughput and storage,

14. Amazon DynamoDB

has 99.999% availability,

15. Amazon DynamoDB

and scales seamlessly.

16. DynamoDB use cases

DynamoDB is best used for unstructured data like real-time video streaming or media content

17. DynamoDB use cases

For tracking inventory or shopping carts for customer profiles

18. DynamoDB use cases

Or on gaming platforms that host session history and leaderboards linked to players

19. Amazon DocumentDB

DocumentDB is the other AWS NoSQL service that works with JSON data and has enhanced compatibility with MongoDB.

20. Amazon DocumentDB

It can be used for large-scaled document workloads

21. Amazon DocumentDB

with no infrastructure management requirements.

22. When to use DocumentDB?

DocumentDB is widely used in content management systems where data like text reviews and images are involved,

23. When to use DocumentDB?

in recommendation engines that manage millions of user profiles,

24. When to use DocumentDB?

and for generative AI use cases involving large semantic language-based data.

25. Memory-based databases in AWS

Another category of databases offered by AWS are memory-based databases. These are designed for high-performance storage and utilize RAM for super-fast retrieval. They are used in applications that require caching, need real-time data processing, or track high-throughout high-speed transactions.

26. MemoryDB for Redis

MemoryDB for Redis is AWS's offering for memory-based databases that gives microsecond read and millisecond write capabilities. It is hosted with 99.99% global availability and is equipped with fault tolerance to recover instantaneously from any outages or issues.

27. What are EC2-hosted databases?

Lastly, let's look at compute-hosted databases, also called EC2-hosted databases. These are custom databases deployed on EC2 instances to simplify data access during compute. They provide granular configuration and management, while leaving the responsibility of backups with the user.

28. Compute databases vs. static databases?

How will you choose between EC2-hosted and AWS-managed databases? For applications where you need full control over database configuration choose EC2-hosted databases. But, if you are looking for an automated and fully managed service then AWS-managed databases are the way to go.

29. Let's practice!

Let's put your database skills to a test!

Create Your Free Account

By continuing, you accept our Terms of Use, our Privacy Policy and that your data is stored in the USA.