Data Warehousing - PowerPoint PPT Presentation

data warehousing n.
Download
Skip this Video
Loading SlideShow in 5 Seconds..
Data Warehousing PowerPoint Presentation
Download Presentation
Data Warehousing

play fullscreen
1 / 11
Data Warehousing
186 Views
Download Presentation
kent
Download Presentation

Data Warehousing

- - - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript

  1. Data Warehousing at Avondale College Presented by: Date: David Heise 29 November, 1996 DW01

  2. Welcome & Summary • Background • COMP820 work-related assignment • EIS proposal to DEET • MComp Data Warehousing Project • Overview 1. Welcome & Summary DW02

  3. Overview • Welcome & Summary • Definition • Importance of Data Warehousing • Decision Support Stages • Data Warehousing - The Data View • Data Warehousing - The Process View • Some Terms • Data Warehousing Issues 1. Welcome & Summary DW03

  4. Definition A data warehouse is a: • Subject oriented • Integrated • Time-variant • Nonvolatile collection of data in support of management decisions. Inmon, W.H. Building the Data Warehouse. 1993. DW04 2. Definition

  5. Importance of Data Warehousing • See definition • Adds ad hoc reporting & analysis • Relieves development burden on IT • Improves performance for complex queries • Relieves OLTP processing burden • Converts corporate data into strategic information DW05 3. Importance of Data Warehousing

  6. Sophistication Information Discovery Multi-Dimensional Analysis More Strategic Decision Making Data Interpretation Data Enquiry More Operational Decision Making Two Three Four Stage: One Decision Support Stages 4. Decision Support Stages DW06

  7. : End User PowerPlay Operational System Production Data - VAX RMS, Databus : Data Warehouse End User Impromptu Operational System External Data - PC, Hardcopy : End User Impromptu Data Warehouse Database The Data View DW07 5. The Data View

  8. Operational Metadata User Metadata and Information Objects VAX RMS Use! Access to Operational Data VAX Databus : Find and Understand Transform & Distribute Data Warehouse PC Data Hardcopy Data and Process Flow Management and Automation The Process View 6. The Process View DW08

  9. Some Terms • OLTP OnLine Transaction Processing • OLAP OnLine Analytical Processing • MDD Multi-Dimensional Database • ROLAP Relational OLAP 7. Some Terms DW09

  10. Data Warehousing Issues • Establishing needs • Mapping goals • Data warehouse design • Security • Data ownership • Data responsibility • Data integration and cleanup • Translating data • Establishing granularity 8. Data Warehousing Issues DW10

  11. The EndConclusions Thank You DW11