Describing modern data warehousing
Created in the 80s, the data warehouse (DW) concept is “a subject-oriented, integrated, non-volatile, variable data repository over time to support management decisions” (C. J. Date, Introdução a Sistemas de Bancos de Dados. eighth edition, Rio de Janeiro Campus, 2004).
In other words, a data warehouse is a database that organizes an organization’s information, leaving the data more aligned with the nomenclature of company affairs so that it can be consumed by reports and applications.
Some important concepts when dealing with a data warehouse are as follows:
- Extract, transform, and load (ETL): This is the technique used to extract the information from the source relational databases, organize this data, and load only the result into the DW.
- Data mart: This is a logical subset of the data warehouse, usually divided by department, subject, or views required by users.
- Business intelligence (BI): This...
