Blog

What is data warehousing?

  • (4.0)
  • | 1172 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:

Global Data Analysis

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.

Ravindra Savaram
About The Author

Ravindra Savaram is a Content Lead at Mindmajix.com. His passion lies in writing articles on the most popular IT platforms including Machine learning, DevOps, Data Science, Artificial Intelligence, RPA, Deep Learning, and so on. You can stay up to date on all these technologies by following him on LinkedIn and Twitter.


DMCA.com Protection Status

Close
Close