Data Modeling Paradigm

Concept

  • Business Modeling

  • Domain Modeling

  • Logical Modeling

  • Physical Modeling

Schema

  • Star Schema

  • Snowflake Schema

  • Fact Constellations Schema

Paradigm

  • Entity-relationship(E-R) Modeling

    3NF, Entity

  • Dimension Modeling

    Fact, Dimension

  • Data Vault Modeling

    Hub, Link, Satellite

  • Anchor Modeling

    Anchors, Attributes, Ties, Knots

Others

  • ETL
  • OLAP, OLTP
  • BI