Dataware Housing

   Objectives:   · Define a data warehouse · Identify data warehouse use cases . List the benefits of a data warehouse What is a data warehouse? A data warehouse is a system that aggregates data from one or more sources into a single consistent data store to support data analytics Data warehouse analytics Data warehouse systems support: Data Mining Artificial Intelligence Machine learning Front-end reporting OLAP Online analytical processing  Where are data warehouses hosted? Traditional data warehouses hosted on-premises within enterprise datacenters initially hosted on mainframes, and then on Unix, Windows and Linux systems Where are data warehouses hosted? 2000’s Growth of larger data volumes, emergence of data ware housing appliances (DWAs), consisting of specialized hardware with pre-integrated software 2010-present Adoption of Cloud Data Warehouses, providing eliminating hardware purchases, as a scalable service pay-as-you-go service Who uses data warehouses? P...