Data Warehouse
A data warehouse is designed to separate big data analysis and query processes (more focused on data reading) from transactional processes (focused on writing). This approach therefore allows a company to multiply its analytical power without impacting its transactional systems and day-to-day management needs.
The data warehouse is a highly recommended tool when you want to make sure that inexperienced users in the management of systems and databases don’t put at risk the information of a company. Given the three-tier architecture used in these solutions, DWH end users can query their data stores without touching or affecting the operation of the system in any way.