Category: Database

Amazon Redshift is a column-oriented database management system that stores data in columns, making it quicker to analyze data. The platform also performs a continuous backup of data, eliminating the risk of losing data or the need to plan for backup hardware. Learn how Hexaware’s automated platform, Amaze for Data & AI, transforms on-premises data warehouse ecosystems to the cloud while ensuring business keeps running smoothly and uninterrupted.

Learn how to implement database software development lifecycle (SDLC) automation when leveraging the AWS Amplify framework to quickly create a three-tier web application following cloud engineering best practices. This approach from AWS Premier Partner Innovative Solutions leverages the AWS Code suite coupled with the Amplify CLI to integrate database migrations against an Aurora Serverless V1 PostgreSQL cluster with deployment of an Amplify project.

ScyllaDB is a wide-column NoSQL database for data-intensive applications requiring high throughput and low latency. It was invented to take advantage of modern, highly performant cloud servers, including the new Amazon EC2 I4i series servers based on Intel Ice Lake x86 processors, and the Is4gen and Im4gn series which use Arm-based Graviton2 processors. ScyllaDB is fully compatible with Apache Cassandra and Amazon DynamoDB and is AWS Outposts Ready for on-premises deployments.

Learn how to use ShardingSphere-Proxy to build database clusters, covering aspects such as sharding, read/write splitting, and dynamic configuration. Apache ShardingSphere is an ecosystem of open-source distributed database solutions, including JDBC and Proxy products, which can be deployed either independently or in combination. The commercial edition provides additional data security and data sharding features from AWS Partner SphereEx.

Many IBM Db2 customers are exploring modernizing their databases by moving them into a containerized environment such as Red Hat OpenShift, Amazon EKS, or IBM’s Cloud Pak for Data. Getting to the end goal of containerizing your database takes a lot of time and effort. To streamline this process, IBM has developed a new utility called Db2 Click to Containerize (also known as Db2 Shift) to help customers move their databases quickly and easily from an on-premises Db2.

Deloitte’s Cloud Managed Services practice helps clients design, build, and operate end-to-end solutions in addition to managing critical business applications running in the cloud. Explore a new feature of AWS Backup for SAP HANA databases running on Amazon EC2, and learn how to integrate HANA database with the AWS Backup service and how to perform a full HANA database backup and restore using AWS Backup.

Learn how the Heimdall Database Proxy can be configured to provide customer query routing for Amazon RDS for Postgres, although any SQL database type including Amazon Redshift can be supported. This provides a single Heimdall Proxy endpoint to access data for multiple customers from multiple databases, transparently. Heimdall Data provides functionality needed to support many complex database environments, and solves many of the challenges in scaling database access.

Today’s customers demand personalized service. To meet these expectations, enterprises must continuously learn, evolve, and develop mechanisms to drive usability and improve the omnichannel experience. In this post, you’ll learn about the Infosys Customer Intelligence Platform (CIP), a solution built using Amazon Neptune and AWS to accelerate data ingestion, data processing, data modeling, and data analytics.

Learn how to set up Active Directory authentication with authorization for Postgres. Heimdall Data provides synchronization scripts for other databases as well, allowing all Amazon RDS instance types to be supported in a similar way. Using Active Directory authentication allows organizations to standardize their password and authorization management via a globally available authentication store, reducing management overhead and improving security and auditing capabilities.

As organizations run mission-critical databases on Oracle Exadata, businesses are increasingly looking for proof points of like-to-like performance of these databases on Amazon Web Services (AWS). This post explores how Tata Consultancy Services (TCS) supported a UK-based utility provider’s digitalization journey by comparing performance of their on-premises Oracle Exadata database with Amazon RDS for Oracle.