Data Warehousing

Technical Seminar Presentation - 2004

DATA WAREHOUSING Presented By Ravish Ranjan Roll no-CS200118179

Under the guidance of Mr. Anisur Rehman

NATIONAL INSTITUTE OF SCIENCE & TECHNOLOGY Palur Hills,Berhampur-761008,Orissa,India Presented By:- Ravish Ranjan(CS200118179)

Technical Seminar Presentation - 2004

INTRODUCTION DATA

WAREHOUSE TECHNOLOGY? * Set of Methods,Technique and Tool

DATA

WAREHOUSE? * Collection of Integrated,Subject Oriented Data



WHY IT IS NEEDED?

Presented By:- Ravish Ranjan(CS200118179)

Technical Seminar Presentation - 2004

DW:CHARECTERISTICS SUBJECT ORIENTED  ACESSIBLE  AVAILABLE  INTEGRATED  TIME VARIENT, SO EFFICIENT  NON-VOLATILE 

Presented By:- Ravish Ranjan(CS200118179)

Technical Seminar Presentation - 2004

Time Variant Data

Presented By:- Ravish Ranjan(CS200118179)

Technical Seminar Presentation - 2004

DW:CRITERIA 

LOAD PERFORMANCE



LOAD PROCESSING



DATA QUALITY MANAGEMENT



QUERY PERFORMANCE



TERABYTE SCALABILIY



NETWORK DATA WAREHOUSE

Presented By:- Ravish Ranjan(CS200118179)

Technical Seminar Presentation - 2004

POPULATING DATA WAREHOUSE • INTERNAL DATA • EXTERNAL DATA

Presented By:- Ravish Ranjan(CS200118179)

Technical Seminar Presentation - 2004

DW:COMPONENT POLICY  TRANSFORMATION  STORAGE  ANALYTICS  PRESENTATION AND ACCESS 

Presented By:- Ravish Ranjan(CS200118179)

Technical Seminar Presentation - 2004

APPLICATION AIR LINES INDUSTRY  IN BANKING  RETAIL INDUSTRY  CREDIT CARD INDUSTRY,ETC 

Presented By:- Ravish Ranjan(CS200118179)

Technical Seminar Presentation - 2004

CONCLUSION Data Warehouse is a very broad subject and this class presentation was focused on the main concepts and characteristics of it in order to give a general idea about this subject. A parallel was made between Operational Systems and Data Warehouse Systems to show their differences mainly in the objectives and type of data that each one deals

Presented By:- Ravish Ranjan(CS200118179)

Technical Seminar Presentation - 2004

Presented By:- Ravish Ranjan(CS200118179)