A data-warehouse is a heterogeneous collection of different data sources organised under a unified schema. 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.
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.
There are a number of different possible architectures and design approaches for the development of the Data Warehouse (DW). Widely used approaches include the
top down Corporate Information Factory architecture (Inmon, 1995), the bottom up dimensional Data Mart approach (Kimball et al., 2008), and the Data Vault approach (Linstedt et al., 2010).Approaches to building a data warehouse The two fundamental design methods, which are used to build a data warehouse, are
Inmon’s (Top-down) and Kimball’s (Bottom-up) approaches.
Top 9 Best Practices for Data Warehouse Development
- 1) Have a data model. ...
- 2) Have a data flow diagram. ...
- 3) Build a source agnostic integration layer. ...
More items
Approaches to Building a Data Warehouse
A data-warehouse is a heterogeneous collection of different data sources organised under a unified schema. There are 2 approaches for constructing data-warehouse: Top-down approach and Bottom-up approach are explained as below. 1. Top-down approach: The essential components are discussed below: