This is a really good question that gets to the heart of good design.
By submitting your email address, you agree to receive emails regarding relevant topic offers from TechTarget and its partners. You can withdraw your consent at any time. Contact TechTarget at 275 Grove Street, Newton, MA.
The data we want to analyse in data warehouse comes from the transactional systems that run the enterprise (HR, finance, CRM etc.)
Pulling that data together and turning it into information for analysis is the job of the warehouse and, in creating a warehouse, we face essentially four problems:
- The data is in incompatible formats
- It is usually of poor quality
- It is dispersed in different systems
- It is not structured for analysis.
To cure these ills we use extract, transform and load (ETL) routines to move data into a data warehouse. The extraction and transformation processes address the incompatibility and data quality issues. Plus, placing the data in a single warehouse removes the dispersal problem.
We can either structure the warehouse for analysis (as Teradata does) in which case there need be no data marts. However, data marts are often employed and typically contain subsets of data from the warehouse, organized to provide a particular analytical view and delivered to groups or individuals in an organization. For example, a mart of marketing data could be provided for the advertising department and one of staff data to the HR department.
So, even if you have a warehouse you don't have to use data marts. Equally, it is possible to create marts without a warehouse. You can put the data from a particular system, a finance system for example, into a data mart and structure the data for analytical purposes.
Once you understand the problems that warehouses and marts are designed to address, it is much easier to decide which you need.
Dig Deeper on Database management system (DBMS) architecture, design and strategy
Related Q&A from Mark Whitehorn
The unstructured data types common in big data systems are often better managed by a NoSQL database than relational software, Mark Whitehorn says.continue reading
IT managers should ask cloud providers some pointed questions about the security of data stored in cloud databases, says expert Mark Whitehorn.continue reading
Expert Mark Whitehorn explains what skills are required for predictive modeling -- and whether business users can do the work of data scientists.continue reading
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.