Database What is & Queries

Purpose & Features of Data Warehouse

data warehouse

Loosely speaking, a data warehouse can be defined as the decision support database that is maintained separately from the organization’s operational databases. A data warehouse is a type of data management system that is designed to support and enable business intelligence activities, especially analytics, like machine learning.

A data warehouse is a subject-oriented, integrated, time-variant, and non-volatile collection of data in support of management’s decision-making process. – According to William H.Inmon

Features of data warehouse

Subject oriented

A data warehouse is organized around a major subject such as customer-supplier, product, and sales, rather than concentrating on the day-to-day operating and transactions processing or data warehouse focuses on the modeling and analysis of data for decision-makers.

Hence data warehouse typically provides s simple and concise view of particular subject issues by excluding data that are not useful in the decision support process.

Integrated

A data warehouse is usually constructed by integrating multiple heterogeneous sources, such as relational databases, flat files, and online transaction, records. Data cleaning and data integration techniques are applied to ensure consistency in naming conventions.

Time-Variant

Data are stored to provide information from on historic perspective (eg. the past 5-10 years) every key structure in the data warehouse contains, either implicitly or explicitly, a time element.

Non-volatile

A data warehouse is always a physically separate store of data transformed from the application data found in the operational environment.

Due to this separation, a data warehouse does not require transaction processing, recovery, and concurrency control mechanism. It usually required only two operations in data accessing initial loading of data and access of data.

Tuts

About Author

Tutsmaster.org provides tutorials related to tech and programmings. We are also setting up a community for the users and students.

You may also like

advantages of database
Database Pros and Cons

Advantages of Database & Disadvantages of Database

  • July 18, 2019
Here are some advantages of database and disadvantages of database. A database management system is a collection of interrelated data
Networking What is & Queries

What is Protocol, Syntax, Semantics and Timing in Networking?

  • July 18, 2019
Protocol, Syntax, Semantics and Timing in Networking? Protocol A protocol is a set of rules that govern data, communications. A