AWS Database Blog

Category: Database

Automate high availability setup in Amazon RDS Custom for Oracle

Amazon Relational Database (Amazon RDS) Custom automates database administration tasks and operations. RDS Custom makes it possible for you as a database administrator to access and customize your database environment and operating system. With RDS Custom, you can customize to meet the requirements of legacy, custom, and packaged applications. Amazon RDS Custom for Oracle supports […]

Use Amazon Aurora Global Database to set up disaster recovery within India

Disaster recovery (DR) ensures that businesses can continue to operate in the event of an unexpected disruption, such as a natural disaster, power outage, or cyberattack. Maintaining resilience is key to operational success for your business, and disaster recovery planning plays a vital role in that. Many regulators across multiple industries are mandating disaster recovery […]

Improve query performance and reduce cost using scheduled queries in Amazon Timestream

In this post, we show you how to use scheduled queries in Amazon Timestream to improve your query performance and reduce cost. Scheduled queries make real-time analytics more performant and cost-effective, so you can derive additional insights from your data and continue to make better business decisions. Timestream is a serverless time series database that […]

Accelerate large database ­­­migrations to Amazon RDS Custom Oracle ­­­using Tsunami UDP

One of the steps in migrating a database to the cloud involves transferring existing data from the source (on premises) to the target (cloud). For medium and large databases, such as those ranging from hundreds of gigabytes to 5 terabytes, speed of data transfer matters. One of the challenges is to minimize the downtime of […]

Building AI-powered search in PostgreSQL using Amazon SageMaker and pgvector

Organizations across diverse sectors are exploring novel ways to enhance user experiences by harnessing the potential of Generative AI and large language models (LLMs). In the fashion industry generative AI is revolutionizing the creative process. By analyzing user preferences and data, AI algorithms can generate unique apparel patterns and designs, bringing a new level of […]

Secure your data with Amazon RDS for SQL Server: A guide to best practices and fortification

Securing SQL Server databases in the cloud is critical, and Amazon Relational Database Service for SQL Server (Amazon RDS) provides several security features to help ensure the confidentiality, integrity, and availability of your database instances. These features include data encryption at rest and in transit, secure user authentication and authorization mechanisms, network isolation, and fine-grained […]

Choose the right Amazon RDS deployment option: Single-AZ instance, Multi-AZ instance, or Multi-AZ database cluster

In addition to offering you a choice of seven well-known engines, Amazon Relational Database Service (Amazon RDS) also offers a number of deployment choices to assist you in selecting the option that best suits your workload. You can evaluate your requirements and then choose the right set of service offerings. In the latest set of […]

Build a knowledge graph on Amazon Neptune with AI-powered video analysis using Media2Cloud

A knowledge graph allows us to combine data from different sources to gain a better understanding of a specific problem domain. In this post, we use Amazon Neptune (a managed graph database service) to create a knowledge graph about technology products. In addition to the data we already have in the graph, we add the […]

Joining historical data between Amazon Athena and Amazon RDS for PostgreSQL

While databases are used to store and retrieve data, there are situations where applications should archive or purge the data to reduce storage costs or improve performance. However, there are often business requirements where an application must query both active data and archived data simultaneously. Developers need a solution that lets them benefit from using […]

Working with JSON data in Amazon DynamoDB

Amazon DynamoDB allows you to store JSON objects into attributes and perform many operations on these objects, including filtering, updating, and deleting. This is a very powerful capability because it allows applications to store objects (JSON data, arrays) directly into DynamoDB tables, and still retain the ability to use nested attributes within these objects in […]