FunctionsofaDatabaseManagementSystem.pptVIP

Functions of a Database Management System Functions of a DBMSC.J. Date Indexing Views Security Integrity Concurrency Backup/Recovery Design Documentation Update/Query Views Custom representations of a database that correspond to the needs of a class of users. Stored SELECT statements. Views Views Provide: representations of data for different users to protect data quality insulate users from changes in structure CREATE VIEW VIEWNAME {VIEW ATTRIBUTES} AS (SELECT ..WHERE ..) Views Views Permit Maintaining a constant user interface Restricting access to specified attributes Specifying user rights Views3 Schema Architecture Security Components that limit access or actions to limit potential damage to data. Security Limit data access to properly authorized users or programs. Protect data against accidental or intentional damage. Deter Detect Minimize Recover Investigate Security Approaches Views limit access and actions Authorization Rules identify users and restrict actions User Defined Procedures in addition to database security functions Encryption encode stored data Authentication positively identify users Authorization Rules Authorization Rules Some DBMS products authorize actions based on specific records and functional descriptions. However, most DBMS’s limit actions on tables to one of: Read: view but not change Insert: read and add records Update: read, insert and change records Alter/Delete: read, insert, update and delete records, change table structure User Defined Procedures Code modules that enforce security procedures are run during processing Integrity Components that preserve the relationship among different related records in the database Integrity The relationship among records in the database Referential Integrity Non Key Integrity Derived Conditions Constraints in SQL CREATE TABLE … or ALTER TABLE … ADD CHECK(condition) PRIMARY KEY attribute-name FOREIGN KEY attribute-name REFERENCES parent-table The parent table must alrea