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.
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
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
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.
9. Write a query to list a new column with the
difference in temp of the cities Delhi and Mumbai, Mumbai
and Jammu and soon. Consider the following table :
City_id City Temp.
1 delhi 40
2 Mumbai 35
3 Jammu 32
4 Pune 18
I have a table in which phno is one of the columns.i do have
some values in tht phno column.i need to update phno column
values with 0(zero) as prefix.give me a correct solution plz...
hi,
how to match retrieve the unmatched records from 2 tables
in which we dont have any primary key. example : table1 has
1,2,3,4,5 and table2 has 1,2,3,4,5,6,7,8,9,10 and i want
the numbers from 6 to 10 to be displayed and should not
come as null. i need the numbers. please reply as soon as
possible.
you are provided with the single table having say 4 col ie
fname lname age city , now the all records with displying of
only fname and lname is required but in this format say my
name is abhay khanna it will come like this
abhay-khanna
rahul-roy
gaurav-singh
the above format is required
system date format is "yy-mm-dd"
"select getdate()" ----> 2009-01-24 20:03:28.513
if i write "select dateadd(dd,2,getdate())
".it returns "2009-01-26 19:59:38.340"...my question is dat
could it be possible to retrive da date in da format "26
jan 2009 ...."??