Top Posts
Reliance Jio launches streaming platform JioGamesWatch
Microsoft Teams down for thousands of users
Carbon: Google programming language as a C++ successor
JavaScript MCQs II
JavaScript MCQs I
Problem Solving Approach
Terms related to Network Security
Set in C++STL
Computer network attack (CNA)
Indexing in DBMS
TECHARGE
  • HOME
  • BLOGS
  • TUTORIALS
    • ALL TUTORIALS
    • PROGRAMMING TUTORIALS
      • JAVA TUTORIALS
      • C++ TUTORIAL
      • C PROGRAMMING TUTORIALS
      • PYTHON TUTORIAL
      • KNOWLEDGE MANAGEMENT TUTORIALS
      • DATA STRUCTURE AND ALGORITHM TUTORIALS
      • PROGRAMMING EXAMPLES
        • CPP EXAMPLES
        • JAVA EXAMPLES
        • C++ GRAPHICS PROGRAM
    • PROJECTS
      • PYTHON PROJECTS
      • SWIFT PROJECT
    • PPROGRAMMING QUIZ
    • DBMS TUTORIALS
    • COMPUTER NETWORK TUTORIALS
    • COMPUTER NETWORK SECURITY TUTORIALS
    • E COMMERCE TUTORIALS 
    • AWS TUTORIAL
    • INTERNET OF THINGS
    • CHEATSHEET
  • MORE
    • JOBS AND INTERNSHIPS
    • INTERVIEW PREPARATION
    • TECH BOOK
    • TECH NEWS
    • INSTAGRAM GALLERY
    • UNIVERSITY PAPERS
    • MNC TWEETS
    • THINKECO INITIATIVES
    • WEB STORIES
    • CONTACT US
  • WRITE +
  • ABOUT US
  • HIRE US
  • BEST COURSES
Dbms Tutorials

DBMS Architecture and Data Abstraction

by anupmaurya March 26, 2022
written by anupmaurya 1 comment

In this article, you’ll learn about Database Architecture and Data Abstraction.

Table of Contents

  • What is Database Architecture?
    • 1-tier Architecture
    • 2-tier Architecture
    • 3-tier Architecture
  • What is Data Abstraction?

What is Database Architecture?

DBMS architecture helps in the design, development, implementation, and maintenance of a database. A database stores critical information for a business. Selecting the correct Database Architecture helps in quick and secure access to this data.

Different types of DBMS architecture are:

1-tier Architecture

1 tier architecture dbms
1 tier architecture DBMS

The simplest of Database Architecture is 1 tier where the Client, Server, and Database all reside on the same machine. Anytime you install a DB in your system and access it to practice SQL queries it is 1 tier architecture. But such architecture is rarely used in production.

2-tier Architecture

2-tier Architecture DBMS
2-tier Architecture DBMS

A two-tier architecture is a database architecture where

  1. Presentation layer runs on a client (PC, Mobile, Tablet, etc)
  2. Data is stored on a Server.

An application interface is called ODBC (Open Database Connectivity) an API that allows the client-side program to call the DBMS. Today most of the DBMS offer ODBC drivers for their DBMS. 2 tier architecture provides added security to the DBMS as it is not exposed to the end-user directly.

3-tier Architecture

3-tier Architecture dbms
3-tier Architecture DBMS

The 3-tier schema is an extension of the 2-tier architecture. 3-tier architecture has the following layers

  1. Presentation layer (your PC, Tablet, Mobile, etc.)
  2. Application layer (server)
  3. Database Server

This DBMS architecture contains an Application layer between the user and the DBMS, which is responsible for communicating the user’s request to the DBMS system and send the response from the DBMS to the user.

The application layer(business logic layer) also processes functional logic, constraint, and rules before passing data to the user or down to the DBMS

Three-tier architecture is the most popular DBMS architecture.

The goal of Three-tier architecture is:

  • To separate the user applications and physical database
  • Proposed to support DBMS characteristics
  • Program-data independence
  • Support of multiple views of the data

What is Data Abstraction?

Data Abstraction is the property by which we hide the non-essential features from clients. Application developers use abstraction to make the system efficient in terms of retrieval of data and reduce complexity in terms of usability of users.

Data Abstraction is used for the following purposes:

  • To provide an abstract view of data.
  • To hide complexity from users.
  • To simplify user interaction with DBMS.
DATA ABSTRACTION in dbms
LEVELS OF DATA ABSTRACTION IN DBMS

Different Levels of Data Abstraction in DBMS are as follows:

  • Physical Level

The lowest level of abstraction describes how the data are actually stored.

  • Logical Level

The Next-higher level of abstraction describes what data are stored in the database and what is relationship exists among those data.

  • View Level

The Highest Level of Data Abstraction describes only part of the entire database. Even though the logical level uses a simpler structure, complexity remains because of the variety of information stored in a larger database.

1 tier architecture2 tier architecture3 tier architecture
Share 4 FacebookTwitterLinkedinRedditWhatsappTelegramEmail
anupmaurya

Hey there, My name is Anup Maurya. I was born with love with programming and works at TCS. One of best global (IT) services and consulting company as System Administrator . I also love graphics designing. It's my pleasure to have you here.

previous post
Introduction to DBMS
next post
Relational Model Concepts

You may also like

Indexing in DBMS

Indexed sequential access method (ISAM)

Lock Based Protocols in DBMS

Closure in DBMS | How to Find Closure

Characteristics of DBMS

Types of database utilities and its functions

DBMS Functions

Different types of Database Users

B+ Tree

Concurrency Control in DBMS

1 comment

Marty November 23, 2020 - 10:21 am

Thank you for the good writeup. It in fact was a amusement account it.
Look advanced to more added agreeable from you!
By the way, how could we communicate?

Comments are closed.

DBMS TUTORIAL

  • DBMS Introduction
  • Relational DBMS
  • DBMS Architecture and Data Abstraction
  • Data Abstraction
  • Different types of Database Users
  • Characteristics of DBMS
  • Types of database utilities and its functions
  • DBMS Functions
  • Relational Model Concepts
  • Difference between DBMS and File System
  • Entity Relationship Diagram – ER Diagram in DBMS
  • Functional Dependency
  • Normalization in DBMS
  • Closure in DBMS | How to Find Closure
  • Second Normal Form (2NF)
  • Third Normal form (3NF)
  • Boyce Codd normal form (BCNF)
  • Transaction in DBMS
  • Transaction property
  • States of Transactions
  • Indexing in DBMS
  • Hashing in DBMS
  • Schedule in DBMS
  • Concurrency Control in DBMS
  • Lock Based Protocols in DBMS
  • Serializability in DBMS
  • Indexed sequential access method (ISAM)
  • DBMS Interview Questions

Words from Readers

Its a very pleasant environment to be on a very interactive learning platform which helps me to enhance my skill set to move forward in an IT marathon.

–Akash Raj

SQL Tutorial

  • SQL Introduction
  • SQL Datatypes
  • SQL Commands

Recent Posts

  • Reliance Jio launches streaming platform JioGamesWatch

    August 6, 2022
  • Microsoft Teams down for thousands of users

    July 21, 2022
  • Carbon: Google programming language as a C++ successor

    July 19, 2022

EDUCATIONAL

  • 5+ Best Humanoid Robots In The World

  • Difference between Google Cloud Platform, AWS and Azure

  • Google Apps You Should Be Using in 2022

  • Top Sites From Where You Can Learn

  • PyScript: Python in the Browser

  • Best Fake Email Generators (Free Temporary Email Address)

  • How to Find Out Who Owns a Domain Name

  • Mobile phone brands by country of origin

  • How to start a new YouTube Channel in 2022

  • Best way to use google search you won’t believe exist

CHEATSHEET

  • HTML Cheatsheet

  • C++ Programming language Cheatsheet

  • Git and Github 2022 Cheat Sheet

  • ReactJs Cheatsheet

  • Linux Commands Cheat Sheet

  • C Programming language Cheatsheet

  • Scala Cheatsheet

PROJECTS

  • Python text to Speech

  • StopWatch using Python

  • Python Rock Paper Scissors Game

  • Currency Converter in Python

  • Alarm clock GUI application with tkinter

  • Print emojis using python without any module

  • Country Date and Time using Python

  • Covid-19 Tracker Application Using Python

  • Python | GUI Calendar using Tkinter

  • Python: Shutdown Computer with Voice

  • Python GUI Calculator using Tkinter

  • Convert an Image to ASCII art using Python

TUTORIALS

  • JAVA TUTORIAL
  • COMPUTER NETWORK
  • DBMS TUTORIAL
  • E-COMMERCE TUTORIAL
  • KNOWLEDGE MANAGEMENT
  • C++ PROGRAMMING
  • COMPUTER NETWORK SECURITY
  • AMAZON WEB SERVICES

TECH NEWS

  • Reliance Jio launches streaming platform JioGamesWatch

  • Microsoft Teams down for thousands of users

  • Carbon: Google programming language as a C++ successor

  • 5+ Best Humanoid Robots In The World

TERMS & POLICY

  • PRIVACY POLICY
  • TERMS AND CONDITIONS

COMPILERS

  • JAVA COMPILER
  • PYTHON COMPILER
  • JS COMPILER
  • C++ COMPILER
  • C COMPILER

JOBS AND INTERNSHIPS

  • TCS off-campus hiring 2022 for software engineers- 2019, 2020, & 2021 Batches

    February 27, 2022
  • Deloitte Recruitment For Any Graduates as Learning Operations Associate Analyst

    February 18, 2022
  • HP Recruitment For Tech Support Intern Position

    February 16, 2022
  • EY Hiring- PAS Global Immigration Advanced Analyst

    February 14, 2022
  • Amazon Recruitment Drive for Virtual Customer Support Associate Position

    February 12, 2022
Join Us On Telegram

@2019-21 - All Right Reserved. Designed and Developed by Techarge

TECHARGE
  • HOME
  • BLOGS
  • TUTORIALS
    • ALL TUTORIALS
    • PROGRAMMING TUTORIALS
      • JAVA TUTORIALS
      • C++ TUTORIAL
      • C PROGRAMMING TUTORIALS
      • PYTHON TUTORIAL
      • KNOWLEDGE MANAGEMENT TUTORIALS
      • DATA STRUCTURE AND ALGORITHM TUTORIALS
      • PROGRAMMING EXAMPLES
        • CPP EXAMPLES
        • JAVA EXAMPLES
        • C++ GRAPHICS PROGRAM
    • PROJECTS
      • PYTHON PROJECTS
      • SWIFT PROJECT
    • PPROGRAMMING QUIZ
    • DBMS TUTORIALS
    • COMPUTER NETWORK TUTORIALS
    • COMPUTER NETWORK SECURITY TUTORIALS
    • E COMMERCE TUTORIALS 
    • AWS TUTORIAL
    • INTERNET OF THINGS
    • CHEATSHEET
  • MORE
    • JOBS AND INTERNSHIPS
    • INTERVIEW PREPARATION
    • TECH BOOK
    • TECH NEWS
    • INSTAGRAM GALLERY
    • UNIVERSITY PAPERS
    • MNC TWEETS
    • THINKECO INITIATIVES
    • WEB STORIES
    • CONTACT US
  • WRITE +
  • ABOUT US
  • HIRE US
  • BEST COURSES