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)
================================================
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