Data Warehouse

DATA WAREHOUSE

Abstract

What is Data Warehouse and who is using it?

Data are raw facts, means facts that have not yet been processed to reveal their meaning. [Rob Coronel 2008]

Now a day, the main interest is database design and implementation for data storage and data management. The main reason for collecting, storing and managing data is to produce information that becomes the basis for rational decision making. For extracting necessary information from the data structures, Decision Support System (DSS) were developed. As the requirements increased, it was difficult for a DSS to extract all important and necessary information from the data structures. That is why, a new data storage system, called a database warehouse is developed. [Rob Coronel 2008]

The purpose of this paper is to understand and explain the basic concepts of Data Warehouses, its advantages and disadvantages and why the use of data warehouse is so important for the organizations in the today’s competitive world.

Methodology used: Case study

Keywords: Data Warehouse , Decision Support Systems.

Contents

DATA WAREHOUSE 1

Abstract 1

Introduction 3

What is a Data Warehouse? 3

Data Warehouse Vs Traditional Database 4

Definition of Data Warehouse 5

Integrated 5

Subject-oriented 5

Nonvolatile 5

Time-variant 6

Types of data warehouses built and managed by the organizations 6

Enterprise data warehouses 6

Data Mart 6

Basic Process of Developing a Data warehouse 7

Extra Transform Load Process (ETL Process) 9

Extract 9

Transform 9

Load 10

Advantages and Disadvantages of Data Warehouses 11

Who is using Data Warehouse? 12

Case Study - New York Central Mutual Fire Insurance Company (NYCM) [11] 12

Conclusion 13

References 14