Rename (relational algebra)

From formulasearchengine
Jump to navigation Jump to search

{{ safesubst:#invoke:Unsubst||$N=Unreferenced |date=__DATE__ |$B= {{#invoke:Message box|ambox}} }} In relational algebra, a rename is a unary operation written as where:

The result is identical to except that the attribute in all tuples is renamed to . For an example, consider the following invocation of on an 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 with the attribute renamed to so that: