Data Modeling (RDBMS or Code)

1 - About

A data model in software engineering is an abstract model that try to represent the reality and describes how data are represented and accessed.

Data models formally define:

Data modeling can be found:

  • in RDMS where a table represents a data entity and the keys, the relationship
  • in code where object (of classes) can represent a data entity and the relationship can be represented by an extra attributes or an extern map.

There is not a right or wrong way of doing things as design decision involves trade-offs between:

  • performance (latency)
  • against reduction of data duplicate and design complexity.

3 - Data Modeling Concepts

4 - Types of RDBMS Physical Models (Schema)

The difference between model (ER, Dimensional, Vault) has everything to do with terminology and method.

There are two basic types of physical models :

E-R models are designed to minimize data storage redundancy and optimize data updates.

Dimensional models are designed to enhance understandability and to optimize query performance.

  • Data Vault

The Data Vault consists of three primary entity types:

  • Hubs,
  • Links,
  • and Satellites.

The Hubs are core business keys, the Links form all relationships, and the Satellites provide all descriptive information.

5 - Documentation / Reference

  • Bookmark "Data Modeling (RDBMS or Code)" at del.icio.us
  • Bookmark "Data Modeling (RDBMS or Code)" at Digg
  • Bookmark "Data Modeling (RDBMS or Code)" at Ask
  • Bookmark "Data Modeling (RDBMS or Code)" at Google
  • Bookmark "Data Modeling (RDBMS or Code)" at StumbleUpon
  • Bookmark "Data Modeling (RDBMS or Code)" at Technorati
  • Bookmark "Data Modeling (RDBMS or Code)" at Live Bookmarks
  • Bookmark "Data Modeling (RDBMS or Code)" at Yahoo! Myweb
  • Bookmark "Data Modeling (RDBMS or Code)" at Facebook
  • Bookmark "Data Modeling (RDBMS or Code)" at Yahoo! Bookmarks
  • Bookmark "Data Modeling (RDBMS or Code)" at Twitter
  • Bookmark "Data Modeling (RDBMS or Code)" at myAOL
data_modeling/data_modeling.txt ยท Last modified: 2017/04/26 14:00 by gerardnico