Glossary of Terms

Database Administrator

Keyword Definition
Data Backup The process of creating copies of data and storing them in a separate location for disaster recovery purposes or as a precaution against data loss.
Data Integrity The accuracy, consistency, and reliability of data stored in a database, typically maintained through the use of integrity constraints and validation rules.
Data Migration The process of transferring data from one database system or storage system to another.
Data Recovery The process of retrieving or restoring data that has been lost, damaged, or accidentally deleted from a database, usually through the use of backup copies.
Database Administrator A person responsible for managing and maintaining a database system, including designing, implementing, and optimizing the database structure and ensuring data security and integrity.
Database Design The process of planning and creating a database structure that meets the requirements of the organization, including determining tables, relationships, and constraints.
Database Management System A software application or system that allows for the management and organization of databases, including handling data storage, retrieval, and manipulation.
Database Performance Tuning The process of optimizing a database system to improve its efficiency, response time, and overall performance by adjusting various parameters and configurations.
Database Security The practice of implementing measures and protocols to protect the database system from unauthorized access, data breaches, and other security threats.
SQL Structured Query Language, a standard programming language used for managing and manipulating relational databases.