Logical bulk operators were defined specifically for the subset of SQL used in the 17 TPC-D queries. Appendix L, gives the of all of the logical operators Model D. Here is a list of the logical operators in Model D, with their corresponding appendices:
Logical Operator Appendix GET L.1 SELECT L.2 EQJOIN L.3 PROJECT L.4 AGG_LIST L.5 ORDER_BY L.6 RM_DUPLICATES L.7 FUNC_OP L.8
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 and the computation of the output logical properties (e.g. the output cardinality and the column unique cardinalities for each attribute in the schema).
Now a few of the simple operators of Model D are discussed, and then a few operators where issues had to be resolved, or decisions had to be made in the development of the model.
| 6.1 Logical Model: | <Logical Operators> |
|---|
| 
Page 1
|