• Home
  • General Science
  • Biology
  • Chemistry
    • Compounds
  • Physics
    • Class 12th
  • Math
  • Articles

EduTzar

  • Skip to primary navigation
  • Skip to main content
  • Skip to primary sidebar
  • Skip to footer
  • Home
  • General Science
  • Biology
  • Chemistry
    • Compounds
  • Physics
    • Class 12th
  • Math
  • Articles

Database Access – What is Database Access & How is it Works

Author: EduTzar | On:8th May, 2021| Comments: 0

Hello friends, Today we are going to learn about what is database access and how it works. So let’s go to the article.

Table of Content

  • Database Access
    • Data Manager 
    • File Manager
    • Disk Manager
    • Buffer Manager

Database Access

DBMS is the bridge between the user and the database. To access the database, the following steps are involved.

Diagramatic Representation of Database Access
Diagramatic Representation of Database Access

Step 1. The user sends a query to the data manager, which is the central software component of the DBMS, to retrieve the set of records.

Step 2. The data manager analyzes the external schema of the user program and finds the database description of the record.

Step 3. The data manager then checks with the conceptual schema to get the data types and location information.

Step 4. The data manager then checks with the physical schema to find out with device the record is in and what Data Manager can use access methods.

Step 5.6. It then sends a request to the file manager for locating a block containing a required record that requests this block from the disk manager, which performs the physical input and output operation to access the required records from the database.

Step 7. The retrieved data is placed into the system buffer (Reserved blocks of primary memory to match the speed of the processor and relatively fast primary memories with the slower secondary memories and minimize the I/O operations between secondary and primary memories).

Step 8. Now the retrieved are sent from the system buffer to the DBMS/User Interface with the help of DBMS.

Step 9. It provides the status information.

In the database access, the storage manager components are responsible for providing the interface between the low-level data stored in the database and the application programs and queries submitted to the system. 

The following are the storage manager components :

  1. Data Manager 
  2. File Manager
  3. Disk Manager
  4. Buffer Manager

Data Manager 

The data manager is the leading software component of the DBMS. The main functions of the Data Manager are

  • It transforms operation in the user queries or an application program from the user’s logical view to a physical file system.
  • Data Manager handles the buffers in the main memory.
  • It enforces constraints to the integrity and consistency of the data.
  • Data Manager synchronizes the operation performed by the user simultaneously.
  • It also controls backup and recovery operations.

File Manager

The file manager’s responsibility is to allocate the space on disk storage, and the data structures used to represent information stored on disks. After fetching the record, the file manager sends the requested record back to the data manager. The file manager is not concerned with the physical characteristics of the underlying storage media.

Disk Manager

The disk manager is the part of the operating system which accepts a requested block or page containing the required record from the file manager. It sends it to the database to perform input/output operations. Then after accessing it returns the requested block to the file manager is not concerned with the physical characteristics of the storage media.

Buffer Manager

Buffer Manager is responsible for fetching data from disk storage into main memory and deciding what data to cache in memory.

Friends if you found this article useful then share it with your friends and comment below.

Thank You!

Read More :

What is Database

Database Approach

Previous Post
Next Post

Reader Interactions

Read More Articles

  • इलेक्ट्राॅन की खोज किसने की थी – Electron ki khoj kisne ki thi : खोजकर्ता, प्रयोग, इतिहास

    इलेक्ट्राॅन की खोज किसने की थी – Electron ki khoj kisne ki thi : खोजकर्ता, प्रयोग, इतिहास

  • कोशिका किसे कहते हैं : परिभाषा, खोज, सिद्धान्त, प्रकार, संरचना और अंग – Koshika Kise Kahate Hain

    कोशिका किसे कहते हैं : परिभाषा, खोज, सिद्धान्त, प्रकार, संरचना और अंग – Koshika Kise Kahate Hain

  • जीवाणु की खोज किसने की : बैक्टीरिया की खोज कब और किसने की – Jivanu Ki Khoj Kisne Ki Thi

    जीवाणु की खोज किसने की : बैक्टीरिया की खोज कब और किसने की – Jivanu Ki Khoj Kisne Ki Thi

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Primary Sidebar

Reet Answer Key 2021

Rajasthan Patwari Answer Key 2021

Search Your Article

Follow on Social Media

New Articles

  • NCC Full Form in Hindi: एनसीसी का फुल फाॅर्म क्या है – NCC क्या है : स्थापना, सिद्धान्त, इतिहास, ध्वज, उद्देश्य और Certificate के फायदे
  • फिटकरी का सूत्र क्या है : रासायनिक नाम, समीकरण, बनाने की विधि, फिटकरी क्या है : परिभाषा, प्रकार, गुण, उपयोग – Fitkari ka sutra
  • ALU Full Form in Hindi : Meaning – ALU का पूरा नाम – Full Form of ALU in Computer
  • इलेक्ट्राॅन की खोज किसने की थी – Electron ki khoj kisne ki thi : खोजकर्ता, प्रयोग, इतिहास
  • कोशिका किसे कहते हैं : परिभाषा, खोज, सिद्धान्त, प्रकार, संरचना और अंग – Koshika Kise Kahate Hain
  • जीवाणु की खोज किसने की : बैक्टीरिया की खोज कब और किसने की – Jivanu Ki Khoj Kisne Ki Thi
  • लेंस की क्षमता का सूत्र क्या है : परिभाषा, सूत्र और मात्रक – Lens Ki Chamta ka Sutra Kya Hai
  • पोषण किसे कहते हैं : पोषण की परिभाषा क्या है, पोषण के प्रकार और वर्गीकरण – What is Nutrition in Hindi
  • संवेग संरक्षण का नियम – Samveg Sanrakshan Ka Niyam और अनुप्रयोग – Law of Conservation of Momentum in Hindi
  • यूग्लीना क्या है : संरचना, वर्गीकरण, आवास और स्वभाव – Euglena in Hindi




Our Subjects

  • Biology
  • Chemistry
  • Class 12th Physics
  • Compounds
  • Computer
  • Full Form
  • Fundamentals of DBMS
  • General Science
  • Math
  • Physics

Our Top Subjects are :

  • Biology
  • Chemistry
  • Physics
  • General Science
  • Math

Our Updates

  • December 2021
  • June 2021
  • May 2021
  • April 2021
  • February 2021
  • January 2021
  • December 2020
  • November 2020
  • October 2020
  • September 2020
  • August 2020
  • July 2020
  • June 2020
  • May 2020
  • April 2020
  • March 2020

Join Us

    Footer

     Top 10 Articles of Bio
     Balanoglossus in Hindi
     Nerve Cell in Hindi
     Virus in Hindi
     Eye in Hindi
     Brain in Hindi
     Biodiversity in Hindi
     Sankramak Rog
     Green House Prabhav Kya Hai
     Mutation in Hindi
     Protein in Hindi
     Malnutrition in Hindi
     
     Top 10 Articles of Chemistry
     CNG Full Form in Hindi
     Plaster of Paris Formula
     Baking Soda in Hindi
     Homogeneous Meaning in Hindi
     Washing Soda Chemical Name
     Bleaching Powder Chemical Name
     Catalyst Meaning in Hindi
     PH का पूरा नाम
     Antigen Meaning in Hindi
     अम्लीय वर्षा
     कार्बन के अपररूप – अपररूपता
     Top 10 Articles of Physics
     Vidyut Dhara Ka S.I. Matrak
     Phonons in Hindi
     Electric Flux in Hindi
     चोक कुंडली क्या है ?
     Urja Kise Kahate Hain
     गतिज ऊर्जा
     Om Ka Niyam
     Ozone Layer in Hindi
     Darpan Ka Sutra
     Toroid kya hai
     Work, Power and Energy in Hindi
    Copyright © 2020 | Edutzar.in | Sitemap | About Us | Contact Us | Disclaimer | Privacy Policy