Threats and solutions
Corrupted data
What is data corruption?
- refers to errors in computer data that occur during writing, reading, storage or
processing which introduce unintended changes to the original data
cause explanation solution explanation
Hard drive Failure of hard drive that RAID - RAID provides one or
failure stores the data would Backup more hard drives in case
result in complete loss of of HD failure
the data or data - use a backup to recover
corruption a previous version of data
Human Data can be deleted or Minimise user - only few people can edit
error incorrectly updated editing - rejects any data that
privileges doesn’t comply with the
Data validation rules
validation
Power Computer suddenly UPS - UPS protects the
outages shuts down results in Redundant computer so the system
and power loss of data or corruption power supply can shut down correctly
problems - RPS will provide full
power to any device
without down time, if
power fails
malware Viruses, trojan horses Firewall - firewall prevents
and ransomware Anti-malware malware from entering a
computer or network
- anti-malware detects
and removed malware
SQL Running malicious SQL Data - validate user inputs
injection
queries to gain access to validation - use GUI components
confidential data or GUI that restrict data
corrupt tables components
Outdated data
Current data – is up to data and not outdated
Keeping data up to data in databases
- adding new records
- changing existing records: updating
- deleting records no longer needed
Invalid data
check Description
Presence The data must exist
Range The data has a lower and upper bound
Uniqueness No duplicates exist
Length Data must be a specific length
Type Data must be appropriate type
Format Data requires a specific entry format
Logical Data is consistent with scenario
Check digit Data is a digit
Corrupted data
What is data corruption?
- refers to errors in computer data that occur during writing, reading, storage or
processing which introduce unintended changes to the original data
cause explanation solution explanation
Hard drive Failure of hard drive that RAID - RAID provides one or
failure stores the data would Backup more hard drives in case
result in complete loss of of HD failure
the data or data - use a backup to recover
corruption a previous version of data
Human Data can be deleted or Minimise user - only few people can edit
error incorrectly updated editing - rejects any data that
privileges doesn’t comply with the
Data validation rules
validation
Power Computer suddenly UPS - UPS protects the
outages shuts down results in Redundant computer so the system
and power loss of data or corruption power supply can shut down correctly
problems - RPS will provide full
power to any device
without down time, if
power fails
malware Viruses, trojan horses Firewall - firewall prevents
and ransomware Anti-malware malware from entering a
computer or network
- anti-malware detects
and removed malware
SQL Running malicious SQL Data - validate user inputs
injection
queries to gain access to validation - use GUI components
confidential data or GUI that restrict data
corrupt tables components
Outdated data
Current data – is up to data and not outdated
Keeping data up to data in databases
- adding new records
- changing existing records: updating
- deleting records no longer needed
Invalid data
check Description
Presence The data must exist
Range The data has a lower and upper bound
Uniqueness No duplicates exist
Length Data must be a specific length
Type Data must be appropriate type
Format Data requires a specific entry format
Logical Data is consistent with scenario
Check digit Data is a digit
