Wires_Guy_wires
Imperial Masterpiece
I've worked with a couple of the worlds finest geneticists. Half of my time was spent on figuring out and fixing databases. One third was spent on figuring out where the hell the samples were and how they were(n't) organized, the rest of the time I spent re-organising and doing actual work.What an impressively messy compilation!
If I'm ever going back to uni, I'm going to make it my life's work to standardize databases in all bioscience.
It's ridiculous how much time is wasted on that stuff, because everyone starts from scratch and changes the entire layout and order halfway through building it.
Just for fun a couple conversations I had:
"Alphabetical, why not numerical? Just take the last number of every animal. No, wait, take the number of every farmer. No wait, it might be better to sort on date of birth. However.. We're not treating them as a population, so maybe it's better to sort on the last six digits of the animal. But they have to be anonimized, so maybe assign each one a unique number after you've sorted them on those six digits. When you're done, generate a unique barcode as well, but it has to be the same as the anonimized number. You know what? Since they all get an unique ID, you don't need to sort them at all."
"I see these samples are sorted alphabetically until 2006, then numerical in 2010, then re-sorted alphabetically in 2011, and after that someone must've done a shuffle a couple of times. Just add the new ones on the bottom and then sort them all again."
"Here's a box of shit/hair/fish/blood, we sorted them, but after an hour we thought it would be faster to not do that. Don't worry, each tube has a number written on it, sometimes upside down, and it's a non-frost-proof marker. The samples need to be kept frozen. The difference between 19 and 61 you ask? Well, look at the handwriting, I did 19 and he did 61. But I did both 66 and 99 so maybe have a look at how tired the writing looks, the worst one is probably 99. Keep in mind that the next batch starts with a zero, so the difference between 01 and 10, 09 and 60, an 08 and 80 might not be obvious, but from there on forward it should be a breeze."