~ Seminar Outline
- Introduction to Data Warehouse
- Problems that lead to data warehouse
- Goals and ojectives of data warehouse
- Data Warehouse Architecture
- OLTP versus data warehouse
- ODS vs. data warehouse vs. data mart
- Data Mining
- Data Architecture
- Logical data model
- Physical data model
- Distributed data model
- Top-down vs. bottom-up vs. middle-out modeling
- Meta data components
- Data Analysis
- Analyzing the source data
- Dirty data categories
- Data cleansing issues
- Types of transformations
- Basic Logical Data Model
- Entities
- Dependent vs. independent entities
- Supertypes and subtypes
- Relationships
- Relationship matrix
- High-level Entity-Relationship diagram
- Refinement of Logical Data Model
- Logical data model
- Cardinality
- Associative entities (intersection data)
- Optionality (existence criteria)
- Primary keys
- Foreign keys
- Refined Entity-Relationship diagram
- Fully Attributed Logical Data Model
- Descriptive attributes
- Normalization
(1NF, 2NF, 3NF, BCNF, 4NF, 5NF)
- Final modeling considerations
- Data Warehouse Extensions
- Derived attributes
- Date/Time Period
- Summarization and aggregation
- Physical attributes
- Access patterns and frequency
- Performance considerations
- DW Database Design Alternatives
- Overnormalization
- Denormalization
- Multi-dimensional design
- Denormalized relational model
- Denormalized star-schema model
|