View over R resources - Githubissues

obiba / opal

OBiBa’s core database application for biobanks or epidemiological studies.

http://www.obiba.org/pages/products/opal/

GNU General Public License v3.0

29 stars 22 forks source link

View over R resources #3569

Open ymarcon opened 4 years ago

ymarcon commented 4 years ago

It should be possible to define a view over a R resource. This view would make use of R by assigning the resource to a R session and by retrieving, using pieces of script:

list of variables (default is column names)
list of entity IDs (ID column to be identified, nrow count)
summary statistics for each variable

Not all the resources can have a view (Opal is not meant to handle billions of rows).

These R Views could be used to export data and to be accessed by Mica.

ymarcon commented 2 years ago

TODO add an upgrade step to clear variables' summary cache (after magma math api changed).