3.1

A Brief History of Data Warehouse

Abstract

Classical data architecture begins with application silo systems. With application silos comes the recognition that data is not integrated. Management cannot look across the corporation and ask what the best data warehouse is for their entire corporation. Another perspective of siloed systems is that they are sometimes called “spider-web systems.” In order to transition out of the world of spider-web systems, the organization builds a data warehouse. The purpose of the data warehouse is to provide the corporation with integrated, bedrock data that can be relied on. The data warehouse is created by ETL technology. Another purpose of the data warehouse is to provide a place for historical data. ...

Get Data Architecture: A Primer for the Data Scientist now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.