Chapter 1 DBMS

Database

A collection of inter-related data organized for efficient retrieval, insertion, and deletion.

Database Management System (DBMS)

Software designed to manage databases efficiently, providing an interface for various operations.

Data Redundancy

The presence of duplicate data in a database, which DBMS aims to eliminate.

Data Integrity

Ensures data correctness and consistency within the database.

ACID Properties

A set of properties (Atomicity, Consistency, Isolation, Durability) that ensure reliable transaction processing in a DBMS.

File Processing System

A method of organizing and storing files on a storage medium, often leading to inefficiencies.

Data Independence

The ability to modify the schema at one level of a database system without affecting the next higher level.

Logical Data Independence

The ability to change the conceptual schema without affecting the external schema or user views.

Physical Data Independence

The ability to change the internal schema without altering the conceptual schema.

Client-Server Architecture

A model connecting multiple PCs and workstations via a network, where the database server provides services to clients.

1-Tier Architecture

A database architecture where users interact directly with the DBMS without additional layers.

2-Tier Architecture

A client-server model where applications on the client side interact directly with the database on the server side.

3-Tier Architecture

An architecture with a middle layer between the client and server, enhancing security and scalability.

Database Administrator (DBA)

The individual responsible for managing database access, security, and performance.

Naive Users

Unsophisticated users who rely on pre-built database applications without DBMS knowledge.

Sophisticated Users

Users familiar with databases who write SQL queries to interact with the database.

Database Designers

Individuals who create the structure of the database, including tables and relationships.

Application Programmers

Developers who write code for users to interact with the database using various programming languages.

Specialized Users

Users who write advanced database applications requiring specialized handling beyond traditional tasks.

Backup and Recovery

Processes managed by the DBA to ensure data is not lost during system failures.