Posts

Showing posts with the label Data Warehouse VS Data Mart

Differences Between Data Warehouse and Data Mart

  Key Differences Between Data Warehouse and Data Mart 1.     Data warehouse is application-independent whereas data mart is specific to decision support system application. 2.     The data is stored in a single,  centralized  repository in a data warehouse. As against, data mart stores data  decentrally  in the user area. 3.     Data warehouse contains a  detailed  form of data. In contrast, a data mart contains  summarized  and selected data. 4.     The data in a data warehouse is  slightly  denormalized while in the case of Datamart it is  highly  denormalized. 5.     The construction of a data warehouse involves a  top-down  approach. Conversely, while constructing a data mart the  bottom-up  approach is used. 6.     Data warehouse is  flexible ,  information-oriented,  and longtime e...