AWS Database Blog

Category: Database

Natural language queries on Oracle Database 26ai: Getting started with Select AI on Amazon RDS for Oracle with Amazon Bedrock

Oracle Database 26ai is now available on Amazon RDS for Oracle, bringing generative AI, vector search, and machine learning into the engine. In this post, part 1 of a three-part series, learn how to set up Select AI to run natural language queries against your relational data using foundation models on Amazon Bedrock, all from within a private Amazon RDS instance.

Enforcing TLS and managing certificate rotation for RDS and Amazon Aurora PostgreSQL

Enforcing TLS and managing certificate rotation for RDS and Amazon Aurora PostgreSQL

When an Amazon RDS or Amazon Aurora PostgreSQL certificate expires and client trust stores aren’t updated, connections fail without warning. This post shows how to enforce TLS for all PostgreSQL connections, configure client-side certificate verification, and deploy automated monitoring that alerts you before certificate rotation events.

Migrate RDS and Aurora logs to CloudWatch Infrequent Access

Migrate RDS and Aurora logs to CloudWatch Infrequent Access

Organizations running Amazon RDS and Amazon Aurora often pay full CloudWatch Logs ingestion rates for database logs they rarely access. This post shows how to build an automated, tag-driven solution that migrates RDS and Aurora CloudWatch log groups from the Standard to the Infrequent Access log class and cuts log ingestion costs by about 50%.

Build zero-downtime write architectures for Amazon Neptune

Build zero-downtime write architectures for Amazon Neptune

Learn how to build zero-downtime write architectures for Amazon Neptune using a write queue pattern with Amazon SQS, Amazon Kinesis Data Streams, or Amazon MSK. By decoupling write acceptance from write execution, your application keeps accepting graph writes during maintenance windows, failovers, and scaling operations.

Oracle Machine Learning for SQL on Amazon RDS: Build machine learning models entirely in SQL

Oracle Machine Learning for SQL on Amazon RDS: Build machine learning models entirely in SQL

Learn how to build, train, and score a credit risk machine learning model entirely in SQL using Oracle Machine Learning for SQL (OML4SQL) on Amazon RDS for Oracle. The built-in AutoML feature selects the best algorithm automatically, with no data movement and no external machine learning platforms.

Detect CDC failures faster with AWS DMS

AWS DMS uses exponential backoff for recoverable errors, and default settings can let a change data capture (CDC) task retry silently for up to 30 minutes before failing. This post shows how to tune four recoverable-error settings so CDC tasks fail within minutes, and how to pair them with Amazon EventBridge and Amazon CloudWatch alerts.

Build semantic search with native vector support in Amazon DynamoDB

Many applications that use Amazon DynamoDB for operational data also need vector similarity search, which until now meant running a separate vector database. DynamoDB now supports native vector search. In this post, we build a semantic search application over research paper abstracts using Amazon Bedrock embeddings, and cover how vector search is metered.