AWS Database Blog
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 […]
Achieve up to 17x lower replication lag with the new write-through cache for Aurora PostgreSQL
Amazon Aurora PostgreSQL-Compatible Edition recently added the logical replication write-through cache. The logical replication write-through cache helps improve performance by reducing the amount of Aurora storage I/O that takes place during logical decoding. When you use the write-through cache, the logical decoder looks in the cache first for data to satisfy queries; if the data is […]
Using an Oracle Database Gateway to connect Amazon RDS Custom for Oracle to PostgreSQL
Amazon Relational Database Service (Amazon RDS) Custom for Oracle allows you to run Oracle databases on AWS, giving you some of the benefits of Amazon RDS automation and the freedom of changing configurations to match different use cases. While working with customers, we have observed use cases that require a connection to be kept with […]
Introducing 99.99% Availability with Amazon ElastiCache for Redis and Amazon MemoryDB for Redis
A managed cloud service eliminates the tedious task of managing infrastructure and offers several key benefits, including scalability, cost savings, and security. These benefits make it compelling for mission-critical applications to move to the cloud. High availability is especially important for these applications because any downtime can cause loss of revenue, impact team productivity, and […]
Migrate your Oracle pluggable database to Amazon RDS for Oracle
Many customers have Oracle multi-tenant databases in their on-premises environments, and may be looking to use Amazon Relational Database Service (Amazon RDS) for Oracle features while using multi-tenant databases. As of August 2022, Amazon RDS for Oracle supports a subset of multi-tenant architecture called single-tenant architecture. A multi-tenant architecture enables an Oracle database to function […]
How Earnin built their ledger service using Amazon QLDB
Amazon QLDB made Earnin’s mobile application more reliable, secure and fast. It also made our backend simpler and allowed our data scientists to be more efficient.