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 …
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 …
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 …
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 …
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 →
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 …
We count visits without cookies and without storing anything on your device. With your permission, we also use Google Analytics for our Google Ads integration and remember which campaign brought you here. We do not record sessions. You can decline and still use the site. Privacy details.