Definitions of fact tables and dimension tables in Bi

Source: Internet
Author: User

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 detailed fact. That is to say, a fact table is an intersection of multiple dimension tables. A dimension table is a form 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. The star architecture is a structure in which the data warehouse flows more than the shard.

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

A dimension table is a set of dimension attributes. Is a form for analyzing the problem. 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.




Definitions of fact tables and dimension tables in Bi

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.