Usually, data warehouse adapts either two-tier or three-tier architecture. We have discussed three-tire architecture in my other post ‘Data Warehouse Three-tier Architecture‘. In this article, we will discuss on the data warehouse two-tier architecture.
Data Warehouse Two-tier Architecture
The data warehouse two-tier architecture is a client – server application. There is a direct communication between client and data source server, we call it as data layer or database layer. Usually, there is no intermediate application between client and database layer.
Below diagram depicts data warehouse two-tier architecture:
As shown in above diagram, application is directly connected to data source layer without any intermediate application.
Example of the two-tier architecture would be storing patient related data into the database and retrieving patient information when required.
Data Warehouse Two-tier Architecture Components
Following are the two-tier architecture components
Client Application – Client tier
Client tier is the front-end application that client uses to get data out from the data warehouse or data tier. On the application tier code is writter for saving data or getting data out of database.
Usually, data warehouse reports are hidden in the GUI to show the required reports.
Database – Data tier
Database or data tier is where the actual data is stored. Various ETL processes are used to load data into database or data warehouse.
Advantages of Data Warehouse Two-tier Architecture
- Following are the some of the advantages:
- Easy to maintain
- Modification of the stored data is easy
Disadvantages of Data Warehouse Two-tier Architecture
- Following are the some of the disadvantages:
- Performance will be degraded with increase user traffic
- Cost – ineffective
Read:
- Data Warehouse Three-tier Architecture in Details
- Data Warehouse Project Life Cycle and Design
- Types of Fact Tables in a Data Warehouse
- Database ACID Properties and Explanation
- Data Warehouse Fact Constellation Schema and Design
- Types of Dimension Tables in a Data Warehouse
- Various Data Warehouse Design Approaches:Top-Down and Bottom-Up