Star Schema

The common term for the dimensional database model, because of its characteristic star-like structure. Dimensional modeling is a database-design technique that is used for data warehouses and data marts. Every dimensional model is composed of one large central table that is called a fact table , and a set of smaller tables that surround it and are called dimension tables . Fact tables typically contain one or more numerical measures or facts, such as Calls Handled , Total Time on Inbound , Dollars Sold , and so on. By contrast, dimension tables most often contain descriptive attributes, such as Agent Name , Queue Name , Time Period , and so on.
For an excellent resource on data warehousing, refer to http://www.dwinfocenter.org/ .

For More Information iWD Data Mart Reference Guide In the intelligent Workload Distribution 8.5.1 iWD Data Mart Reference Guide iWD Data Mart Reference Guide In the intelligent Workload Distribution 9.0.0 iWD Data Mart Reference Guide

Suggestions To comment on a term, or suggest a new term, send a quick email to the Glossary Team

Glossary

A B C D E F G H I J K L M N O P Q R S T U V W X Y Z