Data Warehouses

The term Data Warehouse was first coined in the 1970s. In essence, a data warehouse is a database management system (DBMS) that houses all of the enterprise's data. The data warehouse serves as a single source of truth for all business related queries. In a previous post, we learnt about the need for a reporting database to accomodate the different types of data access patterns. By creating a separate DBMS with its own schema, we can avoid undue stress on the operational system, all the while making the data more accessible to business analysts.