What is the difference between 2-Tier architecture and
3-Tier architecture

Answers were Sorted based on User's Feedback



What is the difference between 2-Tier architecture and 3-Tier architecture..

Answer / ravi148

hi
2-tier - also called client/server applications which
consist of two separate applications, one server
application (typically a database server like Oracle, MSSQL
or any other standalone database) and a client application.
suppose you want to have many different clients for front-
end would be unwise to copy all the business logic (all the
rules of your application) to each client app.,. so its
better to create a middle layer containing the business
logic, and then let the clients talk with this middle
layer. Thus the clients can relatively easily be changed
for other types of clients, without need for remembering
how was the business logic put together.

3-tier architeture where one tier is the backend database
engine, one is the front end client and one is just in
between them, also named the application server or business
logic node.
its uses mainly Load balancing and Fault tolerance.

please rate the status of my reply so that i can understand
my knowledge.
you can call me at 9951123501 for any queries.

Is This Answer Correct ?    298 Yes 42 No

What is the difference between 2-Tier architecture and 3-Tier architecture..

Answer / pavan kumar

Thanks Ravi, for a short but a very effective explanation.

Is This Answer Correct ?    71 Yes 20 No

What is the difference between 2-Tier architecture and 3-Tier architecture..

Answer / amit k. gautam

In 2 tier architecture the application is splitted in to
two parts which is located in two machines called as client
and server that is why it is also known as client server
architecture..in this architecture the business logic
resides either with the client or with the server where
database resides, so if client machine contains the
business logic then is termed as Fat client coz it has to
look after the client related as well as business related
issues where as if business logic resides with the database
server then it is termed as Fat Server since it has to
manage the database related as well as business related
issues so some how either the client or the server
performance hampers.


in 3 tier architecture the application is physically
divided and located in to three different machine one
takes care only about clientrelated issues known as client
tier, one second takes care about all the business logic
related issus and input out taken from the client tier
known as middle tier and the third contains the database
and responsible for managing and manipulating all the
database related issues callled as database tier so this
architecture is basically used for load balancing and fault
tolerence.

for further query feel free to mail me
at:amitjavatech@gmail.com
amit_javatech@yahoo.com
Thanks.

Is This Answer Correct ?    29 Yes 4 No

What is the difference between 2-Tier architecture and 3-Tier architecture..

Answer / ranjithkumar pedana

2 tier architecture is a client-server application...
3 tier architecture is web application.

Is This Answer Correct ?    33 Yes 11 No

What is the difference between 2-Tier architecture and 3-Tier architecture..

Answer / srisri

is a web application 2 tier or three tier?

Is This Answer Correct ?    31 Yes 11 No

What is the difference between 2-Tier architecture and 3-Tier architecture..

Answer / kinthada cnu

very good Ravi
thanks

Is This Answer Correct ?    27 Yes 11 No

What is the difference between 2-Tier architecture and 3-Tier architecture..

Answer / ashwani

2 tier is client server application or in 2 tier one layer
acts as web+App and another as data layer.
in 3 tier one is web layer 2nd is app layer and third is
data layer.
web layer = where client end code resides
app layer = where business logic of application resides
data layer = database layer where database resides

Is This Answer Correct ?    17 Yes 5 No

What is the difference between 2-Tier architecture and 3-Tier architecture..

Answer / ravikanth

thanks ravi

Is This Answer Correct ?    16 Yes 5 No

What is the difference between 2-Tier architecture and 3-Tier architecture..

Answer / balu

I Agree with the point one but not agreed with the next one

"its uses mainly Load balancing and Fault tolerance."

It is not like all the tier 3 system will use the above.

Loadbalancing and fault tolerance will increase the
availablility and scalablity of the System

Is This Answer Correct ?    14 Yes 3 No

What is the difference between 2-Tier architecture and 3-Tier architecture..

Answer / sandeep

very good ravi,thanks

Is This Answer Correct ?    13 Yes 5 No

Post New Answer

More SQL Server Interview Questions

How to check if a table is being used in sql server?

0 Answers  


Why is normalisation important?

0 Answers  


If we use where clause in the left outer join then how the query would behave/act?

1 Answers  


How to convert numeric expression data types using the cast() function?

0 Answers  


How to display n-1 columns from n number of columns, from a single table in MS SQL server 2005?

2 Answers  






what is the main difference between constraints(like primary key etc..)& joins?

2 Answers  


What is a self join in sql server?

0 Answers  


Does partitioning improve performance sql server?

0 Answers  


How to display a past time in days, hours and minutes?

0 Answers  


How to create indexed view?

0 Answers  


Accidentally i deleted my table. How can i get that table?

4 Answers  


How many types of cursor type are there?

0 Answers  


Categories