Table 2 Result size and number of rows of attribute queries presented in Fig. 6(b) on a database table of 300000 crystal structures.
Attribute | EAV | JSONB | ||
---|---|---|---|---|
Rows | Size (MB) | Rows | Size (MB) | |
Cell | 255,671 | 71 | 19,667 | 8 |
Kinds | 537,303 | 150 | 19,667 | 11 |
Sites | 15,352,241 | 4412 | 19,667 | 201 |