data mining and data warehousing lecture notes for mca pdf

This allows data to be grouped in unimaginable ways. Data is stored at a very deep level of detail. The amount of data in the Data Warehouse is massive. The purpose of the Data Warehouse is to integrate corporate data. It is very essential since data is increasing day by day. It increases the speed of data warehouse architecture.

The Data Warehouse Staging Area is temporary location where data from source systems is copied. ETL extracts data, transforms values of inconsistent data, cleanses 'bad' data, filters data and loads data into a target database.

Data warehouse staging area to data warehouse. ĮTL (Extract, Transform, Load) is used to copy data from:- ODS to data warehouse staging area. Operational data store contains data which are constantly updated through the course of the business operations. Its primary purpose is for handling data which are progressively in use. Īn operational data store (ODS) is basically a database that is used for being an temporary storage area for a datawarehouse. Data Warehouses can be architected in many different ways, depending on the specific needs of a business. The worthiness of the architecture can be judge by its use, and concept behind it.

Retrieving data Analyzing data Extracting data Loading data Transforming data Managing data DATA WAREHOUSING INCLUDES:-ĭATA WAREHOUSE ARCHITECTURE Data warehousing is designed to provide an architecture that will make cooperate data accessible and useful to users. Information have no limits, it is very hard to collect information from various sources, so we need an data warehouse from where we can get all the information. Those who gather, analyze, understand, and act upon information are winners. NEED FOR DATA WAREHOUSING Information is now considered as a key for all the works. The primary aim for data warehousing is to provide businesses with analytics results from data mining, OLAP, Scorecarding and reporting. DATA WAREHOUSING AND DATA MINING PRESENTED BY :- ANIL SHARMA B-TECH(IT)MBA-A REG NO : 3470070100 PANKAJ JARIAL BTECH(IT)MBA-A REG NO : 3470070086ĭATA WAREHOUSING Data warehousing is combining data from multiple sources into one comprehensive and easily manipulated database.

Data mining and data warehousing lecture notes for mca pdf