Answer / vijay

2-tier architecture:
2-tier architecture is also called as
client-server architecture, in this architecture both
presentation logic+business logic will in one layer and
database logic will be in another layer . This architecture
is used with in a limited area .
-)Clients retrive fast infromation from server
drawbacks:
1: Both presentation logic&business logic will be in same
layer there will be miss use of business logic(Hacking).
2: Used in limited area.
3:Here clients are called thick clients
ex:banking applications,small scale industry

3-tier architecture:
3-tier architecture is also called as web
environment ,in this presentation logic&business
logic&database logic will be in different layers
.presentation logic is in the client layer and business
logic is in the application server and database logic will
be in server side.
advantages:
1:security is very high bcoz business logic is present in
the application server.
2:Here clients are called thin clients.
drawbacks:
1:while client request any information from server it takes
much time.
2:Each application server contain one busines logic in one
layer.

Answer / ivreddy

Basically 2 tier architecture : This has 2 parts namely
client (front
end) and database (back end).The window application
generally developed in this technology

3 tier architecture :
1 Client-front end (request is given through client)
2.business logic :Middle layer (protocols are used for
processing the request)
3. Database :back end (response is given to the client)
Web applications are good examples for 3 tier architecture
The above answer ,i found in one of the sites.

Answer / sandeep

In my point of view....

2 tier means client and server. In this system client
application interracts directly with server(means Database
server)by means of connection string. This architecture is
used in windows applications. So if any changes is happend
in business rules then we shud make changes in every
clients that were installed in different locations. More
over this system doesnt support scalability and high
availability(clustering). This system is used for small
business system.

3 Tier is for very big systems having complex business
rules . In this system apart from 2 tier a middle layer is
introduced, that is application layer. This layer departs
the direct connection of client with database. So many
features and standards can be achieved. Web applications
are using this architecture. This application and database
layers can be in one machine or in differents machines
located in remote areas.


am I rite ? unless please correct me.

thanks

Answer / shankey*

To solve the problems of one-tier architecture Two-tier
architecture was introduced, The applicitation is divided
into two parts which are Client-Tier & Server-Tier & these
two parts can be located on a single computer or on saprate
computer.
Whereas
Three-Tier architecture was introduced bcause when we
implementing loigic in two tier architecture it becames
overloaded to solve this problem Three-tier architecture
was introduced which is further divided into three parts
which are Client-tier, Business-Tier & Server-Tier*

Answer / bhagwat shinde

2 Tier architecture it's commonly use when your client majority is less if your client's are increasing then we need to configure all the code in client system wherever the client is increase then resides the database one centralized machine (make a server ) and use it.

 3 tier architecture all the three different layer's distribute in three different places it's not necessary to put three different places also you can make the developer system as a web server,Database,and all the GUI related functionality. early day's all the ATM machine transaction done using this feature.

Can group by be used without aggregate functions?

0 Answers  

How to end a stored procedure properly in ms sql server?

0 Answers  

How can I create a table from another table without copying any values from the old table?

3 Answers  

Explain differentiate between a having clause and a where clause?

0 Answers  

what are the different ways of moving data/databases between servers and databases in sql server? : Sql server database administration

0 Answers  

How many triggers you can have on a table?

0 Answers  

write the query for taking database restore in sql?

2 Answers  

What is store procedure? How do they work?

0 Answers  

Explain an incremental backup?

0 Answers  

Explian different types of BACKUPs avaialabe in SQL Server? Given a particular scenario, how would you go about choosing a backup plan?

2 Answers   HCL,

how to find maximum identity number in a table ?

2 Answers   JPMorgan Chase, Thomson Reuters, Wipro,

How to get the query of a table in sql server?

0 Answers