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 that time to provide aggregated information for their customers.
The data warehouses as we know them today became a reality only in the late 1980s. The term data warehouse was originally used in the 1988 article An architecture for a business and information...