1 - SSZG515Data Warehousing EC1Solution Professor Navneet...

Info iconThis preview shows pages 1–8. Sign up to view the full content.

View Full Document Right Arrow Icon
SS ZG515 - Data  Warehousing EC1 Solution Professor Navneet Goyal Computer Science Department BITS, Pilani
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
  ©  Prof. Navneet Goyal, BITS, Pilani Data Warehouse Design OLTP Systems are Data Capture  Systems “DATA IN” systems DW are “DATA OUT” systems OLTP DW
Background image of page 2
  ©  Prof. Navneet Goyal, BITS, Pilani ER Modeling A logical design technique that seeks to  eliminate data redundancy Illuminates the microscopic relationships  among data elements Perfect for OLTP systems Responsible for success of transaction  processing in Relational Databases
Background image of page 3

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
  ©  Prof. Navneet Goyal, BITS, Pilani Problems with ER Model ER models are NOT suitable for DW? End user cannot understand or remember an  ER Model Many DWs have failed because of overly  complex ER designs Not optimized for complex, ad-hoc queries  Data retrieval becomes difficult due to  normalization Browsing becomes difficult
Background image of page 4
  ©  Prof. Navneet Goyal, BITS, Pilani ER vs Dimensional Modeling ER models are constituted to Remove redundant data (normalization) Facilitate retrieval of individual records having  certain critical identifiers Thereby optimizing OLTP performance Dimensional  model  supports  the  reporting  and  analytical  needs  of  a  data  warehouse  system. 
Background image of page 5

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
  ©  Prof. Navneet Goyal, BITS, Pilani Dimensional Modeling: Salient Features Represents data in a standard framework Framework is easily understandable by  end users Contains same information as ER model Packages data in symmetric format Resilient to change Facilitates data retrieval/analysis
Background image of page 6
©  Prof. Navneet Goyal, BITS, Pilani Analyzing the DATA   Active Analysis – User Queries User-guided data analysis Show me how X varies with Y OLAP  Automated Analysis – Data Mining What’s in there? Set the computer FREE on your data
Background image of page 7

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Image of page 8
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 03/14/2010 for the course CSE SS ZG515 taught by Professor Naveneetgoyal during the Summer '10 term at Birla Institute of Technology & Science.

Page1 / 26

1 - SSZG515Data Warehousing EC1Solution Professor Navneet...

This preview shows document pages 1 - 8. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online