Sign in Subscribe

Architecture

A collection of 111 issues

High-Performance Calculations with Teradata Ordered Analytical Functions

Teradata employs two distinct approaches in Ordered Analytic Functions for preparing the data layout necessary for processing. This article explains both approaches and their respective advantages and disadvantages. Teradata Ordered Analytical Functions Teradata Analytic Functions are versatile tools that allow for a wide range of applications. The ability to retrieve

Detecting Overlapping Time Periods with Teradata OVERLAPS Command: A Simple Syntax Guide

Learn how to use the Teradata OVERLAPS command to detect overlapping time periods with this example query. Caution: minimum overlap required.

Teradata Columnar Compression Methods: Run-Length, Dictionary, and Delta Compression

Learn about the benefits of compression in Teradata Columnar, including a reduction in permanent space and disk IOs. Different compression methods are used, including run-length, dictionary, and delta compression. This article explains how each method works and the advantages of using them.

Designing Small Reference Tables for Teradata: Storing All Rows on One AMP for More Efficient Queries

Teradata Statistics Design for High Performance: An Introduction

Learn how Teradata 14.10 simplifies statistics collection for better performance. Discover new features that identify unused and missing statistics.

VantageCloud Lake: Turbocharge Your Data Warehousing with Teradata's Innovative Solution

Introduction Parallel database architectures have undergone significant advancements over the past four decades, transitioning from shared memory architecture to shared disk architecture and, finally, to the more efficient shared-nothing architecture. Databases designed specifically for cloud environments incorporate elements of shared-disk and shared-nothing architectures. Teradata is a powerful and scalable relational

Teradata: Unleashing the Potential of a Powerful Data Warehouse Solution

Enhancing Your Teradata Vantage Design with Teradata Historisation: A Comprehensive Method

Teradata ALTER Table vs. INSERT INTO: Which Method is Efficient?

Teradata ALTER Table versus INSERT INTO Altering the structure of a substantial Teradata table can consume significant resources. Essentially, there are two approaches: altering the DDL through Teradata ALTER TABLE or generating an empty table with the desired DDL statement and transferring data via the Teradata INSERT INTO statement. Each

Understanding Teradata Hash Collisions - A Case Study

To comprehend the issue of Teradata hash collisions, I will briefly explain how rows are allocated. If you are unfamiliar with Teradata Architecture or require a refresher, I suggest reading the following article beforehand: https://letters.dwhpro.com/content/files/2026/05/teradata-physical-storage.html As you know, a hashing algorithm