1 / 5

Data Warehousing

Data Warehousing. Sushanthan Premanath & Indrajith Premanath CSCI 4707. A Quick Summary. The Main Protagonists. Bill Inmon Born 1945 Father of Data Warehousing. Ralph Kimball Born 1944 Commercialized Data Warehousing. Big Data. The data should be de-normalized to 2NF.

kareem
Télécharger la présentation

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 Sushanthan Premanath & Indrajith Premanath CSCI 4707 A Quick Summary

  2. The Main Protagonists Bill Inmon • Born 1945 • Father of Data Warehousing Ralph Kimball • Born 1944 • Commercialized Data Warehousing

  3. Big Data • The data should be de-normalized to 2NF. • This means you get data redundancy. • This means you need more storage. • The data can retrieved more quickly. • Data Warehousing is to provide aggregate data which is in a suitable format for decision making.

  4. ETL and Data Marts • Extraction, Transformation and Loading (ETL) • E – Extraction: Get the data. • T – Transformation: Make it useful. • L – Loading : Save it to the warehouse. • Data Marts • Don’t mess with the data. • Keep it simple for the user. • Small problems are easier to solve.

More Related