Saturday, September 20, 2014

The Inmon Model

The Inmon Model

1) Consists of all databases and information systems in an organization…..
     The CIF (Corporate Information Factory)

2) Defines overall database environment as:
    Operational
    Atomic data warehouse
    Departmental
    Individual
  
The Warehouse is part of the bigger whole (CIF)

================================================

Inmon Modeling

Three levels of data modeling

1) ERD (Entity Relationship Diagram)
Refines entities, attributes and relationships

2) Mid-Level model (*DIS*)
  
   i)    Data Item Sets
   ii)   Data sets by department  
   iii)  Four constructs
         a) Primary data groupings
         b) Secondary data groupings
         c) Connectors
         d) “Type of” data

3) Physical data model

Optimize for performance (de-normalize)

================================================





No comments:

Post a Comment