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.

Sign up for GitHub

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

Jump to bottom

Design the Cassandra database schema for variants #30

Open
schae234 opened this issue Feb 8, 2018 · 1 comment
Open

Design the Cassandra database schema for variants #30

schae234 opened this issue Feb 8, 2018 · 1 comment
Assignees
@schae234
Milestone
First Sprint

Comments

@schae234
Copy link
Member

schae234 commented Feb 8, 2018

I need to know if the philosophy behind the Cassandra schema differs from the one we used for SQLite. I know that Cassandra believes in denormalization so we might be sacrificing efficiency for space (which might have sped up SQLite in the first place)
@schae234 schae234 added this to the First Sprint milestone Feb 8, 2018
@schae234 schae234 self-assigned this Feb 8, 2018
@schae234
Copy link
Member Author

schae234 commented Mar 5, 2018

Query Planning

  • Q1*. Find all chromosome names (from locuspocus)
  • Q2*. Find all SNPs on Chip (from locuspocus)
  • Q3*. Find all individual names (from minus80)
  • Q4. Find the dosage for all SNPs on chrXXX for [individuals]

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@schae234 schae234

Labels
None yet
Projects
None yet
Milestone
First Sprint
Development

No branches or pull requests
1 participant
@schae234