AWS Database Blog

AWS positioned highest in execution in the 2023 Gartner Magic Quadrant for Cloud Database Management Systems

AWS has been named a Leader for the ninth consecutive year in the 2023 Gartner Magic Quadrant for Cloud Database Management Systems, and we have been positioned highest for ability to execute. We are honored to be recognized for delivering value for customers in a year where the possibilities of generative AI have captured all […]

Upgrade to Amazon Aurora MySQL version 3 (with MySQL 8.0 compatibility)

Amazon Aurora MySQL-Compatible Edition version 3 (with MySQL 8.0 compatibility) is the most current major version supported on Amazon Aurora MySQL. You can use Amazon Aurora MySQL version 3 to get the latest MySQL-compatible features and performance improvements. MySQL 8.0 introduces several new features, including JSON functions, window functions, common table expressions (CTEs), and role-based […]

PostgreSQL 11 upgrade strategies for Amazon Aurora PostgreSQL and Amazon RDS for PostgreSQL

Amazon Aurora PostgreSQL-Compatible Edition and Amazon Relational Database Service (Amazon RDS) for PostgreSQL version 11 end of standard support is February 29, 2024. See the Amazon Aurora PostgreSQL and Amazon RDS for PostgreSQL announcements to upgrade your databases: Announcement: Amazon Aurora PostgreSQL 11.x end of support is February 29, 2024 Amazon RDS for PostgreSQL 11 […]

Back up and restore transparent data encrypted databases across accounts in Amazon RDS for SQL Server

Amazon Relational Database Service (Amazon RDS) for SQL Server is an AWS managed database service that simplifies operating and managing Microsoft SQL Server databases. Amazon RDS for SQL Server provides value by handling the provisioning, management, and monitoring of SQL Server databases. Although this operational agility is valuable, data protection and security become even more […]

Migrate rows with unique constraints to Amazon RDS for PostgreSQL or Amazon Aurora PostgreSQL

In a relational database management system, a unique key is a set of one or more attributes (columns) that uniquely identifies each row in a table. It ensures that no two rows in the table can have the same values for the specified attributes. The following are the features of a unique key: Uniqueness – […]

Amazon RDS Custom for SQL Server supports SQL Server 2022

Amazon Relational Database Service (Amazon RDS) Custom for SQL Server now supports Microsoft SQL Server 2022 for Web, Standard, Enterprise and Developer Editions (via BYOM). You can use SQL Server 2022 features such as accelerated database recovery, intelligent query processing, intelligent performance, monitoring improvements, and resumable online index creations. In addition, SQL Server 2022 has […]

Native backup and restore with Amazon S3 integration on Amazon RDS Custom for SQL Server 2022

Amazon Relational Database Service (Amazon RDS) Custom for SQL Server is a managed database service for custom and packaged applications that require access to the underlying operating system (OS) and database (DB) environment. Amazon RDS Custom for SQL Server automates the setup, operation, and scaling of databases in the cloud while granting access to the […]

Visualize and explore knowledge graphs quickly by connecting metaphactory to Amazon Neptune

Knowledge graphs consolidate and integrate an organization’s information assets and make them more readily available to all members of the organization. There are many applications and use cases that are enabled by knowledge graphs. Graphs are a natural way to model and represent information about the world. This idea is not new, but has now […]

Amazon RDS Multi-AZ with two readable standbys: Under the hood

In this post, I discuss Amazon Relational Database Service (Amazon RDS) Multi-AZ DB cluster configurations for Amazon RDS for MySQL and Amazon RDS for PostgreSQL database instances. When you create a Multi-AZ DB cluster, Amazon RDS maintains a primary and two readable standby copies of your data. If there are problems with the primary copy, […]

Build a mortgage-backed securities data model using Amazon Neptune

As organizations adopt modern application architectures such as microservices, application teams tend to retrofit one-size-fits-all databases. The mortgage industry is going through unprecedented transformation due to changing generation technologies such as API adoption. In the mortgage industry, API-enabled software allows lenders, issuers, borrowers, and more to integrate different functionalities into their portal, meaning they bring […]