Database Security: Importance, Integrity and Availability, the Role of a Database Administrator

 

Welcome to class! 

In today’s class, we will be talking about database security: importance, integrity and availability, the role of a database administrator. Enjoy the class!

Importance of Data Security

IMPORTANCE OF DATA SECURITY | classnotes.ng

Data security is critical for most business and even home computer users. Client information, payment information, personal files, bank account details- all this information can be hard to replace and potentially dangerous if it falls into the wrong hands. Data lost due to disaster such as a flood of fire is crushing, but losing it to hackers or a malware infection can have much greater consequences.

Major threats to data security

  1. An accident can happen due to human error or software/hardware error.
  2. Hackers could steal vital information and fraud can easily be perpetrated.
  3. Loss of data integrity.
  4. Improper data access to personal or confidential data.
  5. Loss of data availability through sabotage, a virus, or a worm.

Integrity control

  • Backups:

It is the process of copying and archiving of computer data so it may be used to restore the original after a data loss event.

Backups have two distinct purposes. The primary purpose is to recover data after its loss, be it by data deletion or corruption. The secondary purpose of backups is to recover data from an earlier time, according to a user-defined data retention policy, typically configured within a backup application for how long copies of data are required. Backup is just one of the disaster recovery plans.

  • Application security:

Application security is the use of software, hardware and procedural methods to protect an application from external threats.

The role of database administrator in data security

A database administrator (DB) is a person responsible for the installation, configuration, upgrade, administration, monitoring and maintenance of databases in an organization. The role includes the development and design of database strategies, system monitoring and improving database performance and capacity, and planning for future expansion requirements. They may also plan, co-ordinate and implement security measures to safeguard the database.

A database administrator’s responsibilities can include the following tasks:

  1. Installing and upgrading the database server and application tools.
  2. Allocating system storage and planning future storage requirements for the database system
  3. Modifying the database structure, as necessary, from information given by application developers.
  4. Enrolling users and maintaining system security.
  5. Ensuring compliance with database vendor license agreement.
  6. Controlling and monitoring user access to the database.
  7. Monitoring and optimizing the performance of the database.
  8. Planning for backup and recovery of database information.
  9. Maintaining archive data.
  10. Backing and restoring databases.
  11. Contacting database vendor for technical support.
  12. Generating various reports by querying database as per need.
General evaluation
  1. Define the roles of a database administrator in data security
  2. Define backup and list its importance in data security

Reading assignment

Understanding Data Processing for Senior Secondary Schools by Dinehin Victoria Pages 255 – 260

Weekend assignment

  1. …………….is the practice of keeping data protected from corruption and unauthorized access. (a) Data measurement (b) Data security  (c) Data protection (d) Data control
  2. Which of these is not a type of security control ……? (a) access control (b) auditing (c) encryption(d) storage
  3. .………….. security mechanism uses mathematical schemes and algorithm to scramble data into unreadable text. (a) Encryption (b) Auditing (c) Authentication (d) Auditing
  4. .…………. is the process of copying and archiving data so it may be used to restore original after a data loss (a) Backup (b) Restore (c) Control (d) Saving
  5. …..……… is the computer professional responsible for the configuration, administration and maintenance of a database (a) Programmer (b) System administrator (c) Database administrator (d) System analyst

Theory

  1. Explain two types of data security control.
  2. Mention five (5) duties of a database administrator.

 

In our next class, we will be talking about Crash Recovery: Introduction to ARIES, other Recovery Related Data Structure.  We hope you enjoyed the class.

Should you have any further question, feel free to ask in the comment section below and trust us to respond as soon as possible.

For more class notes, homework help, exam practice, download our App HERE

Join ClassNotes.ng Telegram Community for exclusive content and support HERE

Leave a Reply

Your email address will not be published. Required fields are marked *

Don`t copy text!