Part 3: Data Storage Recommendations

Part 3: Data Storage Recommendations

Size Of Data Warehouse The storage design (hardware & data modelling) vary based on the size of the data warehouse. Broadly, there are three different sizes of data warehouse: Small-Size Data warehouse: DWH databases ~ 200 GB Medium-Size Data warehouse: DWH...
Part 2: Data Storage Approaches

Part 2: Data Storage Approaches

In a Data Warehousing platform, data is classified into two categories; as follows, Hot Data  (Frequently accessed): data which needs to be live and immediately accessible to the user is Hot data. These data will be stored in the Data Warehouse and distributed to the...
Part 1: What is a Data Warehouse?

Part 1: What is a Data Warehouse?

A data warehouse is a subject-oriented, integrated, time-variant and non-volatile collection of data in support of management’s decision-making process. Great. But what do these terms actually mean? Subject-Oriented: A Data warehouse is built and used to analyse any...