Convert: definitions of fact tables and dimension tables in Bi

Bi Data Warehouse product database storage

A typical example is to compare a logical business to a cube. The product dimension, time dimension, and location dimension are different coordinate axes, and the intersection of coordinate axes is a specific fact. That is to say, a fact table is an intersection of multiple dimension tables. A dimension table is a window for analyzing facts.

First, we will introduce the star structure in the database structure. This structure maintains data in a single fact data table located in the structure center. Other dimension data is stored in the dimension table. Each dimension table is directly related to a fact data table and is usually linked to a fact data table by a single key. A star architecture is a kind of architecture that compares the flow of data warehouses.

A fact table is a central table in the data warehouse structure. It contains the numerical measurement values and keys that relate to facts and dimension tables. Fact data tables contain data describing specific events in a business (such as product sales.

A dimension table is a set of dimension attributes. Is a window for problem analysis. It is a specific point of view for people to observe data. It is a type of attribute in consideration of the problem. The set of attributes forms a dimension.

Convert: definitions of fact tables and dimension tables in Bi