What is DBA ? What are the functions of DBA?

No comments

DBA (Data Base Administrator):-

The database administrator(DBA) is a person or a group of person responsibility for overall control of the database system. The database administrator is not the ‘processor’ but the protector of it. 

Function Of  DBA :-

 1.  Deciding the information content of the database :-
It is the D.B.A’s job to decide exactly what information is to be held in the data base. The D.B.A must then define the content of the database.

2.  Deciding the storage structure and access strategy :-
The D.B.A must also decide how the data is to represented in the database and must specify the representation by writing the storage structure definition.

 3.  Defining Authorization checks and validation procedure 

  4.  Defining a strategy for back up and recovery :-
It may happen that any portion of the database can be damaged by human error or a failure in the hardware or supporting operating system. So, it is essential to repair the data concerned with a minimum of delay. The D.B.A must define an implement appropriate recovery strategy.

5.  Monitoring performance and responding to changes in requirements

No comments :

Post a Comment

Subscribe

Milan Panda
Admin
About Me | Contact
Copyright 2023-2024 © Programming1011 . 🎀 Developed and Design By- Milan Panda. Happy Holi All Of You 🎀