Relational Algebra

 

Relational Algebra in DBMS

Relational Algebra is a procedural query language used in a Database Management System (DBMS) to perform operations on relational databases. It forms the theoretical foundation of relational database systems. Relational Algebra operates on tables (relations) and produces new tables as results. It provides a set of operations that help users retrieve and manipulate data stored in relational databases. Modern database systems such as MySQL, Oracle Database, Microsoft SQL Server, and PostgreSQL are based on relational algebra concepts.

Relational Algebra is called procedural because it specifies what operation to perform and how to perform it to get the desired result. Each operation takes one or more relations as input and produces a new relation as output. This property is known as closure property, meaning the result of an operation is always another relation.

🔹 Basic Operations in Relational Algebra

The basic operations are fundamental operations used to retrieve and manipulate data.

1️⃣ Selection

Selection is used to choose rows from a relation based on a specific condition. It filters records according to given criteria.

2️⃣ Projection

Projection is used to select specific columns from a table. It reduces the number of attributes in the result.

3️⃣ Union

Union combines the results of two relations and removes duplicate rows. Both relations must have the same structure.

4️⃣ Set Difference

Set difference returns the rows that are present in one relation but not in the other.

5️⃣ Cartesian Product

Cartesian product combines all rows of one relation with all rows of another relation.

6️⃣ Rename

Rename is used to change the name of a relation or its attributes for clarity or convenience.

🔹 Additional (Derived) Operations

These operations are derived from basic operations.

1️⃣ Join

Join combines related tuples from two relations based on a common attribute. It is widely used to retrieve related data from multiple tables.

2️⃣ Intersection

Intersection returns only the common rows between two relations.

3️⃣ Division

Division is used when we want to find records that are associated with all values in another relation.

🔹 Features of Relational Algebra

  • It is a procedural language

  • Operates on relations (tables)

  • Produces relations as output

  • Based on mathematical set theory

  • Foundation of SQL queries

🔹 Importance of Relational Algebra

Relational Algebra is important because it provides a formal foundation for relational databases. It helps in understanding how database queries work internally. Database query optimizers use relational algebra concepts to execute queries efficiently. It also helps students and developers understand the logic behind SQL operations.

Click here

Comments

Post a Comment

Popular posts from this blog

Syllabus

Velammal College of Engineering and Technology, Madurai – 625 009 Department of Computer Science and Engineering Syllabus Course Code-Title 21CS206 – DATABASE MANAGEMENT SYSTEMS Course Component Professional Core Contact Hours Lecture Tutorial Practical Total Hours Credit 3 0 0 45 3 Course Assessment methods  Continuous Semester-end assessment Internal Assessment Tests and Assignments End semester exam, Student Course exit survey Prerequisite Courses Working Knowledge on Computers Data structures Course Objective To explain the fundamentals of data models and to represent a database system. To describe the internal storage structures using different file and indexing techniques which will help in physical DB design. To illustrate the fundamental concepts of transaction processing- concurrency control techniques and recovery procedures. To demonstrate Storage and Query processing Techniques. To develop a solutions to the real time problems using NoSQL. TOPICS TO BE COVERED UNIT I - ...
Read more

SQL COMMANDS

    What is SQL? SQL (Structured Query Language) is a standard language used to manage and manipulate relational databases. It is used in database systems like: MySQL PostgreSQL Oracle Database Microsoft SQL Server SQL allows users to create databases, insert data, update records, retrieve information, and control access. 🔹 Types of SQL Commands SQL commands are divided into five main categories: DDL – Data Definition Language DML – Data Manipulation Language DQL – Data Query Language DCL – Data Control Language TCL – Transaction Control Language 🔹 1. DDL (Data Definition Language) DDL commands are used to define and manage the structure of database objects like tables. ✅ CREATE Used to create new databases, tables, views, or other database objects. ✅ DROP Used to permanently delete database objects such as tables or databases. ✅ ALTER Used to modify the structure of an existing table (add, delete, or modify columns). ✅ TRUNCATE...
Read more