AWS Database Blog

Databases form a key part of any enterprise and managing databases during an M&A requires careful planning and implementation to ensure a smooth transition and to maintain data integrity. In this post, we highlight some of the key considerations for successful database management during a merger or acquisition spanning from data assessment to integration strategies.

For those seeking to achieve consistent database transaction performance, HAQM RDS has introduced a new feature: dedicated log volume (DLV). This feature is an additional storage volume specifically for database transaction logs. In this post, we examine common DLV performance benefits, use cases, monitoring capabilities, and the cost of deployment.

In this post, we explore how to transition from using Rockset to OpenSearch Service for your DynamoDB use-case effectively. To illustrate this integration, we consider a real-world example of a gaming company that tracks user interactions, such as in-game purchases and player scores, using DynamoDB. This data needs to be analyzed in real time to provide insights into user behavior, detect anomalies, and personalize the gaming experience.

Solutions on AWS help you simplify cloud adoption and accelerate time-to-value by delivering proven, ready-to-deploy architectures tailored for industry, cross-industry, and technology use cases. We have recently added a number of Guidance topics to Solutions for Databases. In this post, we provide a quick reference to the newest Guidance and how it can be used to address your business needs.

In this post, we explore the steps to configure Oracle RAC as a source for AWS DMS.

HAQM RDS for SQL Server now supports configuring password policies for logins using SQL Server Authentication. In this post, we guide you through the process of enabling the password policy for HAQM RDS for SQL Server and creating a SQL Server login that adheres to the policy.

In this post, we demonstrate a process for migrating an HAQM QLDB ledger into HAQM Aurora PostgreSQL using the US Department of Motor Vehicles (DMV) sample ledger from the tutorial in the HAQM QLDB Developer Guide as an example. You may use this solution as a foundation for your own migration, altering it as necessary for your schema and migration strategy.

In this post, we discuss how to use HAQM Aurora PostgreSQL-Compatible Edition as an alternative to HAQM QLDB for auditing and what features of HAQM Aurora PostgreSQL can replace some of the unique capabilities offered by HAQM QLDB.

In this post, we discuss other native indexes supported in HAQM Aurora PostgreSQL-Compatible Edition and HAQM Relational Database Service (HAQM RDS) for PostgreSQL, including GIN, GiST, HASH, and BRIN, and their use cases.

In this series of posts, we discuss index types supported in HAQM Aurora PostgreSQL-Compatible edition and HAQM Relational Database Service (HAQM RDS) for PostgreSQL and their use cases. In this post, we discuss the native B-tree index and its variations.