data warehouse data warehousing features of datawarehouse

The term “data warehouse” was first coined by Bill Inmon in the year 1990.

According to Inmon, a data warehouse is a subject-oriented, integrated, time-variant, and non-volatile collection of data.

A data warehouse is a collection of multiple databases.

A data warehouse provides us generalized and consolidated data in the multidimensional view.

Along with a generalized and consolidated view of data. 

A data warehouse also provides us online analytical processing (OLAP).

·Understanding the data warehouse:-

1.A data warehouse is a database, which is kept separate from the organization’s operational database.

2.There is no frequent updating done in a data warehouse.

A data warehouse is connected by integrating data from multiple heterogeneous sources that support analytical reporting, structured Adhoc queries and decision making.

Data warehousing

Data warehousing means of storing data in one place. In this medium, many types of hardware are used to store the data. Store data on a group or computer of servers is called data warehousing. New and historical data is stored in the data warehouse.

The function of data warehousing is not only to store data but it also provides data protection.

A data warehouse collects information from many types of resources in one place that is called a repository. All information in it is stored in the same schema. Once the collected data stays in the store and it can be accessed for a long time.

features of data warehouse: -

1: -Subject oriented: -Data warehouse is used to analyze a particular subject, that is, it is based on the particular subject.

2: -Integrated: -data warehouse collects data from sources of data in very summary.

3: -Time variant: that means new and historical data is kept in it. Data at any time can be kept in the data warehouse.

4: -Non-volatile: - Once the data is stored in the data warehouse, that data can not be changed, meaning the historical data can not be changed.