nih-cfde / cfde-deriva

Collaboration point for miscellaneous CFDE-deriva scripts
Other
2 stars 3 forks source link

Array ops #369

Closed karlcz closed 2 years ago

karlcz commented 2 years ago

Revise indexing hints on the fact tables to enable a new ermrest feature for "GIN" indexing of integer array columns.

This is the foundation for future benchmarking and optimization experiments, to try to compute faster matches and/or counts. We will try to map faceted query criteria to equivalent array intersection matches on these integer array columns.