The semantics of the logical model include logical properties which are described in section 6.3. Logical bulk operators were defined specifically for the subset of SQL used in the 17 TPC-D queries. The appendices for each logical operator includes a figure showing how the logical operator is used. The only logical operator to get a table from disk is the GET operator, which was discussed in section 3. Many logical operators come straight out of relational algebra.
Examples are the relational algebra select and project operators.
The only logical operator modeled with more than one table as input is join. Strictly speaking, this makes natural join inapplicable since it joins on columns with the same name. It was unnecessary for handling the TPC-D queries to have outerjoins, semijoins or antijoins. Adding additional types of joins has some disadvantages however. Outerjoin, for example, is not fully commutable with other types of joins.