Data Mart: the local warehouse database analysis

Data mart describes the use of a database that is only a department-specific part of the overall data warehouse. This is why it is also referred to as the department database.

Basically, such an extract from the entire database is used to offer a specialist department the opportunity to carry out specific evaluations, for example using online analytical processing (OLAP) – without having direct access to the database currently in use at the logistics center. Even if we are talking about processes, we are talking about a system that knows how to analyze and process certain company data in such a way that it can be used for decision-making, for example.

The data in the data mart

The data is the same (copy of a partial dataset) that is also used in the live system. This makes it possible to implement short-term adjustments right at the start of a warehouse project, especially in the event of problems. The rest of a data warehouse remains untouched. Only the department of a company, a business unit or directly a product division is affected.

Further information on data management in intralogistics can be found under Master data.

Image source: © S.John – Fotolia.com