Teradata moved towards the cloud in order not to lose the connection to modern cloud databases. How the essential things like security, backups, sizing are solved, I show you with the AWS Cloud solution from Teradata.

Read More

What Are Zero-Copy Clones? We all know the following situations: For certain operations, we need to make a backup of tables before making changes. If the tables are relatively small, this is not a big issue. A copy can be made quickly, and in case of an error, it is easy to revert to the

Read More

In this blog post, I will show you what you need to pay special attention to when you switch from Teradata to Snowflake. We will look at the effect of executing DML statements (such as UPDATE or DELETE) in Snowflake and compare this with Teradata Row Storage and Column Storage.

Read More

Anyone who has been dealing with Teradata for a long time knows what a primary index is. But at some point, a new term crept in with Teradata Release 15: Primary AMP Index. In this blog post, I will show you what it is, and when a Primary AMP is best used to improve the

Read More

Cloud databases put traditional MPP systems in the area of data warehousing under increasing pressure. Why this is so and the advantages and disadvantages of both types of database systems I show you in this blog post. The Architecture Of A MPP Database System MPP database systems are shared-nothing systems. Each node has its CPU,

Read More

In this article, I will explain the main differences in the Architecture between Teradata and Snowflake. It is not meant to be a complete comparison of all features or advantages and disadvantages but is limited to the differences from an architecture perspective. Snowflake vs. Teradata Architecture Snowflake vs. Teradata Summary As you have seen, at

Read More

This blog post will compare the architecture of these two popular database systems. As you will see, they are not that far apart, and you will find much of what you know about Teradata in Amazon Redshift. Even though Amazon Redshift always stores the data in columns, the similarities are big. And meanwhile, Teradata is

Read More

Introduction Teradata has several methods available to perform a join. However, they all have one requirement in common: The rows of two tables that are joined must be located on the same AMP. The selected join method, together with the way in which rows to-be-joined are copied to a common AMP, is called a join

Read More

Often we have already reduced the size of our tables immensely using Multivalue Compression, and yet we need more space. Shrinking A Teradata Table To A Minimum Size I used once a simple trick for you that has allowed me to reduce a table already optimized with multivalue compression to 10% of its size. This

Read More

By way of introduction, I would like to mention that Teradata block-level compression is often performed by default nowadays. Therefore, this blog post’s considerations are only useful on Teradata systems, where this is not the case. Since Teradata Block Level Compression has been around, I often see that multi-value compression is not used. First, I

Read More