Please enable JavaScript.
Coggle requires JavaScript to display documents.
Lecture 9: DATABASE AND DATA CENTER - Coggle Diagram
Lecture 9: DATABASE AND DATA CENTER
Database
Collection of information organized and used on computers
Database components – software, hardware, data, procedures, database access language
Common database vendors - Oracle, IBM, MySQL, Sybase, Microsoft
Locking the Database
Course level – database is locked during updates
Moderate level – locked at table level
Fine level – locked at record/field level
Auditing a Database
Database permission
Operating system security
Password strength and management
Activity monitoring
Database encryption
Database vulnerability
Data Center
Major Threats
Natural – flood, earthquakes, fire
Man-made – terrorist, riot, theft, sabotage
Environmental hazard – temperature, humidity
Environmental hazard – temperature, humidity
Continuity Concerns
Slow Company - Perform full backup each week
Medium Company - Daily incremental backups, weekly full backups
Fast Company - Hourly incremental backups, daily full backup
Operation Controls
Facility and site resiliency - power, heating, ventilation, air-conditioning
Physical access control - alarm systems, facility monitoring
Personnel - roles and responsibilities, segregation of duties
Disaster Recovery Plan
IT managers and auditors should plan for what, who, when, where, how, which and why
Plan to shift to one or more alternate company locations
Establish contractual relationships with third-party providers of alternate computing sites
Alternate Computing Sites - Cold Site, Warm Site, and Hot Site