Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator
Creator

which tier to use

Hi all,

 

Can you please all tell me when to use 3 tier architecture and when to use  tier architecture.

 

PS:This question was asked in interview

 

Manu

Labels (1)
1 Solution

Accepted Solutions
Highlighted

Hi, I would say always, or almost always. The 3 tier architecture is very common and helps to make developments easier and faster.

First tier holds qvds with flat information from db, this helps in analyzing source data and free resorces from db server. You extract the information, create the qvd and next queries will be on qvd, not to db server.

 

Second tier is transforming this flat data from tier 1 in the bussiness data needed by your apps, this can be done in one or many layer of qvds, reading from tier 1 qvds and creating tier 2 qvds, with all the fields needed by your apps.

 

Third tier is the presentation layer, the apps the user will use with charts, tables... with almost no script, just doing an optimized load of tier 2 qvds. In some cases doing a binary load of data model apps.

https://community.qlik.com/t5/QlikView-Documents/Three-Tier-Architecture/ta-p/1483564

View solution in original post

1 Reply
Highlighted

Hi, I would say always, or almost always. The 3 tier architecture is very common and helps to make developments easier and faster.

First tier holds qvds with flat information from db, this helps in analyzing source data and free resorces from db server. You extract the information, create the qvd and next queries will be on qvd, not to db server.

 

Second tier is transforming this flat data from tier 1 in the bussiness data needed by your apps, this can be done in one or many layer of qvds, reading from tier 1 qvds and creating tier 2 qvds, with all the fields needed by your apps.

 

Third tier is the presentation layer, the apps the user will use with charts, tables... with almost no script, just doing an optimized load of tier 2 qvds. In some cases doing a binary load of data model apps.

https://community.qlik.com/t5/QlikView-Documents/Three-Tier-Architecture/ta-p/1483564

View solution in original post