Projection

• Deletes attributes that are not in projection list.

• Schema of result:

  • exactly the fields in the projection list, with the same names that they had in the (only) input relation.

• Projection operator has to eliminate duplicates! (Why??)

  • Note: real systems typically don’t do duplicate elimination unless the user explicitly asks for it. (Why not?)

Previous slide

Next slide

Back to first slide

View graphic version