Want to Know What Really Makes Us Human? Better Know Your SQL

Author: William Murakami-Brundage
Published: September 20, 2010 at 8:30 am
Share

 

Genetic research is hot stuff. From homo sapiens to drosophila melanogaster, everyone wants to know what life is really made of.

All that research data has to go somewhere, and often it is placed straight into a database, stuck somewhere, and (the theory is) accessed by men with lab coats and clipboards.

There is a different truth: genetic researchers apparently are some of the original open-source pioneers. From the Online Mendelian Inheritance in Man Database (OMIM), and Entrez's numerous genome codes, to the genome of Illumina Corporation's CEO, this data is available for public use. The secret: you better know your SQL to access it.

The OMIM database is a trove of data about genetic illnesses and vulnerabilities. Unlike Entrez or other, more complex databases, it can be searched by keyword, including diagnoses. OMIM pulls data from several other major genetic databases and compiles the results.

Thankfully, it also cites the location of the research in case you want to know, for example, the location of the genetic vulnerability for schizophrenia (note, there are several possible culprits).

Entrez is technically the 'life sciences search engine' (read: database collection) that is part of the National Center for Biotechnological Information (NCBI). Entrez hosts open-access databases for all things genetic. Some of these are accessible by keyword searching, others through various forms of modified SQL. Be warned, it is imperative that users have SQL experience past the surface level. Genetic research is not easily understood; thankfully some information can still be gleaned by basic users.

Lastly, the not-so-open-source data: Illumina's human genomes (two data sets). Hosted via Amazon's Web Suite, there is a nominal fee for using these databases. Amazon charges per GB of data transfer, as Illumina's information is in the Cloud.

Continued on the next page
 
 

About this article

Profile image for tbrun1977

Article Author: William Murakami-Brundage

Librarian, avowed geek, and part-time cook. Happily married with too many pets to list. I am a graduate student at Drexel and also work as a health information specialist - I handle data, and lots of it. …

William Murakami-Brundage's author pageAuthor's Blog

Article Tags

Share: Bookmark and Share

Add your comment, speak your mind

Personal attacks are NOT allowed
Please read our comment policy