Data Warehouse vs Data Mart
People think a data mart is just a small data warehouse, and it is not quite. A warehouse holds every source in the firm, cleaned and kept for years. A mart is one team's slice, cut from the warehouse for its own questions. Build marts from the warehouse, or each one will clean the data its own way.
Data Warehouse
A big store of data built for reports. Clean data from many apps lives there.
A data warehouse is a database built for reports, not for running an app. Data from many systems is cleaned and loaded into it. It stores the data in tables with a fixed shape. It is tuned to scan millions of rows fast. Analysts use SQL on it to answer questions about the whole business.
Data Mart
A small slice of the warehouse for one team. It holds only what they need.
A data mart is a small part of a data warehouse made for one team. It holds only the tables that team needs, such as sales or finance. The data is often already summed up for their questions. This makes it simpler and faster for that team to use. Many data marts can be built from one warehouse.
In one line
- Data Warehouse
- A big store of data built for reports. Clean data from many apps lives there.
- Data Mart
- A small slice of the warehouse for one team. It holds only what they need.