Transactions Archives - Page 4 of 4

Teradata Referential Integrity: What it is and Why You Need it for Data Consistency and Performance Popular

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

Illustration of a dense isometric network of connected data nodes

Introduction to Teradata Referential Integrity Teradata implements 3 Types of Referential Integrity. 1. What is Standard Referential Integrity? The Standard Referential Integrity checks every Row INSERT, DELETE, or UPDATE immediately to ensure referential integrity. A reference index sub-table is required for referential integrity. Violation of referential integrity results in the failure of execution and generates …

Maximizing Performance with Multiple Teradata Sessions

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

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

Teradata Sessions explained in a few Sentences Example 1: Multiple Sessions which do not improve performance The graph shows that all four transactions (T1, T2, T3, T4) are concurrently active on all AMPs. Even for a single-row lookup, these transactions necessitate accessing all AMPs. None of the transactions use a single rowhash for access, resulting …

Teradata Table Design Checklist: Primary Index, Character Set, and Data Type Considerations Popular

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

Teradata Table Design Checklist As creating tables is a frequent task, I deemed it necessary to provide a checklist. 1. Primary Index Or NOPI Table? The Primary Index serves multiple purposes, primarily functioning as the primary access path to the data and being optimized for an even distribution of rows. However, designing a table without …

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 …

Achieve Incredible Teradata Join Performance

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

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, …

Teradata Concurrency Control: Locking and Transactions Explained

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

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

Learn how Teradata Concurrency Control uses locking and transactions to prevent simultaneous updates, deletions, or insertions in different sessions.

Teradata Transient Journal: How It Protects Transactions Against Failures and Deadlocks Most read

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

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

Learn about the Teradata Transient Journal, a crucial component for ensuring data integrity and protecting against system failures. This dictionary table is managed by each AMP, containing rows copied before changes are made to a transaction. If a transaction fails, the journal is used to roll back and restore the affected table rows. Discover ways to minimize journaling and improve performance, including BTEQ tricks and using load utilities. Find out how to avoid system-level errors and ensure there is always enough permanent space in the DBC database.

Teradata Data Loss Protection: Transient Journal, Fallback, RAID 1, and Clique

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

Learn how Teradata protects your data against potential loss with its various features. Each feature offers unique protection on different levels.