AWS Database Blog

Speed up database migration by using AWS DMS with parallel load and filter options

Some migrations might take a long time because they have large tables. However, AWS Database Migration Service (AWS DMS) features such as parallel load and filters might be able to help speed up this process. AWS DMS is a data migration service that has robust features for supporting both homogenous and heterogeneous database migrations. AWS […]

Amazon Managed Blockchain sessions and workshops from AWS re:Invent 2022

Engaging with the customers at AWS re:Invent is always a great opportunity for us to learn more about their use cases, get their feedback on our services, and present new features and capabilities. The Amazon Managed Blockchain team conducted a series of presentations and workshops that focused on how customers are using blockchain technology and […]

Improve application availability on Amazon Aurora

An Online Transaction Processing (OLTP) database is a key building block of a highly available application. Business-critical workloads can leverage Amazon Aurora database clusters in Multi-AZ configuration to help improve their overall uptime, and reduce the impact of availability-related events such as Multi-AZ failovers. In this post, we discuss aspects of Amazon Aurora related to […]

Use point-in-time recovery to restore an Amazon DynamoDB table managed by AWS CDK

Point-in-time recovery (PITR) in Amazon DynamoDB is a fully managed capability that creates continuous backups of your DynamoDB table data. Continuous backups are important to ensure business continuity and compliance with regulations, and to protect against human errors, such as unintended writes or deletes. When PITR is enabled for a DynamoDB table, DynamoDB automatically backs […]

Choose shard keys to optimize Amazon DocumentDB Elastic Clusters

As applications grow, data grows as well, so it’s imperative for a modern cloud-based application to have a database that can automatically scale. Amazon DocumentDB (with MongoDB compatibility) is a fully managed, native JSON database built with a flexible schema for enterprise applications that decouples storage and compute, improving scalability and reducing time-consuming administrative tasks. […]

Monitor SQL Login creation on Amazon RDS for SQL server

Maintaining database security is indispensable for the success of any organization. Implementing database user authentication and authorization is an important step in securing a database system. Conventional database authentication is based on a username-password mechanism. This process requires constant time and effort from both DBAs and end users to manage the credentials. In contrast, incorporating […]

Data modelling for an internet-scale online transactional system using Amazon DynamoDB

Relational database management system (RDBMS) technology was the preferred choice for data storage for decades. In recent years, the rise of internet-scale applications and exponential data growth have challenged the way industries have designed their database strategies. Organizations are seeing clear benefits in scalability and performance by migrating mission-critical online transactional systems built on RDBMS […]

Configure Kerberos authentication for Amazon RDS for PostgreSQL without joining an Active Directory domain

Organizations that adopt centralized authentication mechanisms gain the following benefits: Enhanced security posture: Centralized authentication enables quick addition or removal of user access throughout the network, giving organizations improved security and the ability to respond quickly to security threats. Scalability: By controlling access through a centralized database, organizations can scale their network and minimize performance […]

Use semantic reasoning to infer new facts from your RDF graph by integrating RDFox with Amazon Neptune

Semantic reasoning is a powerful form of symbolic AI that brings meaning to data. At a high level, this is achieved by inferring new facts from existing information (or base facts) using a data model and knowledge of the domain. It can be useful for performing calculations, ensuring consistency, and detecting intricate patterns. Semantic reasoning […]

Query data with DynamoDB Shell – a command line interface for Amazon DynamoDB

For newcomers to DynamoDB, the learning curve can be steep, so we developed DynamoDB Shell (ddbsh), an open-source command line interface for Amazon DynamoDB. One of the objectives of ddbsh is to provide a simple and intuitive environment for newcomers to DynamoDB that allows them to get started by running familiar SQL-like commands. The query […]