Teradata BI Model Repository - Teradata Schema Workbench

Teradata Schema Workbench User Guide

Product
Teradata Schema Workbench
Release Number
16.20
16.10
15.10
Published
June 2015
Language
English (United States)
Last Update
2018-05-25
dita:mapPath
gvf1512702977003.ditamap
dita:ditavalPath
Audience_PDF_include.ditaval
dita:id
B035-4106
Product Category
Teradata Tools and Utilities

The Teradata OLAP solution relies on a star or snowflake schema hosted in your Teradata Database accelerated by AJIs, and administered by native Teradata users and security roles. A star schema normally has a primary or fact table and one or more dimensional tables. A snowflake schema also uses a fact table, but has normalized dimensions to lower redundancy.

The Teradata BI Model Repository is a key component of the Teradata OLAP solution. A Teradata BI Model Repository stores the OLAP cube definition schemas and must be installed on each Teradata server. Cube schemas define the multidimensional model on top of your star or snowflake schema. AJIs, managed by Teradata Aggregate Designer, create pre-aggregated views as database objects to improve Teradata ROLAP performance. Teradata users and roles are leveraged by the solution to control access to all data.

Teradata BI Model Repository Architecture