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.

How many types of cursor type are there?

0 Answers  

---

What is shared lock?

0 Answers  

---

Explain fundamentals of Data ware housing & OLAP?

2 Answers  

---

how insert selected column only ?

3 Answers   Robert Half,

---

What is create command?

0 Answers  

---

---

which one will take 1st priority in case of insert statement and select statement???

2 Answers   HCL,

---

how to give input dynamically to a insert statement in sqlserver

3 Answers   HCL,

---

You have modified 100 store procedures and want to replicate these changes from development to prodution, and production can have users using the Server/DB, how would you replicate without causing issues?

0 Answers  

---

What is a periodical index?

0 Answers  

---

What is the syntax to execute the sys.dm_db_missing_index_details? : sql server database administration

0 Answers  

---

Can we use custom code in ssrs?

0 Answers  

---

How do I perform an unattended install of sql server 2000?

0 Answers  

---