Posts

DATA WAREHOUSE IMPLEMENTATION

-
Image
CHAPTER1 CHAPTER2 CHAPTER 3 DATA WAREHOUSE IMPLEMENTATION  WHAT? Data warehouse implementation is a series of activities that are essential to create a fully functioning data warehouse after classifying, analyzing and designing the data warehouse with respect to the requirements provided by the client.  Various phases of data warehouse implementation are: -  (i) Planning  (ii) Data Gathering  (iii) Data Analysis (iv) Business Actions Data warehouses need few important components to defined while designing implementation of system, such as data marts, OLTP/OLAP, ETL, meta data etc. WHY?  To identify & store the data in effective manner. It can help in making decision based on strong data analysis. It stores data from various sources with different formats & with help of ETL tools convert this data into standard format. HOW?  The processes are as follow: - Planning: -  It is one of most important steps of process. It helps in ...
Post a Comment
Read more

Chapter 2: DEVELOPING DATA WAREHOUSE

-
Image
 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...
Post a Comment
Read more

Chapter 1 : INTRODUCTION

-
Image
CHAPTER 1  Introduction of Data-ware house   (i) Definition of Data-ware house (ii) Characteristics of Data-ware house (iii) Data-ware house Usage (iv) DBMS vs Data-ware house     (i) DEFINITION OF DATA  WAREHOUSE "Data-warehouse is a digital storage system that connects large amount of data from many digital sources." It stores current and historical data in one place and act as single source of an organization. Its goal is produced statistical result that may help in decision making. Description of Diagram: -  1. Data source: -   It collects the data from various sources/locations.                  ロ                      ロ                            ロ                    ロ               shop1...
Post a Comment
Location: PFW2+F6 Ansing, Maharashtra, India
Read more