DWHPro Insights

Architecture

Understanding the Downsides of Data Lakes: Challenges and Pitfalls to Consider

Illustration of three stacked database units of differing heights inside a circle

Introduction Data lakes have gained significant popularity in recent years as organizations seek more flexible and scalable solutions to store and process their ever-growing volumes of data. While data lakes offer numerous advantages over traditional data storage and processing systems, they also have their fair share of challenges and pitfalls. In this critical article, we …

Read more

Teradata Native Object Store on AWS, Microsoft Azure, and Google Cloud Popular

Illustration of three stacked database units of differing heights inside a circle

Teradata Vantage has also made its move into the public cloud. Teradata Vantage is now available in AWS, Microsoft Azure, and Google Cloud. It is worth noting that the same Teradata software runs on these three major cloud providers. This makes it relatively easy to run Teradata on-premise and in these 3 different public clouds …

Read more

Maximizing Performance with Teradata Sparse Maps: An Introduction

Illustration of three stacked database storage units of differing heights against abstract chart shapes

Introduction to Teradata Sparse Maps The Teradata hashing architecture and how AMPs are used to split tables for maximum parallelism evenly have been unchanged since the beginning. What is new is the ability to create your hash maps. Hash maps, as we usually know them, are also called contiguous maps. If you are not familiar …

Read more

The Teradata MAPS Architecture – Great Performance with All Rows on One AMP Popular

Illustration of three stacked database units of differing heights inside a circle

For a history table, ref_code alone cannot be unique when several versions of a code must coexist. The large-table example therefore uses a nonunique primary index. Define any required version uniqueness separately, and enforce the rule for identifying the current row. How to use the Teradata MAPS Architecture? In an earlier article (link to All …

Read more

Understanding Teradata AMPs and their tasks in a Teradata system Widely read

Illustration of three stacked database storage units of differing heights against abstract chart shapes

The components around the AMP are covered separately: how the PE, BYNET and AMP divide the work and a short overview of the architecture. 🎓 Prefer video? Lecture 2 of my Udemy course Teradata Performance Tuning in Practice, “Shared-nothing parallelism: nodes, PEs and AMPs”, covers this topic. See the course on Udemy →

Teradata Physical Storage: Exploring Data Blocks and Storage Demographics Widely read

Illustration of three stacked database units of differing heights inside a circle

This is a conceptual explanation with historical implementation examples. Logical cylinders and sectors do not imply mechanical disk geometry, and exact packing thresholds must be checked for the target release. It is not an instruction to run storage-maintenance utilities on a live system. Introduction to Teradata Physical Storage In the second part of this series …

Read more

Protected by Security by CleanTalk and CleanTalk Anti-Spam