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
Project Description: This is a Customer Management project. Customer data is presented in a text file. The program can load this text data into its database columns. The data ma

Serialisable Schedules: If the processes of two transactions conflict with each other, how to verify that no concurrency related problems have happened? For this, serialisability t

#A multinational tour operator agency has gained new business growth in the North American market through the use of social media. Its operation has expanded by 50% within six mont

Illustrate the collaboration and relationship diagram A collaboration is the society of interfaces, classes and other elements which work together to provide some cooperative b

Write short notes on transaction state? A transaction may not always complete its implementation successfully such a transaction is termed aborted A transaction must be in o

Define garbage collection. Garbage may be formed also as a side effect of crashes. Periodically, it is essential to find all the garbage pages and to add them to the list of fr

Although how will the system recover The selection of REDO or UNDO for a transaction for the recovery is completed on the basis of the state of the transactions. This state is

What is a view? How it is related to data independence? A view might be thought of as a virtual table, that is, a table that does not really exist in its own right but is inste

want a idea for final year project

explain the steps for reduction of er model into relational model?