BIAnalytix Tip Summary: Data Mart vs. Data Warehouse

Data Mart Defined
A data mart is a decision support system that is designed to support a given department within a larger organization, the Human Resources business unit for example. Data marts are typical housed on hardware owned and supported by the business units for which they are intended; they have data that is stored only at a grain that the BU demands, and this data is often kept at some level of aggregation. The sources for data marts are sometimes the corporate data warehouse, and if the source is an originating transaction system, there are typically no more than one or two involved. Concisely, the data mart is a subject specific, tactical store that is of interest to few users outside of the owning BU.

 Data Warehouse Defined
A data warehouse is a decision support system that is designed to support most if not all aspects of a corporate entity. Data warehouses are installed on hardware owned and supported by corporate IT. They contain data at an un-aggregated grain in order to cover any and all possible needs regarding drill down and data mining. A data warehouse will contain as much history as is available from the various source systems and will typically be populated from between five to dozens of transactional and operational systems. As one would expect, the combination of low grain, years of history, and enterprise spanning scope is a recipe for huge quantities of data.
There is an ongoing religious debate in the Business Intelligence community surrounding these two phrases. Trying to settle the debate is beyond the scope of this tip, but hopefully this equation will help: Business Unit, tactical, limited scope = data mart; Corporate driven, strategic, enterprise wide scope = data warehouse. Whichever side of the debate one falls, we can all agree that a data mart and a data warehouse are not the same thing.

BIAnalytix is an advanced Data Warehouse and Business Intelligence system made up of modules designed to include media data from most of the common sources in a media corporation. The BIAnalytix design realizes the vision of a comprehensive data warehouse and puts the information your executives, managers, and employees need at their fingertips.

© Copyright 2011, Decentrix Inc. All rights reserved.
Decentrix Inc. 1200 17th Street, Suite 200, Denver, Colorado, 80202 Phone: 303-899-4000  
 
 Decentrix Website Solution & Collaborative Intranet Tools   |   DishOnTheWeb.com by Decentrix, Dish Network Retailer Solutions
Afftraq Affiliate Sales Tracking Solution   |  HotDesk, Superior Website & Intranets for Small to Medium Size Business

Home Products Website Solution Collaboration NetAnalytix e-Commerce Technology Overview Architecture Quickcentrix Quickcentrix Integration Kit Consulting Web Analytics Consulting e-Commerce Consulting Business Intelligence Analytics Decentrix Process Online Marketing Site Visitors Search Engines Register With Yahoo Register With Google Search Engine Ranking Becoming Visible Online Collecting Prospect Lists Checklist Target Market Tours Website Solution Tour Collaboration Tour NetAnalytix Tour BIAnalytix Tour Clients News Press Releases e-Newsletters Contact Support Sales Company Vision Management Team Careers