Database Management System and SQL
Database Management System and SQL
  • Database Management System and SQL
  • Database
    • Introduction to Database
      • Definition
      • File System
      • Different types of Database
      • Uses of DBMS
      • Basic Terms in Database
      • Query Language
    • View of Data
      • Data Abstraction
      • Schema & Instance
      • Data Models
    • Database Architecture
      • DBMS Tier Architecture
      • Three Schema Architecture
      • Data Independence
    • Relational Database Management System (RDBMS)
      • Entity-Relationship (ER) Model
      • Attributes
      • Keys
      • Relationship
    • Functional Dependencies
    • Normalization
  • MySQL
    • Terminology
    • Database Statements
    • Table
      • Data Type
      • Create
      • Show
      • Describe
      • Drop
      • Alter
      • Auto Increment
      • Index
    • Insert
    • Select
      • Condition
      • Aggregate Functions
      • Join
    • View
    • Delete
    • Update
    • MySQL Constraints
      • NOT NULL
      • DEFAULT
      • CHECK
      • UNIQUE
      • PRIMARY KEY
      • FOREIGN KEY
Powered by GitBook
On this page
  • DBMS Architecture
  • DBMS Architecture Classification
  • 1-Tier Architecture
  • 2-Tier Architecture
  • 3-Tier Architecture

Was this helpful?

  1. Database
  2. Database Architecture

DBMS Tier Architecture

PreviousDatabase ArchitectureNextThree Schema Architecture

Last updated 1 year ago

Was this helpful?

DBMS Architecture

  • The DBMS design depends upon its architecture.

  • The basic client/server architecture is used to deal with a large number of PCs, web servers, database servers and other components that are connected with networks.

  • The client/server architecture consists of many PCs and a workstation which are connected via the network.

  • DBMS architecture depends upon how users are connected to the database to get their request done.

  • Database architecture can be seen as a single tier or multi-tier. But logically, database architecture is of two types like: 2-tier architecture and 3-tier architecture.

DBMS Architecture Classification

  • 1-Tier Architecture

  • 2-Tier Architecture

  • 3-Tier Architecture

1-Tier Architecture

  • In this architecture user directly access the database.

  • Changes are done directly to the database itself.

  • No user application is used for user.

  • It is used for development of the local application.

2-Tier Architecture

  • It follows client server architecture.

  • Applications on the client side directly communicate with the database at the server side. API's like: ODBC, JDBC are used for interaction.

  • User interfaces and application programs are run on the client side.

  • Server provides the database functionalities.

  • To communicate with the DBMS, client side application establishes a connection with the server side.

3-Tier Architecture

  • It follows client server architecture.

  • In this architecture client application don't communicate with the server directly.

  • Application on the client side interacts with an application server which further communicates with the database system.

  • End user has no idea about the existence of the database beyond the application server.

  • The database also has no idea about any other user beyond the server application.

  • 3-Tier architecture is used in large web application.