DWHPro Insights

Architecture

BTEQ Multi-Statement Requests: Transaction Boundaries and Migration

Icon of a chrome hammer inside an orange circle over a brick pattern

In BTEQ, request boundaries matter. A semicolon that terminates the first SQL statement at the end of a line sends that request before the next line is read. Adding another semicolon at the start of the next line does not combine an already-submitted request. Correct multi-statement request formatting There is no trailing semicolon on the …

Read more

Teradata Hybrid: Bridge or Destination?

Icon of a chrome hammer inside an orange circle over a brick pattern

For many years, Teradata was the undisputed leader in large-scale data warehousing. Banks, insurers, and telcos built their most critical systems on it. Today, the market is very different. Cloud-native databases such as Snowflake, BigQuery, and Databricks have set new standards in elasticity and simplicity. The question is: what role will Teradata play in this …

Read more

Introduction to Apache Spark: A Powerful Solution for Big Data Processing and Analytics

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

Introduction Processing and analyzing large volumes of data quickly and efficiently is essential in today’s data-driven world. Apache Spark, an open-source big data processing engine, is a leading solution for handling massive datasets that offers a fast and flexible alternative to traditional data processing frameworks like Hadoop’s MapReduce. This article introduces Apache Spark, explores its …

Read more

Comparing Index Types of SQL Server and Teradata: Clustered vs Row Partitioning, Non-clustered vs NUSI, USI, Join Index, and More

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

This article compares the index types in SQL Server and Teradata. It can benefit those transitioning between the two platforms to understand their distinctions and overlaps, despite their different architectures. Clustered Index vs Teradata Row Partitioning SQL Server clustered indexes store the table rows at the B-tree leaf level. Range seeks and Teradata partition elimination …

Read more

Streamlining Table Cloning in Teradata and Leveraging Zero-Copy Cloning in Snowflake

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

Table cloning is required for purposes such as data backup, testing, and replication. Teradata, a leading data warehousing platform, provides an efficient method for cloning tables. However, Snowflake, a cloud-based data warehousing platform, offers an even more effective approach with its zero-copy cloning feature. This article will compare table cloning in Teradata with Snowflake’s zero-copy …

Read more

Teradata Row Retrieval: Understanding Hashing, Indexing, and Search Algorithms

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

Introduction Teradata uses various mechanisms, such as hash maps, master and cylinder indexes, and binary and sequential search algorithms, to locate table rows. This article explains the process of locating table rows in Teradata using these elements and techniques. Hash Maps Teradata’s architecture utilizes the Massively Parallel Processing (MPP) model, which distributes data among Access …

Read more

Teradata vs SQL Server: Key Architectural Differences and Performance Implications Widely read

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

This article will highlight the contrasting architectural features of Teradata and SQL Server, along with their shared aspects and performance impacts. The piece titled “Teradata versus SQL Server” will be periodically updated. For comparisons against other platforms: how Teradata and Amazon Redshift differ and what makes Teradata an RDBMS rather than an appliance. The same …

Read more

Teradata vs. Redshift: A Comparison of Join Strategies and Architecture

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

Teradata and Redshift share similar architectures and data distribution methods. Teradata’s AMPs store portions of table data, while Redshift utilizes slices. There are notable differences in the way data is stored on file systems. Row/column storage and join-maintenance trade-offs are workload- and deployment-dependent. This article does not establish universal row-store superiority or lower operating effort. …

Read more

Protected by Security by CleanTalk and CleanTalk Anti-Spam