click below
click below
Normal Size Small Size show me how
CUT6 12.6
Computers: Understanding Tech 6e 12.6
Term | Definition |
---|---|
database administration | An important IT function that involves operating and maintaining the database system. |
database administrator (DBA) | The person who handles the daily database operations, including installing and upgrading the database, ensuring rapid response times, integrating security strategies, and completing regular data backups. |
downtime | Time in which a system is unavailable. |
data corruption | A serious failure that occurs when data is unreadable, incomplete, or damaged. |
backup and recovery plan | A plan developed by a database administrator to ensure frequent data backups. It enables the administrator to recover the data in the event of a data loss. |
database response time | The lag time between a user issuing a command and the database system taking action. |
record locking | A situation that occurs when multiple users attempt to edit an existing record, automatically preventing changes to be written to the database as a safety precaution. The DBMS only allows one user at a time to alter a record. |
data integrity | A term that describes the accuracy of the information provided to database users. Sometimes called data quality. |
redundancy | The duplication of one or more fields of data in multiple tables. |
normalization | The process of structuring a database to avoid redundancy (duplication of entries) and undesirable dependencies (relationships between entries). |
data contamination | A ripple effect caused by an error in the system. It involves the spread of incorrect information and can have serious consequences. |
data validation | Techniques that ensure that users enter correct and complete data into the system. |
referential integrity | Involves making sure that the records entered into tables remain consistent with the relationships between the tables. |
range check | A simple error-checking system usually performed on numeric data entries. |
alphanumeric check | A data validation check that allows only letters of the alphabet and digits to be entered. |
consistency check | A data validation check made against previously entered data that has already been validated. |
completeness check | A data validation check that ensures that every required field in a record contains an entry. |