Categories
  Encyclosphere.org ENCYCLOREADER
  supported by EncyclosphereKSF

Rename (relational algebra)

From Wikipedia - Reading time: 2 min

In relational algebra, a rename is a unary operation written as where:

The result is identical to R except that the b attribute in all tuples is renamed to a.[1] For an example, consider the following invocation of ρ on an Employee relation and the result of that invocation:

Name EmployeeId
Harry 3415
Sally 2241
EmployeeName EmployeeId
Harry 3415
Sally 2241

Formally, the semantics of the rename operator is defined as follows:

where is defined as the tuple t, with the b attribute renamed to a, so that:

References

[edit]
  1. ^ Introduction to Database Systems. Pearson Education India. 2010. pp. 103–105. ISBN 978-81-317-3192-5.

Licensed under CC BY-SA 3.0 | Source: https://en.wikipedia.org/wiki/Rename_(relational_algebra)
14 views | Status: cached on November 12 2024 23:31:15
Download as ZWI file
Encyclosphere.org EncycloReader is supported by the EncyclosphereKSF