Functions of a database administrator

• Keep up with current technological trends
• Predict future changes
• Emphasis on
  established off the shelf products

• Protection of data against accidental or
  intentional loss, destruction, or misuse
• Firewalls
• Establishment of user
  privileges
• Complicated by use of
  distributed systems such as internet access and client/ server technology.
  

• Integrity controls protects data from
  unauthorized use
• Data consistency
• Maintaining data
  relationship
• Domains- sets
  allowable values
• Assertions- enforce
  database conditions

• We must assume that a
  database will eventually fail
• Establishment
  procedures
• how often should the
  data be back-up?
• what data should be
  backed up more frequently?
• who is responsible
  for the backups?
• Back up facilities
• automatic dump-
  facility that produces backup copy of the entire database
• periodic backup- done
  on periodic basis such as nightly or weekly
• cold backup- database
  is shut down during backup
• hot backup- a
  selected portion of the database is shut down and backed up at a given
  time
• backups stored in a
  secure, off-site location

• Application of proven strategies for
  reinstallation of database after crash
• Recovery facilities
  include backup, journalizing, checkpoint, and recovery manager

• Set installation
  parameters/ upgrade DBMS
• Monitor memory and CPU
  usage
• Input/ output
  contention
• user striping
• distribution of
  heavily accessed files

7.
Improving query processing performance