1 / 11

Data Warehousing

Data Warehousing. at Avondale College. Presented by: Date:. David Heise 29 November, 1996. DW01. Welcome & Summary. Background COMP820 work-related assignment EIS proposal to DEET MComp Data Warehousing Project Overview. 1. Welcome & Summary. DW02. Overview. Welcome & Summary

kent
Download Presentation

Data Warehousing

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

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

More Related