Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

create stored materialized procedures for invitrodb 4.2 release and downstream apis #224

Open
brown-jason opened this issue Apr 9, 2024 · 1 comment
Assignees

Comments

@brown-jason
Copy link
Collaborator

brown-jason commented Apr 9, 2024

all resulting tables should have prefix mv_ (materilized view).
mv_bioactivity - includes level 3 through 6 with one to many relationships as json
mv_bioactivity_agg - chemical level summarized bioactivity e.g. number of assays chem was tested in
mv_assay - assay source through assay component endpoint join of all assay annotation information
mv_assay_agg - agg of number chemicals tested etc.

Also create stored procedure to create/drop these tables for release so they are not sitting in invitrodb itself long term

@brown-jason brown-jason self-assigned this Apr 9, 2024
@madison-feshuk
Copy link
Collaborator

Within the mc3_param column, conc should be ordered by increasing dose and resp ordered accordingly. Currently logc does not appear ordered within the bioactivity flat view of v4.1.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants