DWHPro Insights

Architecture

“Explore Teradata’s Shared Nothing Architecture with Our Video Course”

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

This historical video introduces Teradata’s classic shared-nothing architecture and component interactions. Hashing does not guarantee even data or workload distribution: primary-index values, maps and intermediate-result skew matter. Platform-specific details in the recording should be checked against current documentation. http://youtu.be/uwRdLr8sRdY

Teradata Physical Storage: Understanding the Technical Details for Performance Optimization Most read

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

A thorough understanding of the Teradata system’s technical intricacies is crucial to attaining expertise in performance optimization. Although many of us are knowledgeable about existing optimization opportunities, resolving complex performance issues often requires an in-depth understanding of internal data storage. The physical medium may be HDD, SSD or a cloud storage service, depending on deployment. …

Read more

Teradata Data Access: Single-AMP vs. All-AMP Binary Search and Sequential Search Popular

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

Teradata data access is categorized based on the number of AMPs involved and the technique employed to search rows within a data block. 🎓 Prefer video? Lecture 6 of my Udemy course Teradata Performance Tuning in Practice, “The access paths the optimizer can choose”, covers this topic. See the course on Udemy → In our …

Read more

The Teradata RDBMS

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

Introduction Teradata is a name synonymous with data warehousing and large-scale data analytics. Teradata has provided organizations with innovative solutions and technologies for over four decades as a pioneer in the field. This article will delve into the fascinating world of Teradata, exploring its history, architecture, and diverse applications. We will also address some common …

Read more

Teradata Transient Journal: How It Protects Transactions Against Failures and Deadlocks Most read

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

Learn about the Teradata Transient Journal, a crucial component for ensuring data integrity and protecting against system failures. This dictionary table is managed by each AMP, containing rows copied before changes are made to a transaction. If a transaction fails, the journal is used to roll back and restore the affected table rows. Discover ways to minimize journaling and improve performance, including BTEQ tricks and using load utilities. Find out how to avoid system-level errors and ensure there is always enough permanent space in the DBC database.

Protected by Security by CleanTalk and CleanTalk Anti-Spam