Thursday, October 3, 2013

The role of "Database administrators" in a DBMS.

                                                Database administrators are the people making the strategic and policy decisions regarding the data of the enterprise, and providing the necessary support for implementing these decisions. In other words, they are responsible for the overall control of the system. Let’s see what are the major functions of the Database administrators.

        Defining the conceptual schema
This includes identifying what are the entities, what are the information to be stored in each of the entity and so on, according to the company requirements. Here, the database is designed logically.

        Defining the internal schema
In here, the database administrators have to create the physical database design. Afterwards,  they should create the corresponding storage structure and must define the associated mapping between internal and conceptual schema.

        Linking with the users
This explains that the database administrators should check whether the data needed by the users are available in the database.

        Defining Security and integrity rules
The database administrators should define and facilitate security features and integrity rules to make sure that the database is secured properly.

        Defining backup and recovery procedures
It is the responsibility of the database administrators to define and implement proper backup and recovery plan in order to minimize the data 

No comments:

Post a Comment