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
Abstract
Introduction
What is a Data Warehouse?
Data Warehouse Vs Traditional Database
Definition of Data Warehouse
Integrated
Subject-oriented
Nonvolatile
Time-variant
Types of data warehouses built and managed by the organizations
Enterprise data warehouses
Data Mart
Basic Process of Developing a Data warehouse
Extra Transform Load Process (ETL Process)
Extract
Transform
Advantages and Disadvantages of Data Warehouses
Who is using Data Warehouse?
Case Study – New York Central Mutual Fire Insurance Company (NYCM) [11]
Conclusion
References