Go to Qiita Advent Calendar 2024 Top
LoginSignup
0
2

Delete article

Deleted articles cannot be recovered.

Draft of this article would be also deleted.

Are you sure you want to delete this article?

More than 5 years have passed since last update.

@Qiitaman(Kenji Suzuki)

Data Structure for DWH

Last updated at Posted 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

参考

0
2
4

Register as a new user and use Qiita more conveniently

  1. You get articles that match your needs
  2. You can efficiently read back useful information
  3. You can use dark theme
What you can do with signing up
Sign upLogin
0
2

Delete article

Deleted articles cannot be recovered.

Draft of this article would be also deleted.

Are you sure you want to delete this article?