AWS Database Blog

Amazon Aurora PostgreSQL database authorization using role-based access control

Many customers are using Amazon Aurora PostgreSQL-Compatible Edition for running their business-critical database workloads in AWS. Aurora PostgreSQL is a fully managed, PostgreSQL-compatible, and ACID-compliant relational database engine that combines the speed, reliability, and manageability of Amazon Aurora with the simplicity and cost-effectiveness of open-source databases. In this post, we present a database authorization solution […]

Managed Contributing to therapeutic drug development using Amazon Managed Blockchain

In the pharmaceutical industry, the cost of clinical research and clinical trials is extremely high, which results in higher drug prices and insurance expenses. Furthermore, the high costs have resulted in decreased numbers of clinical trials at national research institutes and universities, slowing the progress of pharmaceutical research. In addition, incidents of data falsification or […]

10 Amazon Aurora tips for application developers – Part 2

This is the second post of the two-part series on how application developers can take advantage of Amazon Aurora features, capabilities, and complementary services. In Part 1, we shared the first five tips: Split the application SQL read/write load to enhance your app’s performance. For Java apps, use AWS JDBC drivers for faster app recovery […]

10 Amazon Aurora tips for application developers – Part 1

Amazon Aurora is a MySQL- and PostgreSQL-compatible enterprise class database built from the ground up for cloud-native applications. Application developers write their code using standard tooling and libraries such as JDBC drivers for Java applications, and NodeJS packages for JavaScript applications. Developers often treat Aurora like a typical RDBMS database engine and fail to utilize […]

AWS Optimization and Licensing Assessments can help you to optimize Amazon RDS migration and usage costs

Oracle and Microsoft customers have been deploying their database workloads to Amazon Web Services in record numbers. The AWS Optimization and Licensing Assessment (AWS OLA) has helped many of these customers save on third party licensing costs and run their database resources efficiently on Amazon Elastic Compute Cloud (Amazon EC2) and VMware Cloud on AWS […]

Migrate Oracle Databases to AWS using transportable tablespace

Administering databases in self-managed environments such as on premises or Amazon Elastic Compute Cloud (Amazon EC2) requires you to spend time and resources on database administration tasks such as provisioning, scaling, patching, backups, and configuring for high availability. Organizations are moving their self-managed Oracle databases to AWS managed database services to offload undifferentiated heavy lifting […]

Friend microservices using Amazon DynamoDB and event filtering

The gaming industry has evolved significantly over the past few years. A feature that has become essential to that evolution is to be friends with other players and play together in the same game. From the players’ point of view, the process to become friends is straightforward. A player sends a friend request to another, […]

Migrate document workloads from Oracle SODA to Amazon DocumentDB

In this post, we show you a modernization path for the migration of your JSON workloads from on-premises databases to the AWS Cloud. You can move your document workloads to Amazon DocumentDB (with MongoDB compatibility), and use full capabilities of this purpose-built JSON database. Amazon DocumentDB is a fully-managed native JSON document database that makes […]

Implement vertical partitioning in Amazon DynamoDB using AWS Glue

In this post, we show you how to use AWS Glue to perform vertical partitioning of JSON documents when migrating document data from Amazon Simple Storage Service (Amazon S3) to Amazon DynamoDB. You can use this technique for other data sources, including relational and NoSQL databases. DynamoDB can store and retrieve any amount of data, […]

How to handle AWS DMS replication when used with Oracle database in fail-over scenarios

AWS Database Migration Service (AWS DMS) is used for migrating databases to AWS, but you can also use it for replicating data with low latency from any supported source to any supported target. When working with Oracle database, AWS DMS stops replicating data changes due to reset logs when the standby database is transitioned to […]