Design the Cassandra database schema for variants

LinkageIO / HapDab

Not your parents' haplotype database

MIT License

1 stars 1 forks source link

Design the Cassandra database schema for variants #30

Open schae234 opened 6 years ago

schae234 commented 6 years ago

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 commented 6 years ago

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]