This presentation teaches you how to design effective semantic view layers on Teradata. After briefly explaining the mechanics of how the Teradata Parser processes views, it dissects a number of semantic view examples that have been successfully implemented in production environments to help you understand what works and what constructs are problematic. The emphasis is upon practical issues from understanding how to design a single view to design patterns appropriate for virtual star schemas.

Key Points 

  • Which Query Rewrites are particularly important for the view designer to understand?
  • The role of constraints versus statistics in semantic view design.
  • What syntactic forms should you stay away from when designing a complex view?
  • Under what conditions does a UNION view work well for a semantic layer?

Since a variety of topics are crammed into a single session, it is strongly encouraged (but not required) that one already have taken the standard instructor-led courses on Teradata Physical Database Design and Physical Database Tuning before attending this session.

Note: This presentation is part of the Data Modeling-Intro to Implementation Series.

Presenter: Stephen Molini, Principal Consultant – Teradata Corporation

This course is offered by the Teradata Education Network. To enroll online, click the Training URL link below to go to the TEN site and Log in. If you're not a member click browse, select your region, and search on the Course Number. Or to enroll by phone, call the Enrollment Center at 1-937-242-4460. Note: You must be a member to register for a course.

Audience: Those with a role Database Administrator (DBA), Data Modeler, ETL Developer, Application Developer, Programmer, Performance Analyst, or Data Warehouse Architect

Course number:46183
Training URL:
Format:Recorded webcast
Credit hours:1.00