Introduction to Temporal Data Management in Teradata
Learn about Teradata's temporal data management functionality based on TSQL2 specification in this article. Discover how it simplifies historization.
Data Modeling
A collection of 20 issues
Decomposable Columns: Definition, Impact on Performance, and Workarounds
Learn about decomposable columns, which can be split and lead to better performance for data access. Find out how to optimize their use in this guide.
The Importance of PDM in Database Compression and Resource Usage Optimization
The importance of the PDM
Compression is a widely used method for reducing IOs by enabling the accommodation of more rows in each data block. Data blocks are the smallest unit exchanged between hard drives and main memory, which is the most costly operation in any database system.
Compression can
Effective Teradata Performance Optimization: A Guide to Measuring Improvements
Optimizing Teradata performance can be time-consuming and unpredictable. Before starting, it's crucial to define clear goals and measure improvements using absolute criteria like CPU usage and disk access. In this article, we'll explore the areas that can be optimized in a typical Teradata Data Ware
Teradata Statistics Maintenance: Milestones, Aging and Recollection, Collection Statement Register, and Triggered Partial Recollection Specification
Learn how to maintain your Teradata data warehouse to keep it running smoothly. Discover how to collect statistics and refresh them as needed.
Data Modeling Considerations for Teradata: SET and MULTISET Tables
Discover the differences between Teradata MULTISET and SET tables for effective data modeling. Learn how to avoid duplicates and improve performance.
Teradata Denormalization for Performance Tuning
Avoid data warehouse project failures by choosing the right data model. In this article, we explore denormalization techniques for when it makes sense, including repeating groups, prejoins, and derived information. We also discuss alternatives to denormalization, such as Global Temporary Tables and
Teradata Tuning: Fixing The Broken Data Model
Learn about the challenges of Teradata Performance Optimization from an expert. Discover why fixing a poorly designed data model is critical to success.
Data Modeling and the Teradata FSLDM
Overview
* What is A Data Model?
* What are the Major Types of Data Models?
* What is FS-LDM?
* How is FS-LDM Implemented?
Dimensional Modeling
* Dimensional Modeling (DM) is a modeling technique in data warehousing, visually represented as a fact table surrounded by dimension tables.
* Some of the terms commonly used in
Teradata Historisation - Daily snapshot to change history
For various reasons, we may need to switch our Teradata historisation from snapshot tables to a start date/end date logic table, which I usually call a change history, as only changes trigger a historisation.
A principal motivation for such a move away from a daily snapshot table could be