O'Reilly logo

Applied Architecture Patterns on the Microsoft Platform - Second Edition by Gregor Noriskin, Dmitri Olechko, Andre Dovgal

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

The extract, transform, and load pattern for centralized data aggregation

The extract, transform, and load (ETL) pattern proved very useful in different architectural solutions. In data warehousing, it is used even more often than in data migration.

Tip

A data warehouse is a large data store constructed from several data sources and is intended to be used for reporting and analysis purposes. Data warehouses are constantly updated by feeding data from the data sources.

A part of a data warehouse that focuses on a specific area of interest is called a data mart.

First systems using data aggregation in a single source were developed in the early 1970s. For example, AC Nielsen, a global marketing research firm, used what they called "data mart" around ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required