120 likes | 300 Views
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.
E N D
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