MGAD30H3 Chapter Notes - Chapter 4: Data Corruption, Concurrency Control, Encryption
Document Summary
Chapter 4 security part ii auditing. Operational problems re flat-file approach to data management. Operational features and risk with centralized, partitioned, and replicated database models in a ddp. Storage: costs more money to store same data. Updating: instead of updating one, may need to update multiple. Currency: one user may have outdated information. Task-data dependency: people will need additional info if their needs. Database approach change: resources are controlled by database management system (dbms) Knows which data elements each user is allowed access. Users sends request for data, dbms validates authorization. Database management system: 4 key objectives: program development, backup and recovery, database usage reporting (audit trail), database access (granting access) Physical arrangement of records, linkage between files, structure of data records, sequence: conceptual view. Database logically and abstractly: external view. The portion that a user is authorized to access.