DWHPro Insights

data block

Introduction to Teradata Big Data Blocks: Advantages and Disadvantages

Illustration of a stopwatch dial on an orange paint-splash background

Teradata Big Data Blocks – Introduction Teradata 13.10 introduced larger file systems components, such as cylinders and data blocks. The cylinder size was increased from 1.9 MB to 11.3 MB, while the data block size limit was raised from 127.5 KB to 1 MB in Teradata 14.10. Current Database Limits documentation lists maximum non-spool row …

Read more

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

The Importance of PDM in Database Compression and Resource Usage Optimization

Illustration of a stopwatch dial on an orange paint-splash background

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 be automated through block-level compression …

Read more

Teradata Physical Storage: Exploring Data Blocks and Storage Demographics Widely read

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

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 …

Read more

Protected by Security by CleanTalk and CleanTalk Anti-Spam