Data Warehousing in Computer Integrated Manufacturing

1

• Data Warehousing in Computer Integrated
  Manufacturing
• Steve Daino
• IEM 5303

2
Introduction to Data Warehousing

• 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

3
Fundamentals of Data Warehousing

• Types of Data Warehousing
• Technological Building Blocks
• Data Warehouse Framework and Architecture
• Data Warehouse Logical Model

4
Types of Data Warehouses

• 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

5
Technological Building Blocks

• 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

6
Data Warehouse Framework and Architecture

• 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

7
Data Warehouse Framework and Architecture (contd)

• 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

8
Data Warehouse Logical Model

• Business Structure Alignment
• Data De-normalization
• Data Transformation
• Data Scrubbing
• Data Staging

9
Benefits of 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

10
Benefits of 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

11
Data Warehousing Case Studies

• 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