| Backup |
The process of creating copies of data to ensure its availability in case of data loss or corruption. |
| Data Integrity |
The accuracy, consistency, and reliability of data stored in a database, ensuring it is valid and trustworthy. |
| Data Redundancy |
The storage of the same data in multiple places within a database, which can lead to inconsistency and inefficiency. |
| Data Warehousing |
The process of collecting and managing data from various sources for business intelligence and analysis purposes. |
| Database Administrator |
A professional responsible for managing and maintaining a database system. |
| Database Management Systems |
A software system that manages databases and allows users to access and manipulate data. |
| Database Security |
The protection of electronic databases from unauthorized access, use, disclosure, disruption, modification, or destruction. |
| Database Storage Engine |
A software program or module that is responsible for managing how data is stored, organized, and accessed in a database. |
| Index |
A data structure that improves the speed of data retrieval operations in a database. |
| Indexing |
The technique of creating data structures, called indexes, to improve the speed of data retrieval operations in a database. |
| Normalization |
The process of organizing data in a database to eliminate redundancy and improve efficiency. |
| Query |
A request for data from a database using a specific set of criteria. |
| Query Optimization |
The process of selecting the most efficient execution plan for a query in a database management system. |
| Relational Database |
A type of database that organizes data into tables with predefined relationships between them. |
| SQL |
Structured Query Language, a programming language used to manage and manipulate databases. |
| Sqlite |
A lightweight relational database management system (RDBMS) that uses its own storage engine and is contained in a single disk file without a separate server process. |
| Transaction |
An atomic set of database operations that must be executed as a whole, ensuring data consistency. |
