How to Diagram a Data Warehouse

This post was originally published on Pure Storage

To understand the way your data warehouse functions, a diagram displays the flow of data and every resource included in the process. A data warehouse diagram helps organizations make decisions when upgrades are needed or changes to infrastructure are necessary for expansions. They can also be used when planning the design of a new warehouse.

What Are the Components of a Data Warehouse?

A data warehouse has five main components. Each of these components is included in a diagram that you create. Some warehouses have multiple instances of each component, but at least one will be present when you create your diagram.

The five components are:

ETL Procedures

Data is extracted from its original source and loaded into a database housed in the warehouse. The Extract, Transform, and Load (ETL) process is a set of commands used to pull data from its source (e.g., files stored on a server) and transform data before it’s loaded into the database. For example, you might take a full name from a file and transform it to a first and last name. The two values are then loaded into first and last name columns in the database.


At first glance, data might be

Read the rest of this post, which was originally published on Pure Storage.

Previous Post

Why is your multicloud so slow?

Next Post

Dell to jump into vRAN market this year