Sign in Subscribe

Data Modeling

A collection of 20 issues

The Apprenticeship That Vanished

Banks are cutting junior data engineers today. The bill comes due in 2035. The 2026 layoff numbers are real. Tens of thousands of tech workers lost their jobs in early 2026, with a disproportionate share hitting junior roles. The official narrative is that AI made these jobs redundant. That narrative

Teradata - Merging two change history tables

Real-World Map-Reduce Implementations: Design and Fault Tolerance

Here is an illustration depicting the design of real-world map-reduce implementations, such as Hadoop: The input files reside in a distributed file system, such as HDFS for Hadoop, or GFS as Google calls it. Worker processes handle mapper or reducer tasks. Want more practical data engineering analysis like this? Join

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

Teradata Referential Integrity: What it is and Why You Need it for Data Consistency and Performance

Introduction to Teradata Referential Integrity What is Teradata Referential Integrity?Referential integrity ensures that a value created in a foreign key (FK) column of a referencing (child) table also exists as a primary key (PK) in the referenced (parent) table. The parent table's column does not have to

7 Deadly Sins That Destroy A Teradata Data Warehouse

The Importance of Teradata Surrogate Keys

What are Teradata Surrogate Keys? A Teradata Surrogate Key is an artificial key that maps to a natural key. It is usually of the data type INTEGER or BIGINT and is represented by a single column. The natural key can consist of multiple columns. The surrogate key is generated automatically

Why You Need a Performance Specialist for Your Data Warehouse Project

The Importance of a Good Data Model for Teradata Performance Optimization

Welcome to part two of our Teradata performance optimization series. In this article, we will delve into how a good data model can prevent future performance issues in data warehousing projects. We will also discuss the drawbacks of taking over operational systems' source definitions directly and th

Understanding Soft Referential Integrity and Its Role in Improving Performance

Learn about referential integrity and how it ensures data consistency in databases. Discover soft referential integrity and its use in inner join elimination.