|< < 43 > >|

Translating SQL Queries into Relational Algebra

The initial plan

Create the initial plan by creating an expression using:

  • select

  • project

  • product

Note: Initial plan has product, not join.

  • Joins will be introduced by combining products and selects.

  • If the query is written using explicit joins, (e.g. select ... from R join S ...), I suspect that it is a better idea to introduce join operators immediately.

|< < 43 > >|