Download
data and database administration n.
Skip this Video
Loading SlideShow in 5 Seconds..
Data and Database Administration PowerPoint Presentation
Download Presentation
Data and Database Administration

Data and Database Administration

144 Views Download Presentation
Download Presentation

Data and Database Administration

- - - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript

  1. Data and Database Administration

  2. Data Dictionary • Data Dictionary stores the information about the database, including attribute names and definitions for each table in the database

  3. Database Administration Functions • Managing security, and privacy. • Managing data integrity. • Providing data backup and recovery.

  4. Data Security • Data Security: Protection of the data against accidental or intentional loss, destruction, or misuse. • Threats to Data Security • Improper data retrieval. • Loss of data integrity. • Loss of availability.

  5. Data Management Software Security Features • Authentication • Viewsor sub-schemas • Authorization rules • Encryption

  6. Authorization matrix

  7. Data Integrity • The most vital part of managing data integrity in a multi-user environment is providing concurrency control • Concurrency Control - The process of managing simultaneous operations against a database so that data integrity is maintained and the operations do not interfere with each other in a multi-user environment. • Lost Update Problem

  8. Backup and Recovery • Types of Database Failure • Aborted transactions. • Incorrect data. • System failure (database intact) • Database destruction