Data warehouse workload characteristics

A data warehouse workload refers to all operations that transpire in relation to a data warehouse. The depth and breadth of these components depend on the maturity level of the data warehouse. The data warehouse workload encompasses: The entire process of loading data into the warehouse Performing data warehouse analysis and reportingThe Gartner Group has identified six workloads that demonstrate the way organizations use their data warehouses. Michelle A. Poolet believes there are five distinct data warehouse use cases, each of which might include one or more of those six workloads.All this indicate something similar, namely a diverse workload running on a data warehouse system concurrently : Whether it is continuous data loads while end users are querying data, or whether it is short running, OLTP like activities (both queries and trickle data loads) mixed in with more classic ad-hoc data intensive query patterns