INFS2200/INFS7903 Relational Database Systems Week 12: Database Administration

These flashcards cover key vocabulary terms related to database administration as discussed in the lecture notes.

Database Administrator (DBA)

A professional responsible for managing all aspects of a database, ensuring performance, security, and recovery.

DBMS

Database Management System; software that provides and controls access to databases, supporting multiple users.

Backup and Recovery

Strategy to manage the duplication of data to prevent loss and restore databases after failures.

Disk Space Management

The process of organizing, allocating, and managing disk space for a database.

Performance Tuning

The activities conducted to optimize the performance of a database system.

SQL

Structured Query Language; a standard programming language used for managing and manipulating databases.

Concurrency Control

Methods used to manage simultaneous operations without conflicting, ensuring database integrity.

Control File

File containing information needed to maintain and verify database integrity and structure.

Redo Log Files

Files that store information for recovering committed data changes in a database.

Data Dictionary

Metadata that describes the structure of the database, including tables, fields, and relationships.

Transaction

An individual operation or series of operations performed as a single logical unit of work in a database.

Sessions

Specific connections established between a user process and a database server.

Availability

The capability of a database to remain operational and accessible, ensuring no downtime.

Replication

The process of copying and maintaining database objects in multiple locations.

Client/Server Architecture

A model where client applications request resources and services from centralized server systems.

Fault Tolerance

The ability of a system to continue functioning in the event of a failure of one or more components.

Hot Standby

Standby database that is kept in sync with the primary database for instant recovery.

Data Files

Files that store actual database data and are essential for the functioning of the database.

Index Files

Files that optimize the speed of data retrieval operations on a database.

User Profiles

Information outlining user permissions and roles within the database system.