Definition of fact tables and dimension tables in BI

A typical example is to compare the logical business to a cube, the product dimension, the time dimension, and the location dimension as different axes, and the intersection of the axes is a detailed fact. This means that the fact table is an intersection of multiple dimension tables. A dimension table is a form of analyzing facts.

First, the star structure in the database structure is introduced, which maintains the data in a single fact table in the center of the structure, and other dimension data is stored in the dimension table. Each dimension table is directly related to the fact table and is usually joined to the fact table by a key. A star schema is a schema that is more flow-oriented to a data warehouse.

A fact table is a central table in a data warehouse structure that includes numeric measures and keys that relate facts to dimension tables. The fact table includes data describing specific events within the narrative business (such as product sales).

A dimension table is a collection of dimension attributes. is a form that analyzes the problem. Is that people observe the specific angle of the data, is a kind of attribute when considering the problem, the collection of attributes constitutes a dimension.

Definition of fact tables and dimension tables in BI