DATABASES

These flashcards cover key vocabulary terms and definitions related to databases, aiding in the understanding of fundamental concepts in database management systems.

Database

A collection of data and information organized for easy access, management, and updates.

DBMS (Database Management System)

A set of software programs that control the organization, storage, management, and retrieval of data in a database.

RDBMS (Relational Database Management System)

A type of DBMS that organizes data into related tables.

ACID properties

A set of properties (Atomicity, Consistency, Isolation, Durability) that ensure reliable transactions in a database.

Data integrity

The accuracy and consistency of data in a database.

Data validation

The process of ensuring that the data entered into a database is accurate and meets certain criteria.

Data verification

The process of checking that data corresponds to an original source.

Schema

The logical structure of a database, which includes the tables, fields, and relationships.

Redundant data

Data that is duplicated in multiple places, often leading to data inconsistency.

Referential integrity

A property of a database that ensures relationships between tables remain consistent.

Transaction

A single logical operation that interacts with a database, which can include operations such as updating or retrieving data.

Concurrency

The ability of the database to allow multiple users to access and modify data at the same time.

Normalization

The process of organizing a database to reduce redundancy and improve data integrity.

Entity-relationship diagram (ERD)

A visual representation of the entities within a database and their relationships to one another.

Simple query

A query that retrieves data using one parameter value.

Complex query

A query requiring multiple parameter values, often involving Boolean operators.

Data mining

The process of analyzing data from different perspectives and summarizing it into useful information.

Data matching

The process of comparing records from different databases to identify similarities and differences.