Data Modeling Techniques

Last updated Nov 13, 2024

Explore various Data Modeling Techniques to enhance your understanding and application of data structures:

• Relational Modeling: The origin of all modeling techniques.
• Dimensional Modeling: A technique for organizing data to support fast retrieval of aggregated data.
• Data Vault Modeling: A detail-oriented, historical tracking, and uniquely linked set of normalized tables that support one or more functional areas of business.
• Anchor Modeling: An approach that provides agility in managing changes and historical data over time.
• Bitemporal Modeling: Allows tracking both the historical and the system record of data.
• Entity-Centric Data Modeling (ECM): Focusing on the central entity, it offers two sub-techniques:
  • Focal Modeling: Centered around a focal point, offering clarity in complex data structures.
  • Activity Schema: Designed to model and record activities, emphasizing the dynamic aspects of the business process.
• Unified Star Schema or Puppini Bridge

See Enterprise data warehouse (inmon and kimball), data vault and big table:

Also see Inmon vs Kimball

See Normalization vs Denormalization

For a deeper dive, continue exploring Data Modeling.

Inmon vs Kimball

Origin:
References:
Created 2024-01-20