Maximizing Performance with Teradata Sparse Maps: An Introduction

arch1

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

arch4

How to use the Teradata MAPS Architecture? In an earlier article (link to All Rows on One AMP – By Design), I showed an alternative design for small reference tables, ensuring that all rows in the table are stored on a single Teradata AMP using the Teradata MAPS architecture. The design allows for single-AMP retrieval …

Read more

Understanding Teradata Secure Zones: A Clear Explanation and Possible Use Cases

arch4

Teradata Secure Zones I’ve had a few conversations recently with different customers about the “Secure Zones” optional feature added in Teradata 15.10 based on those. There is a fair amount of misunderstanding about what this feature offers and does. This article aims to provide some clear information for anyone considering using this feature. Before I …

Read more

Teradata Physical Storage: Exploring Data Blocks and Storage Demographics

arch2

Introduction to Teradata Physical Storage In the second part of this series on Teradata Physical Storage, let me take over from Roland to continue where we stopped in part 1. We will enter the world of data blocks and dive deeper into the sequence of actions and consequences for the lives of rows populating data …

Read more

DWHPro

Expert network for enterprise data platforms. Senior consultants, project teams built for your challenge — across Teradata, Snowflake, Databricks, and more.

📍Vienna, Austria & Miami, Florida

Quick Links
Services Team Teradata Book Blog Contact Us
Connect
LinkedIn → [email protected]
Newsletter

Join 4,000+ data professionals.
Weekly insights on Teradata, Snowflake & data architecture.