teradata Archives - Page 12 of 15

Teradata Query Parallelism: A closer look at how Teradata’s shared-nothing architecture and parallel processing capabilities deliver exceptional performance. Popular

04/11/202604/28/2023 by Roland Wenzlofsky

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

Teradata Query Parallelism A query on a Teradata system runs in parallel at every step, whether for joining, sorting, or aggregating data. Teradata’s uniqueness lies in its ability to apply parallelism at every step of the query process. This advantage resulted from its architectural design, which integrated high levels of parallelism from the start, even …

The Importance of Teradata Surrogate Keys

08/22/202604/28/2023 by Roland Wenzlofsky

Illustration of a dense isometric network of connected data nodes

What are Teradata Surrogate Keys? A Teradata Surrogate Key is an artificial key that maps to a natural key. It is usually of the data type INTEGER or BIGINT and is represented by a single column. The natural key can consist of multiple columns. The surrogate key is generated automatically and is represented by an …

Why Teradata’s LIKE operator behaves differently for CHAR and VARCHAR columns

04/11/202604/28/2023 by Roland Wenzlofsky

Illustration of a glossy orange database cylinder with data fragments across its surface

Have you observed the different behavior of the Teradata LIKE operator when applied to a CHAR or VARCHAR data type column? Consider the following table as an illustration: Creating a table: To illustrate, we will add a single row. We will run the SQL statement for the column with the VARCHAR data type. Next, we …

Achieve Incredible Teradata Join Performance

04/11/202604/28/2023 by Roland Wenzlofsky

Illustration of a stopwatch dial on an orange paint-splash background

Executive summaryGUEST POST BY ARTEMIY KOZYR Today I shed some light on how Data Warehousing lies at the core of Retail Banking operations. We will see the actual case of vital marketing process malfunction and dive deep under the surface level to comprehend data alchemy technical issues. You will learn how to approach such issues, …

Become a Teradata Vantage Expert with Our Free Android App: Download Now from Google Play Store!

04/11/202604/28/2023 by Roland Wenzlofsky

Become a Teradata Vantage expert by downloading our new Android app for free from the Google Play store and practicing.

Teradata Multivalue Compression and Presence Bytes for NULL Values

04/11/202604/28/2023 by Roland Wenzlofsky

Multivalue compression and null indication serve distinct purposes yet share a common objective of storing information about the values of each row’s columns. To conserve space, Teradata utilizes presence bytes to retain information on multivalue compression and nullability. Readers familiar with earlier releases will recognize that the name “presence byte” originally referred only to NULL …

Why You Need a Performance Specialist for Your Data Warehouse Project

04/11/202604/28/2023 by Roland Wenzlofsky

Illustration of an entity-relationship diagram, boxes joined by arrows

When do you need a fire brigade most? When your house is on fire! When is the best time to establish the fire brigade? No, not when your house is on fire, but before the city the house is located in is founded. Finally, when should there be a fire safety inspection? Before and while you …

Teradata Priority Scheduler and Resource Allocation Rules Popular

04/11/202604/28/2023 by Roland Wenzlofsky

Illustration of a person in a suit standing beside a database cylinder

Learn about Teradata’s priority scheduler and how resources are allocated across workloads and requests in this detailed guide on workload management.