Sign in Subscribe

Roland Wenzlofsky

Follow me on LinkedIn for daily thoughts on data engineering, Teradata, Snowflake, AI, and the changing IT market: https://linkedin.com/in/rwenzlofsky

https://www.dwhpro.com

Teradata Columnar Solution: Advantages and Disadvantages

How Advanced Is The Teradata Columnar Solution? A Column Store is defined by three distinct properties: * Improved compression compared to Row Stores. This results from considerably better compression rates that we can achieve by packing columns into data blocks. Since the values of a column come from a domain, the

Improving Database Performance and Security with Teradata Write-Ahead Logging (WAL)

Accessing data has always been the bottleneck of database systems. Once the data resides in the main memory, it can be promptly processed. Although SSDs are now predominantly used instead of hard disks, copying data into the main memory remains the slowest operation. The Teradata Write-Ahead Logging (WAL) feature enhances

Understanding Teradata's Primary AMP Index for Improved Performance

Experienced Teradata users are familiar with the concept of a primary index. However, a new term has surfaced with the introduction of Teradata Release 15: Primary AMP Index. This blog post will demonstrate a Primary AMP Index's benefits and optimal usage for improving load and query performance. First,

Switching from Teradata to Snowflake: What to Know About DML Statements and Data Deletion

In this blog post, I will show you what you need to pay special attention to when switching from Teradata to Snowflake. Want more practical data engineering analysis like this? Join DWHPro Letters and get field-tested notes on Teradata, Snowflake, AI, migrations, performance, and enterprise data work. Early subscribers keep

Zero-Copy Clones: A Space and Time-Saving Solution for Database Management with Snowflake

What Are Zero-Copy Clones? We are all familiar with creating table backups before performing specific operations. This is not a significant problem for smaller tables, as duplicates can be swiftly created and any errors can be rectified by reverting to the backup table. If the table is enormous, making a

Comparing the Architecture of Amazon Redshift and Teradata: Similarities and Differences

This post will contrast the architecture of two widely-used database systems. The similarities between Teradata and Amazon Redshift are notable, as much of your knowledge about Teradata can be applied to Amazon Redshift. Although Amazon Redshift stores data in columns permanently, the similarities remain significant. Want more practical data engineering

Understanding Teradata Load Isolation

Teradata Transactions: Main Characteristics and Best Practices