Fact tables and dimension tables

Source: Internet
Author: User

Explanation 1:

Fact tables are data tables combined by a certain field of analysis.
The latitude table is a combination of analysis indicators in this field.

Interpretation 2:

To put it simply;
A fact table is a transaction table.
A dimension table is a basic table.
Used to explain the specific content of the keyword latitude in a fact table.

Explanation 3:

Fact data table
The central table in the data warehouse architecture, which contains the digital metric values and keys that relate to facts and dimension tables. Fact data tables contain data describing specific events in a business (such as banking transactions or product sales.

Dimension Table
A table in a data warehouse. Its entries describe the data in a fact data table. A dimension table contains the data used to create a dimension.

Here is another example. A bank records deposits. Table A stores actual data, including the account number, institution number, and deposit amount. Table B stores the correspondence between institution Number and institution name. A is a fact table and B is a dimension table.

 

Fact table
Each data warehouse contains one or more fact data tables. Fact data tables may contain business sales data, such as cash registration transactions.
The generated data, fact data tables usually contain a large number of rows. Fact data tables are mainly characterized by digital data (FACTS) that can be summarized to provide relevant units as historical data, each fact table contains an index composed of multiple parts. This index contains the primary key of the foreign key's correlated latitude table, and the dimension table contains the fact record feature. Fact data tables should not contain descriptive information, nor contain any data except the numerical measurement field and the index field corresponding to the fact and latitude table.
There are two "metric values" contained in a fact data table: one is a cumulative measurement value, and the other is a non-cumulative measurement value. The most useful measurement value is the accumulative measurement value, and the accumulated number is very meaningful. You can obtain the summary information through the cumulative measurement value, for example. You can summarize the sales of specific products in a group of stores in a specific period of time. Non-cumulative measurements can also be used in fact data tables. A single summary result is meaningless. For example, when measuring the temperature at different locations of a building, it makes no sense to accumulate the temperature of all different locations in the building, but it makes sense to calculate the average value.
Generally, a fact data table must be associated with one or more latitude tables. When you use a fact data table to create a multi-dimensional data set, you can use one or more dimension tables.
Dimension Table
A dimension table can be seen as a window for users to analyze data. A latitude table contains the fact record feature of a fact data table. Some features provide descriptive information and some features specify how to summarize the fact data table data, to provide useful information for analysts, a dimension table contains a hierarchical structure that helps Summarize data. For example, a dimension table containing product information usually contains a hierarchy of products into several categories, such as food, beverage, and non-consumer products. each category of these products is further subdivided multiple times, until each product reaches the lowest level.
In a dimension table, each table contains fact features independent from other dimension tables. For example, a customer dimension table contains data about customers. The column fields in a dimension table can be divided into different levels of structure.

 

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: info-contact@alibabacloud.com 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.