Architecture
A collection of 111 issues
Teradata Unique Secondary Index: Everything You Need to Know
Learn about Teradata's unique secondary indexes (USI) and how they provide an alternate access path to reduce disk IOs while retrieving data. This article explains the technical differences between USI and other indexes, and provides detailed information on the data retrieval process. Discover how t
A Brief History of Parallel Database Architectures and Their Limitations
Discover the history of parallel database architectures - from shared memory to shared disk and shared-nothing. Learn about the advantages and limitations of each architecture and how fault tolerance is handled. Explore the shift towards big data and the trend of "Hadoop over SQL."
Understanding Teradata Parsing Engine and Access Rights: Impact on System Performance
Learn about the Teradata parsing engine's tasks and how it impacts overall system performance. Find out how to clean up the DBC. AccessRights table to improve parsing times in this informative article.
Column-Oriented Storage in Teradata: A Solution for Big Data Challenges
Learn about Teradata's column-orientated storage, which offers an alternative way of laying out data on disks, benefiting data retrieval in Big Data times. This article explains how columnar tables work, how they differ from row-oriented databases, and how you can create them in Teradata 14.00.
Understanding the Relationship Between RDBMS and Hadoop: A Map Reduce Example
Discover how Map Reduce is becoming a key feature of most database vendors' RDBMS. Follow an example of SQL aggregation statement joined with two tables.
Doing Teradata Hashing The Right Way
Teradata Explain Statement: A Guide to Optimizing SQL Performance
Never Again "No More Room In Database". I'll Show You How!
Discover the exciting new features of Teradata Version 16.00, which can significantly improve data warehouse administration and loading. Learn how to avoid error messages and manage skewed tables with the new Global Space Soft Limit and SKEW features.
Maximizing Efficiency: How Teradata MAPS Feature Minimizes Downtime and Simplifies Table Distribution
Teradata's MAPS Feature allows for hardware expansion with minimal downtime by delaying table redistribution. Learn how to use MAPS INSERT. SELECT here.