中文网站
  Advanced Search
Read the latest Blogs from IT professionals in the field. Read and write community created documents. Need IT help? Ask our staff. Connect with your peers. Check our Tech Shop for posters, books and software tools. Home

3.2 Database Systems: The Relational Algebra

1. The relational algebra is a procedural query language.

  • Six fundamental operations:
    - select (unary)
    - project (unary)
    - rename (unary)
    - cartesian product (binary)
    - union (binary)
    - set-di erence (binary)
  • Several other operations, de ned in terms of the fundamental operations:
    - set-intersection
    - natural join
    - division
    - assignment
  • Operations produce a new relation as a result.