Table 5.
Q-error, MAE, and SMAPE of different cardinality estimators with the DMV dataset.
| Method | Q-Error | MAE | SMAPE |
|---|---|---|---|
| PostgreSQL | 1 × | / | / |
| MySQL | 1 × | / | / |
| TreeRNN | 1.71 | 1526 | 0.40 |
| VSCNN | 3.01 | 2593 | 0.55 |
| MSCN (string) | 2.96 | 2418 | 0.43 |
| NoSamplingTreeLSTM | 8.90 | 4374 | 0.86 |
| NoSamplingTreeLSTM | 2.36 | 2106 | 0.33 |
| TreeLSTM (ours) | 1.49 | 923 | 0.36 |