AWS Database Blog

Legacy application modernization can be complex. To reduce complexity and risk, you can choose an iterative approach by first replatforming the workload to Amazon Aurora. Then you can use the cloud-native integrations in Aurora to introduce other AWS services around the edges of the workload, often without changes to the application itself. This approach allows […]

When you authenticate with a web or mobile application, you typically do so with a username and password where you’re authenticated against a user database such as Amazon Cognito. You’re expected to secure your password and rotate it periodically or when it has been compromised. When you’re building a user-facing application that is running on […]

July 2023: This post was reviewed for accuracy. Monitoring SQL Server is an essential aspect of any relational database management system (RDBMS) when dealing with performance problems. Many of our customers want to capture certain systems and user-defined events for monitoring and troubleshooting problems related to SQL Server. SQL Server logs these events in SQL […]

In the first part of this series, we discussed several use cases for including a second Region in your disaster recovery (DR) plans for your Amazon Relational Database Service (Amazon RDS) for Oracle  database instances. We also introduced cross-Region automated backups to assist you in establishing and maintaining cross-Region point in time restore (PITR) capability for your Amazon […]

Today, customers using Amazon Relational Database Service (Amazon RDS) for Oracle have several managed high availability (HA) and disaster recovery (DR) capabilities to choose from based on your business requirements and use cases: With Amazon RDS Multi-AZ, you get enhanced availability and durability for database (DB) instances within a specific AWS Region. This is often […]

October 2022: This post was reviewed and updated with a new architecture diagram and code updates to factor the change from CDK 1.x to CDK 2.x. Amazon ElastiCache for Redis is an AWS managed, Redis-compliant service that provides a high-performance, scalable, and distributed key-value data store that you can use as a database, cache, message […]

A common practice when creating a data model design, especially in the relational database management system (RDMS) world, is to start by creating an entity relationship diagram (ERD). Afterwards, you normalize your data by creating a table for each entity type in your ERD design. The term normalization refers to the process of organizing the […]

When using a document data store as your service’s source of truth, you may need to share the changes of this source with other downstream systems. The data events that are happening within this data store can be converted to business events, which can then be sourced into multiple microservices that implement different business functionalities. […]

This is a guest post by Russell Waterson, Knowledge Graph Engineer at Data Lens Ltd. Customers use knowledge graphs to consolidate and integrate information assets and make them more readily available. Building knowledge graphs by getting data from disparate existing data sources can be expensive, time-consuming, and complex. Project planning, project management, engineering, maintenance and […]

This is a guest post by Russell Waterson, Knowledge Graph Engineer at Data Lens Ltd. Customers use knowledge graphs to consolidate and integrate information assets and make them more readily available. Building knowledge graphs by getting data from disparate existing data sources can be expensive, time-consuming, and complex. Project planning, project management, engineering, maintenance and […]