Advantages And Disadvantages Of A Data Warehouse

807 Words4 Pages
Introduction There are many different approaches to a data warehouse’s design and its development. Two approaches that stand out amongst the rest are the Top-Down approach versus the Bottom-Up approach, both of which come with their own advantages and disadvantages. Data Warehouse vs Data Mart Data Warehouse • Enterprise wide. • Amalgamation of all data marts. • Data is gathered from the staging area. • Makes queries on the presentation resource. • Provides a structure of the corporate view of the data. • Follows the Entity Relational model. Data Mart • Focuses on individual departments. • Follows a singular business process. • Makes use of a STAR join that focuses on the facts and dimensions of the data. • It provides the relevant technology for optimal data access and analysis. • Provides a structure of the departmental view of the data. (Ponniah, 2010) Bill Inmon and Ralph Kimball Bill Inmon is one of data warehousing’s gurus who is a main proponent of the Top-Down approach. His view on database warehousing is that it is a centralized repository for the entire enterprise’s information. The information of the data warehouse is stored at the most granular level possible and is stored within a normalized data model. Bill Inmon sees the data warehouse as the centre of the ‘Corporate Information Factory’ which provides the logical framework for the business so that accurate and informative Business Intelligence can be supplied. (Ponniah, 2010) Ralph Kimball is a main
Open Document