1

More than 5 years have passed since last update.

@Qiitaman(Kenji Suzuki)

Data Structure for DWH

Last updated at 2018-08-10Posted at 2018-08-10

Storing Detailed Information

Mainly in Relational Database Model
Star Schema
- A Fact Table and Dimension Tables
  - Fact Table: History of transaction
  - Dimension Table: Master data
- Each entry in a Fact Table is a primary key of some Dimension Table
- A Fact Table has a great number of tuples

An Example of Star Schema

Snowflake Schema
- Hierarchical structure of a Dimension Table
  - Capable of reducing redundant entries

Storing Summary Information

Multidimensional Data
- also called as a Data Cube
Applying Group‐By and other aggregate functions for the Fact Table by some attributes of Dimension tables, beforehand.
- to speed up the performance of common queries
- some operations are available for Data Cubes

An Example of Data Cube

参考

1

Register as a new user and use Qiita more conveniently

You get articles that match your needs
You can efficiently read back useful information
You can use dark theme

What you can do with signing up

1