Fundamentals of Databases - CS301 Lecture 1

A set of vocabulary flashcards based on the lecture notes from the Fundamentals of Databases course.

DBMS

Database Management System, which contains information about an enterprise, a collection of interrelated data, and a set of programs to access that data.

Data redundancy

The unnecessary duplication of data in multiple file formats, leading to inconsistencies.

Data isolation

The situation where multiple files and formats prevent easy access to data.

Integrity constraints

Rules that ensure data integrity, such as account balance must be greater than zero.

Transaction Management

The process of ensuring that all operations in a transaction complete, maintaining the database's consistent state.

Physical Data Independence

The ability to change the physical schema without affecting the logical schema.

Data Definition Language (DDL)

Specification notation for defining the schema of a database.

Data Manipulation Language (DML)

The language used for accessing and updating the data in a database.

Declarative DML

A type of DML that specifies what data is needed without detailing how to get it.

Relational model

A database model where all data is stored in tables.

Database schema

The overall logical structure of the database, including its tables and their relationships.

Query Processor

Component that interprets and executes DDL and DML statements.

Normalization

The process of organizing data to minimize redundancy.

ACID properties

Set of properties (Atomicity, Consistency, Isolation, Durability) that ensure reliable processing of database transactions.

Client-server architecture

A model in which a server provides resources or services to multiple client applications.

Database Administrator (DBA)

A person responsible for managing and maintaining the database, including schema definition and access control.