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. • Providing data backup and recovery.
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.
Data Management Software Security Features • Authentication • Viewsor sub-schemas • Authorization rules • Encryption
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
Backup and Recovery • Types of Database Failure • Aborted transactions. • Incorrect data. • System failure (database intact) • Database destruction