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
Data Base Management System 1. Draw the Architecture of MySQL and explain about its subsystems briefly. 2. Elaborate with the help of an example the concept of Primary key a

coventions for displaying an ER schema as ER diagram

Index And Tree Structure Let us talk about the data structure that is used for creating indexes. Can we use Binary Search Tree (BST) as Indexes? Let us initial reconsider

#ques Define a job scheduling strategy that will meet business requirement of reporting availability by 6am CST for the following cubes? Show the job scheduling dependencies in a p

Single Valued Normalisation  Codd in the year 1972 formed three normal forms (1NF, 2NF, and 3NF). These were based on functional dependencies between the attributes of a relati

Question: (a) List four disadvantages of the File Processing System as compared to the Database Systems. (b) The integrity of a database is enforced by integrity rules. One

What is meant by object identifiers? Object-oriented systems use an object identifier to recognize objects. Object identifiers are unique: that is every object has a single ide

What is object identity? An object retains its identity even if some or all the values of variables or explanations of methods change overtime.

Primary index A primary index is a file that has a sorted series of records having two columns: a block address for that key field in the data file; and the ordering key field.

Probelm: a) In the context of OODBMS, define the following terms with appropriate examples. (i) Object class. (ii) Abstract class. (iii) Aggregation. (iv)