Category: Database

Horizontally scaling a SQL database involves separating the write-master from read-only servers. This allows the write server to perform dedicated write operations rather than processing redundant read queries. However, writing to one node and reading from another can result in inconsistent data due to synchronization delays. Heimdall Data offers a database proxy to help developers and architects achieve optimal scale from their Amazon RDS and Amazon Aurora environment without any application changes.

Are you thinking of deploying VMware Greenplum on the AWS Cloud? Many customers also want to shift the responsibility for infrastructure to AWS, considering the alternatives. With VMware Greenplum on AWS, deployments are completely automated and completes in less than an hour. VMware Greenplum is a commercial fully-featured MPP data warehouse platform powered by the open source VMware Greenplum Database. It provides powerful and rapid analytics on petabyte scale data volumes.

Amazon Redshift is a fast, scalable, easy-to-use data warehouse solution built on massively parallel processing (MPP) architecture and columnar storage. SnapLogic is an easy-to-learn data integration tool that allows business analysts and integration specialists to accomplish data ingestion from various sources into Redshift. The SnapLogic Redshift Bulk Load Snap (pre-built connector) is part of the SnapLogic Intelligent Integration Platform and enables loading large volumes of data rapidly into Redshift all at once.

Many organizations are looking to migrate existing, on-premises enterprise data warehouse systems to cloud-based data warehouse systems such as Amazon Redshift. Here, we discuss how Cognizant’s Intelligent Migration Workbench (IMW) can be used to accelerate the data warehouse migrations while converting Oracle PL/SQL and Tetradata BTEQ scripts. IMW makes it easy to move mission critical proprietary code to AWS, giving customers competitive edge through faster time to market.

Rewriting an application code for performance optimization generally requires a significant amount of effort. Also, IT and development groups using third-party applications like Tableau may not have access to the application code. Heimdall’s database proxy solution offers a flexible and cost-effective alternative to rewriting your application for performance and scale. Heimdall transparently provides SQL control and visibility to the application owner without (re)writing a single line of code.

AWS Premier Partner Apps Associates, an industry leader for migrating and managing Oracle workloads to the cloud, recently conducted an independent survey of more than 300 Oracle application customers to uncover what’s holding IT decision makers (ITDMs) back from moving their Oracle apps to the cloud. The study uncovered several myths that many ITDMs still believe to be true, although many of these myths have since been debunked—not by declaration but by repeatable, proven success.

Questis, a configurable technology platform for financial intermediaries, realized their backend infrastructure required additional development to improve performance, provide high-availability, and rapidly scale to meet the needs of Questis customers accessing the platform. Learn why they chose to team up with Heimdall Data, an AWS Competency Partner that offers a transparent database proxy and gives developers SQL visibility and control to improve backend performance and scalability.

Metaphactory is a graph data management platform that helps you build knowledge graphs and smart applications. It makes authoring, curating, editing, linking, searching, and visualizing graph data easy, fast, and affordable. Amazon Neptune supports open-source and open-standard API operations and allows you to use existing information resources to build your knowledge graphs and host them on a fully managed service.

With the introduction of Amazon Aurora Serverless (currently in preview), SaaS providers are now equipped with a model to bring the scale and cost efficiency of serverless computing directly to storage partitioning models of SaaS solutions. We take a closer look at how Aurora Serverless works and how it influences your approach to storage partitioning in SaaS environments. The goal here is to highlight the implications of the serverless storage model, identifying key areas that will be of particular interest to SaaS developers.

NTT DATA Services provides a mainframe re-host solution that minimizes application code change while benefiting from the agility AWS offers. NTT DATA’s re-hosting reference architecture, migration best practices, and extensive technology feature set streamline mainframe migrations to AWS. NTT DATA is an APN Advanced Consulting Partner that helps clients navigate and simplify the modern complexities of business and technology, delivering the insights, solutions, and outcomes that matter most to their objectives.