Data Warehouse

What is Data Warehouse:

A data warehouse is a relational database that is designed for query and analysis rather than for transaction processing. It usually contains historical data derived from transaction data, but it can include data from other sources. It separates analysis workload from transaction workload and enables an organization to consolidate data from several sources.

In addition to a relational database, a data warehouse environment includes an extraction, transportation, transformation, and loading (ETL) solution, an online analytical processing (OLAP) engine, client analysis tools, and other applications that manage the process of gathering data and delivering it to business users.

Abbreviated DW, a collection of data designed to support management decision making. Data warehouses contain a wide variety of data that present a coherent picture of business conditions at a single point in time.

Development of a data warehouse includes development of systems to extract data from operating systems plus installation of a warehousedatabase system that provides managers flexible access to the data.

The term data warehousing generally refers to the combination of many different databases across an entire enterprise

Data Warehouse is collection of data from different operational systems in to one place.we can read,write,modfy the data as per requirement similar like the database.but main difference between database and datawarehouse is that we use data warehouse for decision support and analysis purpose.