Monday, 20 November 2017

What is Database Administrator (DBA)

Posted by
DBA is an important person in the development of any information system. He is responsible for design, design, operation and management of database. He must be technically component good manager and skilled diplomat. He should have good communication skills. Managerial skills are important in planning coordinating and carrying out different task technical skills are required to understand the complex hardware and software issue.
Function of DBA
Preliminary database planning
DBA may participate in preliminary database planning if appointed early.
Identifying user requirement
DBA identifies the current user environment. He closely studies the current system and its outputs. He also interviews different user to know their current and future requirements.
Developing and maintaining data dictionary
Data dictionary is a very collection of data about database. The DMA stores data item names , source, meanings and usages in data dictionary. The data dictionary is revised regularly to update it as the project continues. 
Designing logical model
After analyzing the user environment, the DBA develops a logical data model for the organization. This data model consists on entities, attitudes and relationships.
Choosing  a DBMS
The DBA chooses a particular database management system on the basis of logical data model. The selected DBMS should satisfy all requirements and constrains identified in the logical data model.
Developing physical model
The DBMS creates the exact layout of data according DBMS and available resource of software and hardware.
Creating and loading Database
After developing physical model, the DBA creates the structure of database by using DBMS. He also load  the data in database.
Developing user view
Any project is basically developed to serve the user. DBA should guide the user about the functionality of database. If any request of the user is not satisfying , DBA should justify  it.
Writing and maintaining documentation
The documentation is very important when the project is reviewed or revised. It is normally maintain dictionary system  the DBA should insure the  proper documentation of the project.
Developing and enforcing data standard 
Data in database must be inserted according to the Standard required by organization. \
DBA ensures that the inserted data is always according to these standards. The user interface should guide the user to insert proper data. For example, the text fields may contains default values that make it easy for the user to judge the guide the type of data to be inserted.  Integrity means that database must always satisfy the rules that apply to the real word. For example, if any employees can only work in one department, database should not allow and employee to be registered into department consistency means that to different pieces of data cannot contradict each other. For example if data of birth of an employee is 7/8/78 at one place and it is 12/12/80 at another place than the database is inconsistent.  DBA must ensure that such situation never occurs.
Developing operating procedure
DBA should establish procedure for different operation. The procedure include security and authorization, recording hardware and software failure, taking performance  measurement, shutting down database property, restarting and recovering after failure.
Training the user
The DBA should train end users, application programmers and other user so that they may use the database effectively.

0 comments:

Post a Comment