Table of Contents
Student Notes
Opening Slide
TOPICS COVERED
1960'S
MID 60'S-LOTS OF MASTER FILES
1965
1970
1975
1980
THE EXTRACT PROGRAM #1
THE EXTRACT PROGRAM #2
THE DATA WAREHOUSE #1
THE DATA WAREHOUSE #2
SUBJECT ORIENTATION
PROCESS APPLICATION ORIENTATION
SUBJECT-ORIENTATION
INTEGRATION #1
INTEGRATION #2
DATA INTEGRATION #1
DATA INTEGRATION #2
TIME VARIANCY #1
TIME VARIANCY #2
NONVOLATILE #1
NONVOLATILE #2
THE DATA WAREHOUSE #3
GRANULARITY OF DATA
GRANULARITY
PARTITIONING OF DATA
PARTITIONING
DATA MODELING
REPRESENTING ENTITIES AND RELATIONSHIPS
CORPORATE ERD MODEL
RELATIONSHIP BETWEEN THE ERD AND THE DIS
MID-LEVEL MODELLING
THE MID-LEVEL OR "DIS"
RELATIONSHIPS IN THE ERD
AN EXPANDED DIS
STAR SCHEMA #1
STAR SCHEMA #2
DEVELOPMENT
DEVELOPMENT:Step #1
DEVELOPMENT:Step #2
DEVELOPMENT:Step #3
Sales star schema
THE FACT TABLE #1
THE FACT TABLE #2
Example of the Sales Fact Table
THE TIME TABLE
Example of the Sales star schema
QUERYING
EXAMPLE OF "DRILL-DOWN"
EARLY WAREHOUSING EFFORTS
INFLOW OF DATA
DATA CLEANSING TOOLS
DATA MIGRATION
MIGRATION TOOLS
DATA MIGRATION
TRANSFORMATION PROCESS
SYSTEM FLOW
ARCHITECTED ENVIRONMENT
LEVELS OF THE ARCHITECTURE #1
LEVELS OF THE ARCHITECTURE #2
DATA MINING
WHEN TO MINE
DATA MINING TOOLS
DATA MINING SYSTEMS
TRANSFORMING DATA #1
TRANSFORMING DATA #2
TRANSFORMING DATA #3
AN EXAMPLE
THE FUTURE
CONCLUSION #1
CONCLUSION #2
THE END |
Presentation Created By: Steve
Email: seminfs@comcast.net
"SEARCH ENGINES"
Yahoo
Lycos
Alta Vista
|