Database Administration#
Database administration focuses on the operational management of database systems so that they remain available, reliable, secure, and performant. Three core responsibilities are concurrency ontrol, security management, and backup and recovery. These functions direectly affect the quality, reliability, and safety of the data that supports organizational processes.
Concurrency#
Concurrency refers to multiple users or applications accessing and modifying the database at the same time. Without proper control, concurrent access can lead to problems such as lost updates, inconsistent reads, or deadlocks.
Database administrators (ADBs) configure transaction isolation levels (e.g. read committed, repetable read) to balance consistency and performance.
The DBMS uses locks (row-level, page-level, table-level) to prevent conflicting operations from corrupting data.
DBAs monitor and tune systems to detect and resolve deadlocks where transactions wait indefinitely for each other’s locks.
Key Point
Concurrency mechanisms allow many users to work with the database at once while preserving data integrity and reliability.
Security#
Database security protects data from unauthorized access, modification, or disclosure. It is closely related to organizational information security but focuses on controls implemented within the DBMS.
Verifying user identity (e.g. username/password, multi-factor authentication).
Defining roles and privileges that specify which tables, views, and operations (SELECT, INSERT, UPDATE, DELETE) each user may perform.
Encrypting data at rest and in transit to protect sensitive information such as personal or financial data.
Recording access and changes to deteect misuse and support compliance requirements.
Security Tip
When designing a database, define roles and privileges early. Align them with organizational policies and legal requirements (e.g. data protection regulations) to avoid exposure sensitive data.
Backup and Recovery#
Backup and recovery ensure that data can be restored after failures such as hardware crashes, software errors, or accidental deletions. This is essential for maintaining availability and minimizing data loss.
Full, incremental, and differential backups; scheduling (daily, weekly); and retention policies.
Restoring from backups, applying transaction logs, and validating restored data.
Offsite backups, replication to secondary sites, and documented recovery time objectives.
Integration with Database Quality#
Concurrency, security, and backup.recovery are not isolated tasks. Together, they determine how reliable, scalable, and secure a database system is:
Concurrency affects performance and consistency for many simultaneous users.
Security ensures that only authorized users can access or modify data, preserving confidentiality and integrity.
Backup and recovery guarantee that data remains available and can be restored after failures, supporting organizational continuity.