Scribd Logo
Upload

Welcome to Scribd!

    • 4 views

    Data Storage and Querying

    Uploaded by

    rambabu mahato

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd

    Data Storage and Querying

    Uploaded by

    rambabu mahato
    4 views3 pages

    Copyright

    © © All Rights Reserved

    Available Formats

    PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd
    Download as pdf or txt
    4 views3 pages

    Data Storage and Querying

    Uploaded by

    rambabu mahato

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd
    Download as pdf or txt
    of 3

    Data Storage and Querying

    The functional components of a database system can be


    broadly divided into:
    • The storage manager is important because databases typically require a large
    amount of storage space
    • The query processor is important because it helps the database system simplify and
    facilitate access to data
    The overall computer system consists of four modules as:
    Hardware, Operating system, File management system and
    Application program

    Storage Manager
    A storage manager is a program module that provides the interface between the
    low-level data stored in the database and the application programs and queries
    submitted to the system. The storage manager is responsible for the interaction
    with the file manager. Storage manager is responsible for storing, retrieving and
    updating data in the database
    The storage manager components include:
    • Authorization and Integrity Manager: This module tests for the
    satisfaction of integrity constraints and checks the authority of users
    to access data
    • Transaction Manager: Transaction manager ensures that the
    database remains in a consistent (correct) state despite system
    failures and concurrent transaction executions proceed without
    conflicting
    • File Manager: This module manages the allocation of space on disk
    storage and data structures used to represent information stored on
    the disk
    • Buffer Manager: Buffer manager is responsible for fetching data from
    the disk storage into main memory. The buffer manager is a critical part
    of the database system
    • Data files: These are files in the physical memory used to store the
    database itself
    • Data Dictionary: Data dictionary stores the metadata (data about
    data) that provides the information about the definitions of the data
    items and their relationships, authorizations, and usage statistics. In
    addition, any changes made to the physical structure of the database
    are automatically recorded in the data dictionary
    • Indices: Indices are used to provide faster access to data items
    stored in the physical storage
    Query Processor
    The work of query processor is to execute the query
    successfully
    The major components of query processor include:
    • DDL Interpreter: This is the interpreter used to
    interpret DDL statements and records the definitions
    in the data dictionary

    • DML Compiler: DML compiler translates the DML statements in a


    query language into an evaluation plan consisting of low-level
    instructions that the query evaluation engine understands. When a
    user wants to perform a DML operation, the data dictionary has to
    be checked for the validation purpose
    Query Evaluation Engine: This module executes the
    low-level instructions generated by the DML
    compiler

    You might also like