Tuesday, February 26, 2013

[DWH] Data Mart

 Data Mart

When we restrict the scope of a data warehouse to a sub set of business process or subject area we call it a Data Mart. Data Marts can be stand-alone entities, built from warehouses or be used to build warehouse. 

1. Stand-Alone Data Marts – These are single subject areas data warehouses. Stand alone data marts could cause many stove-pipe/silo data marts in the future. 

2. Data Marts fed from Enterprise Data Warehouses (Top-Down). This is the Top-Down strategy suggested by Bill Inmon. Here we build an enterprise data warehouse (EDW) hosting data for multiple subject areas. From the EDW we build subject area specific data marts. 

3. Data Marts building Data Warehouses (Bottom-Up). This is the Bottom-Up strategy suggested by Ralph Kimball. Here we build subject area specific data marts first, keeping in mind the shared business attributes (called conformed dimensions). Using the conformed dimensions we build a warehouse. 


1 comment:

  1. Oil-Gas
    Legacy fabric buildings are customizable for projects dependent on application-specific design, prompt delivery, quality installation services, technical expertise and strategic partnering. All three building dimensions can be customized to accommodate large vehicles and bulk storage requirements. Conveyors, bridge cranes, large portals, offset peaks and variable roof slopes are just some additions available.

    fabric structures