---
title: "Multi-tired Application Vs. Stored Procedures: Top Differences"
description: "Tired Applications. The concept of tiered applications presents a solution to design architects that uses distributed resources dynamically with the ability to insert software and hardware when and wh..."
url: https://srinimf.com/2015/05/03/difference-between-multi-tired-application-and-stored-procedures/
date: 2015-05-03
modified: 2026-10-10
author: "Srini"
image: https://i0.wp.com/srinimf.com/wp-content/uploads/2015/05/pexels-photo-1741231.jpeg?fit=1880%2C1253&ssl=1
categories: ["DB2"]
tags: ["DB2 Tips and Solutions", "Stored procedures"]
type: post
lang: en
---

# Multi-tired Application Vs. Stored Procedures: Top Differences

## **Tired Applications**

The concept of tiered applications presents a solution to design architects that uses distributed resources dynamically with the ability to insert software and hardware when and where they are needed.

Two-tiered client/server applications might require extensive and expensive deployment strategies for DB2 enablers and business logic.

Related[DB2 11 Certification for z/OS Developers](https://srinimf.com/2016/01/01/db2-version-11-certification-for-application-developers/)

Multi-tiered (three or more tiers) client/server applications greatly reduce the deployment issues because DB2 enablers and business logic are kept on the lower tiers. The client has the presentation layer of the system while the business logic is on the middle tier and the database access on the server tier.

Related[How to describe Data consistency in better way](https://srinimf.com/2016/09/29/how-to-describe-data-consistency-in-better-way/)

This flexibility comes with many benefits, including:

Each tier can be developed, installed, and maintained independently.

Code from existing business logic and database access can be separated and reused as deemed necessary.

With good planning, you can reuse common software solutions.

Any number of hardware and software configurations can be deployed to produce a modular packaging of information services.

A substantial improvement in the maintenance of client/server applications.

## **[Stored Procedures](https://srinimf.com/2015/10/07/how-db2-stored-procedure-is-beneficial-in-the-below-scenario/)**

Stored procedures reside and execute on the database server (or the server tier), they can be developed and installed with minimal maintenance activity. Stored procedures support and encourage [what is](https://srinimf.com/2022/10/03/what-is-multitasking-in-python-and-how-it-supports/), by far, the most pervasive of current computing trends.

### Share this:

-
- [Tweet](https://twitter.com/share)
- [![](https://i0.wp.com/assets.pinterest.com/images/pidgets/pinit_fg_en_rect_gray_20.png)](https://www.pinterest.com/pin/create/link/?url=https%3A%2F%2Fsrinimf.com%2F2015%2F05%2F03%2Fdifference-between-multi-tired-application-and-stored-procedures%2F&media=https%3A%2F%2Fi0.wp.com%2Fsrinimf.com%2Fwp-content%2Fuploads%2F2015%2F05%2Fpexels-photo-1741231.jpeg%3Ffit%3D1200%252C800%26ssl%3D1&description=Multi-tired%20Application%20Vs.%20Stored%20Procedures%3A%20Top%20Differences)
-
- [Share on Tumblr](https://www.tumblr.com/share)
- [Share on WhatsApp (Opens in new window) WhatsApp](https://srinimf.com/2015/05/03/difference-between-multi-tired-application-and-stored-procedures/?share=jetpack-whatsapp)
- [More](#)
-

- [Print (Opens in new window) Print](https://srinimf.com/2015/05/03/difference-between-multi-tired-application-and-stored-procedures/?share=print)
- [Share on Reddit (Opens in new window) Reddit](https://srinimf.com/2015/05/03/difference-between-multi-tired-application-and-stored-procedures/?share=reddit)
- [Share on Telegram (Opens in new window) Telegram](https://srinimf.com/2015/05/03/difference-between-multi-tired-application-and-stored-procedures/?share=telegram)
- [Email a link to a friend (Opens in new window) Email](mailto:?subject=%5BShared%20Post%5D%20Multi-tired%20Application%20Vs.%20Stored%20Procedures%3A%20Top%20Differences&body=https%3A%2F%2Fsrinimf.com%2F2015%2F05%2F03%2Fdifference-between-multi-tired-application-and-stored-procedures%2F&share=email)
-

### Like this:

Like Loading…