• 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

  • ALU Full Form in Hindi :  Meaning – ALU का पूरा नाम – Full Form of ALU in Computer

    ALU Full Form in Hindi : Meaning – ALU का पूरा नाम – Full Form of ALU in Computer

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

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

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

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

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

New Articles

  • Winzo App Download – 2023,Latest Version Apk, Login, Install
  • 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

Our Subjects

  • Apps Review
  • 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

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