CSIT115 Data Management and Security - Data Integrity

These flashcards encompass key terms and definitions related to data integrity in database management.

Data Integrity

Refers to the overall completeness, accuracy, and consistency of data over its entire life-cycle.

Consistency Constraints

Conditions that must be satisfied by every persistent state of a database.

ROLLBACK Statement

Allows for the immediate reversals of recent modifications in a database.

COMMIT Statement

Makes all modifications performed since the beginning of a session permanent in a database.

Primary Key Constraint

A constraint that uniquely identifies each record in a database table.

Foreign Key Constraint

A constraint that creates a relationship between two tables in a database.

NULL Constraint

A constraint that specifies whether a column can hold null values.

Stored Procedure

A piece of code stored in the database that can be executed as a single unit.

Trigger

A database object that is automatically invoked when certain events occur on a specified table.

Logical Backup

Saves information in the form of logical database structure and content.

Physical Backup

Raw copies of the directories and files that store database contents.

AUTOCOMMIT

A system variable that controls whether database modifications are automatically committed.

mysqldump

A utility for creating backups of databases in MySQL.

Referential Integrity

A property that ensures that relationships between tables remain valid.

Data Corruption

A form of data loss that data integrity techniques aim to prevent.

What are shared routines in programming?

Shared routines, also known as functions and procedures, are reusable blocks of code that perform specific tasks and can be called upon multiple times throughout a program.