Database Administrator: Definition, Functions & DBMS

Database Administrator

The data administrator is the person who makes the strategic and policy decisions regarding the data of the enterprise. Now we know of Data Administrator, it is easier to define database administrator in reference with data administrator. Therefore,  the database administrator (DBA) is a person who provides the necessary technical supports for implementing those decisions. Thus, the DBA is responsible for the overall control of the system at a technical level.

Functions/Role of Database Administrator:

  1. Defining the internal schema
    The DBA must define how the data is to be represented in the stored database. This process is usually referred to as physical database design.
  2. Defining the external schema
    The DBA must also decide exactly what information is to be stored in the database.  This process is usually called as logical database design.
  3. Liaising with 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 schema.
  4. Defining security and integrity rules
    The DBA must define security rues for the protection of data against unauthorized users. He/She must also define integrity rule for checking accuracy or validity of data.
  5. Defining backup and recovery procedures
    The DBA must  define backup and recovery procedures because the damage to any portion of the system causes error.
  6. Monitoring performance and responding to the changing requirements
    The DBA must monitor performance and make the appropriate adjustments as the requirements change.

Definition of DBMS:

Database can be defined simply as, related form of information. In other words, A database is a collection of interrelated data of certain place or things in such a way that it can be easily accessed by programs like DBMS.

Properties of Databse:

  1. A Database represents some aspects of the real world.
  2. A Database is a collection of related data with some meaning.
  3. Database is designed, built and populated with data for a specific purpose.

Thank You for visiting us.
Visit again for daily updates and more tech related information.

 -ThecosmoTech

You May Also Like:

DBMS: Concept, Objectives, Advantages & Disadvantages

What Is Blockchain? A Thorough Details.

Best And Useful Command Prompt Tricks & Codes