Datawarehouse
DATA WAREHOUSE
ABSTRACT
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.
The purpose of this paper is to explain the basic concepts of Data Warehouses, advantages and disadvantages.
Keywords: Decision Support Systems, Databases, Data Warehouse.
Contents DATA WAREHOUSE 1 Introduction 3 What is a Data Warehouse? 3 Data Warehouse Vs Traditional Database 3 Definition of Data Warehouse 4 Integrated : 4 Subject-oriented: 4 Nonvolatile: 4 Time-variant: 4 Types of data warehouses that can be built and managed by the organizations 5 Enterprise data warehouses: 5 Data Mart: 5 Basic Process of Developing a Data warehouse: 6 Extra Transform Load Process (ETL Process): 7 Extract: 7 Transform: 7 Load: 7 Advantages and Disadvantages of Data Warehouses 8 What is Business Intelligence? 8 Conclusion: 9 References 10
Introduction
In this information age, management, executives and business users are using well organized data for decision support and the organizational planning. For decision making process, Decision Support Systems were developed. But due to the information requirement and their complexity, it was difficult for Decision Support System to extract all necessary information from the data. There for a new data storage system, called the data warehouse was developed.
What is a Data Warehouse?
A data
ABSTRACT
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.
The purpose of this paper is to explain the basic concepts of Data Warehouses, advantages and disadvantages.
Keywords: Decision Support Systems, Databases, Data Warehouse.
Contents DATA WAREHOUSE 1 Introduction 3 What is a Data Warehouse? 3 Data Warehouse Vs Traditional Database 3 Definition of Data Warehouse 4 Integrated : 4 Subject-oriented: 4 Nonvolatile: 4 Time-variant: 4 Types of data warehouses that can be built and managed by the organizations 5 Enterprise data warehouses: 5 Data Mart: 5 Basic Process of Developing a Data warehouse: 6 Extra Transform Load Process (ETL Process): 7 Extract: 7 Transform: 7 Load: 7 Advantages and Disadvantages of Data Warehouses 8 What is Business Intelligence? 8 Conclusion: 9 References 10
Introduction
In this information age, management, executives and business users are using well organized data for decision support and the organizational planning. For decision making process, Decision Support Systems were developed. But due to the information requirement and their complexity, it was difficult for Decision Support System to extract all necessary information from the data. There for a new data storage system, called the data warehouse was developed.
What is a Data Warehouse?
A data
References: [1] [Online - Link: http://en.wikipedia.org/wiki/Extract,_transform,_load ] [2] WHITE PAPER Overview Architecture for Enterprise Data Warehouses DAVID M WALKER [3] Peter Rob, Carlos Coronel, “Database Systems: Design, Implementation, and Management”, 8th Edition; [4] [Online - Link: http://en.wikipedia.org/wiki/Business_intelligence ] [5] [Online - Link: http://download.oracle.com/docs/cd/B10500_01/server.920/a96520/concept.htm] [6] Adam Getz, Guident Technologies Inc. – [Whitepaper], “Data Warehouses” [7] Advantages and disadvantages to using a DW”; [Online - Link: http://www.exforsys.com/tutorials/data-warehousing/advantages-and-disadvantages-to-using-a-data-warehouse.html]; [8] [Online - Link: Faruk Pasic, http://faruk.ba/wp-content/uploads/2010/11/Faruk-Pasic-Data-Warehouse-Project-Paper.pdf] [9] [Online - Link: http://en.wikipedia.org/wiki/Data_warehouse]