Database Architectures used by Database Developer: Introduction to SQL

December 03, 2013 , , 1 Comments

According to earlier discussion about employee’s details storage in database, any business application can have some major elements as Single-tier Architecture, Two-tier architecture, Three-tier Architecture and at the last N-tier Architecture in context of SQL server. A database developer can easily use this concepts in sql by following below description.

Single-Tier Architecture

In single-tier architecture, all elements of a business application are combined as a single executable unit. This unit is installed on all the computers that the users need to work on. It is required to recompile and redistribute the entire application to all the computers, after any modification. That’s why it becomes complicated to modify the application or to fix any bugs.

Two-Tier Architecture

This architecture makes entry to address the problems in modifying an application faced in a first scenario. In two-tier architecture, the application is divided into two manageable parts; one part handles the data, while the other provides the user interface. The two parts can be located on a single computer or on separate computers over a network.

The part that handles the user interface (UI) is called the client tier. The part that Implements the application logic and manages the input data based on the business rules is called the server tier, as shown in the following connection.

Client Computers<---------------------------------->Database Server

Two-tier architecture is also called client-server architecture. Most RDBMSs, such as Microsoft Access, SQL Server, and Oracle adhere to the client-server architecture. RDBMS provides centralized functionality required while supporting many users.

Three-Tier Architecture

When implementing complex business solutions in case of a two-tier architecture, the tier on which the business logic is implemented becomes over loaded. As a result, it takes more time to execute. Therefore, to provide further flexibility, the two-tier architecture can be split into three tiers. In three-tier architecture, the first tier is the client tier, the second or middle tier is called the business tier and the third tier is called the server tier. The server tier contains a database server that manages the data.

Client Computers<-------->Business Tier <-------->Database Server

The business tier consists of all the business rules. It consists of the application logic that Implements rules and checks the data. The advantage of a three-tier application is that it allows you to change the business rules without affecting the other two tiers.

For instance in a banking application for loans, the user tier is the front-end, used by the customer to specify the loan details. The server tier can consist of an RDBMS in which the data is stored. The business tier lies between the other two tiers and consists of business rules, such as the loan limit and the interest rate charged to a customer. If there is a change in the rate of interest, only the middle tier component needs to be modified.

N-Tier Architecture

Vivek Rohil

Some say he’s half man half fish, others say he’s more of a seventy/thirty split. Either way he’s a fishy bastard. Google

1 comment:

  1. Excellent service! Very clean and easy to use facility. Staff is very helpful too. Helped me a lot in storing my items there. Actually, I was planning to store fewer items in the storage unit., but ended up storing all my items.
    Self storage software