4 tier architecture and BI

Go down

4 tier architecture and BI Empty 4 tier architecture and BI

Post  SnowShine429 on Sat Feb 14, 2015 8:48 pm

hello everybody,

i am trying to understand architectures in general and somewhat baffled; your help withthe following will be highly appreciated..

in a 4 tier architecture Database -> Application -> Presentation -> Client Tier .. where does the BI layer fit in? i just want to add BI piece to something like below but I am not sure how to proceed.

4 tier architecture and BI Jw-0321-sso4-100156654-orig

SnowShine429

Posts : 36
Join date : 2013-02-16

Back to top Go down

4 tier architecture and BI Empty Re: 4 tier architecture and BI

Post  ngalemmo on Sun Feb 15, 2015 1:19 am

Between the users and the database.  The architecture you show seems to imply somebody is coding Java.  That is not the usual case with DW implementations.  The BI layer typically covers presentation and some business logic. Business logic may also be handled during load (ETL) as well as in database.
ngalemmo
ngalemmo

Posts : 3000
Join date : 2009-05-15
Location : Los Angeles

http://aginity.com

Back to top Go down

4 tier architecture and BI Empty Re: 4 tier architecture and BI

Post  SnowShine429 on Sun Feb 15, 2015 10:17 am

thank you sir,

yes this is an OLTP architecture where we have an application from where users enter transactions etc. does it make sens to put the DW database after the database tier and then a BI presentation layer?

SnowShine429

Posts : 36
Join date : 2013-02-16

Back to top Go down

4 tier architecture and BI Empty Re: 4 tier architecture and BI

Post  nick_white on Tue Feb 17, 2015 3:24 am

Your n-tier architecture applies on a system-by-system basis, so your OLTP architecture is different from your OLAP/BI architecture. You don't need to mix the two as they are separate systems

Regards,

nick_white

Posts : 364
Join date : 2014-01-06
Location : London

Back to top Go down

4 tier architecture and BI Empty Re: 4 tier architecture and BI

Post  ngalemmo on Tue Feb 17, 2015 4:07 am

Yeah, what Nick said.

As far as the Data Warehouse goes, the operational systems are a black box. All the DW is concerned with is the data feeds, which are handled by the ETL layer. ETL loads data into the DW database layer. The DW is then queried by the BI layer.
ngalemmo
ngalemmo

Posts : 3000
Join date : 2009-05-15
Location : Los Angeles

http://aginity.com

Back to top Go down

4 tier architecture and BI Empty Re: 4 tier architecture and BI

Post  Sponsored content


Sponsored content


Back to top Go down

Back to top


 
Permissions in this forum:
You cannot reply to topics in this forum