Definition data Warehouse VS database

hello-im-a-datawarehouseVery often, the question is asked- what's the difference between a data mart and a data warehouse- which of them do I need?

Data warehouse or Data Mart?

Data Warehouse:

  • Holds multiple subject areas
  • Holds very detailed information
  • Works to integrate all data sources
  • Does not necessarily use a dimensional model but feeds dimensional models.

Data Mart

  • Often holds only one subject area- for example, Finance, or Sales
  • May hold more summarised data (although many hold full detail)
  • Concentrates on integrating information from a given subject area or set of source systems
  • Is built focused on a dimensional model using a star schema.

More Detail regarding Data Warehouse Vs Datamart: and Inmon vs Kimball

As the concept of decisional systems, and data warehouses and data marts evolved, two major points of view came into existence. There are two giants in this field. Bill Inmon, and Ralph Kimball.

There are some that argue the best approach is to start with data marts, department by department, then merge them together to form a data warehouse- this is more in line with Kimballs approach.

"You can catch all the minnows in the ocean and stack them together and they still do not make a whale, "

Ralph Kimball, on the other hand, advocates what he calls a bus architecture data warehouse. His methodology specifies conformed dimensions, where multiple fact tables share common dimensional tables. For me, each of these fact tables represents a data mart. The row of dimensional tables that all the fact tables plug into is the bus, and because, for example, the finance and the sales data marts both use the same product dimension table there is integration between departments.

The more extreme data mart strategy is that of the completely stand alone data mart, the concept being that its fast, easy, cheap, and delivers value immediately. I'm a supporter of this at the desktop level- thats the point of the Datamartist tool afterall. But I don't buy this for server based architectures- what is really fast, easy and cheap when you have to buy servers, create a project and form a commitee? In my mind if you've decided you need a central server solution, some level of integration is needed, and don't pretend its going to be magic.

You might also like

7 SQLiteAdmin - Summary of Data Definition Language Functions
7 SQLiteAdmin - Summary of Data Definition Language Functions
File-Only vs In-Database MapReduce
File-Only vs In-Database MapReduce

Survey: IT and business at odds on defining big data success  — TechTarget
Data warehouse vendors will feel the burn. Hadoop and NoSQL products probably won't replace the enterprise data warehouse, but they are competing for workloads.

Okidata OkiData 43979201 Toner Cartridge for B420/B430 Series Printers, 7000 Page Yield, Black
CE (Okidata)
  • LED
  • 7 Page
  • Black
Canon Cameras US Canon USB Cable IFC-400PCU for Canon Cameras & Camcorders
Photography (Canon Cameras US)
  • Cable for transfering still images from the camera via USB port
  • Digital camera compatibility: EOS 10D, S400, S330, S300, A300, A200, A100, A10, A20, S30, S40, S45, A30, A40, A60, A70
  • Camcorder compatibility: ZR45mc, ZR50mc, ZR65mc, ZR70mc. ZR80mc, ZR85mc, ZR90mc
Master Caster - Media File Rack CD Holder
CE (Master Caster)
  • Black media file rack/CD holder for letter size desk drawer.
  • Fits any letter size file drawer in desks or file cabinets.
  • Secures and protects confidential data inside locked file drawers.
  • Hides up to 24 CD s.
  • For use with standard and slimline jewel cases.


How is data warehouse different from a database?

A database is a storage of data in its most generic form. Data stored in a data might be used for data warehouse, CRM or many other types of data management uses. A simple database is used in many common computer applications from virus checkers, where data is stored about every known computer virus, to movie editing software where video clips are stored in a database as they are edited.
A data warehouse describes a specific type of database application that is usually used for analytics. Data warehouse also implies some set of processes for the data within, as well as some business v…