Chapter 2: DEVELOPING DATA WAREHOUSE
CHAPTER 1 https://datawarehousestudywithchanda1179.blogspot.com/2022/12/chapter-1-introduction.html CHAPTER 3 CHAPTER 2 TOPIC COVER: Developing data warehouse. CONTENTS (i) Data warehouse components (ii) Steps and crucial decisions for design and construction of data warehouse (iii) Three-Tier data ware Architecture (i) Data warehouse Components It consists mainly four parts: - Data Sources ETL Processing / Staging area Dataware house / Presentation area Data Access / End user Let's understand in detail: - 1. Source system: - It is system that contain data to provide a data warehouse. This may include operational database and other internal or external systems. 口 OPERATIONAL DATABASE: - It refers to a system that is used to process the day-to-day transactions of an organization. It includes hardware & software must be up to date in order to run smoothly. EXAMPLE: - AIRPORT OPERATIONAL SYSTEMS (AOS) These systems cont...