Overall Structure of DBMS

Overall Structure of DBMS
The Structure of DBMS is divided into several components which perform specific functions
such as Query processing, storage management, etc. Each of these components is sub-divided
into other components to execute different operations like DDL interpretation, DML
compilation, etc. There are three major components of the structure of DBMS Query Processor,
Storage Manager, and Disk Storage. Every component more or less depends on the other
component for its proper functioning.
Database Users:
Users are differentiated by the way they expect to interact with the system:
 Application programmers:
o Application programmers are computer professionals who write application
programs. Application programmers can choose from many tools to develop
user interfaces.
 Sophisticated users:
o Sophisticated users interact with the system without writing programs. Instead,
they form their requests in a database query language.
o They submit each such query to a query processor, whose function is to break
down DML statements into instructions that the storage manager understands.
 Specialized users :
o Specialized users are sophisticated users who write specialized database
applications that do not fit into the traditional data-processing framework.
 Naïve users :
o Naive users are unsophisticated users who interact with the system by invoking
one of the application programs that have been written previously.
o For example, a bank teller who needs to transfer $50 from account A to account
B invokes a program called transfer. This program asks the teller for the amount
of money to be transferred, the account from which the money is to be
transferred, and the account to which the money is to be transferred.
Database Administrator:
 Coordinates all the activities of the database system. The database administrator has a
good understanding of the enterprise’s information resources and needs.
 Database administrator's duties include:
o Schema definition: The DBA creates the original database schema by executing
a set of data definition statements in the DDL.
o Storage structure and access method definition.
o Schema and physical organization modification: The DBA carries out changes
to the schema and physical organization to reflect the changing needs of the
organization, or to alter the physical organization to improve performance.
o Granting user authority to access the database: By granting different types of
authorization, the database administrator can regulate which parts of the
database various users can access.
o Specifying integrity constraints.
o Monitoring performance and responding to changes in requirements.
Query Processor:
The query processor will accept query from user and solves it by accessing the database.
Parts of Query processor:
 DDL interpreter
This will interprets DDL statements and fetch the definitions in the data dictionary.
 DML compiler
a. This will translates DML statements in a query language into low level instructions
that the query evaluation engine understands.
b. A query can usually be translated into any of a number of alternative evaluation plans
for same query result DML compiler will select best plan for query optimization.
 Query evaluation engine
This engine will execute low-level instructions generated by the DML compiler on
DBMS.
Storage Manager/Storage Management:

 A storage manager is a program module which acts like interface between the data
stored in a database and the application programs and queries submitted to the system.
 Thus, the storage manager is responsible for storing, retrieving and updating data in the
database.
 The storage manager components include:
o Authorization and integrity manager: Checks for integrity constraints and
authority of users to access data.
o Transaction manager: Ensures that the database remains in a consistent state
although there are system failures.
o File manager: Manages the allocation of space on disk storage and the data
structures used to represent information stored on disk.
o Buffer manager: It is responsible for retrieving data from disk storage into
main memory. It enables the database to handle data sizes that are much larger
than the size of main memory.
o Data structures implemented by storage manager.
o Data files: Stored in the database itself.
o Data dictionary: Stores metadata about the structure of the database.
o Indices: Provide fast access to data items.
ADD COMMENT

Overall Structure of DBMS

Uploaded by

Copyright:

Available Formats

Overall Structure of DBMS

Uploaded by

Document Information

Copyright

Available Formats

Share this document

Share or Embed Document

Sharing Options

Did you find this document useful?

Is this content inappropriate?

Copyright:

Available Formats

Overall Structure of DBMS

Uploaded by

Copyright:

Available Formats

Overall Structure of DBMS

Storage Manager/Storage Management:

You might also like