Relational Algebra

最新推荐文章于 2023-11-25 00:50:02 发布

再见小小ronnie

最新推荐文章于 2023-11-25 00:50:02 发布

阅读量440

点赞数

分类专栏： Database

本文链接：https://blog.csdn.net/u011094114/article/details/52614817

版权

Database 专栏收录该内容

1 篇文章 0 订阅

订阅专栏

本文详细介绍了关系数据库中的基本操作，包括限制（Restrict）、投影（Project）、乘积（Product）、并集（Union）、交集（Intersect）、差集（Difference）、连接（Join）及除法（Divide）。这些操作对于理解和实施数据库查询至关重要。

摘要由CSDN通过智能技术生成

The original operators

Restrict: returns a relation containing all tuples from a specified relation that satisfy a specified condition.

Project: returns a relation containing all (sub)tuples that remain in a specified relation after specified attributes have been removed.

Product: returns relation containing all possible tuples that are a combination of two tuples, one from each of two specified relations.

Union: return a relation containing all tuples that appear in either or both of two specified relations.

Intersect: returns a relation containing all tuples that appear in both of two specified relations.

Difference: returns a relation containing all tuples that appear in the first and not the second of two specified relations.

Join: return a relation containing all possible tuples that are a combination of two tuples, one from each of two specified relations, such that the two tuples contributing to any given combination have a common value for the common attributes of the two relations.

Divide: Takes two unary relations and one binary relation and returns a relation containing all tuples from on unary relation that appear in the binary relation matched with all tuples in the other tuples in the other unary relation.