Explain the role of a database administrator, Database Management System

Explain the Role of a database administrator

a. Defining the Schema 

 The DBA describes the schema which consists of the structure of the data in the application.

The DBA defines what data needs to be present in the system ad how this data has to be denoted and organized. 

b. Liaising with Users 

The DBA wants to interact continuously with the users to understand the data in the system and its employ.

c. Defining Security & Integrity Checks 

 The DBA finds out about the access restrictions to be defined and demonstrates security checks accordingly. Data Integrity checks are as well defined by the DBA.

d. Defining Backup / Recovery Procedures 

 The DBA as well defines processes for backup and recovery. Defining backup procedures involves specifying what data is to backed up, the periodicity of taking backups and as well the medium and storage place for the backup data. 

E. Monitoring Performance 

The DBA has to incessantly check the performance of the queries and take measures to optimize all the queries in the application.

Posted Date: 5/6/2013 3:29:31 AM | Location : United States

Related Discussions:- Explain the role of a database administrator, Assignment Help, Ask Question on Explain the role of a database administrator, Get Answer, Expert's Help, Explain the role of a database administrator Discussions

Write discussion on Explain the role of a database administrator
Your posts are moderated
Related Questions
This language that enable user manipulate to or access data as organized by appropriate data model. Low level or Procedural DML : DML needs a user to specify what data ar

Preliminary entities and attributes of human resourse management database management system

Synonyms It allows short names or alternative names for objects. Example :               CREATE SYNONYM D30               FOR EMPD30;   Now if we give command:

Which component is not included in database environment ? A users component is not included in database environment.

What three major types of actions includes databases? Briefly discuss these The three major types of actions including databases are: (i) Defining: It includes specifyin

Explain ER Relationship model? An entity-relationship model (ERM): An entity-relationship model (ERM) is an abstract theoretical illustration of structured data. Entity-relatio

why shadow copy technique is used?

A use case diagram giving a pictorial overview of user requirements and brief use case descriptions. As the case study contains only an outline of a business scenario, you will als

Consider the following frequency counts of some itemsets in a transaction database r : freq({A}, r) = 0.405 freq({B}, r) = 0.510 freq({C}, r) = 0.303 freq({A

For each m:n relationship type R, we make a new table (say S) to represent R. We also contain the primary key attributes of both the participating entity types as a foreign key att