Mindmajix

What is data warehousing?

Definition of Data Warehousing

Data Warehousing is a relational database which is used to store large volumes of data for analyzing business but not for business transaction processing

Data warehouse is a subject oriented, integrated, non-volatile, time variant database in support of management decision-W.H.Inmon

Subject oriented:

Tables in DWH has to be concentrated on subject

Ex: Products, Customers, Sales

Integrated:

When we bring data from multiple sources, we need to make sure that the data has to be in uniform format

Ex:

Screenshot_1

Non volatile:

In DWH data is for read only.

Time variant:

To compare business across time

Time

Year

Quarter

Month

Week

Day

Features of Data Warehouse:

  • A DWH is designed to support decision making process. Hence it is known as Decision Support System(DSS)
  • It analyzes the business transactions in order to support decision making
  • DWH is a container data
  • DWH is the process of developing a data warehouse
  • DWH is a read only database because it is designed to read the data for analysis but not for transactional processing
  • DWH is a historical database because it can store historical business information
  • Father of Data warehousing   W.H.Inmon. In 1987, he designed a data warehouse

0 Responses on What is data warehousing?"

Leave a Message

Your email address will not be published. Required fields are marked *

Copy Rights Reserved © Mindmajix.com All rights reserved. Disclaimer.
Course Adviser

Fill your details, course adviser will reach you.