4 tier architecture and BI

View previous topic View next topic Go down

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.


SnowShine429

Posts : 36
Join date : 2013-02-16

View user profile

Back to top Go down

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.
avatar
ngalemmo

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

View user profile http://aginity.com

Back to top Go down

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

View user profile

Back to top Go down

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 : 366
Join date : 2014-01-06
Location : London

View user profile

Back to top Go down

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.
avatar
ngalemmo

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

View user profile http://aginity.com

Back to top Go down

Re: 4 tier architecture and BI

Post  Sponsored content


Sponsored content


Back to top Go down

View previous topic View next topic Back to top

- Similar topics

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