Recent posts / Archive

Categories

Posts matching category: MySQL

SQL - it is very handy!

Originally posted by Dan on 11:13 Sat 14 July 2007, last modified 11:24 Sat 14 July 2007.

File under: 3rd party tools covariates MySQL phd

SQL is really very useful. This single query allows me to find the greatest range of a particular variable for every day in my database (which is over 5000 days) read more...

edit or comment

Hierarchical database in MySQL...

Originally posted by Dan on 06:00 Mon 6 November 2006, last modified 12:34 Mon 7 May 2007.

File under: covariates databases MySQL phd

Okay, so I need to investigate the effect of covariates on influenza infections across a country. Covariates are basically cofounding variables, that may be predictive of the outcome under study. I'm investigating influenza - so lets look at population density. To analyse such data, we need a system to store and retrieve it; a database.

read more...

edit or comment