Scribd Logo
Upload

Welcome to Scribd!

  • 38 views

    Bahria University: Assignment # 6

    Uploaded by

    AqsaGulzar
    This document contains an assignment submission for a data warehouse course. It summarizes three different data warehouse schemas: galaxy schema, fact constellation schema, and star cluster schema. For each schema, it describes the key characteristics, importance, and uses. The galaxy schema allows multiple fact tables to share dimension tables without a direct relationship. The fact constellation schema links fact tables hierarchically to allow drilling down. The star cluster schema combines aspects of the star and snowflake schemas.

    Copyright:

    © All Rights Reserved
    Download as DOCX, PDF, TXT or read online from Scribd

    Bahria University: Assignment # 6

    Uploaded by

    AqsaGulzar
    38 views3 pages
    This document contains an assignment submission for a data warehouse course. It summarizes three different data warehouse schemas: galaxy schema, fact constellation schema, and star cluster schema. For each schema, it describes the key characteristics, importance, and uses. The galaxy schema allows multiple fact tables to share dimension tables without a direct relationship. The fact constellation schema links fact tables hierarchically to allow drilling down. The star cluster schema combines aspects of the star and snowflake schemas.

    Original Title

    03-134171-005_assignment6.docx

    Copyright

    © © All Rights Reserved

    Available Formats

    DOCX, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    This document contains an assignment submission for a data warehouse course. It summarizes three different data warehouse schemas: galaxy schema, fact constellation schema, and star cluster schema. For each schema, it describes the key characteristics, importance, and uses. The galaxy schema allows multiple fact tables to share dimension tables without a direct relationship. The fact constellation schema links fact tables hierarchically to allow drilling down. The star cluster schema combines aspects of the star and snowflake schemas.

    Copyright:

    © All Rights Reserved
    Download as DOCX, PDF, TXT or read online from Scribd
    Download as docx, pdf, or txt
    38 views3 pages

    Bahria University: Assignment # 6

    Uploaded by

    AqsaGulzar
    This document contains an assignment submission for a data warehouse course. It summarizes three different data warehouse schemas: galaxy schema, fact constellation schema, and star cluster schema. For each schema, it describes the key characteristics, importance, and uses. The galaxy schema allows multiple fact tables to share dimension tables without a direct relationship. The fact constellation schema links fact tables hierarchically to allow drilling down. The star cluster schema combines aspects of the star and snowflake schemas.

    Copyright:

    © All Rights Reserved
    Download as DOCX, PDF, TXT or read online from Scribd
    Download as docx, pdf, or txt
    You are on page 1of 3

    Bahria University

    Lahore Campus

    Assignment # 6
    Name: Aqsa Gulzar

    Enrollment No: 03-134171-005

    Program: BSCS(7A)

    Semester: 7

    Course title: Data Warehouse

    Instructor Name: Sir Junaid

    Date assigned: 22/04/2020

    Date of submission: 26/04/2020


    1. Galaxy Schema
     Multiple fact tables share the same dimension tables. the fact tables in a galaxy do
    not need to be directly Related.
     This schema is difficult due to its complexity
     Combination of many stars together. Arrangement of fact and dimension tables
    made a star.

    Importance of Galaxy Schema


     Multiple facts tables
     Fact tables do not need to be directly related
     Normalized form of star and snowflake schema
     Provides a flexible schema

    Uses of Galaxy schema


     This schema is helpful for aggregating fact tables for better understanding.
     Different fact tables are explicitly assigned to the dimensions.
    2. Fact Constellation Schema
     A fact constellation schema consists of a set of star schemas with hierarchically
    Linked fact tables. The links between the various fact tables provide the ability to
    “drill down”.
     More complex.
     Collection of several star schemas

    Importance of Fact Constellation Schema


     Dimension tables are shared by many fact tables.
     Tables cannot be maintained easily.
     It is normalized form of star and snowflake schema.
     Its heavy complex queries are used to get data from the database.
     Consumes more space and not easy to operate as it has many joins

    Uses of Fact Constellation Schema


     Used in to find typical sales data we need many facts tables
     Used in flexible environment where no restriction of time.
    3. Star Cluster Schema
     Combination of star schema and snowflake schema.
     May need more complex joins while querying.
    Importance of Star Cluster Schema
     A fact table is formed for each transaction entity and key of table is combination
    of keys of associated components entities.
     Classification entities should be collapsed down their hierarchies until they reach
    either a fork entity or a component entity
     Numerical attributes within transaction entities should be aggregated by the
    dimensions.
     It contains DE normalized dimension tables

    Use of star cluster schema


     Used when users have to interact with table structures with simple quires
     Used when query execution time is less

    You might also like