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
To comment on a term, or suggest a new term, send a quick email to the Glossary Team