Database-Administrator (DBA) - PowerPoint Presentation, Computer Science Computer Science Engineering (CSE) Notes | EduRev

Created by: Jatin Yadav

Computer Science Engineering (CSE) : Database-Administrator (DBA) - PowerPoint Presentation, Computer Science Computer Science Engineering (CSE) Notes | EduRev

 Page 1


Database Administrator [DBA] 
Definition 
 Centralized control of the database is exerted by a 
person or group of persons under the supervision of a high-
level administrator. This person or group is referred to as the 
database administrator (DBA). They are the users who are 
most familiar with the database and are responsible for 
creating, modifying, and maintaining its three levels. 
  Database Administrator is responsible to manage the 
DBMS’s use and ensure that the database is functioning 
properly. 
Copyright @ www.bcanotes.com 
Page 2


Database Administrator [DBA] 
Definition 
 Centralized control of the database is exerted by a 
person or group of persons under the supervision of a high-
level administrator. This person or group is referred to as the 
database administrator (DBA). They are the users who are 
most familiar with the database and are responsible for 
creating, modifying, and maintaining its three levels. 
  Database Administrator is responsible to manage the 
DBMS’s use and ensure that the database is functioning 
properly. 
Copyright @ www.bcanotes.com 
 DBA administers the three levels of database and 
consultation with the overall user community, sets up the 
definition of the global view of the various users and 
applications and is responsible the definition and 
implementation of the internal level, including the storage 
structure and access methods to be used for the optimum 
performance of the DBMS. 
 DBA is responsible for granting permission to the users 
of the database and stores the profile of each user in the 
database. 
Database Administrator [DBA] 
De finition… 
Copyright @ www.bcanotes.com 
Page 3


Database Administrator [DBA] 
Definition 
 Centralized control of the database is exerted by a 
person or group of persons under the supervision of a high-
level administrator. This person or group is referred to as the 
database administrator (DBA). They are the users who are 
most familiar with the database and are responsible for 
creating, modifying, and maintaining its three levels. 
  Database Administrator is responsible to manage the 
DBMS’s use and ensure that the database is functioning 
properly. 
Copyright @ www.bcanotes.com 
 DBA administers the three levels of database and 
consultation with the overall user community, sets up the 
definition of the global view of the various users and 
applications and is responsible the definition and 
implementation of the internal level, including the storage 
structure and access methods to be used for the optimum 
performance of the DBMS. 
 DBA is responsible for granting permission to the users 
of the database and stores the profile of each user in the 
database. 
Database Administrator [DBA] 
De finition… 
Copyright @ www.bcanotes.com 
Responsibilities of  DBA 
Deciding the information content of the database 
It is the DBA’s job to decide exactly what information is to be 
held in the database - in other words, to identify the entities of 
interest to the enterprise and to identify the information to be 
recorded about those entities. Having done this, the DBA must 
then define the content of the database by writing the 
conceptual schema. 
Copyright @ www.bcanotes.com 
Page 4


Database Administrator [DBA] 
Definition 
 Centralized control of the database is exerted by a 
person or group of persons under the supervision of a high-
level administrator. This person or group is referred to as the 
database administrator (DBA). They are the users who are 
most familiar with the database and are responsible for 
creating, modifying, and maintaining its three levels. 
  Database Administrator is responsible to manage the 
DBMS’s use and ensure that the database is functioning 
properly. 
Copyright @ www.bcanotes.com 
 DBA administers the three levels of database and 
consultation with the overall user community, sets up the 
definition of the global view of the various users and 
applications and is responsible the definition and 
implementation of the internal level, including the storage 
structure and access methods to be used for the optimum 
performance of the DBMS. 
 DBA is responsible for granting permission to the users 
of the database and stores the profile of each user in the 
database. 
Database Administrator [DBA] 
De finition… 
Copyright @ www.bcanotes.com 
Responsibilities of  DBA 
Deciding the information content of the database 
It is the DBA’s job to decide exactly what information is to be 
held in the database - in other words, to identify the entities of 
interest to the enterprise and to identify the information to be 
recorded about those entities. Having done this, the DBA must 
then define the content of the database by writing the 
conceptual schema. 
Copyright @ www.bcanotes.com 
Responsibilities of  DBA… 
Deciding the storage structure and access strategy 
The DBA must also decide how the data is to be represented in 
the database, and must specify the representation by writing 
the storage structure definition. In addition, the associated 
mapping between storage structure definition and the 
conceptual schema must also be specified.  
Copyright @ www.bcanotes.com 
Page 5


Database Administrator [DBA] 
Definition 
 Centralized control of the database is exerted by a 
person or group of persons under the supervision of a high-
level administrator. This person or group is referred to as the 
database administrator (DBA). They are the users who are 
most familiar with the database and are responsible for 
creating, modifying, and maintaining its three levels. 
  Database Administrator is responsible to manage the 
DBMS’s use and ensure that the database is functioning 
properly. 
Copyright @ www.bcanotes.com 
 DBA administers the three levels of database and 
consultation with the overall user community, sets up the 
definition of the global view of the various users and 
applications and is responsible the definition and 
implementation of the internal level, including the storage 
structure and access methods to be used for the optimum 
performance of the DBMS. 
 DBA is responsible for granting permission to the users 
of the database and stores the profile of each user in the 
database. 
Database Administrator [DBA] 
De finition… 
Copyright @ www.bcanotes.com 
Responsibilities of  DBA 
Deciding the information content of the database 
It is the DBA’s job to decide exactly what information is to be 
held in the database - in other words, to identify the entities of 
interest to the enterprise and to identify the information to be 
recorded about those entities. Having done this, the DBA must 
then define the content of the database by writing the 
conceptual schema. 
Copyright @ www.bcanotes.com 
Responsibilities of  DBA… 
Deciding the storage structure and access strategy 
The DBA must also decide how the data is to be represented in 
the database, and must specify the representation by writing 
the storage structure definition. In addition, the associated 
mapping between storage structure definition and the 
conceptual schema must also be specified.  
Copyright @ www.bcanotes.com 
Responsibilities of  DBA… 
Liaising with the users 
It is the business of the DBA to liaise with users, to ensure that 
the data they require is available, and to write the necessary 
external schemas. In addition, the mapping between any given 
external schema and the conceptual schema must also be 
specified. In practice the external DDL will probably include 
the means for specifying the mapping, but the schema and the 
mapping should be clearly distinguishable. 
Copyright @ www.bcanotes.com 
Read More

Content Category

Related Searches

Database-Administrator (DBA) - PowerPoint Presentation

,

Extra Questions

,

mock tests for examination

,

Sample Paper

,

ppt

,

study material

,

Computer Science Computer Science Engineering (CSE) Notes | EduRev

,

Objective type Questions

,

Important questions

,

Database-Administrator (DBA) - PowerPoint Presentation

,

practice quizzes

,

pdf

,

Computer Science Computer Science Engineering (CSE) Notes | EduRev

,

Database-Administrator (DBA) - PowerPoint Presentation

,

video lectures

,

Free

,

Summary

,

MCQs

,

Computer Science Computer Science Engineering (CSE) Notes | EduRev

,

Semester Notes

,

past year papers

,

Viva Questions

,

Exam

,

Previous Year Questions with Solutions

,

shortcuts and tricks

;