 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
Outline
and Detailed Agenda Logical Data Modeling
Introduction
•
What is Data Modeling
•
Why use Data Modeling
•
The benefits of Data Modeling
•
Overall development framework
o
Stages of development
o
The kinds of projects
•
Data driven development
•
Modeling concepts
o
Data modeling
o
Process modeling
o
Usage modeling (model interaction)
•
Characteristics of good models
High
Level Data Modeling
•
Introduction to data modeling
•
Brainstorming business rules, entities and relationships
•
Rules for the High Level Data Model
•
Explanation of major objects
o
Entities,Attributes, Relationships
o
Business rules
o
Multiple relationships
o
Recursive relationship
•
Purpose of high level: Scope, management review, top-down framework
•
Finding primary entities
•
Defining relationships
•
Validating entities
•
Identifying keys
•
EXERCISE: High level data modeling
Detailed
Data Modeling
•
Model expansion
•
Detailed modeling constructs
•
Methods of Model Expansion
•
Types of Data
•
Types of Keys
•
Types of Entities
•
EXERCISE: Model expansion
Normalization
•
What normalization is
•
What normalization is not
•
Rules and steps of normalization
•
Practical tips for normalization
•
EXERCISE: Mini-exercise
•
EXERCISE: Case study
Views
Analysis
•
Definition of a data view
•
Sources of data views of data
•
Importance of views
•
Results of views analysis
•
EXERCISE: Data views for case study
Current
Systems Analysis
•
Reasons for doing current systems analysis
•
Analyzing current data
•
Problems in current data analysis
•
Analyzing current processes
•
Importance of current systems analysis
Model
Consolidation
•
Reality of separate model development
•
Importance of integration
•
Rules for integration
•
Conflict resolution
Data
Model Refinement
•
Abstraction: generalization and aggregation
•
Subtyping
•
Aggregation
•
Bill of materials
•
Derived data
•
Change data
•
Modeling goals
•
Modeling time
•
Final model stabilization
•
EXERCISE: Model refinement in case study
Model
Interaction
•
The importance of model interaction
•
Issues in model interaction
•
Integrating models via matrices
•
Integrating models via maps
•
Integrating models via views
•
Other validations and cross-checks
•
EXERCISE: Data usage mapping
Preparing
for Design
•
Phase review
•
Review participants
•
Goals of phase review
•
Introduction to design
•
Purpose of design
•
Steps of design
•
Safe data design trade-offs
•
Aggressive data design trade-offs
Advanced Topics
© Copyright 2009 DebTech International, LLC. All Rights Reserved.