Data Warehousing

This kind of architecture is generally preferred by small organizations that need to create quick reporting capability across one organ of the enterprise like sales or inventory. There is generally one source involved in this and the reports are directly created out of the data mart..

Independent Data Marts

This kind of architecture is generally preferred by small organizations that need to create quick reporting capability across one organ of the enterprise like sales or inventory. There is generally one source involved in this and the reports are directly created out of the data mart..

Linked Data Marts

In this architecture, multiple data marts are linked together to create a centralized reporting solution. This kind of architecture often arises by creating need based reporting. However, this also forms a stepping stone towards creation of the Centralized Data Warehouse.

Hub and Spoke Architecture

In this architecture, there is a centralized hub and varying spokes that represent a part of the entirety of the hub. This architecture is used when different users or departments in an organization have different data needs. Even stringent data security can result in this architecture so as to control the flow of data to different users.