Jump to: navigation, search

Glossary: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

Retrieved from "https://docs.genesys.com/Glossary:Star_Schema (2019-07-21 10:38:26)"
This page was last modified on November 18, 2013, at 18:12.