Jump to: navigation, search

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


Suggestions

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

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

This page was last edited on July 30, 2020, at 16:23.
Comments or questions about this documentation? Contact us for support!