Smart questions
Smart answers
Smart people
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Member Login

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips now!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

Join Tek-Tips
*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

LINK TO THIS FORUM!

Add Stickiness To Your Site By Linking To This Professionally Managed Technical Forum.
Just copy and paste the
code below into your site.

Partner With Us!

"Best Of Breed" Forums Add Stickiness To Your Site
Partner Button
(Download This Button Today!)

Feedback

"...I have to add my thanks and appreciation for your wonderful site... People who frequent the site are the two best things - nice and smart..."

Geography

Where in the world do Tek-Tips members come from?
milsnips (Programmer)
12 Jan 01 5:02
I am creating a web solution with SQLServer, InterDev and ASP scripting.

Will this fall into the category of a 2-tier or a 3-tier architecture.
Thanks for anyone's help.

Paul Milcev.
palbano (Programmer)
12 Jan 01 20:59
Tier 1 = Client Browser Application hosting application presentation layer.

Tier 2 = Web Server Application (IIS) providing connectivity for Tier 1 and hosting Web Application environment for logic and processing layer.

Tier 3 = Other components or developer code that provides business logic or access to other resources (SMTP Server) as needed by the Web Application.

Tier 4 = Database Server Application (SQL Server) providing Relational Database Engine and hosting application data layer.

Good luck
-pete
MerlinB (Programmer)
15 Jan 01 7:12
You could call this 2.5 tier! (now for more than you wanted...)
Strictly speaking a 2 tier app has a client application talking directly to a database.
You can then 'muddy' the water by introducing Stored Procedures and Triggers on the server database - by doing this you shift some of the 'business logic' (a rather wishy-washy term!) to the server.  Not stictly a tier, as it can only reside on the same machine as the database, but a logical layer none-the-less.
Now add IIS and ASP to the soup, and you might call this the third tier.  As you suspect, it is mearly acting as a remote 'Client' tier. There will probably be some 'validation' logic on the actual client (javascript), as well as the presentation logic (html).  Back at IIS the Business Logic (data fetch, insert, update, delete with validation) will reside - yet both are wrapped in the same 'page' of code.  Yes, this is a tier - but not quite as distinct as all that, but as it can run on a different machine to the database and client - it is a tier.

Another 'tier' could be 'remote procedures' (DCOM objects, or SOAP/Corba/Tuxedo objects [depending on the OS of the macine that hosts them]).  You might call methods of these 'objects' instead of direct calls to the database. They would return or consume result sets, and perform the 'Business Logic'.  This layer is the more traditional '3rd Tier'.  However, implementing it is painful - both in development time and developer sanity.  It becomes most useful when you deal with multiple data sources, or when your web site crawls from excess of ASP.

Basically, the tier description (I believe) identifies how many computers the various lumps of code could run on.  So you could add a load balancing layer, a replication layer etc..
Hope this was useful!

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close