Content text 02. Data Warehouse Architecture.pdf
pacmann.io © 2022 – Pacmann AI 5 Data Warehouse Architecture
pacmann.io © 2022 – Pacmann AI 6 What is Data Architecture? Data warehouse architecture is the overall arrangement in the process of data communication, from data processing to presentation to the user. source: link
pacmann.io © 2022 – Pacmann AI 7 Types of Architecture Architecture Key Behavior Illustration Single Tier All data is integrated into a centralized repository, ensuring that every user accesses the same set of data. [Source] -> [Data Warehouse] -> [BI Tools] Two Tier Before store in warehouse, data is temporarily stored in a staging [Source] -> [Staging Area] -> [Data Warehouse] -> [BI Tools] Three Tier After stored in warehouse, user can access data with specific subset through data mart [Source] -> [Staging Area] -> [Data Warehouse] -> [Data Mart] -> [BI Tools] Data Warehouse has many types of architectures, here we will start discussing some types of architectures based on data usefulness for end-user.