Transcript Slides

Data Warehousing
in CIM
•
Data Warehousing in Computer
Integrated Manufacturing
Steve Daino
IEM 5303
Slide 1
2000 YourNameHere
Introduction to Data Warehousing
Data Warehousing
in CIM
• Definitions and Concepts
– “A centralized, integrated, repository of
information that must support complex
decision support queries without
performance degradation”
• Considerations
–
–
–
–
–
–
Time and Money
Space
Consolidation
Security
User Friendliness
Project Planning
Slide 2
2000 YourNameHere
Fundamentals of Data Warehousing
Data Warehousing
in CIM
• Types of Data Warehousing
• Technological Building Blocks
• Data Warehouse Framework and
Architecture
• Data Warehouse Logical Model
Slide 3
2000 YourNameHere
Types of Data Warehouses
Data Warehousing
in CIM
• Operational Data Store
– Replicated production database adjusted
for errors
• Data Mart
– Contains limited information regarding a
specific department or business process
• Enterprise Data Warehouse
– Holds information taken from throughout
an organization
Slide 4
2000 YourNameHere
Technological Building Blocks
Data Warehousing
in CIM
• Relational Database Management System
(RDBMS)
– Stores information in a Database
– Integrity and relation of data within tables
• Structured Query Language (SQL)
– Used to create, maintain and view data
– User point of entry
• On-line Analytical Processing Software
– Allows users to view summarized data
– Control of data search and analysis
Slide 5
2000 YourNameHere
Data Warehouse Framework and
Architecture
Data Warehousing
in CIM
• Operational and External Database Layer
– front line operational systems
• Information Access Layer
– Used to process and display data in
desired format
• Data Access Layer
– Communication between information
access layer and operational database
• Data Directory Layer
– Repository of Meta-Data - “Yellow-Pages”
Slide 6
2000 YourNameHere
Data Warehouse Framework and
Architecture (cont’d)
Data Warehousing
in CIM
• Process Management Layer
– Updates the data warehouse (scheduler)
• Application Messaging Layer
– “middleware” to transport information
throughout the enterprise
• Data Warehouse Layer
– Core of the data warehouse
• Data Staging Layer
– Replication Management
Slide 7
2000 YourNameHere
Data Warehouse Logical Model
• Business Structure Alignment
Data Warehousing
in CIM
• Data De-normalization
• Data Transformation
• Data Scrubbing
• Data Staging
Slide 8
2000 YourNameHere
Benefits of Data Warehousing in CIM
Data Warehousing
in CIM
• CIM Defined
• “Systems which enable integrated,
rationalized design, development,
implementation, operation and
improvement of production facilities and
their output over the life cycle of the
product”
– Data Warehousing provides ability to
establish and understand the correlation
between activities of different
organizational groups within a company
Slide 9
2000 YourNameHere
Benefits of Data Warehousing in CIM
Data Warehousing
in CIM
• Concurrent Engineering Defined
• “CE is a systematic approach to the
integrated, concurrent design of products
and their related processes, including
manufacture and support”
– Data Warehousing can provide
information for analysis that can aid in
reducing design and production costs,
ensuring product quality, and reducing
the time required to go from product
concept to production
Slide
10
2000 YourNameHere
Data Warehousing Case Studies
Data Warehousing
in CIM
• Toyota Motor Company
– Reduced factory to dealer shipment time
• General Motors
– Harvest existing data for marketing
purposes
• MCI World Comm
– Electronic interchange of product
information for manufacturers
Slide
11
2000 YourNameHere