Blog

What is data warehousing?

  • (4.0)
  •   |   542 Ratings

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

Popular Courses in 2018

Get Updates on Tech posts, Interview & Certification questions and training schedules