What is Database Administrator?, Responsibilities of Database Administrator(DBA), Application Architecture, System Structure

What is Database Administrator?, Responsibilities of Database Administrator(DBA), Application Architecture, System Structure

Database Administrator(DBA)

Database Administrator is one which Coordinates all the activities of the database system; the database administrator has a good understanding of the enterprise’s information resources and needs.


Responsibilities of Database Administratior(DBA)
Database administrator's duties include:

• Schema definition
• Storage structure and access method definition
• Schema and physical organization modification
• Granting user authority to access the database
• Specifying integrity constraints
• Acting as liaison with users
• Monitoring performance and responding to changes in requirements

Overall System Structure

1.) The different types of users interact with Database system through application interfaces, application programs, query tools and administrative tools.

2.) The query processor & storage manager interact with Database

3.) The database on disk storage is categorized into Data,

indices, data dictionary and statistical data.

Overall System Structure

Application Architecture

Two-tier architecture: E.g. client programs using ODBC/JDBC to

communicate with a database

Three-tier architecture: E.g. web-based applications, and

applications built using ―middleware‖