Module 4.2
Database Management
Managing and protecting data
Validation Data meets a set of requirements – ‘F’ or ‘M’
Verification Correctness – ‘F’ or ‘M’
Integrity Overall completeness, accuracy and consistency of data
Access control Good password policies
User rights and privileges
Physically secured
Logging changes Keep track of who and when they made changes
Parallel data sets Keeping multiple copies of data
Warehousing Takes records, modifies them and stores them on separate database
optimized for ‘mining’
Database management
Database Administrator
Designing database
Security
Back up plans
Monitoring performance
General maintenance
Programmers
Develop software withing the rules set by the DBA
Multiple programs use the same database
Database Management
Managing and protecting data
Validation Data meets a set of requirements – ‘F’ or ‘M’
Verification Correctness – ‘F’ or ‘M’
Integrity Overall completeness, accuracy and consistency of data
Access control Good password policies
User rights and privileges
Physically secured
Logging changes Keep track of who and when they made changes
Parallel data sets Keeping multiple copies of data
Warehousing Takes records, modifies them and stores them on separate database
optimized for ‘mining’
Database management
Database Administrator
Designing database
Security
Back up plans
Monitoring performance
General maintenance
Programmers
Develop software withing the rules set by the DBA
Multiple programs use the same database
