Page 7 - DCAP603_DATAWARE_HOUSING_AND_DATAMINING

Unit 1: Data Warehouse Practice
Sartaj Singh, Lovely Professional University

unit 1: Data Warehouse practice notes

contents

Objectives
Introduction
1.1 What is a Data Warehouse?
1.1.1 Use of Data Warehouses in Organisations
1.1.2 Query Driven Approach versus Update Driven Approach for Heterogeneous
Database Integration
1.1.3 Differences between Operational Database Systems and Data Warehouses
1.1.4 Need to Build a Data Warehouse
1.2 Data Warehousing

1.3 Characteristics of Data Warehouse
1.4 Data Warehouse Components
1.5 Designing the Data Warehouse
1.6 Data Warehouse Architecture

1.6.1 Why do Business Analysts need Data Warehouse?
1.6.2 Process of Data Warehouse Design
1.6.3 A Three-tier Data Warehouse Architecture
1.6.4 OLAP Server Architectures
1.7 Getting Heterogeneous Data into the Warehouse

1.8 Getting Multidimensional Data out of the Warehouse
1.9 Summary
1.10 Keywords
1.11 Self Assessment
1.12 Review Questions

1.13 Further Readings

objectives

After studying this unit, you will be able to:
l z Know data warehouse concept

l z Explain data warehouse components
l z Describe data warehouse architecture

LoveLy professionaL university 1