1 / 8

Data and Database Administration

Data and Database Administration. Data Dictionary. Data Dictionary stores the information about the database, including attribute names and definitions for each table in the database. Database Administration Functions. Managing security, and privacy. Managing data integrity.

ember
Download Presentation

Data and Database Administration

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

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

More Related