What are the functions of the Database Administrator? Show Before trying to understand the functions of the database administrator, it is necessary to first learn the three different functional levels needed to maintain a database. These levels are the data administration (DA), the database administration (DBA), and database steward. What is a data administrator?
A data administration (also known as a database administration manager, data architect, or information center manager) is a high level function responsible for the overall management of data resources in an organization. In order to perform its duties, the DA must know a good deal of system analysis and programming. These are the functions of a data administrator (not to be confused with database administrator functions): 1. Data policies, procedures, standards 2. Planning- development of organization's IT strategy, enterprise model, cost/benefit model, design of database environment, and administration plan. 3. Data conflict (ownership) resolution 4. Data analysis- Define and model data requirements, business rules, operational requirements, and maintain corporate data dictionary 5. Internal marketing of DA concepts 6. Managing the data repository What is a database administrator?
Database administration is more of an operational or technical level function responsible for physical database design, security enforcement, and database performance. Tasks include maintaining the data dictionary, monitoring performance, and enforcing organizational standards and security. What is a database steward?
A database steward is an administrative function responsible for managing data quality and assuring that organizational applications meet the enterprise goals. It is a connection between IT and business units. Data quality issues include security and disaster recovery, personnel controls, physical access controls, maintenance controls, and data protection and privacy. For example, in order to increase security the database steward can have control over who can gain access to the data base by assigning a specific privileges to users. Now that you have an idea of the different responsibilities involved in maintaining a database, we can list and describe the functions of a database administrator. What are the functions of a database administrator? 1. Selection of hardware and software
2. Managing data security and privacy
How many major threats to database security can you think of? 1. Accidental loss due to human error or
software/ hardware error. 3. Managing Data Integrity
4. Data backup
5. Database recovery
If there are back up facilities, are there also journalizing, checkpoint, and recovery facilities? Yes
6. Tuning database performance
7. Improving query processing performance l l Are there any shared administration functions? Yes
These are share administration functions 1. Database design
2. Database implementation
3. Operations and maintenance
4. Growth and change
New functions 1. Data warehouse administration
Review Questions: Multiple Choice 1. A person who takes overall responsibility for data, metadata, and the policies about data use is the _______. A. Data administrator 2. The _________ has a more hands-on, physical involvement with the database than the ____________. A. Data administrator; Database administrator 3. Before- and after-images of records that have been modified by transactions are in a ____. A. database change log 4. Which is NOT one of the basic facilities for backup and recovery of a database? A. Checkpoint facility 5. Which of the following is the goal of database security? A. To protect primarily against accidental or intentional loss of data Answers: 1. A Questions: 1. List the functions of a database administrator. 1. Selection of hardware and software 2. What impact has the internet caused to the management of data security.
As a result of the internet, managing data security effectively has become more difficult because access to data has become open through the internet and corporate intranets. 3. What are five major threats to data security? 1. Accidental loss due to human error or software/ hardware error. 4. Explain the function of a recovery manager? The recovery manager is a module of the DBMS which restores the database to a correct condition when a failure occurs and which resumes processing user requests. 5. What is the difference between backward (rollback) and forward (roll forward) recovery? The rollback is the back out or undo of unwanted changes to the database. Before-images of the records that have been changed are applied to the database, and the database is returned to an earlier state. Used to reverse the changes made by transactions that have been aborted or terminated abnormally.
Roll forward is the technique that starts with an earlier copy of the database. After-images (the results of good transactions) are applied to the database, and the database is quickly moved forward to a later state. References: http://perjasa.org.my/mba/dba.html http://myphlip1.pearsoncmg.com/phlip/mplistres1.cfm?vbookid=321 http://www.mysql.com/doc/en/MySQL_Database_Administration.html What are four main responsibilities of a DBA quizlet?Maintain the structure of the database/database design. Maintain the data dictionary. Identifying new tables/relationships. Create pre-set/standard queries/reports.
What are the responsibilities of the DBA and the database designers quizlet?The responsibilities of the DBA is to control, monitor, and coordinate the database itself. The responsibility of the database designer is to focus and define the content, structure of the database.
What is the role of a database administrator DBA within a company quizlet?Database administrator (DBA) is a person/group responsible for establishing policies and procedures to control and protect a database. They work within guidelines set by data administration to control the database structure, manage data changes, and maintain DBMS programs.
What does DBA stand for quizlet?DBA stands for. database administrator. Structured Query Language (SQL) is used to (check all that apply) Create a table, Insert data, Delete data.
|