Definition data Warehouse VS database
Very 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?
- 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.
- 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.
"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
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 43979201 Toner Cartridge for B420/B430 Series Printers, 7000 Page Yield, Black
Canon USB Cable IFC-400PCU for Canon Cameras & Camcorders
Photography (Canon Cameras US)
- Media File Rack CD Holder
CE (Master Caster)
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…