What is data warehouse approach?

What are the approaches to data warehousing?

There are 2 approaches for constructing data-warehouse: Top-down approach and Bottom-up approach are explained as below. External source is a source from where data is collected irrespective of the type of data. Data can be structured, semi structured and unstructured as well.

What is data warehouse concept?

What is a Data Warehouse? A data warehouse is a relational database that is designed for query and analysis rather than for transaction processing. It usually contains historical data derived from transaction data, but it can include data from other sources.

What is data warehouse with example?

Data Warehousing integrates data and information collected from various sources into one comprehensive database. For example, a data warehouse might combine customer information from an organization's point-of-sale systems, its mailing lists, website, and comment cards.

What is top-down approach and bottom-up approach in data warehousing?

Bottom-up approach: First, the data is extracted from external sources (same as happens in top-down approach). Then, the data go through the staging area (as explained above) and loaded into data marts instead of datawarehouse. The data marts are created first and provide reporting capability.