ISYS6332 – Data Warehouse | Topic – 1 Data Warehouse Concept

an Introduction about Data Warehouse Concept

1. ISYS6332 – Data Warehouse Topic – 1 Data Warehouse Concept

2. LEARNING OUTCOMES Describe data warehouse concept on business organization.

3. OUTLINE Introduction History Defining data warehousing Data warehouse architecture Benefits of data warehousing Problems or limitations of data warehousing Data Marts

4. Introduction

5. Introduction A data warehouse is a historical database and should be considered as the long term memory of an organization. Data warehouses are typically used for Online Analytical Processing (OLAP) to support management queries.

6. History

7. History

8. Defining Data Warehousing

9. A subject-oriented, integrated, time-variant, and non-volatile collection of data in support of management’s decision-making process. Defining Data Warehousing

10. Data Warehouse Architecture

11. Every data warehouse has three fundamental components as can be seen in the picture beside. These are as follows : Load Manager Warehouse Manager Data Access Manager Data Warehouse Architecture

12. Benefits of Data Warehousing

13. Benefits of Data Warehousing Potential high ROI (Return on Investment) Unbeatable competitive advantage High Productivity in corporate decision making and business intelligence Cost effective Enhanced customer service

14. Problems or Limitations of Data Warehousing

15. Problems or Limitations of Data Warehousing

16. Data Marts

17. Data mart and data warehouse An organization could maintain both a data warehouse (representing data of all departments in a unified way) and individual departmental data marts. Hence, the data mart can be standalone (individual) or linked centrally to the corporate data warehouse

18. Relationship between data mart and data warehouse A collection of data marts can constitute an enterprise-wide data warehouse. Conversely, a data warehouse may be visualized as a collection of subset of data marts

19. REFERENCES Bhatia, Parteek . (2019). Data Mining and Data Warehousing Principles and Practical Techniques. Cambridge University Press. ISBN 978-1-108-72774-7