AWS. Database services
High level overview of AWS database services
In a previous post we looked at from a higher level perspective various data storage services available with AWS. In this post somehow we expand this view by considering the database services available with AWS.
AWS offers a variety of database options to choose from. It supports in-memory databases, relational and non-relational databases. Furthermore, it offers warehousing services. Below we will review some of the available options.
The first database service we will look into is the relational database service (RDS). This service allows us to fully manage relational database services such as MySQL, Microsoft SQL Server, PostgreSQL and Amazon Aurora.
In addition to relational databases, AWS offers support for non-relational databases such as Amazon DynamoDB. This is a fast and flexible NoSQL database service with extremely low latency performance.
Amazon Neptune is a graph-based database service that allows us to build and run graph applications with highly connected datasets.
Furthermore, AWS offers scalable data warehouse services via the Amazon Redshift service. Amazon Redshift uses SQL to analyze structured and semi-structured data across data warehouses, operational databases, and data lakes, using AWS-designed hardware and machine learning to deliver the best price performance at any scale. Redshit is perfect for big data storage solution.
Frequently applications need to cache results. The Amazon ElasticCache service offers microsecond latency and scale with in-memory caching
The AWS Database Migration Service allows us to migrate databases to AWS quickly and securely. The source database remains fully operational during the migration, minimizing downtime to applications that rely on the database. The service can migrate your data to and from the most widely used commercial and open-source databases.
In this post we went over a high level overview of the database services available on AWS. In particular, we saw that AWS supports relational and non-relational databases as well as in memory databases suitbale for caching application queries. In addition, AWS supports data warehousing via Amazon Redshift service. Finally AWS allows us to migrate data from our local database to AWS cloud with the database migration service.