DWHPro Insights

Architecture

Teradata VantageCloud Lake: Architecture and Use Cases Widely read

Illustration of three stacked database storage units of differing heights against abstract chart shapes

Introduction Parallel database architectures have undergone significant advancements over the past four decades, transitioning from shared memory architecture to shared disk architecture and, finally, to the more efficient shared-nothing architecture. Databases designed specifically for cloud environments incorporate elements of shared-disk and shared-nothing architectures. Teradata is a powerful and scalable relational database management system designed to …

Read more

What Is Teradata? Architecture, Strengths and Use Cases

teradata

Introduction Discover the world of Teradata, an industry-leading data warehouse and analytics platform that offers parallel query processing and several deployment options. This comprehensive blog post will explore Teradata’s key features and benefits, learn about its architecture, and discuss its significance in modern data-driven organizations. Stay tuned as we unlock the power of this robust …

Read more

Teradata Columnar Solution: Advantages and Disadvantages Popular

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

How Advanced Is The Teradata Columnar Solution? A Column Store is defined by three distinct properties: Why Is The Teradata Solution Great Even Though It Does Not Offer Columnar Processing? Assuming a standard query, a date range selection is frequently made with a WHERE condition imposing a date restriction. However, only a portion of the …

Read more

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

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

In this blog post, I will show you what you need to pay special attention to when switching from Teradata to Snowflake. We will analyze the impact of running DML statements (e.g., UPDATE or DELETE) in Snowflake and contrast it with Teradata’s Row Storage and Column Storage. SQL compatibility is one part of a production …

Read more

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

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

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 copy can take a long …

Read more

Teradata in the Cloud: Advantages and Disadvantages of MPP Database Systems Popular

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

Introduction to Teradata in the Cloud Cloud databases are pressuring traditional data warehousing MPP systems. This blog post will illustrate the reasons for this and outline the pros and cons of each database system. The Architecture of an MPP Database System MPP database systems employ a shared-nothing architecture, wherein each node has its own CPU, …

Read more

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

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

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. Teradata can store data in columns, though it was not …

Read more

Teradata Transactions: Main Characteristics and Best Practices Widely read

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

What Are The Main Characteristics Of Transactions in Teradata? The Teradata Mode For Transactions Various techniques exist for composing SQL statements and applying transaction handling. Each approach has unique benefits, drawbacks, and characteristics worth considering. Let’s examine two sequential statements as an illustration: Using Teradata Mode With Explicit Transaction These statements can be executed as …

Read more

Teradata Architecture: How Shared-Nothing Parallelism Works Widely read

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

Teradata Query Parallelism Teradata can execute scans, joins, sorts and aggregations in parallel. The chosen plan determines how many AMPs participate; a primary-index lookup can use one AMP, and dependencies may serialize parts of a request. 🎓 Prefer video? Lecture 2 of my Udemy course Teradata Performance Tuning in Practice, “Shared-nothing parallelism: nodes, PEs and …

Read more

Protected by Security by CleanTalk and CleanTalk Anti-Spam