What are Deadlocks? Deadlocks occur when each of two transactions holds the lock on a database object the other transaction needs next. Here is an example: Transaction 1 locks some rows in table 1, and transaction 2 locks some rows in table 2. The next step of transaction 1 is to lock rows in table 2, and transaction

Read More

The bottleneck of database systems has always been accessing the data. As soon as the data is in the main memory, it can be processed. Even though mainly SSDs are now used, and less and less hard disks, copying the data into the main memory is still the slowest process. Teradata WAL is a feature

Read More

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

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

What Are The Main Characteristics Of Transactions in Teradata? The Teradata Mode For Transactions There are several ways of writing SQL statements and making use of transaction handling. Each method has its own advantages, disadvantages, and behavior which has to be considered. As an example, let’s look at two statements which have to be executed

Read More

Teradata Sessions explained in a few Sentences Example 1: Multiple Sessions which do not improve Performance As shown in the graph above, all 4 transactions (T1, T2, T3, T4) are active on all AMPs simultaneously. Even if only one row is required, all of these transactions involve all AMPs to look this row up. None

Read More