Data Warehousing Study Guide

Synopsis

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 Can Include Data From Other Sources. Data Warehouses Separate Analysis Workload From Transaction Workload And Enable An Organization To Consolidate Data From Several Sources. In Addition To A Relational Database, A Data Warehouse Environment Can Include An Extraction, Transportation, Transformation, And Loading (etl) Solution, Online Analytical Processing (olap) And Data Mining Capabilities, Client Analysis Tools, And Other Applications That Manage The Process Of Gathering Data And Delivering It To Business Users.