Chapter :- 3 (English)

4. Relational Algebra

Relational Algebra

Relational Algebra is a procedural query language used in relational database theory. It operates on relations (tables) and uses a set of operations to produce new relations as output. It forms the mathematical foundation for SQL and query processing in DBMS.

 

Basic Relational Algebra Operations

Operation	Symbol	Description
Selection	σ	Selects rows based on a condition
Projection	π	Selects specific columns
Union	∪	Combines tuples from two relations
Set Difference	−	Returns tuples in the first relation but not in the second
Cartesian Product	×	Combines all tuples from two relations
Rename	ρ	Renames relation or attributes
Join operations	⋈	Combines related tuples from two relations

 

Advantages of DBMS

✔ 1. Data Redundancy Control

Minimizes duplication of data through normalization and centralized storage.

✔ 2. Data Consistency

Because redundancy is reduced, the chances of inconsistent data are also minimized.

✔ 3. Improved Data Security

DBMS provides:

·       Authentication

·       Authorization

·       Access control

to protect sensitive data.

✔ 4. Data Independence

Changes in data structure do not affect application programs.

✔ 5. Efficient Data Access

Indexing, query optimization, and concurrency control improve performance.

✔ 6. Backup and Recovery

Automatic backup and recovery ensure data is protected from failures.

✔ 7. Multi-User Access

Supports concurrent access with proper isolation and locking mechanisms.

✔ 8. Centralized Management

Allows centralized control over data and policies.

 

Disadvantages of DBMS

 1. High Cost

DBMS software, hardware requirements, and trained personnel can be expensive.

 2. Complexity

Requires specialized knowledge to design, manage, and maintain.

3. High Resource Usage

DBMS consumes significant memory, storage, and CPU resources.

 4. Performance Overhead

For small applications, DBMS may slow things down due to:

·       Communication overhead

·       Security checks

·       Concurrency controls

 5. Risk of System Failure

If the central DBMS fails, the entire system may stop functioning until recovery.