The logical model
defines the semantics of the database model
and the operators used in the logical algebra
used (in the optimizer) to describe all of the queries
the user could write.
The semantics of the logical model include logical properties
which are described in section 6.3.
Logical bulk operators
specifically for the subset of SQL
used in the 17 TPC-D queries.
of all of the logical operators Model D.
is a list
of the logical operators
in Model D,
with their corresponding appendices:
The appendices for each logical operator includes a figure
showing how the logical operator is used.
Below the figures
for each logical operator
in appendix L
is an example use of the logical operator
of the output logical properties
and the column unique cardinalities
for each attribute in the schema).
a few of the simple operators of Model D
a few operators
had to be resolved,
had to be made
in the development of the model.