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.
Here are your search results
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,
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
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
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
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
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