Blog

What is data warehousing?

  • (4.0)
  • | 849 Ratings |
  • Last Updated June 09, 2017

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

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

Get ahead in your career by learning Informatica through Mindmajix? Informatica Training.

Subject-oriented:

Tables in DWH has to be concentrated on the 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 a uniform format

Ex:

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 the 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

Subscribe For Free Demo

Free Demo for Corporate & Online Trainings.

Free Demo Popup -->